Category: Computer

Month 1: Basic Computer Fundamentals & Operating Systems (Weeks 1–4)

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.

Month 2: Application Software — MS Word & MS PowerPoint (Weeks 5–8)

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).

Month 3: Application Software — MS Excel, Database Basics & Capstone (Weeks 9–12)

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.

Top