CBSE Syllabus For Class 12 Computer Science For Term 1 & Term 2 2023-24: For CBSE board students in Class 12, Computer Science is an important subject. It is also essential for CBSE Class 12 students to be aware of the subject’s syllabus for the academic year 2023-24. The syllabus for Class 12 CBSE Computer Science covers all of the relevant and important information on the course structure and practicals that students will be studying throughout the academic year 2023-2024.
CBSE Syllabus For Class 12 Computer Science Term 1 & Term 2 2023-24
Students can access the CBSE Syllabus For Class 12 Computer Science for the academic year 2023-24 by clicking the link provided below.
CBSE 12th Computer Science Syllabus For Term 1 & Term 2 2023-24
CBSE Class 12 Computer Science Syllabus For Term 1 & Mark Distribution 2023-24
The theory syllabus for Class 12 Computer Science Term 2 for the academic year 2023-24, as well as the mark distribution for each unit. The marking scheme and time duration for each unit are also included in CBSE 12th Computer Science Term 1 Syllabus.
CBSE Syllabus For Class 12 Computer Science Term 1 2023-24
Here you can check CBSE Class 12 Computer Science Syllabus For Term 1 2023-24.
|
Unit I: Computational Thinking and Programming – 2
|
|
Revision of Python topics covered in Class
|
|
Functions: types of function (built-in functions, functions defined in module, user defined functions), creating user defined function, arguments and parameters, default parameters, positional parameters, function returning value(s), flow of execution, scope of a variable (global scope, local scope)
|
|
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 writelines(), reading from a text file using read(), readline() and readlines(), 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 writerow() and read from a csv file using csv.reader( )
|
CBSE Class 12 Computer Science Mark Distribution For Term 1 2023-24
Here you can check CBSE Class 12 Computer Science Mark Distribution For Term 1 2023-24.
|
Unit No |
Unit Name |
Term-1 |
|
I |
Computational Thinking and Programming – 2 |
35 |
|
II |
Computer Networks |
— |
|
III |
Database Management |
— |
|
Total |
35 |
CBSE Class 12 Computer Science Syllabus Term 2 & Mark Distribution 2023-24
The theory syllabus for Class 12 Computer Science Term 2 for the academic year 2021-2022, as well as the mark distribution for each unit. The marking scheme and time duration for each unit are also included in this CBSE 12th Computer Science Term 2 Syllabus 2023-24.
CBSE Syllabus For Class 12 Computer Science Term 2 2023-24
Here you can check CBSE Class 12 Computer Science Syllabus For Term 2 2023-24.
|
Unit I: Computational Thinking and Programming – 2
|
|
Data Structure: Stack, operations on the stack (push & pop), implementation of stack using
|
|
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, Micro waves, 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, URL, website, web browser, web servers, web hosting
|
|
Unit III: Database Management
|
|
Database concepts: introduction to database concepts and its 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 database, use database, show databases, drop database, show tables, create table, describe 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, 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 fetch one(), fetch(), row count, creating database connectivity applications
|
CBSE Class 12 Computer Science Mark Distribution For Term 2 2023-24
Here you can check CBSE Class 12 Computer Science Mark Distribution For Term 2 2023-24.
|
Unit No |
Unit Name |
Term-2 |
|
I |
Computational Thinking and Programming – 2 |
5 |
|
II |
Computer Networks |
10 |
|
III |
Database Management |
20 |
|
|
Total |
35 |
Term-Wise CBSE Syllabus For Class 12 Computer Science Practical & Mark Distribution 2023-24
The practical syllabus for CBSE Class 12 Computer Science Term 1 & Term 2 for the academic year 2023-24, as well as the mark distribution for each unit. The marking scheme and time duration for each unit are also included in CBSE 12th Computer Science Practical Syllabus.
CBSE Class 12 Computer Science Practical Syllabus For Term 1 2023-24
Here you can check CBSE Class 12 Computer Science Practical Syllabus For Term 1 2023-24.
|
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 name and roll number. Search for a given roll number and display the name, if not found display 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).
|
|
Create a CSV file by entering user-id and password, read and search the password for given user- id.
|
CBSE Class 12 Computer Science Practical Mark Distribution For Term 1 2023-24
Here you can check CBSE Class 12 Computer Science Practical Mark Distribution For Term 1 2023-24.
| Practicals |
Term-1 (15 Marks) |
|
Lab Test:
1. Python program |
6 |
|
2. 3 SQL Queries based on one/two table(s), 2 output questions based on SQL queries |
— |
|
Report file: Term – 1 : Minimum 15 Python programs based on Term – 1 Syllabus Term – 2 :
|
4 |
|
Project (using concepts learnt in Classes 11 and 12) Term – 1 : Synopsis of the project to be submitted by the students (documentation only, may not submit the code during Term – 1) Term – 2 : Final coding + Viva voce (Student will be allowed to modify their Term 1 document and submit the final executable code.) |
3 |
|
Viva voce |
2 |
CBSE Class 12 Computer Science Practical Syllabus For Term 2 2023-24
Here you can check CBSE Class 12 Computer Science Practical Syllabus For Term 2 2023-24.
|
Python Programming
|
|
Write a Python program to implement a stack using
|
|
Database Management
|
|
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
|
| Joining of two |
|
Similar exercise may be framed for other
|
|
Integrate SQL with Python by importing suitable
|
|
Database Management
|
|
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
|
|
Similar exercise may be framed for other
|
|
Integrate SQL with Python by importing suitable
|
CBSE Class 12 Computer Science Practical Mark Distribution For Term 2 2023-24
Here you can check CBSE Class 12 Computer Science Practical Mark Distribution For Term 2 2023-24.
|
Practicals |
Term-2 (15 Marks) |
|
Lab Test: 1. Python program |
2 |
|
2. 3 SQL Queries based on one/two table(s), 2 output questions based on SQL queries |
4 |
|
Report file: Term – 1 : Minimum 15 Python programs based on Term – 1 Syllabus Term – 2 :
|
3 |
|
Project (using concepts learnt in Classes 11 and 12) Term – 1 : Synopsis of the project to be submitted by the students (documentation only, may not submit the code during Term – 1) Term – 2 : Final coding + Viva voce (Student will be allowed to modify their Term 1 document and submit the final executable code.) |
5 |
|
Viva voce |
1 |
Other Important Links Related To CBSE Class 12 Computer Science
You should have the following study materials to boost your exam preparation for the Class 12 Computer Science exam. Click on the link to access the study materials.
Download Chapter-Wise NCERT Textbooks For CBSE Class 12 Computer Science 2023-24
Computer Science is an important subject in Class 12. The book has multiple benefits from class 12 exam preparation to exam preparation for various higher studies in the computer science field.
Here you can download NCERT Textbook for Class 12 Computer Science.
Download CBSE 12th Computer Science Text Books
We have covered the detailed guide on CBSE Syllabus For Class 12 Computer Science. Feel free to ask any questions related to CBSE Class 12 Computer Science in the comment section below.
FAQs On CBSE Syllabus For Class 12 Computer Science 2023-24
Here you can check FAQs On CBSE Syllabus For Class 12 Computer Science 2023-24.
Is there any change in the CBSE Syllabus For Class 12 Computer Science 2023-24?
Yes, CBSE had reduced the CBSE Syllabus For Class 12 Computer Science by 30% in the year 2020-21.
How to download CBSE Syllabus For Class 12 Computer Science 2023-24 PDF?
Download CBSE Syllabus For Class 12 Computer Science 2023-24 PDF from the above article.
What is the marking scheme in CBSE 12th Computer Science 2023-24?
The marking scheme in CBSE 12th Computer Science 2023-24 is:
Theoretical Paper: 70 marks and
Practical/ Project Work: 30 Marks
How is the marking scheme distributed in the CBSE Syllabus For Class 12 Computer Science?
The marking scheme distributed in the CBSE Syllabus For Class 12 Computer Science:
I. Computational Thinking and Programming 2 – 40 Marks,
II. Computer Networks- 10 Marks and
III. Database Management -20 Marks
What is the best book for Class 12 Computer Science?
Move fast with Computer Science with C++ by Sumita Arora is one of the best books for class 12.
Can I get the revised CBSE Syllabus For Class 12 Computer Science in PDF?
Yes. You can get the revised CBSE Syllabus For Class 12 Computer Science in PDF from the above article.
Is Computer Science with C++, by Reeta Sahoo also a good book for class 12?
Yes, Computer Science with C++, by Reeta Sahoo also a good book for class 12
How many marks of practical in Class 12 Computer science?
As per the CBSE Syllabus For Class 12 Computer Science 2023, there is a maximum of 30 marks for practicals in Class 12 Computer Science.