PGDCA I Sem (PC Package) According to Makhanlal University Bhopal

UNIT–I

Office Packages: Office activates and their software requirements, Word-processing, Spreadsheet, Presentation graphics, Database, introduction and comparison of various office suites like MS-Office, Lotus-Office, Star-Office,Open-Office etc. MS Word Basics: Introduction to MS Office, Introduction to MS Word, Features & area of use. Working with MSWord, Menus & Commands, Toolbars & Buttons, Shortcut Menus, Wizards & Templates, Creating a NewDocument, Different Page Views and layouts, Applying various Text Enhancements, Working with -Styles, Text Attributes, Paragraph and Page Formatting, Text Editing using various features ; Bullets, Numbering, Auto formatting, Printing & various print options

UNIT–II

Advanced Features of MS-Word: Spell Check, Thesaurus, Find & Replace; Headers & Footers, Inserting - Page Numbers, Pictures, Files, Autotexts, Symbols etc., Working with Columns, Tabs & Indents, Creation & Working with Tables including conversion to and from text, Margins & Space management in Document, Adding References and Graphics, Mail Merge, Envelops & Mailing Labels. Importing and exporting to and from various formats.

UNIT–III

MS Excel: Introduction and area of use, Working with MS Excel, Toolbars, Menus and Keyboard Shortcuts, concepts of Workbook & Worksheets, Using Wizards, Various Data Types, Using different features with Data, Cell and Texts, Inserting, Removing & Resizing of Columns & Rows, Working with Data & Ranges, Different Views of Worksheets, Column Freezing, Labels, Hiding, Splitting etc., Using different features with Data and Text, Cell Formatting including Borders & Shading,

UNIT–IV

Advanced Features of MS Excel: Multiple Worksheets: Concept, Creating and Using Multiple Worksheets; Use of Formulas, Calculations & Functions, Various types of Functions, Cell Referencing,Absolute and Relative Addressing, Working with Different Chart Types, Chart Wizard, Printing of Workbook & Worksheets with various options, Database: Creation, Sorting, Query and Filtering a Database; Creating and Using Macros;

UNIT–V

MS PowerPoint: Introduction & area of use, Working with MS PowerPoint, Creating a New Presentation, Working with Presentation, Using Wizards; Slides & its different views, Inserting, Deleting and Copying of Slides; Working with Notes, Handouts, Columns & Lists, Adding Graphics, Sounds and Movies to a Slide; Working with PowerPoint Objects, Designing & Presentation of a Slide Show, Printing Presentations, Notes, Handouts with print options.