Course Syllabus
Module 1: Fundamentals of Computers & IT
- Hardware & Architecture: Central Processing Unit (CPU), Motherboard, input/output peripheral devices, and SMPS.
- Memory & Storage: RAM, ROM, secondary storage devices, and data processing concepts.
- Data Representation: Binary, Octal, Decimal, and Hexadecimal number systems and conversions.
AdmitKard +3
Module 2: Operating Systems (OS) & Desktop Utilities
- Windows OS: Desktop customization, Control Panel configurations, Windows accessories, and file management.
- Command Line Systems: Basic Disk Operating System (DOS) structures and Linux terminal essentials.
AdmitKard +2
Module 3: Office Automation – Part I
- Word Processing (MS Word / Docs): Text layout formatting, page borders, templates, tables, and Mail Merge tools.
- Data Processing & Typing: Data entry protocols alongside English and local-language typing drills.
Mangalayatan University +2
Module 4: Internet Basics & Computer Networking
- Network Foundations: LAN, MAN, WAN categories, and common network topologies (Star, Bus, Ring, Mesh).
- Web Use: Web browsers, search algorithms, and official email communication protocols.
VedantSri +3
Semester 2: Advanced Software Applications & Programming
Module 5: Office Automation – Part II
- Advanced Spreadsheets (MS Excel / Sheets): Mathematical functions, lookup tools, formulas, data filters, macros, and Pivot Tables.
- Multimedia Presentations (MS PowerPoint): Building interactive slide decks, animations, and transitions.
Indian Institute of Skill Development Training +3
Module 6: Database Management Systems (DBMS)
- Database Concepts: Relational database structures, keys, and table creation.
- SQL Administration: Running DDL/DML commands, database queries (
SELECT, WHERE, LIKE), and basic table manipulation via MySQL or MS Access.
Makhanlal Chaturvedi Rashtriya Patrakarita Evam Sanchar Vishwavidyalaya +2
Module 7: Foundations of Programming
- Coding Concepts: Introduction to variables, algorithms, flowcharts, arrays, and control structures.
- Core Languages: Foundational programming syntax utilizing C, C++, or Python.
Mangalayatan University +2
Module 8: Web Designing & Digital Applications
- Frontend Web Development: Creating basic web structures using HTML, CSS style definitions, and basic JavaScript triggers.
- Commercial Applications: Fundamental operations of financial accounting using Tally ERP/Prime, basic graphic tools (e.g., Photoshop), and foundational cybersecurity practices.
Mangalayatan University +2
Evaluation Components
- Theory Examinations: Semester-end written papers covering IT theory, architecture, and programming logic.
- Practical Lab Work: Hands-on assessment evaluating live database queries, spreadsheet calculations, and coding.
- Capstone Project: A final submission combining database integration, responsive web pages, or a foundational program script.