📘 Module 1: Introduction to Computer Basics

Topics Covered

• What is a computer: hardware, software, input & output devices

• Operating systems (Windows basics)

• File and folder management

• Keyboard shortcuts and essential computer operations

• Basic troubleshooting

• Introduction to internet usage

• Email creation and handling

• Understanding Cloud Storage (Google Drive, OneDrive)

Outcome

Students gain confidence in operating computers independently for study, office work, or personal use.

📘 Module 2: MS Excel (Beginner to Advanced)

Topics Covered

Beginner Level

• Understanding Excel interface

• Data entry, formatting, shortcuts

• Basic formulas: SUM, AVERAGE, MIN, MAX

• AutoFill, Flash Fill

• Basic charts

Intermediate Level

• Conditional formatting

• Data Validation

• Sorting & Filtering

• Pivot Tables & Pivot Charts

• Text functions (LEFT, RIGHT, MID, TRIM, LEN)

• Logical functions: IF, AND, OR

• Lookup functions: VLOOKUP, HLOOKUP, XLOOKUP

Advanced Excel

• Power Query basics

• Creating dashboards

• Automation using Macros

• Scenario & What-If analysis

• Protecting sheets & data security

Projects

• Sales dashboard

• Attendance tracker

• Finance calculation sheet

• HR payroll Excel project

📘 Module 3: Power Apps & Canvas Apps

Topics Covered

• What is Power Apps?

• Introduction to Canvas Apps

• Creating your first app from scratch

• Data sources: SharePoint, Excel, Dataverse

• Building forms and screens

• Adding controls, galleries, dropdowns, filters

• Power Fx Functions (If, Patch, Navigate, Lookup)

• App design fundamentals

• Connecting Power Apps with Power Automate

• Publishing & sharing apps within an organization

Real-Time Projects

• Employee attendance app

• Expense tracker app

• Student registration app

• Task management app

By the end, learners can build fully functional business apps without coding.

📘 Module 4: CCC (Course on Computer Concepts) Preparation

Topics Covered

• Introduction to IT

• Microsoft Office (Word, Excel, PowerPoint)

• Internet & web concepts

• Email & communication tools

• Digital payments (UPI, AEPS, Wallets)

• Cybersecurity basics

• Practice questions & mock tests