CBSE 12 Computer Science Syllabus 2024: Mark Distribution, Unit wise, Practical, and Important Topic
Content Curator | Updated On - Nov 4, 2023
CBSE Class 12 Computer Science syllabus 2024 is designed to help students understand and apply various concepts in an effective manner. It covers topics like functions, file handling, basic data structures (such as stacks), computer networks basics, database concepts (including SQL), and the connection between Python and SQL. The syllabus outlines marks distribution and provides detailed unit-wise syllabus content, practicals and projects
CBSE 12 Computer Science is one of the elective subjects in the CBSE Class 12 Examination. The total marks allocated for the exam are 100. Out of which 70 marks for the theory and 30 marks for the practical examinations. As per the latest CBSE Exam Pattern, there will be 45 questions to be answered. All questions will carry equal marks. To perform well in their CBSE Class 12 exam, students must go through the syllabus.
CBSE Class 12 Computer Science 2024: Marks Distribution
CBSE Class 12 Computer Science Exam Pattern 2024 exam pattern includes theory and practical exams with a total of 100 marks with 180 periods.
| Chapter | Theory marks | Periods | |
|---|---|---|---|
| Theory | Practical | ||
| Computational Thinking and Programming – 2 | 40 | 70 | 50 |
| Computer Networks | 10 | 15 | - |
| Database Management | 20 | 25 | 20 |
| TOTAL | 70 | 110 | 70 |
CBSE Class 12 Computer Science 2024: Important Topics
One of the prerequisites of the Class 12 Computer Science course is that the students should have the basic knowledge of the concepts of computer science the Class 11. To achieve maximum benefit and marks in the class 12 exam students should follow the right book, make a well-planned study schedule, create short notes, revise important topics regularly, and solve previous question papers. The important topics that will be covered are:
- Computational Thinking and Programming - 2
- Computer Networks
- Database Management
CBSE Class 12 Computer Science Syllabus: Unit Wise
Given below are the details of unit wise CBSE Class 12 Computer Science Syllabus
| Unit 1: Computational Thinking & Programming -2 | |
| TOPICS | SUBCOMPONENTS |
|---|---|
| Revision | Revision of Python topics covered in Class XI. |
| Functions |
|
| Execution Handling |
|
| Text File |
|
| Binary File |
|
| CSV File |
|
| Data Structures |
|
| Unit 2: Computer Networks | |
| TOPICS | SUBCOMPONENTS |
| Networking Evolution |
|
| Data Communication terminologies |
|
| Transmission media |
|
| Network devices |
|
| Network Topologies and Network Types |
|
| Network Protocol |
|
| Introduction To Web Services |
|
| Unit 3: Database Management | |
| Database Concepts |
|
| Relational data model |
|
| Structured Query Language |
|
| The interface of Python with an SQL database |
|
CBSE 12 Computer Science Term Wise Theory Syllabus
CBSE has released an updated syllabus for Term I and Term II Examination 2024. The Term wise syllabus is given below:
Computer Science Term I Exam 2022
Unit I: Computational Thinking and Programming – 2
- Revision of Python topics covered in Class XI.
- Functions: types of function (built-in functions, functions defined in module, user
- defined functions), creating user-defined functions, arguments and parameters, default parameters, positional parameters, a function returning value(s), the flow of execution, the scope of a variable (global scope, local scope)
- Exception Handling: Introduction, handling exceptions using try-except-finally blocks
- Introduction to files, types of files (Text file, Binary file, CSV file), relative and absolute paths
- Text file: opening a text file, text file open modes (r, r+, w, w+, a, a+), closing a text file, opening a file using with clause, writing/appending data to a text file using write() and write lines(), reading from a text file using read(), readline() and deadlines(), seek and tell methods, manipulation of data in a text file
- Binary file: basic operations on a binary file: open using file open modes (rb, rb+, wb, wb+, ab, ab+), close a binary file, import pickle module, dump() and load() method, read, write/create, search, append and update operations in a binary file
- CSV file: import csv module, open/close CSV file, write into a CSV file using a writer(), writers(), writers(), and read from a CSV file using a reader()
Computer Science Term II Exam 2022
Unit I: Computational Thinking and Programming – 2
- Data Structure: Stack, operations on the stack (push & pop), implementation of stack using the list.
Unit II: Computer Networks
- Evolution of Networking: introduction to computer networks, the evolution of networking (ARPANET, NSFNET, INTERNET)
- Data communication terminologies: the concept of communication, components of data communication (sender, receiver, message, communication media, protocols), measuring capacity of communication media (bandwidth, data transfer rate), IP address, switching techniques (Circuit switching, Packet switching)
- Transmission media: Wired communication media (Twisted pair cable, Co-axial cable, Fiber-optic cable), Wireless media (Radio waves, Microwaves, Infrared waves)
- Network devices (Modem, Ethernet card, RJ45, Repeater, Hub, Switch, Router, Gateway, WIFI card)
- Network topologies and Network types: types of networks (PAN, LAN, MAN, WAN), networking topologies (Bus, Star, Tree)
- Network protocol: HTTP, FTP, PPP, SMTP, TCP/IP, POP3, HTTPS, TELNET, VoIP
- Introduction to web services: WWW, Hyper Text Markup Language (HTML),
- Extensible Markup Language (XML), domain names, URLs, websites, web browsers, web servers, web hosting
Unit III: Database Management
- Database concepts: introduction to database concepts and their need
- Relational data model: relation, attribute, tuple, domain, degree, cardinality, keys (candidate key, primary key, alternate key, foreign key)
- Structured Query Language: introduction, Data Definition Language and Data Manipulation Language, data type (char(n), varchar(n), int, float, date), constraints (not null, unique, primary key), create a database, use the database, show databases, drop the database, show tables, create a table, describe the table, alter table (add and remove an attribute, add and remove primary key), drop table, insert, delete, select, operators (mathematical, relational and logical), aliasing, distinct clause, where clause, in, between, order by, the meaning of null, is null, is not null, like, update command, delete command, aggregate functions (max, min, avg, sum, count), group by, having clause, joins: cartesian product on two tables, equi-join, and natural join
- The interface of Python with an SQL database: connecting SQL with Python, performing insert, update, and delete queries using the cursor, displaying data by using connect(), the cursor(), execute(), commit(), fenchone(), fetch(), row count, creating database connectivity applications, use of %s format specifier or format() to perform queries
CBSE 12 Computer Science Syllabus 2024: Practical
- The 30 marks are practically divided into Lab Tests, Report files, Projects, and Viva voce.
- In the Lab Test, there is a Python program that uses 60% logic, 20% documentation, and 20% code equality and there is another Python program that is small in size but can display the results if a SQL query is sent out to a database. In the Report file, out of 20 Python programs, at the very least 4 programs should send SQL queries to the database and should retrieve results.
- The project contains the computer science concepts that are learnt both in Class 11 and Class 12.
- Viva Voce is the last round of the practicals’ s and it is used to test the candidate's knowledge of the subject learned.
CBSE 12 Computer Science Syllabus 2024: Marks Distribution Practical
Given below are the details of the CBSE 12 Computer Science Syllabus marks distribution for practical
| S No | Area | Marks |
|---|---|---|
| 1 | Lab Test: 1. Python program (60% logic + 20% documentation + 20% code quality) | 8 |
| 2. SQL queries (4 queries based on one or two tables) | 4 | |
| 2 | Report File Minimum 15 Python programs. SQL Queries – Minimum 5 sets using one table / two tables. Minimum 4 programs based on Python - SQL connectivity | 7 |
| 3 | Project (using concepts learnt in Classes 11 and 12) | 8 |
| 4 | Viva voce | 3 |
| Total Marks | 30 |
CBSE 12 Computer Science Syllabus 2024: Important Topics for Practical
Practicals are very significant in the learning process of students. It engages students, helps them grasp scientific topics and investigations, and assists them in developing new abilities. Practical knowledge enhances and adds value to the student's profession. The following are the themes from which to pick for the practicals:
Python Programming
- 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 in the file.
- Remove all the lines that contain the character 'a' in a file and write it to another file.
- Create a binary file with the name and roll number. Search for a given roll number and display the name, if not found display an appropriate message.
- Create a binary file with roll number, name and marks. Input a roll number and update the marks.
- Write a random number generator that generates random numbers between 1 and 6 (simulates a dice).
- Write a Python program to implement a stack using the list.
- Create a CSV file by entering user-id and password, and read and search the password for the given user ID.
Database Management
- Under the database management concept, a student table should be created and data Create a student table and insert data. Implement the following SQL commands on the student table:
- ALTER table to add new attributes / modify data type/drop attribute
- UPDATE table to modify data
- ORDER By to display data in ascending/descending order
- DELETE to remove tuple(s)
- GROUP BY and find the min, max, sum, count, and average
- A similar exercise may be framed for other cases.
- Integrate SQL with Python by importing suitable modules.
Suggested Reading Material
- NCERT Textbook for COMPUTER SCIENCE (Class XII)
- Support Materials on the CBSE website.
Project
The CBSE class 12 project aims to create something tangible and useful using Python file handling/ Python-SQL connectivity. This should be done in groups of two to three students from class 12 and should be started by students at least 6 months before the project submission deadline.
The project aims to find a real-world problem that is worthwhile to solve. Students are encouraged to visit local businesses and enquire about the problems that they are facing. For example, if a business is finding it hard to create invoices for filing GST claims, then students can do a project that takes the raw data (list of transactions), groups the transactions by category, accounts for the GST tax rates, and creates invoices in the appropriate format. Students can use a wide variety of Python libraries to create user-friendly applications such as games, software for their school, software for their disabled fellow students, and mobile applications.
CBSE 12 Computer Science Syllabus 2024 - FAQs
Ques. How many chapters are there in the CBSE class 12 Computer Science Syllabus 2024?
Ans. There are a total of 13 chapters including SQL, Query, Database Concepts, etc.
Ques. Which portion of CBSE 12 Computer Science 2024 is deleted?
Ans. The CBSE Board has reduced around 30% of the portion as a part of the CBSE Class 12 Computer Science Deleted Syllabus 2023-24. Web scripting, payment apps, database management, etc have been deleted.
Ques. What are the subjects in CBSE 12 Computer Science?
Ans. The subjects in CBSE 12 Computer Science cover the following subjects: Computer networks. Database management, Computational thinking and programming – 1, Commands, Database concept, etc.
Ques. How many marks have been allotted for practicals and viva in CBSE Computer Science?
Ans. In the 100 marks exam, 30 marks have been allotted for practical and viva. The students must secure passing marks separately in practical and written examinations.
Ques. Is Class CBSE 12 Computer Science easy?
Ans. Teachers and students can rate CBSE Class 12 Computer Science exam as moderately difficult. But all questions are based on the CBSE Sample paper. only
Ques. Is the CBSE exam for computer science conducted online?
Ans. The CBSE exam for computer science is conducted offline, like any other subject. The students are required to solve questions about programming, Javascript, SQL, etc.
Ques. How to pass CBSE 12 Computer Science?
Ans. CBSE 12 Computer Science exam can be passed by following the right book, making a study schedule, creating short notes, revising important topics regularly, and solving previous question papers.
Ques. Which book can be referred to for programming?
Ans. The books prescribed by the CBSE can be referred to for programming and the students are suggested to study from the stated books only.
Ques. Is computer science an optional subject in CBSE Class 12?
Ans. Computer Science (CS) is an optional subject at the higher secondary stage of school education. Computer science can help pursue a career in software development or related area after going through professional courses at higher levels.
Ques. What is the minimum passing mark in CBSE 12 computer science?
Ans. Students are required to secure a minimum of 33% marks to pass the CBSE 12 computer science examination.
Ques. What is the weightage of computer science in the CBSE 12 exam?
Ans. The theory paper will be of 70 marks and the practicals will be of 30 marks in the CBSE Class 12 Computer Science Paper 2024. It is followed by a project also.
*The article might have information for the previous academic years, please refer the official website of the exam.