Maharashi Dayanand University (MDU) 2006 M.C.A Computer FUNDATION IN IT AND MS-OFFICE - Question Paper

1. (a) elaborate the major components of motherboard? How is it responsible for the performance of the computer
system? List out the name of 4 manufactured of motherboard.
(b) What are meaning of External representation and Representation of data.

2. (a) What are the advantages and disadvantages of primary memory over auxiliary memory?
(b) What do you mean by Primary Memory? Differentiate ranging from SIMM, DIMM and RIMM.


3. (a) What is the major function of Operating System? How is operating system related with system software?
(b) Write short notes on the following:

(i)Graphical User Interface
(ii)Privacy and Security of info.





4. (a) Write down the classification and generation of programming language with examples. Also explain the different Characteristics of a good programming.
(b) What is difference ranging from active matrix and passive matrix flat panel display devices?

5. (a) Can you access MS-Access report in spreadsheet? If yes, how? Is it also possible to convert MS-Excel Table Into a MS-Access database file ? Illustrate the identical if yes.
(b) What do you mean by document templates? Justify their usefulness.

6. (a) Explain the concept of customization of slide in MS Power Point. elaborate its usefulness? Illustrate with help
of an example.
(b) What is Macro? How is the identical described and run in MS Excel? Illustrate the identical.

7. (a) Represent the subsequent data in binary number:

255 -255 15 -15 using:

(i)Signed magnitude method
(ii)1’s complement method
(iii) 2’s complement method

(b) What do you mean document templates? Justify their usefulness

8. (a) What do you understand by Pivot table? discuss its usefulness.
(b) What are cell-notes? State their usefulness. How do you add, delete or edit cell-notes in MS-Excel ?

Earning:   Approval pending.