Madhya Pradesh Bhoj _Open_ University

Document Sample
Madhya Pradesh Bhoj _Open_ University Powered By Docstoc
					    Madhya Pradesh Bhoj (Open) University
            Theory Assignment for Session 2004-05
                            Programme : D.C.A.
Note : All question carry equal marks. Questions are solved in same sequence as
       given in assignments.

Course Code : DCA-01 Fundamentals of Computers & IT                Max. Marks : 20
                                   First Assignment
Q.1a. Explain Cache Memory and Virtual Memory.
   b. Explain the following Commands:
      i. CHKDISK             ii FORMAT            iii. DELTREE        iv. XCOPY
Q.2a. Explain the various type of topology with examples.
   b. Differentiate between Motherboard and CPU.
Q.3a. What do you understand by Computer System? Explain its main characteristics.
   b. Draw a block diagram of computer system. Also explain each unit of them.
Q.4a. What is an Operating System? Describe its Main Features.
   b. What do you mean by term software? Explain system software and application
      software with suitable examples.

Course Code : DCA-01 Fundamentals of Computers & IT                   Max. Marks : 20
                                  Second Assignment
Q.1a. What is a Batch file? Explain with suitable examples.
   b. Differentiate between LAN ,MAN And WAN.
Q.2a. What do you understand by Spooling? Explain with examples.
   b. Explain the following:
      i.      MODEM                         ii.     Half Duplex & Full Duplex
      iii     Communication Channels
Q.3. Write notes on the followings:
   a. Printer         b.      Scanner       c.      Plotter
Q.4a. What do you understand by Client/Server computing? How does it differ from
      networking? Describe various advantages and disadvantages of client/server
   b. What is a computer virus? How does it differ from a biological virus? What are
      the different kinds of viruses? Explain with example.

Course Code : DCA-03 PC Package (Win XP: Word, Excel, PP)           Max. Marks : 20
                                 First Assignment
1. What is desktop? Explain the purpose of Window-XP Desk Top. How does the Desk
   top shortcut wizard work?
2. What is Font? How can we install a new font?
3. What do you mean by Word Processing? What are the features, functions and
   advantages of Word Processing System? Also explain creating, saving and opening of
   document in MS-Word.
4. Explain the procedure for entering data into cells, editing data in a cell and clearing
    the contents of cells.
5. Explain the following:
    a) Paragraph Formatting.         c.      Previewing Document.
    b) Printing Document             d.      Process of importing a file from other
                                             programmed into MS-Word.
6. What is difference between Wizard and Template?
7. What is difference between Work book & Worksheet and Tool Bar & Menu?
8. Explain the Following:
    a) Function Wizard               b) Test Wrapping
    c) Worksheet Functions           d) Excel Application.
    e) Automatic Recalculation in Excel.
    f) Creating, Sorting and Filtering Database.
9. Explain the Following:
    i. Slide Sorter ii.      Master Slide           iii. Custom Animation
    iv. Slide Show. v.       Slide Layout
10. How Power point is more useful in Office Work? Explain with suitable examples.

Course Code : DCA-03 PC Package (Win XP: Word, Excel, PP)                Max. Marks : 20
                                    Second Assignment
1. Explain following:
    a) Notepad          b) Character Map       c) Header and Footer d) Tool Bar
    e) Network Neighborhoods f) Difference between DOS and Windows.
2. How does Windows-XP organize files and folders on drives? Also explain how to
    search files and folders?
3. What is Icon? How can we change the icon associated with an object?
4. What is Mail Merge? What type of facilities it provide? And write down the method
    to do mail merge for mailing letter.
5. What is hyper link? How can you add a hypertext link to a document?
6. What is the difference between a relative cell reference and an absolute cell
7. What is the meaning of Sheet in Excel ? Can I print my sheet with the gridlines? If
    yes then explain how it is done?
8. What is Chart? How many types of Chart does Excel support? Explain each with
9. Explain the each step of creation of Slide and presentation of slide?
10. Explain the various steps of slide printing.
Course Code : DCA-05 MS Access                                           Max. Marks : 20
                                     First Assignment
Q.1a. What is the concept of Database design? Explain the various steps to design a
    b. What are the various method of designing a table? Explain with examples.
Q.2a. What is a Report? Explain the use of Report in Database?
    b. What do you understand by Label? Explain use of label in database.
Q.3a. How to Import data from Excel workbook to Access?
    b. Discuss the different data types offered by Access in details?
Course Code : DCA-05 MS Access                                          Max. Marks : 20
                                  Second Assignment
Q.1a. Explain the types of Relation in details. Write steps to establish relation between
   b. What is a Query? Explain various types of queries with the help of suitable
Q.2a. What is a Macro? How to create a macro? Explain with examples.
   b. How to filter data through Selection Method?
Q.3a. Discuss the application of a database in corporate sector?
   b. What ia primary key? Why do you need to create a primary key?

Course Code : DCA-07 Programming in “C” Language                        Max. Marks : 20
                                    First Assignment
1. Describe four basic data types. How could we extend the range of values they
   represent? And also describe variable and the meaning the “value” of variable.
2. Define structure of a C program. Fit the following algorithm in above structure. For a
   certain circuit with an inductance L and resistance R, the damped natural frequency is
   given by
                       Frequency = ∫1/LC – R2 / RC2
   Give the frequency by inputting value of L,C and R.
3. What is recursion? Discuss its advantages and disadvantages.
4. Compare in terms of their functions, the following pairs of statements:
   a) While and do….while.
   b) While and for.
   c) Break and goto.
   d) Break and continue.
   e) Continue and goto
   Give an example of each of the term given.
5. What is the difference between Structure and Union?
6. What is an array? Defined its types with one example.
7. the annual examination results of 100 students are tabulated as follows:
Roll No.               Subject1              Subject2               Subject 3

Write a program to read the data and determine the following:
   (a) Total marks obtained by each student.
   (b) The highest marks in each subject and the Roll No. of the student who secured it.
   (c) The student who obtained the highest total marks.

Course Code : DCA-07 Programming in “C” Language                       Max. Marks : 20
                            Second Assignment

1. Write the structure of C program. How data type is used in C program. Explain
   fundamental and user define Data type.
2. Explain the following function with example:
   a) getch()        b) getchar() c) putchar() d) printf()   e) fprintf()
3. What is a Conditional Operator? Explain with example.
4. Write a program to transpose of matrix.
5. What is function? What are the advantages of using function? Write the difference
   between „Call by Value‟ and „Call by Reference‟.
6. What is Structure? Explain nesting of structure with example. Create a structure
   „Student‟ that have a following information
       Class, student name, result (pass or fail)
   Using this structure write a program to read information of 50 students and print
   result wise list.
7. Use Recursive calls to evaluate:
       f(x)= x- x3/3! + x5/5! – x7/7! + ………..

Course Code : DCA-09 GUI Programming in VB                            Max. Marks : 20
                                    First Assignment
1. In which respect structural programming are different from modular programming.
2. Write all the steps followed by you do begin a project in VB.
3. Write about different data types used in VB.
4. With the help of examples demonstrate the three forms of resume statements.
5. Write code in VB to create a pop-up menu.
6. What are the uses of programme bar? How can it be created in a programmes.
7. Describe about OLE automation
8. What are key words in an APE function declaration in visual basic.

Course Code : DCA-09 GUI Programming in VB                               Max. Marks : 20
                                    Second Assignment
1. In order to start a application development task in visual basic, what minimum
   requirements are to be completed.
2. Name and describe about various types of windows used in VB.
3. Given your opinion about the variable declaration within the module.
4. Write about different types of arrows faced in VB programming? What lyte of arrows
   can be encountered at design time.
5. In multiple document interface forms, name the various types of forms. In order to
   explain the process of connection by given one example.
6. What do you mean by a flying manager. How will you create it? Describe.
7. How can you initiate the OLE process between two Oleservers from within your OLE
   client application.
8. How does an API function differ from a macro.