Module – 2 Office Automation Package
1. Keyboard basics,
2. Correct way of typing,
3. Alphabet Placement and Positioning
4. Typing with various keys
5. Speed typing
6. Using shortcut keys
Unit 2- Word Processing
1. Getting started
2. The word interface
3. Backstage View (Creating, opening and saving document, document properties),
4. Entering and editing Text
5. Paragraph creation,
6. Moving text (Cut, Copy & Paste),
7. Holding multiple items in clipboard
8. Undo, Redo,
9. Using Shortcuts
10. Zoom In-Out
11. Converting to PDF
1. Setting font styles, size, color
2. Typeface (Bold, Italic, Underline)
3. Font Effects
4. Change case
5. Highlighting, paragraph indenting
6. Alignments
7. Line Spacing
8. Drop cap,
9. Bullets & Numberings
10. Borders & Shading
11. Heeader & Footer
12. Footnote & Endnote
13. Inserting Page break,
14. Page numbering, Date & Time
15. Line break
16. Word wrap
17. Creating cover page
18. Page border
19. Tables of Contents
20. Using Page Themes & Color
21. Inserting Watermarks
1. Page Orientation
2. Setting page margins,
3. Page Size
4. Columns
5. Page Setup & Printing
1. Inserting cliparts
2. Inserting pictures
3. Insering Textboxes and other files
4. Formatting & Editing Pictures
5. Picture styles,
6. Picture borders,
7. Picture effects & layouts
8. Positioning,
9. Grouping & Ordering
10. Rotating and cropping,
11. Adding and Editing Shapes & SmartArt,
12. Inserting Various types of charts
13. Charts layout & Formating
1. Creating tables
2. Table Styles
3. Borders & Shadings
4. Cell Alignment,
5. Inserting & Deleting rows or columns,
6. Merging
7. Splitting
8. Sorting
9. Using formula
10. Converting table into graphs
1. Find & Replacce
2. Auto Correct,
3. Bookmarks
4. Hyperlinks & CrossReference,
5. Spell Check
6. Thesaurus
7. Macros
8. Mail merge
9. Track change
10. Document protection & Security
Unit 3- Spreadsheet
1. Creating a Spreadsheet
2. Entering data into spreadsheet
3. Rows, Columns & Cells
4. Selecting range
5. Cell Addressing,
6. Filling continuous rows & columns
7. Inserting, Deleting or Hiding a Row, Column or
8• Creating text, number and date series.Worksheet
1. Mathematical Operations (Addition, Subtraction, Multiplication,
2. Creating & Copying Formulas and Using Functions,
3. Cell Referencing (Absolute,
4. Cube 3D Formula
5. HLookup & VLookup
1. Formatting cells (Setting Fonts,
2. Text Decoration
3. Setting background colors
4. Text Alignment,
5. Merge & Wraps,
6. Border & Shading),
7. Formatting worksheet (page orientation)
8. Adjusting Margins,
9. Header & Footer
10. Insert page break
11. Set background
12. Freeze panes
13. Conditional Formating
1. Data Sorting & Filtering
2. Creating Data List,
3. Data Validation
4. Data Consolidation
5. What-if Analysis
1. Adding different types of Charts,
2. Charts layout and formatting,
3. Pivot tables & Charts
1. Find & Replace,
2. Spell Check,
3. Thesaurus
4. Macros
5. Track Changes
6. Workbook & Worksheet Protection,
7. Page Setup & Printing
Unit 4- Digital Presentation
1. Creating, Opening and saving a presentation
2. Save as PDF,
3. Image or Video file
4. Selecting Presentation Layouts
5. Applying themes & background
6. Add & Delete Slides
7. What is a Placeholder,
8. Adding Text to a slide,
9. PowerPoint Views,
10. Printing handouts
• Creating a Presentation using Template
• Creating a Blank Presentation
• Opening and saving a Presentation
• Entering and Editing Text
• Inserting and Deleting Slides in a Presentation
and slides
• Creating a Presentation using Template
• Creating a Blank Presentation
• Opening and saving a Presentation
• Entering and Editing Text
• Inserting and Deleting Slides in a Presentation
1. Setting Font size & style
2. Formatting Text Color
3. Text Alignment
4. Insert a Textbox
5. Adding Header & Footer
6. Using Slide Master
• Applying Themes & Background
• Adding Pictures, Textbox, Tables, Charts, Shapes, Word Tables or Excel Worksheets
•
3. Inserting Objects & Multimedia-
1. Inserting Tables, Charts, Shapes and other objects
2. Adding text to shape
3. Group Ungroup Objects
4. Creating Photo Album,
5. Inserting and Formatting pictures, cliparts, movies
6. Setting Animation & Transition effects,
7. Adding Audio & Video
• Save as PDF, Image or Video file, PowerPoint Views, Printing handouts and slides.