Module 1

Computer Fundamentals

• Definition & Characteristics of Computer
• Applications of Computers
• Components of a Computer System
• Input & Output Devices
• Hardware & Software
• Files & Folders Management
• Installing Applications & Shortcuts
• Control Panel Overview
• Taskbar & Desktop Management

Module 2

Operating System – Windows

• Desktop, Icons, Taskbar, Start Menu
• Windows Explorer – Files & Folders
• Recycle Bin, Window Operations
• Control Panel Settings
• Themes, Wallpaper, Screensaver
• Mouse Operations
• Creating Shortcuts
• Notepad & Windows Accessories

Module 3

MS Word – Word Processing

• Font Formatting & Effects
• Cut, Copy, Paste, Undo, Redo
• Paragraph Formatting, Lists
• Margins, Headers & Footers
• Spell Check & Grammar
• Tables – Insert, Merge, Split
• Pictures, Shapes, WordArt

Module 5

MS PowerPoint – Presentation

• Create & Manage Presentations
• Slide Layouts, Themes, Backgrounds
• Tables, Shapes, Images, WordArt
• Animations & Transitions
• Video, Audio, Hyperlinks

Module 4

MS Excel – Spreadsheet

• Excel Interface, Cells, Rows, Columns
• Formatting (Numbers, Text, Dates)
• Formulas & Operators
• Basic Functions (SUM, AVERAGE, MIN, MAX)
• Charts & Graph Types
• Page Setup & Printing
• Advanced Excel:
• VLOOKUP, HLOOKUP
• INDEX + MATCH
• IF, Nested IF, Grade Formula
• SUMIF, COUNTIF
• FILTER Function
• INDIRECT
• CHOOSE Function
• EMI (PMT Formula)
• Date & Time Formulas
• Absolute & Relative Cell Reference

Module 6

Internet & Communication

• Internet Basics & Browsers
• Searching Information Online
• Email Setup & Management
• Sending/Receiving Emails
• Attachments & Email Settings

Module 7

Typing Skills

• English Typing Practice
• Speed Improvement Techniques
• Accuracy Training