CBSE Computer Science & IP Courses for Classes 11th & 12th

Syllabus of Computer Science (CS) for Class 12th

UNIT 1 – Computational Thinking and Programming – 2  

1. Functions
2. Exception Handling
3. Files
4. Text File Operations
5. Binary File Operations
6. CSV File Operations
7. Data Structure

Please note: 

• Python Topics Covered in Class XI will be discussed first.

UNIT 2 – Computer Networks

1. Evolution of Networking
2. Data Communication Terminologies
3. Transmission Media
4. Network Devices
5. Network Topologies and Types
6. Network Protocols
7. Introduction to Web Services

UNIT 3 – Database Management 

1. Introduction to database
2. Relational Data Model:
3. Structured Query Language (SQL)
4. Interface of Python with SQL Database

UNIT 4 – Python program

1. Working on Python program 

• Read a text file line by line and display each word separated by a #
• Read a text file and display the number of vowels/consonants/uppercase/lowercase characters
• Remove lines containing ‘a’ character in a file and write to another file
• Create a binary file with name and roll number, search for a given roll number
• Create a binary file with roll number, name, and marks, update marks for a given roll number
• Random number generator simulating a dice
• Implement a stack using a list
• Ceate a CSV file with user-id and password, read and search the password for a given user-id

2. SQL queries

• Integrating SQL with Python:
• Import a suitable module (e.g., ‘sqlite3’) to integrate SQL with Python.
• Establish connection to a database using Python.
• Execute SQL queries using cursor.
• Fetch and manipulate data using Python code.
• Close the database connection.

Exams & Project File Preparation