MS Office/ CUC Syllabus
Week 1: Introduction to Computers and MS Paint
- Introduction to Computer, Mouse, Keyboard, UPS, Desktop
- MS Paint: Pencil, Eraser, Toolbox, Color Filling Image Option
Week 2: MS Paint Tools and Basic Operations
- MS Paint: Tool Options, Clipboard, Save & Save As, Cut, Copy, etc.
- Notepad/WordPad: Font, Font Color, Size, Face, Font Styles, Page Setup
Week 3: MS Paint and Notepad/WordPad Operations
- MS Paint: Tools Options, Clipboard, Cut, Copy, Paste, etc.
- Notepad/WordPad: Edit Menu (Cut, Copy, Paste, Find, Replace)
Week 4: Computer Properties & Basic Typing
- Computer Properties: Popup Menu, Personalize, Gadgets, Screen Resolution, Task Bar
- Typing Practice (Hindi/English)
Week 5: Control Menu and Folder Management
- Control Menu: Mouse, Keyboard, Display, Fonts, Folder Options, Add & Remove Programs, Date & Time
- Folder Management: Creating, Deleting, Renaming, Moving, and Organizing Files
Week 6: MS Word 2003/2007 Basics
- Introduction to MS Word: Title Bar, Menu Bar/Ribbon, Toolbars, Ruler, Taskbar, Status Bar
- Basic Tools: Office Button, New, Open, Save, Print, Print Preview
Week 7: Word Formatting and Basic Editing
- Quick Access Toolbar: Undo, Redo, Cut, Copy, Paste, Find, Replace
- Formatting: Font, Font Style, Size, Format Painter (Word 2003 & 2007)
Week 8: Advanced Word Functions
- Home: Paragraph Formatting, Bullets, Numbering, Border & Shading, Alignment, Change Case
- Page Layout: Themes, Page Setup, Page Background, Paragraph Setting
Week 9: MS Word: Inserting and Formatting
- Inserting Pictures, Clipart, Shapes, SmartArt, Hyperlinks, Headers/Footers, Page Numbers
- Mail Merge: Labels, Envelopes, Start Mail Merge
Week 10: MS Excel Basics
- Introduction to MS Excel: Spreadsheet, Worksheet, Workbook, Rows, Columns, Cells
- Quick Access Toolbar: Undo, Redo, Cut, Copy, Paste, Office Clipboard
Week 11: Excel: Data Formatting and Basic Functions
- Home: Font Formatting, Alignment, Merge Cells, Wrap Text, Number Formatting
- Introduction to Excel Functions: SUM, AVERAGE, PERCENTAGE, Count, SumIf
Week 12: MS Excel: Advanced Data Tools
- Sorting, Filtering, Data Validation, Consolidation, What-If Analysis (Goal Seek, Scenario, Data Table)
- Using Pivot Tables and Charts
Week 13: MS Excel: Advanced Formulas and Functions
- Advanced Formulas: Logical Functions (IF, AND, OR, NOT), Text Functions (Concatenate, Left, Right, etc.)
- Financial Functions: SLN, PMT, Lookup Functions, Define Names
Week 14: MS PowerPoint Basics
- Introduction to MS PowerPoint: Slides, Handouts, Speaker Notes, Media Clips, Organizational Charts
- Basic Operations: Home Tab (New Slide, Layout, Font, Paragraph)
Week 15: PowerPoint Design and Animation
- PowerPoint Design: Page Setup, Themes, Colors, Fonts, Effects
- Animation: Custom Animation, Transitions, Slide Timings
Week 16: PowerPoint View and Slide Show
- PowerPoint View Options: Normal, Slide Sorter, Notes Page, Slide Master
- Slide Show: Custom Slide Show, Narration, Rehearse Timings
Week 17: PowerPoint Practice
- PowerPoint Assignment Practice
Week 18: Introduction to the Internet
- Basic Concepts: Websites, Web Pages, ISP, Connection Types, HTTP, URL, Browsers, Email (Sending and Receiving Attachments)
Week 19: Google Search and Social Media
Week 20-22: Internet Practice
- Hands-on practice with browsing, searching, and using Internet tools.