The syllabus of Post Graduate Diploma in Computer Applications (P.G.D.C.A.) Program offered by Faculty of Engineering & Technology of Guru Nanak Dev University is as follows:
SEMESTER – I
PAPER–I: PC COMPUTING-I (MS Office) 2003
Time: 3 Hrs. Max. Marks: 100
Theory: 50
Practical: 50
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, A!ignment, 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 
