PGDCA PC Package Syllabus Notes
UNIT–I
1. Office Packages: Office activates and their software requirements
2. various office suites like MS-Office, Lotus-Office, Star-Office, Open-Office etc.
3. MS Word Basics:
- Introduction to MS Office
- Introduction to MS Word
- Features of MS Word
- Working with MS Word
- Menus & Commands
- Toolbars & Buttons
- Shortcut Keys
- Wizards & Templates
- Creating a New Document
- Different Page Views and layouts
- Applying various Text Enhancements
- Working with -Styles
- Text Attributes
- Paragraph and Page Formatting
- Bullets and Numbering
- Auto formatting
- Printing & various print options
UNIT–II
4. Advanced Features of MS-Word:
5. Inserting
8. Creation & Working with Tables including conversion to and from text
9. Margins & Space management in Document
10. Adding References and Graphics
11. Mail Merge
13. Importing and exporting to and from various formats.
UNIT–III
14. MS Excel:
- Introduction and area of use
- Working with MS Excel
- Toolbars
- Menus
- 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
- Using different features with Data and Text
- Cell Formatting including Borders & Shading
UNIT–IV
15. Advanced Features of MS Excel:
- Multiple Worksheets: Concept
- Creating Worksheet
- Using Multiple Worksheets
- Use of Formulas
- Functions and Various types of Functions
- Cell Referencing
- Absolute and Relative Addressing
- Working with Different Chart Types
- Chart Wizard
- Printing of Workbook & Worksheets with various options
16. Database:
17. Creating and Using Macros
UNIT–V
18. MS PowerPoint:
- Introduction & area of use
- Creating a New Presentation
- Working with Presentation
- How to save a presentation
- its different views
- Inserting, Deleting and Copying of Slides
- Working with Speaker Notes
- Handouts
- Columns & Lists
- Slide Layout and its types
- Adding Graphics
- Sounds and Movies to a Slide
- Working with PowerPoint Objects
- Designing & Presentation of a Slide Show
- Printing Presentations with print options