CIT Course Syllabus Overview

Module 1: Computing Fundamentals & Operating Systems

• Introduction to IT: Evolution of computers, generations, and types of computer systems.
• Hardware Essentials: Understanding CPU, RAM, ROM, storage devices (HDD, SSD), and input/output peripherals.
• Operating Systems: * Installation, configuration, and file management.
• Hands-on training with Windows and an introduction to Linux environments.
• Data Representation: Binary, octal, and hexadecimal number systems.

Module 2: Office Automation & Productivity Tools

• Word Processing: Advanced formatting, mail merge, tables, and document layout design.
• Spreadsheet Applications: Formulas, functions ($VLOOKUP$, $IF$ statements), data sorting, filtering, and pivot tables.
• Presentation Software: Creating professional slide decks, transitions, animations, and multimedia integration.

Module 3: Database Management Concepts

• Introduction to Databases: Understanding DBMS architecture, tables, fields, and keys (Primary & Foreign keys).
• SQL Basics: Writing basic queries to create tables, insert data, and retrieve information using SELECT, WHERE, and JOIN clauses.

Module 4: Networking Essentials & Internet Technologies

• Network Basics: LAN, WAN, MAN topologies, and the OSI model.
• Internet Protocols: Understanding TCP/IP, IP addressing, DHCP, and DNS.
• Web & Security Basics: Safe browsing practices, firewalls, introduction to cloud computing, and email configuration.

Module 5: Programming Principles & Web Development

• Logic & Algorithms: Flowcharts, pseudo-code, and problem-solving logic.
• Front-End Web Development: * HTML5: Structuring web content.
• CSS3: Styling, layouts, and responsive design fundamentals.
• Introduction to Scripting: Basic programming concepts (variables, loops, conditions) using JavaScript or Python.