Goal: Build complete operational fluency in computer hardware basics, Windows 10/11 administration, system utilities, and internet productivity.
Week 1: Computer Fundamentals & Hardware Architecture
Generations and types of computers, CPU architecture, primary/secondary memory (RAM, ROM, SSD, HDD), input/output devices, and peripheral connections.
Keyboard mastery and touch-typing fundamentals (targeting 25–30 WPM).
Week 2: Windows 10/11 Operating System & File Management
Desktop environment, File Explorer, folder hierarchy, file extensions, compression (ZIP/RAR), Control Panel, Windows Settings, and Task Manager.
Essential built-in utilities: Notepad, WordPad, Paint, Snipping Tool, and PDF readers/converters.
Week 3: OS Administration, System Utilities & Linux Overview
Creating bootable USB drives, overview of Windows 10/11 installation, GPT vs. MBR partitioning, and Disk Management.
User account control, device drivers, Disk Cleanup, Defragmentation, System Restore, Windows Defender/Antivirus, and a practical overview of Ubuntu Linux desktop navigation.
Week 4: Internet, Cloud Productivity & Month-1 Exam
Web browsers, search operators, online form filling, Google Drive/Docs/Sheets, professional email writing (To, CC, BCC, attachments), and cyber hygiene.
Month-1 Evaluation: Typing speed & OS file-management/partitioning practical test + 30-minute theory quiz.
Goal: Master professional document drafting, automated bulk mailings, and corporate presentations.
Week 5: MS Word — Formatting & Document Structure
Page setup, margins, orientation, paragraph styles, bullets/numbering, tables, headers/footers, page numbering, and watermarks.
Week 6: MS Word — Advanced Productivity & Official Drafting
Mail Merge for bulk letters, labels, and certificates; Macros; Track Changes; Table of Contents; hyperlinks; and print-ready PDF exports.
Week 7: MS PowerPoint — Slide Design & Visuals
Slide layouts, Slide Master, themes, SmartArt, charts, tables, and embedding audio/video media.
Week 8: MS PowerPoint — Animations & Month-2 Exam
Custom animations, slide transitions, rehearsal timings, presenter view, and exporting presentations as videos/PDFs.
Month-2 Evaluation: Create a formatted multi-page report with Mail Merge (Word) and an 8-slide business/academic presentation (PowerPoint).
Goal: Master workplace data analysis in Excel, understand basic database management, and complete an end-to-end office project.
Week 9: MS Excel — Core Formulas & Spreadsheet Fundamentals
Workbook navigation, relative vs. absolute cell referencing, cell formatting, sorting, filtering, and SUM, AVERAGE, COUNT, MIN/MAX.
Week 10: MS Excel — Logical, Conditional & Lookup Functions
Conditional and lookup formulas: IF, AND, OR, COUNTIF, SUMIF, VLOOKUP, XLOOKUP, and date/text manipulation functions.
Week 11: MS Excel Data Analysis & MS Access Basics
Conditional formatting, Data Validation dropdowns, Pivot Tables, Pivot Charts, and print page-break setup in Excel.
Introduction to MS Access: creating database tables, primary keys, data-entry forms, and printable reports.
Week 12: Final Integrated Capstone & Certification Exam
Capstone Project: Configure a clean Windows user workspace and build an integrated office portfolio comprising a formatted company letterhead & Mail Merge notice (Word), a 6-slide summary deck (PowerPoint), and an automated employee attendance/sales tracker (Excel).
Final Certification Exam: Practical workstation exam + viva voce covering Basic Computer, Operating Systems, and Application Software.
Call us at:
+91-9779600740, 9855474016