Introduction to Computer Systems

Evolution of computing devices, components of a computer system, input/output devices, memory types, data security, and types of software (system and application).

Python Programming Fundamentals

Basics of Python: syntax, operators, data types, expressions, control statements, loops, lists, and dictionaries.

Introduction to NumPy and creating arrays from lists.

Database Concepts & SQL (Class XI)

Introduction to databases and RDBMS, data models, and SQL operations: CREATE, SELECT, INSERT, UPDATE, DELETE, and filtering with WHERE, BETWEEN, and logical operators.

Emerging Technologies

Overview of AI, Machine Learning, NLP, AR/VR, Robotics, Big Data, IoT, Cloud and Grid Computing, and Blockchain technology.

Data Handling with Pandas (Class XII)

Working with Pandas Series and DataFrames: creation, indexing, slicing, and performing operations using Python.

Importing/exporting data between CSV files and DataFrames.

Data Visualization

Using Matplotlib for creating line, bar, and histogram plots; customizing charts with labels, titles, and legends for data interpretation.

Advanced SQL Operations

Use of mathematical, text, and date functions; aggregate functions; Group By, Having, and Join operations for relational data management.

Computer Networks & Internet Concepts

Basics of PAN, LAN, MAN, WAN; network devices and topologies; internet concepts like URL, WWW, web pages, and browser configuration.

Societal and Ethical Impacts of IT

Cyber safety, digital footprints, net etiquettes, data protection, intellectual property rights, plagiarism, e-waste management, and awareness about tech-related health issues.

Practical and Project Work

Hands-on Python and SQL exercises, Pandas and Matplotlib applications, and a project integrating Class XI–XII concepts.