CBSE Class 12 Computer Science (Code 083) is an advanced subject designed to build strong foundations in programming, databases, and computer networks. The syllabus focuses on Python programming, SQL-based database management, and basic networking concepts, preparing students for higher studies in B.Tech (CSE/IT), BCA, and software-related careers.
The curriculum consists of three theory units carrying 70 marks and a practical component of 30 marks. With hands-on coding, database integration, and problem-solving tasks, the subject emphasises real-world applications aligned with NEP's competency-based learning approach.
The CBSE Class 12 Computer Science theory examination is a 3-hour paper carrying 70 marks, designed to test logical thinking, programming accuracy, and conceptual clarity.
Key highlights of the exam pattern:
The Class 12 Computer Science syllabus focuses on advanced Python programming integrated with databases and networking concepts.
| UNIT | TITLE | SYLLABUS CONTENT (Key Topics) | MARKS |
|---|---|---|---|
| Unit I | Computational Thinking and Programming - II |
Revision of Python topics of Class XI: • Functions (user-defined, parameters, return values) • Exception Handling (try-except-finally) • File Handling (text, binary, CSV) • Binary files using pickle • CSV operations • Stack implementation using list |
40 |
| Unit II | Computer Networks |
• Evolution of networks • Transmission media • Network devices • Network types & topologies • TCP/IP and common protocols • Web services basics (WWW, URL, HTML) |
10 |
| Unit III | Database Management |
• Relational model & keys • SQL (DDL, DML) • Constraints • Aggregate functions • GROUP BY & HAVING • Joins • Python-SQL connectivity |
20 |
| Total (Theory) | 70 | ||
Regular practice of Python programs and SQL query sets is essential for scoring well.
Students are advised to follow the NCERT textbook sequence, as board questions are framed strictly in accordance with it.
| Unit | Marks | Key Focus | Question Types |
|---|---|---|---|
| Python Programming | 40 | File handling, Stack, Exception handling | Program output, Trace table, Code writing |
| Database Management | 20 | SQL queries, Joins, Python-SQL connectivity | Query writing (4 queries), Table design |
| Computer Networks | 10 | Topologies, Devices, Protocols | Diagrams, Definitions, MCQs |
Python programming carries the highest weightage (57%), making file operations and SQL integration crucial for exam success.
The practical examination carries 30 marks and evaluates a student's hands-on coding and problem-solving skills.
Students must maintain well-documented, error-free code with clear comments.
| Component | Details | Marks |
|---|---|---|
| Lab Test |
Python program: 60% logic, 20% documentation, 20% code quality SQL queries: 4 queries based on one or two tables |
12 (8 + 4) |
| Report File |
• Minimum 15 Python programs • Minimum 5 SQL query sets (one/two tables) • Minimum 4 programs using Python-SQL connectivity |
7 |
| Project | Project based on concepts learnt in Classes XI and XII | 8 |
| Viva Voce | Oral examination based on practical work and project | 3 |
| Total | 30 | |
# Reading and writing to a text file
with open('data.txt', 'r') as file:
content = file.read()
print(content)
# Writing to a CSV file
import csv
data = [['Name', 'Age'], ['John', 25], ['Alice', 22]]
with open('output.csv', 'w', newline='') as file:
writer = csv.writer(file)
writer.writerows(data)
Access essential Computer Science preparation resources:
The subject carries 100 marks: 70 marks for theory and 30 marks for practicals.
Python 3 is used throughout both theory and practical examinations.
MySQL is used along with Python connectivity through mysql-connector-python.
Computational Thinking & Programming carries 40 out of 70 theory marks (57%).
Yes. Project work is mandatory and carries 8 marks in the practical exam.
A minimum of 15 Python programs and 5 SQL query sets must be maintained in the practical file.
Program output and logic questions (25 marks), SQL queries (15 marks), and theory questions (30 marks).
Students must score 33% aggregate across theory and practicals to pass.