Subjects Of PGDCA In GNDU

I want to do Post Graduate Diploma in Computer Applications (P.G.D.C.A.) from Guru Nanak Dev University so please tell me how many subjects are there in a course, give me there names? Also provide me the complete syllabus of PGDCA course of GNDU?

Can you provide me the syllabus of Post Graduate Diploma in Computer Applications (P.G.D.C.A.) offered by Guru Nanak Dev University, Amritsar?

[pooja]

The syllabus of Post Graduate Diploma in Computer Applications (P.G.D.C.A.) offered by Guru Nanak Dev University, Amritsar is as follows:

SEMESTER I
PAPERI: PC COMPUTING-I (MS Office) 2003

UNIT I
MS-Word: Introduction to Ms-Office, Ms-Access, Ms Excel. Parts of window of word (Title bar, menu bar, status bar, ruler) , Creation of new documents, opening document ,insert a document into another document. Page setup, margins, gutters, font properties, Alignment, page breaks, header footer deleting ,moving, replace, editing text in document. Saving a document, spell checker, printing a document. Creating a table, entering and editing, Text in tables. Changing format of table, height width of row or column Editing, deleting Rows, columns in table. Borders, shading, Templates, wizards, Drawing objects, mail merge

UNIT II
MS-Power Point: Introduction to Ms power point. Power point elements (templates wizard Views, color schemes ,Exploring power point menu (opening & closing menus, working With dialogues boxes), adding text, adding title, moving text area, resizing text Boxes, adding pictures. Starting a new slide, saving presentation, printing slides .Views (slide View slide sorter, notes view, outline view) .Formatting & enhancing text formatting, Choosing transitions. Creating a graph, displaying slide show, adding multimedia Slide transitions Timing slide display, adding movies & sounds Using a pick look Wizards to change format.

UNIT III
MS-Excel: Introduction to Worksheet/Spreads, Features of excel. Describe the excel Window, different functions on different data in excel, creation of graphs, editing it and formatting, changing chart type to 2d chart or 3d chart, creation of worksheet, adding, deleting, moving the text in worksheet, linking different sheets, sorting the data, querying the data, filtering the data (auto and advance filters), What-if analysis, printing a worksheet. MS-Access: Introduction, Understanding Databases. Creating the tables entering records in table, deleting table, modifying table fields, linking tables, Queries Forms, formatting forms, relating a form to tables, Reports(building reports, formatting report. displaying the information of table using reports Adding Graphs to your reports.

References:
1. PC Computing by R.K. Taxali. 2. PC Software by Rachpal Singh & Gurinder Singh


Syllabus P.G.D.C.A Guru Nanak Dev University, Amritsar