Computer Fundamentals
Introduction to Computer Systems
Evolution of computer
Computer generation & types of computer
Understanding system software & application software
Windows 11 Operating System
Overview of Windows 11 interface and features
Navigation through Start Menu, Taskbar, and Windows Explorer
File Management in Windows 11
Windows 11 Advanced Features
Text Editing and Drawing Tools
Introduction to Paint
Introduction to Notepad
Introduction to Wordpad
English Typing & Local language
Microsoft Word
Introduction to MS Word application
Creating, formatting, and editing documents
Using styles, headings, and sections
Inserting tables, images, and charts
Mail merge and creating professional documents
MS word back stage view
MS word cover page design
MS word header & Footer
MS word page setup and printing
MS word- Document proofing
Use of AI in MS Word
Microsoft Excel
Introduction to Excel
Data Entry and Formatting
Basic Formulas and Functions
Working with Data
Cell Referencing and Range Selection
Basic Data Visualization
Working with Worksheets
Basic Conditional Formatting
Printing and Page Layout
Data Validation
Basic Excel Shortcuts and Tips
AI in Excel
Microsoft PowerPoint
Introduction to PowerPoint
Creating and Formatting Slides
Adding and Formatting Content
Text Formatting and Styles
Designing for Impact
Animations and Transitions
Multimedia and Interactive Elements
Presenting and Delivering a PowerPoint
Advanced PowerPoint Features
Internet & email Technology
Introduction to the Internet
Basic Internet Navigation
Understanding Online Content
Introduction to Email
Composing and Sending Emails
Email Etiquette
Managing Email Folders
Safety and Security on the Internet
Internet Services and Tools
HTML and CSS
Introduction to Web Development
Introduction to HTML (Hypertext Markup Language)
HTML Document Structure and Tags
Introduction to CSS (Cascading Style Sheets)
Styling Text and Fonts
Colors and Backgrounds in CSS
Advance IT
Introduction to Tally
Learn creativity on Photoshop
Learn creativity on CorelDraw
Intro to PC Hardware
Microsoft Excel for professional use
SUMIFS, COUNTIFS, AVERAGEIFS
VLOOKUP / HLOOKUP
INDEX and MATCH
IF, AND, OR (Nested IF)
Pivot Tables and Pivot Charts
Data Validation
Power Pivot and Data Models
Macros and VBA (Visual Basic for Applications)
Text Functions
Linking Data Across Sheets and Workbooks
Excel Data Analysis
Microsoft Power BI
Data Import and Transformation in Power BI
Data Visualization in Power BI
Google Suite and Drive
Introduction to Google Suite & Cloud storage
Cloud storage and sharing
Introduction to Google Docs for word processing
Introduction to Google Sheets
presentation Using Google Slides
Collaboration features in Sheets, Slides, documents in real-time
Google Forms
Website Deploying in real world
Introduction to Artificial Intelligence
Basics of AI and its applications
Overview of machine learning and neural networks
AI Tools for Data Analysis
Real world AI Application for content development
Real world AI Application for graphics processing
Real world AI application for motion graphics
Final Project and Revision
Comprehensive project integrating the skills learned: Excel, Power BI, Google Suite, and AI tools.
Example Project: Create an interactive dashboard using Power BI with data from Google Sheets.
