madhya pradesh bhoj open university Madhya

Document Sample
madhya pradesh bhoj open university Madhya Powered By Docstoc
					      Madhya Pradesh Bhoj (Open) University
              Theory Assignment for Session 2005-06
                                 Programme : DCA

Note : All question carry equal marks. Questions are solved in it sequence as given in
       assignments.
Course Code : DCA-01                                   Fundamental of Computer and IT
First Assignment                                                           Max. Marks : 20
Q.1a. Do you think that computer is more intelligent than human being? Discuss.
   b. Write the name of different input and output devices. Explain any one input and one
       output device in detail
Q.2a. What is the software? Discuss the characteristics of user-friendly software.
   b. What do you understand by Protocol? Explain with suitable examples.
Q.3a. Describe in brief the architecture of a computer system.
   b. Explain different types of memory and distinguish between Dynamic and Static
       RAM?
Q.4a. What do you number system? Explain various number system with their conversion
       rule.
   b. Describe LAN, MAN and WAN with example.

Course Code : DCA-01                                  Fundamental of Computer and IT
Second Assignment                                                         Max. Marks : 20
Q.1a. Why do we need computers? Explain various uses of it.
   b. What is an Operating System? Explain the major function of OS.
Q.2a. Define the term hardware. Discuss in brief the classification of hardware components
      of a microcomputer.
   b. What do you understand by Internal and External Commands? Explain five
      commands of each.
Q.3. Write short notes on the following:
      a.     Personal Digital Assistant           c.      Laptop computer
      b.     Notebook Computer                    d.      Generation of Computer
Q.4a. Differentiate between Simplex, half-Duplex and Full-Duplex.
   b. What is virus? Explain different kinds of virus in brief. How will you protect your
      system?

Course Code : DCA-03                                                      PC-Package
First Assignment                                                          Max. Marks : 20
Q.1a. What is a word processor? What are the uses of a word processor?
    b. What is an electronic spreadsheet? Discuss the area where an electronic spreadsheet
       finds its major contribution.
Q.2    Write notes on the following with example in term of MS-word.
           i.      Mail Merge        ii.     Style sheet           iii.   Table
Q.3a. Write steps to create a presentation in power point for Madhya radish Bhoj (Open)
       University, Bhopal.
    b. Explain the following in reference of MS-Powerpoint with suitable examples.
       i.      Master Slide ii.      Custom Animation iii.         Slide Sorter
Q.4. Write short notes on the following in reference of MS-Excel:
       i.      Absolute Addressing.          ii      Header and footer    iii.  Functions


                                            1
Course Code : DCA-03                                                      PC-Package
Second Assignment                                                         Max. Marks : 20
Q.1a. How can you insert a table in your documents? Explain any two ways.
   b. Explain the following in reference of MS-word.
      i.     Word Art        ii.     Clip Art      iii.   Find and Replace
Q.2a. What is the difference between "Copying Text and "Moving Text"?
   b. Discuss the role of AutoCAD software in corporate sector.
Q.3a. What is the difference between the datasheet view and the design view of a table?
   b. Discuss the steps to create a macro.
Q.4a. Write different functions of Excel and Access and also differentiate between both.
   b. How we create database? Write and explain each step.

Course Code : DCA-05                                                      MS-Access
First Assignment                                                          Max. Marks : 20
Q.1a. What is macro? Write various steps to create and run a macro.
   b. What is the significance of Report? Explain various part of report.
Q.2a. What are the various controls in form? Explain.
   b. Write notes on Cross tab Query and Update query.
Q.3a. What do you understand by database? Explain the properties of database.
   b. Explain various type of relation ships with suitable examples.
Q.4a. Explain Primary Key, Secondary key, Foreign Key with example.
   b. What is the difference between manual database and computerized database.

Course Code : DCA-05                                                   MS-Access
Second Assignment                                                      Max. Marks : 20
Q.1a. How to export MS access table into excel worksheet.
   b. What is mailing Label? Write steps to create a mailing label.
Q.2a. What is form? How to create a form?
   b. How to create a query? Explain various steps.
Q.3a. How to work with Subdatasheets?
   b. Explain the following:
      i.     Editing of record              ii.     Wildcards
Q.4a. Explain the different ways of creating a table.
   b. Explain table saving and table opening .

Course Code : DCA-07                                     Programming in C Language
First Assignment                                                        Max. Marks : 20
Q.1a. What do you understand by dynamic memory allocation?
   b. Define recursion and how it it achieved by C language.
Q.2a. How do you initialize the structure? Write complete code in C for store and display
       the information of 10 Books.
Q.3a. Define file. How can we define, open and close the file in C language? Explain with
       example.
   b. Explain formatted Input and formatted output function used in C with examples.
Q.4. Write short notes on the following:
   a. Union           b.     Pointer       c.     Storage Class




                                             2
Course Code : DCA-07                                       Programming in C Language
Second Assignment                                                         Max. Marks : 20
Q.1a. What are the different looping structures available in C language? What are the
      differences between them?
   b. What is the role of return statement in C language?
Q.2a. Describe the importance of call by value and call by reference used in C function.
   b. Discuss control statement used in C language.
Q.3a. Differentiate between coupling and cohesion.
   b. Differentiate between Top-down and Bottom-up designs.
Q.4. Write short notes on the following
      a.      Pre-processor directives and its uses
      b.      Switch and Case statement
      c.      Presidency of operator

Course Code : DCA-09                                GUI Programming in Visual Basic
First Assignment                                                         Max. Marks : 20
Q.1a. Explain various features of MDI parent and child form.
   b. Design a form to store array of integers and write code to search a particular number
       from array.
Q.2a. Describe various elements of Visual Basics IDE.
   b. Differentiate between Text Box and Label Box.
Q.3a. Explain the Database Programming with VB.
   b. How can variables be declared in VB? Explain different types of variable in VB.
Q.4a. Explain hardware and software requirements of Visual basic.
   b. Explain text control in VB with example.

Course Code : DCA-09                                   GUI Programming in Visual Basic
Second Assignment                                                         Max. Marks : 20
Q.1a. What do you understand by event driven program ? Explain with suitable example.
   b. Explain various control statements of Visual basic. Explain each statement using
      suitable example with coding.
Q.2a. What is debugging? Explain various debugging method of VB.
   b. Explain procedures in Visual Basic with example.
Q.3a. Explain project explorer and its utility during application development.
   b. Write differences between objects and control of Visual basic.
Q.4a. Explain Tool Box.
   b. Explain different types of Visual basic.

Course Code : DCA-11                                         Internet & Web page Design
First Assignment                                                        Max. Marks : 20
Q.1a. What is website? Write down the steps to create and maintain a website.
   b. What is the significance of URL in the Internet World? How many different types of
       URLs are there? Describe each with the help of an example.
Q.2a. How many types of Internet Connections are available? Describe.
   b. What is the different security measures applied in internet?
Q.3a. Write the different tools needed to develop web-site.
   b. Define Telnet with its merits and demerits.
Q.4a. Explain the concept of e-mail and its advantages.
   b. Describe web server.



                                            3
Course Code : DCA-11                                       Internet & Web page Design
Second Assignment                                                       Max. Marks : 20
Q.1a. What do you mean by Internet? List out various advantages and Disadvantages of
      Internet.
   b. How does file transfer protocol work? How many different basic file formats does it
      understand? What is the basic difference between an authorized FTP and Anonymous
      FTP?
Q.2a. What are the different types of lists offered by HTML? Explain each with appropriate
      example.
   b. Differentiate between Home page and Start Page. Also define plug-ins.
Q.3a. Explain web server, FTP server and Mail Server.
   b. How you will publish your website? What are the minimum requirements to do it?
Q.4a. Explain Voice chat and video chat.
   b. Describe Data transmission protocol.




                                            4