Department of Studies in Information Technology

Karnataka State Open University

Mukthagangothri, Mysore – 570 006

DEPARTMENT OF STUDIES IN INFORMATION TECHNOLOGY

Diploma in Information Technology

NOTE: You are required to read the following instructions carefully before you answer.

1. Write the Roll Number, Name and Title of the course at the beginning of your answer of each subject.

2. You should answer all Questions under each paper.

3. You should write the assignment separately with regard to each paper.

4. Assignments without Roll No. and Name will be rejected.

5. After writing the assignment, you should tag the assignment together, put them in a cover and send it to the address given below (Preferably in a long book).

6. Assignment cover should be super scribed by “Assignment for Diploma in Information

Technology” and write your Roll number and Name.

7. Your assignment should reach to:

Chairperson,

Department of Studies in Information Technology,

Karnataka State Open University,

Mukthagangothri,

Mysore-570006.

8. Assignments should reach us on or before May 31st 2015

The assignments received after the last date will be summarily rejected. No further extension is allowed. Also browse the website www.ksoumysore.edu.in for further details- (Timetable for contact program will be hosted shortly).

9. Assignment sent to any other address of the University will not be valued.

10. The students are ADVICED TO KEEP A COPY OF THE ASSIGNMENTS with them and submit it in case the University demands the same.

Note: Assignment 1 and 2 should be written separately.

DIT-11: Fundamentals of Information Technology

Assignment 1:

1.  Explain different generations of Computers.

2.  Describe different types of Number Systems.

Assignment 2:

1.  Discuss different types of ROM memory.

2.  Explain different process models along with their merits and demerits.

DIT-12: Office Automation

Assignment 1:

1.  Write the steps for the following:

a)  to add page numbers to your book in MS Word

b)  to change/set margins in my pages in MS Word

1. What is Data Filtering MS Excel?

Assignment 2:

1.  Write the difference between character formatting and paragraph formatting?

2.  Explain the ways of generating reports in MS Access

DIT-13: Database Management System

Assignment 1:

1.  Explain the applications and characteristics of DBMS?

2.  Explain the three-level architecture of DBMS with the help of an example.

Assignment 2:

1.  Describe how strong and weak entity types differ and provide an example for each.

2.  Define the five basic operators of relational algebra with an example each.

DIT-14: Communication Networks

Assignment 1:

1.  Differentiate between different types of computer networks?

2.  Explain OSI reference model in detail.

Assignment 2:

1.  Explain IPv4.

2.  Explain the working of SMTP.

DIT 15: C PROGRAMMING

Assignment 1:

1.  Differentiate algorithm and flowchart.

2.  Explain the basic structure of a C program.

Assignment 2:

1.  What is an array? Differentiate single and two dimensional array.

2.  What are storage classes? Explain its types.

DIT 16: DBMS and C Programming Lab

Assignment 1:

1.  Write a c program to find the simple interest.

2.  Write a C program to search an element using linear search.

Assignment 2:

1.  Write SQL commands used to query and manipulate the existing database objects.

2.  Explain rollback and commit commands.