|
Computer Fundamentals
|
|
|
|
Introduction to Computers, History & Generations
|
|
|
|
Types of Computers (Micro, Mini, Mainframe, Super)
|
|
|
|
Input & Output Devices
|
|
|
|
Hardware vs Software, Application vs System Software
|
|
|
|
Number Systems & Conversions (Binary, Decimal)
|
|
|
|
Introduction to Operating Systems (Windows vs Linux)
|
|
|
|
File & Folder Structure in Windows
|
|
|
|
Control Panel & System Settings
|
|
|
|
OS Utilities & Troubleshooting Basics
|
|
|
|
Quiz + Assignment
|
|
|
Operating Systems
|
|
|
|
Functions of Operating System
|
|
|
|
Types of Operating Systems
|
|
|
|
File Management
|
|
|
MS Word
|
|
|
|
Word Basics, Page Setup, Formatting, Paragraphs
|
|
|
|
Tables, Header/Footer, Sections, Page Numbers
|
|
|
|
Mail Merge & Templates
|
|
|
|
Quiz + Assignment
|
|
|
MS Power Point
|
|
|
|
PowerPoint Basics, Slide Design & Layout
|
|
|
|
Inserting Charts, SmartArt, Transitions
|
|
|
|
Slide Master, Themes, Rehearse Timings
|
|
|
|
Word + PowerPoint Integration Exercise
|
|
|
|
Quiz + Assignment
|
|
|
MS Excel
|
|
|
|
Excel Interface, Data Types, Cell Referencing
|
|
|
|
Basic Formulas (SUM, AVERAGE, COUNT, etc.)
|
|
|
|
Sorting, Filtering, Conditional Formatting
|
|
|
|
Data Validation & Dropdowns
|
|
|
|
Working with Charts (Column, Pie, Bar, Line)
|
|
|
|
Freeze Panes, Print Setup, Page Breaks
|
|
|
|
IF, AND, OR, Nested Functions
|
|
|
|
Introduction to Lookup Functions (VLOOKUP)
|
|
|
|
Mini Project: Excel Data Report
|
|
|
|
Quiz + Assignment
|
|
|
Networking and Internet Technologies
|
|
|
|
Introduction to Internet, Browsers, IP Address
|
|
|
|
Creating & Managing Gmail Account
|
|
|
|
Google Drive: Docs, Sheets, Slides
|
|
|
|
Using Search Engines & Online Tools (PDF, Compressors)
|
|
|
|
Online Safety: Phishing, Passwords, 2FA
|
|
|
|
Cyber Hygiene & Digital Footprint
|
|
|
|
Cloud Storage vs Local Storage
|
|
|
|
File Conversion & Management (Word to PDF, etc.)
|
|
|
|
Practical Test: Email with Attachment + Google Forms
|
|
|
|
Quiz + Assignment
|
|
|
Typing & Data Entry
|
|
|
|
English Typing Speed Test (Typing Master)
|
|
|
|
Home Row Keys & Accuracy Techniques
|
|
|
|
Practicing Data Forms (Survey/Entry Forms)
|
|
|
|
Online Form Filling Practice (Bank, Govt. Forms)
|
|
|
|
Numeric Keypad Data Entry
|
|
|
|
Speed Test & Assessment
|
|
|
|
Quiz + Assignment
|
|
|
Mini Project + Evaluation
|
|
|
|
Project: Create Resume (Word) + Expense Report (Excel) + Presentation (PPT)
|
|
|
|
Review & Improve Projects
|
|
|
|
Practical Test (Word, Excel, PPT)
|
|
|
|
Viva Preparation
|
|
|
|
Viva + Internal Exam
|
|
|
Advanced Excel for Analytics
|
|
|
|
Recap of Excel Basics + Named Ranges
|
|
|
|
Logical Functions (IF, IFS, AND, OR)
|
|
|
|
Lookup Functions (VLOOKUP, HLOOKUP)
|
|
|
|
XLOOKUP & INDEX-MATCH
|
|
|
|
Text Functions (LEFT, RIGHT, MID, CONCATENATE)
|
|
|
|
Date & Time Functions
|
|
|
|
Data Cleaning Tools: Remove Duplicates, Trim
|
|
|
|
Pivot Tables & Slicers
|
|
|
|
Dashboard Design with Excel
|
|
|
|
Quiz + Assignment
|
|
|
Power BI
|
|
|
|
Introduction to Power BI Interface
|
|
|
|
Importing Data from Excel, CSV, Web
|
|
|
|
Power Query – Data Cleaning
|
|
|
|
Visuals: Bar, Line, Pie, Map, Matrix
|
|
|
|
Filters, Slicers, Tooltips
|
|
|
|
DAX Basics (SUM, COUNT, IF, RELATED)
|
|
|
|
Creating Reports & Pages
|
|
|
|
Drill Through, Bookmarks
|
|
|
|
Publish to Power BI Service
|
|
|
|
Project: Sales Dashboard
|
|
|
|
Quiz + Assignment
|
|
|
MySQL for Data Analysis
|
|
|
|
Introduction to MySQL, DBMS Concepts
|
|
|
|
DDL Commands (CREATE, ALTER, DROP)
|
|
|
|
DML Commands (INSERT, UPDATE, DELETE)
|
|
|
|
SELECT Queries, WHERE Clause
|
|
|
|
JOINS (INNER, LEFT, RIGHT)
|
|
|
|
GROUP BY, HAVING, ORDER BY
|
|
|
|
Functions: COUNT, SUM, AVG, MAX, MIN
|
|
|
|
Views, Indexes
|
|
|
|
Subqueries + Practice Assignments
|
|
|
|
Mini Project: Student or Sales DB
|
|
|
|
Quiz + Assignment
|
|
|
Python for Data Analytics
|
|
|
|
Python Basics: Variables, Data Types
|
|
|
|
Lists, Tuples, Dictionaries
|
|
|
|
Loops & Conditional Statements
|
|
|
|
Introduction to Pandas
|
|
|
|
DataFrames, Series, CSV Handling
|
|
|
|
Data Cleaning with Pandas
|
|
|
|
NumPy Arrays & Math Functions
|
|
|
|
Data Visualization with Matplotlib, Seaborn
|
|
|
|
Mini Project using Python (e.g. Sales Analysis)
|
|
|
|
Quiz + Assignment
|
|
|
Tableau
|
|
|
|
Tableau Interface & Data Connection (Excel/CSV)
|
|
|
|
Measures, Dimensions, Data Types
|
|
|
|
Creating Bar, Line, Pie, Maps
|
|
|
|
Filters, Parameters, Sorting
|
|
|
|
Creating Dashboards & Stories
|
|
|
|
Actions, Tooltips, Highlight
|
|
|
|
Using Calculations in Tableau
|
|
|
|
Publish to Tableau Public
|
|
|
|
Project: Interactive Dashboard
|
|
|
|
Quiz + Assignment
|
|
|
Capstone Project + Interview Prep
|
|
|
|
Final Project using Excel + SQL + Power BI / Tableau
|
|
|
|
Project Review & Improvements
|
|
|
|
Resume Creation + LinkedIn Optimization
|
|
|
|
Interview Questions & Answers
|
|
|
|
Mock Interview Practice
|
|
|
|
Viva + Project Presentation
|
|
|
|
Final Assessment & Certificate Distribution
|
|