Reference Books:

·         HTML & XHTML: The Complete Reference Guide, 5thEdition

·         Web Design in a Nutshell, Second Edition by Jennifer Niederst Robbins, Second Edition September2001

·         Learning Web Design: HTML, Graphics, and Animation

·         A Beginner's Guide to HTML, Graphics, and Beyond by Jennifer Niederst Robbins

·         Introduction to HTML-Kamlesh N agrawal

·         Data communication and networking-Ferozon

·         Networking Concepts-Tanunbaum

SEMESTER- I

SUBJECT-PROGRAMMING WITH C

SUBJECT CODE-DCA103

MAX. MARK-100                                                           MIN. MARK-40

UNIT– I: Introduction:

Introduction Character set, Identifiers and Keywords, Variables, Displaying variables, Reading Variables, Character and Character String, Qualifiers, Type define Statements, Value initialized variables, Constants, Constant Qualifier, Operators and Expressions, Operator Precedence and Associativity, Basic input output: Single Character I/O, Types of Characters in format string, Scanf with specifier.

UNIT–II: Control Structures-

Control Structure: If - statement, If -else statement, Multi decision, Compound Statement, Loops: For-loop, While-loop, Do-While loop, Break statement, Switch statement, Continue statement, Go to statement.

UNIT–III: Functions &Arrays-

Functions: Function main, Functions accepting more than one parameter, User defined and library functions, Concept associatively with functions, function parameter, Return value, recursion comparisons of Iteration and recursion variable length argument list.

Arrays: Scope and Extent, Multidimensional Arrays, Array of Strings, Function in String, passing arrays to functions, accessing array inside functions.

UNIT– IV Pointes

Pointers: Definition and use of pointer, address operator, pointer variable, referencing pointer, void pointers, pointer arithmetic, pointer to pointer, pointer and arrays, pointer and functions, pointers and two dimensional arrays, array of pointers, pointers constants, pointer and strings.

UNIT–V: Structure and Union-

Declaring and using Structure, Structure initialization, Structure within Structure, Operations on Structures, Array of Structure, Array within Structure, Creating user defined data type, pointer to Structure and function- Union, difference between Union and Structure, Operations on Union, Scope of Union.

Suggested Books:-

1.                                                     Let us C- Yashwant Kanetkar.

2.                                                     Programming in C-E. Balaguruswamy

Semester-I

SUBJECT-MULTIMEDIA AND TOOLS

SUBJECT CODE-DCA107

MAX. MARKS-100                                                      MIN. MARKS-33

Multimedia and tools

Unit- 1. Introduction to Multimedia Components of multimedia, Web and Internet multimedia applications, Transition from conventional media to digital media, Text, Audio, Video, Image, Animation, uses of multimedia, needs of multimedia.

Unit-2. Computer Fonts and Hypertext, Usage o f text in Multimedia, Families and faces of fonts, outline fonts, bitmap font’s International character sets and hypertext, Digital fonts techniques, text editing software, text editors, colours in fonts, size of font.

Unit-3. Audio fundamentals and representations. what is the audio, types of audio, Digitization of sound, frequency and bandwidth, data rate, audio file format, Sound synthesis, MIDI, wavetable, Compression and transmission of audio on Internet, Adding sound to your multimedia project, Audio software and hardware.

Unit-4. Image fundamentals and representations, Colour Science,  Colour Models, Colour palettes, 2D Graphics, Image Compression and File Formats :GIF, JPEG, JPEG 2000, PNG, TIFF, EXIF, PS, PDF, Basic Image Processing [ Can Use Photoshop ], Use of image editing software, Retouching.

Unit-5. Video and Animation, Video Basics , How Video Works, Broadcast Video Standards, Analog video, Digital video, Video Recording and Tape formats, Shooting and Editing Video (Use Adobe Premier for editing), Video Compression and File Formats. Video compression based on motion compensation, MPEG-1, MPEG-2, MPEG-4, MPEG-7, MPEG-21, Animation: Cell Animation, Computer Animation, Morphing.

Text books Reference:

Multimedia technologies-Dr. D.A. Godse

SEMESTER- I

SUBJECT-PROGRAMMING IN C LAB                   SUBJECT CODE-DCA 106

MAX. MARK- 50                                                       MIN. MARK-17

PRACTICAL TASK:

Programming in C–Lab

1.      Setting–up environment for C programming.

2.      Compiler Installations (command line, IDEs).

3.      Using IDEs.

4.      Displaying various messages onscreen.

5.      Programs with simple arithmetic.

6.      Programs to display criteria based results.

7.      Programs to take input from user.

8.      Program to take input based on some criteria.

9.      Programs on unit conversions.

10.  Programs on iterative operation.

11.  Programs to create a numbers series.

12.  Programs to check special.

13.  Characteristic numbers.

14.  Programs to create specific patterns.

15.  Programs for creating functions.

16.  Programs on recursion.

17.  Programs on C preprocessor.

18.  Programs on recursion.

19.  Programs to use various storage classes.

20.  Programs on data type handling and conversion.

21.  Programs to introduce Pointers.

22.  Programs on handling Array.

23.  Programs on matrix calculations.

SEMESTER- I

SUBJECT-Multimedia and tools Lab                 SUBJECT CODE-DCA 107

MAX. MARK- 50                                                       MIN. MARK-17

PRACTICAL TASK:

Multimedia and tools-Lab                

1.                   use text editor software

2.                   use audio editor software

3.                   Use video editor software

4.                   Use  image editor software

5.                   Use animator software

SEMESTER- I

SUBJECT-FUNDAMENTAL OF IT

SUBJECT CODE-DCA105

MAX.MARK- 50                                                                              MIN. MARK-17

Computer based Lab/based PC packages

1.                                                               Text Manipulations

2.                                                               Usage of Numbering, Bullets, Tools and Headers

3.                                                               Usage of Spell Check and Find and Replace

4.                                                               Text Formatting

5.                                                               Picture Insertion and Alignment

6.                                                               Creation of Documents Using Templates`

7.                                                               Creation of Templates

8.                                                               Mail Merge Concept

9.                                                               Copying Text and Picture from Excel

10.                                                           Creation of Tables, Formatting Tables

11.                                                           Splitting the Screen

12.                                                           Opening Multiple Document, Inserting Symbols in Documents

MS-EXCEL

1.                                                               Creation of Worksheet and Entering Information

2.                                                               Aligning, Editing Data in Cell

3.                                                               Excel Function (Date, Time, Statistical, Mathematical, Financial Functions)

4.                                                               Changing of Column Width and Row Height(Column and Range of Column)

5.                                                               Moving, copying, Inserting and Deleting Rows and Columns

6.                                                               Formatting Numbers and Other Numeric Formats

7.                                                               Drawing Borders around Cells

8.                                                               Creation of Charts Raising Moving

9.                                                               Changing Chart Type

10.                                                           Controlling the Appearance of a Chart

MS-POWERPOINT

Working with Slides

1.                                                               Creating, saving, closing presentation

2.                                                               Adding Headers and footers

3.                                                               Changing slide layout

4.                                                               Working fonts and bullets

5.                                                               Inserting Clipart: working with clipart,

6.                                                               Applying Transition and animation effects

7.                                                               Run and Slide Show

Semester-II

Semester-II

Subject:- GUI-Programming in Visual Basic

Subject Code: DCA-201

Max Marks:100                                                              Min. Marks:40

UNIT:-I

Editions of Visual Basic, Event Driven Programming, Terminology, Working environment, project and executable files ,various editions of vb, code formatting option, Automatic code completion features.

Creating Programs - Introduction to objects, Controlling objects, Properties, methods and events, Working with forms, Interacting with the user: Msg Box function, Input Box function, Code statements, Managing forms, Creating a program in Visual Basic, IDE.

UNIT: II

Overview of variables, Declaring, Scope, arrays, User-defined data types, constants working with Procedures, working with dates and times, using the Format function, Manipulating text strings, Controlling Program Execution -Comparison and logical operators, If Then statements, Select Case Statements looping structures, Using Do…Loop structures, For…Next statement, Exiting a loop.

UNIT: III

Types of controls, Overview of standard controls, Combo Box and List Box, Option Button and Frame controls Menu, Status bars, Toolbars, Advanced standard controls, ActiveX controls, Insert table objects, Validation, Error Trapping & Debugging - Overview of run-time errors, error handling process, The Err object, Errors and calling chain, Errors in an error-handling routine, Inline error handling, Error-handling styles, General error-trapping options Type of errors, Break mode Debug toolbar, Watch window, Immediate window, Local window, Tracing program flow with the Call Stack.

UNIT: IV

Saving data to file, basic filling, data analysis and file, the extended text editor, Random access file, the design and coding, Data Access Using the ADO Data Control -Overview of ActiveX data Objects, Visual Basic data access features, Relational database concepts Using the ADO Data control to access data, Overview of DAO, RDO, Data Control, structured query language (SQL), Manipulating data Using Data Form Wizard.

UNIT: V

Overview of Report, Data Report, Add groups, Data Environment, Connection to database Introduction to Crystal Report Generator. Overview of drag and drop, Mouse events, Drag-and drop basics, Date Time Control, Calendar, Print Dialog, MDI (Multiple Document Interface).

BOOK RECOMMENDED:

·         Mastering Visual Basic 6 Fundamentals–By Microsoft

·         Mastering in Visual Basic–By BPB Publications.

·         Introduction to VB Programming–V. K. Jain

SEMESTER- II

SUBJECT- DESKTOP PUBLISHING

SUBJECT CODE     -DCAC202

 MAX. MARK-100                                                                MIN. MARK       -40

DESKTOP PUBLISHING

UNIT–I

DTP, Introductions to Printing, Types of Printing, Offset Printing, Working of offset Printing, Transparent Printout, Negative & Positives for Plate were making, Use of Desk Top Publishing in Publications, Importance of D.T.P in Publication, Advantage of D.T.P in Publication, Mixing of graphics & Image in a single page production, Laser printers - Use, Types, Advantage of laser printer in publication.

UNIT–II

Introductions To Page Maker, Page Maker Icon and help, Tool Box, Styles, Menus etc., Different screen Views, Importing text/Pictures, Auto Flow, Columns, Page Layout Different page format / Layouts, News paper page format, Page orientations, Columns & Gutters, Printing in reduced sizes.

UNIT–III

Master Pages and Stories, Story Editor, Menu Commands and short-cut commands, Spell check, Find & Replace, Import Export etc., Fonts, Points Sizes, Spacing etc., Installing Printers, Scaling (Percentages), Printer setup, Use of D.T.P. in Advertisements, Books & Magazines, News Paper, Table.

UNIT–IV

Introduction to Adobe Photoshop & Documents, Various Graphic Files and Extensions, Vector Image and Raster Images, Various Color Modes and Models Introduction to Screen and Work Area, Photoshop Tools & Palettes ,Use of Layers & Filters, Working with Images.

TEXT&REFERENCEBOOKS:

1.       PAGEMAKER 4.0 & 5.0 BY B. P. B. PUBLICATIONS.

2.       PRAKHAR COMPLETE COURSE FOR DTP (CORELDRAW, PAGEMAKER, PHOTOSHOP)

Practical LAB:

1.       Complete Page Maker S/W

2.       Complete Adobe Photoshop

3.       Hindi Typing on PageMaker and MS-Word.

SEMESTER- II

SUBJECT - DATA BASE MANAGEMENT SYSTEM

SUBJECT CODE-DCA 203

MAX. MARK-100                                                                                     MIN. MARK     - 40

  UNIT – I : Introduction To DBMS

Data, Information and knowledge, concept of DBMS, Advantages of DBMS, data independence, database Administration roles, DBMS architecture, different kinds of DBMS users, importance of data dictionary, contents of data dictionary, types of database languages. Data models: network, hierarchical, relational, Introduction to ODBC concept.

UNIT – II: E-R Model

Entity - Relationship model as a tool for conceptual design-entities, attributes and relationships. ER diagrams; Concept of keys; Case studies of ER modeling Generalization; specialization and aggregation.

UNIT – III: Relational Model

Structure to Relational Database, Relational Algebra, and Extended Relational- Algebra Operation, Simple and complex queries using relational algebra, The Domain Relational Calculus, Tuple relational calculus.

UNIT – IV: Relational Database Design

Pitfalls in Relational Database Design, Decomposition, Functional Dependencies, Normalization: 1NF, 2NF, BCNF, 3NF, 4NF, 5NF.

UNIT – V: Structured Query Language:

DDL and DML: Creating Table, Specify Integrity Constraint, Modifying Existing Table, Dropping Table, Inserting, Deleting and Updating Rows in as Table, Where Clause, Operators, ORDER BY, GROUP Function, SQL Function, JOIN, Set Operation, SQL Sub Queries. Views: What is Views, Create, Drop and Retrieving data from views. Security: - Management of Roles, Changing Password, Granting Roles & Privilege, with drawing privileges.

REFERENCE BOOKS:

1.        “Database System Concepts”, Sudarshan, McGraw Hill.

2.        “Introduction to Database Management Systems” (2006 ISRD Group) Tata McGraw Hill.

3.        “An Introduction to Database System”, C.J. Date.

4.        Introduction to Relational Database and SQL programming”, Allen, Tata McGraw Hill.

5.        “SQL”, Scott Urman.

SUGGESTED BOOKS:

1.Data Base Management System : Alexies & Mathews

2.Data Base Management System : Raguramakrishnan.

SEMESTER  - II

SUBJECT   -   GUI- PROGRAMMING IN VB LAB                     SUBJECT CODE     -PDCAP-204

MAX. MARK-   50                                                                  MIN. MARK     -  21

PRACTICAL   TASK:

1.       WAP to perform arithmetic operation using command buttons. (Declare variables globally).

2.       WAPtotakeinputofprincipal,rate&timeandcalculatesimpleinterest&compound interest.

3.     Write a program to take input of x and print table of x in the following format. X * 1 =X

X * 2 = 2X

         -

         -

X * 10 = 10*X

4.      Design an interface, which will appear like marksheet. It will take input of marks in five subjects and calculate total marks and percentage then provide grade according to following criteria. (Using nested if) (Use tab index property to move focus).

If % Then Grade

>=90 A+

> = 75 &<90 A

> = 60 &<75 B

> = 45 &<60 C

Otherwise F

5.     WAP to create a simple calculator (Using control array)

6.     Write a program to check whether ancentered no. is prime or not.(Using for loop & Exit for)

7.     Write a program which will count all vowels, consonants, digits, special characters and blank spaces in a sentences (Using select case)

8.     WAP to illustrate all functionalities of listbox and combobox.

9.     WAP using check boxes for following font effects. Bold Italic Underline, Increase font size Decrease font size Font color

10.    WAP for temperature conversion using optionbutton

11.    WAP to launch a rocket using pictures box and timer control.

WAP to change back color of any control (label, textbox) using scroll box.

12.    WAP to search an element for a one dimension static array.

13.    WAP to sort a dynamic array of (a)n numbers (b)n strings (Input array size at run time)

14.    WAP to take input of two matrices and perform their addition, subtraction and multiplication using Menu editor.

15.    WAP to illustrate call by value and call by reference ( to swap to values)

16.    Write a program to calculate factorial of a number using user defined function.

17.    Take input of a word and WAP to check whether it is a palindrome or not. (Without using structure fun)

18.    WAP to find smallest among given three numbers using user defined procedures.

19.    WAP to generate, print and find sum of first n elements of fibonacci series using recursion.

20.    WAP to perform read write operations in a sequential file.

21.    Create a user defined data type having fields name (as string of length 20 bytes), Roll no (as integer), class (as string of 10 bytes). WAP to create a random access file to store above data and perform following operations in this file.

(a)       Write new record (b) Read / display existing record (c) Delete any record (d)Search any record (f) Lists elected records (e) close the file

22.    WAP to display records of a table using DAO & bound control code for buttons to move at first record, next record, previous record, last record in the table.

23.    Create a table using visual data manager and write a program using RDO &advanced bound control to add, delete, edit & navigate records.

24.    WAP to access a database using ADO &display a key column in the combo box or list box when an item is selected in it, its corresponding records is shown in MSH flexgrid.

25.    Using Data Environment create a program to display records of any table.

26.    WAP to generate mark sheet of students in a class through data report.

27.    WAP to illustrate various key board and mouse events.

28.    Using drive, directory and file list box (it will show only .bmp files). Let the user select the bmp files, which will appear in picture box as user click on any item in list box.

29.    Using toolbar design an interface for string manipulation. Toolbar should have tabs to

(a)     Find length of string (b) No of blank spaces in sting (c) Reverse the string Also show current date & time in status bar

SEMESTER - II

SUBJECT   - DATABASE MANAGEMENT SYSTEM LAB                 SUBJECT CODE     -PDCAP-205

MAX. MARK- 50                                                                          MIN. MARK     - 21

PRACTICAL   TASK:

1.         Using the following database,

Colleges (cname, city, address, phone, afdate) Staffs ( sid, sname, saddress, contacts) StaffJoins ( sid, cname, dept, DOJ, post, salary)

Teachings ( sid, class, paperid, fsession, tsession) Subjects ( paperid, subject,   paperno, papername)

Write SQL statements for the following –

a.       Create the above tables with the given specifications and constraints.

b.       Insert about 10 rows as are appropriate to solve the following queries.

c.        List the names of the teachers teaching computer subjects.

d.       List the names and cities of all staff working in your college.

e.        List the names and cities of all staff working in your college who earn more than15,000

f.        Find the staffs whose names start with ‘M’ or ‘R’ and ends with ‘A’ and/or 7 characters long.

g.        Find the staffs whose date of joining is2005.

h.       Modify the database so that staff N1 now works in C2College.

i.         List the names of subjects, which T1 teaches in this session or all sessions.

SEMESTER - II

SUBJECT   - DESKTOP PUBLISHING                SUBJECT CODE     -PDCAP-205

MAX. MARK- 50                                                                          MIN. MARK     - 21

PRACTICAL   TASK:

·         Use and understand basics of PageMaker.

·         Use and understand basics of adobe Photoshop.

·         Image editing.

Eligliity : 12th Passed In Any Stream

Required Documents : All Marksheets/Aadhar Card/Caste Certificate/Domicile Certificate/Ration Card/APAAR ID/Passport Photo/Mobile Number/Email ID/Gap Certifcate