Semester 1 – Computer Fundamentals & Office Applications

1. Computer Fundamentals

• Introduction to Computers
• History and Generations of Computers
• Types of Computers
• Components of a Computer
• Hardware and Software
• Input and Output Devices
• Memory and Storage Devices
• CPU and its Functions
• Operating Systems
• Basic Troubleshooting
• Computer Safety and Maintenance

2. Windows & Computer Operations

• Introduction to Windows
• Desktop and Start Menu
• Files and Folders
• File Management
• Installing and Uninstalling Software
• System Settings
• Basic System Maintenance
• Keyboard and Mouse Operations
• Common Windows Shortcuts

3. MS Word

• Creating and Saving Documents
• Text Formatting
• Paragraph Formatting
• Page Setup
• Tables
• Images and Shapes
• Headers and Footers
• Page Numbers
• Mail Merge
• Printing Documents
• Creating Letters, Applications and Reports

4. MS Excel

• Introduction to Spreadsheets
• Rows, Columns and Cells
• Data Entry and Formatting
• Basic Formulas
• Functions
• Sorting and Filtering
• Tables
• Charts and Graphs
• Page Setup and Printing
• Basic Data Analysis

5. MS PowerPoint

• Creating Presentations
• Slide Layouts
• Text and Images
• Tables and Charts
• Themes and Templates
• Transitions
• Animations
• Slide Show
• Presentation Techniques

6. Internet & Email

• Introduction to Internet
• Web Browsers
• Search Engines
• Effective Internet Searching
• Email Account Management
• Sending and Receiving Emails
• Attachments
• Email Etiquette
• Cloud Storage
• Online Forms

7. Computer Typing

• English Typing
• Regional Language Typing
• Keyboard Familiarization
• Typing Practice
• Speed and Accuracy
• Document Typing
• Basic Data Entry

8. Digital Literacy

• Digital Payments
• Online Banking Basics
• Digital Documents
• Online Applications
• Government Online Services
• Downloading and Uploading Documents
• Scanning and Printing
• PDF Creation and Management

9. Computer Networking – Basic

• Introduction to Networking
• LAN, MAN and WAN
• Network Devices
• Modem and Router
• Wi-Fi
• IP Address – Basic Concept
• Internet Connection
• File and Printer Sharing
• Basic Network Troubleshooting

10. Cyber Security & Digital Safety

• Introduction to Cyber Security
• Password Security
• Malware and Viruses
• Phishing and Online Fraud
• Safe Browsing
• Data Privacy
• Social Media Safety
• Antivirus
• Backup and Data Protection

Semester 2

11. Advanced MS Excel

• Advanced Formulas
• IF Functions
• COUNTIF and SUMIF
• VLOOKUP / XLOOKUP – Basic Introduction
• Conditional Formatting
• Data Validation
• Advanced Sorting and Filtering
• Charts
• Pivot Tables – Basic
• Practical Data Management

12. Computerized Accounting – Tally

• Introduction to Accounting
• Introduction to Tally
• Company Creation
• Ledger and Groups
• Voucher Entry
• Sales and Purchase
• Receipt and Payment
• Inventory Management
• GST – Basic Concepts
• Reports and Statements
• Practical Accounting Exercises

13. Graphic Design – Basic

• Introduction to Graphic Design
• Design Principles
• Digital Images
• Image Editing
• Basic Photoshop / Alternative Graphics Software
• Cropping and Resizing
• Background Removal
• Text and Typography
• Posters and Banners
• Social Media Graphics

14. Desktop Publishing

• Introduction to DTP
• Page Layout
• Text Formatting
• Image Placement
• Visiting Card Design
• Certificate Design
• Brochure Design
• Pamphlet Design
• ID Card Design
• Printing and Exporting

15. Database Management – Basic

• Introduction to Database
• Database Concepts
• Tables and Records
• Fields and Data Types
• Creating a Database
• Data Entry
• Queries
• Forms
• Reports
• Basic Database Management

16. Web Designing

• Introduction to Websites
• Web Browsers and Web Servers
• HTML Fundamentals
• HTML Tags
• Text and Formatting
• Links
• Images
• Tables
• Forms
• Introduction to CSS
• Basic Website Creation

17. Basic Programming with Python

• Introduction to Programming
• Introduction to Python
• Variables
• Data Types
• Operators
• Input and Output
• Conditional Statements
• Loops
• Lists and Dictionaries
• Functions
• Simple Python Programs

18. Computer Hardware & Troubleshooting

• Computer Hardware Components
• Motherboard
• Processor
• RAM
• Hard Disk / SSD
• SMPS
• Keyboard and Mouse
• Monitor
• Printer
• Hardware Installation
• Software Installation
• Common Computer Problems
• Basic Troubleshooting

19. Digital Marketing – Basic

• Introduction to Digital Marketing
• Social Media Platforms
• Content Creation
• Basic SEO Concepts
• Social Media Marketing
• Email Marketing
• Online Advertising – Basic
• Website Promotion
• Digital Branding

20. Employability & Professional Skills

• Communication Skills
• Resume Preparation
• Interview Skills
• Workplace Etiquette
• Professional Email Writing
• Office Management
• Teamwork
• Time Management
• Customer Service
• Freelancing – Basic Introduction

Practical Training

Students should receive practical training throughout the course in:

• Computer Operation
• MS Office
• Internet and Email
• Typing and Data Entry
• Excel Data Management
• Tally and Accounting
• Graphic Design
• DTP
• Database
• Web Designing
• Python Programming
• Hardware Troubleshooting
• Digital Marketing