Syllabus PGDCA Guru Nanak Dev University

as I am doing PGDCA from Guru Nanak Dev University for study purpose looking for its syllabus , so can you plz here provide me

[Shaleen]

On your demand I am providing Guru Nanak Dev University PGDCA Syllabus

SEMESTER – I
PAPER–I: 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, 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.

To complete syllabus here I am providing pdf