| Updated On - Sep 2, 2024
CBSE Class 12 Computer Science Syllabus 2024-25 has been released. You can download the full syllabus from the official website, cbseacademic.nic. CBSE Class 12 Computer Science Syllabus is divided into 3 units:
- Computational Thinking and Programming - 2
- Computer Networks
- Database Management
Apart from the theory syllabus, there are some specified practical works based on Python programs. CBSE conducts the Computer Science exam for a total of 100 marks divided into theory and practical. The theory paper carries 70 marks, while 30 marks are assigned to the practical work.
This article contains detailed chapter-wise topics and the list of practicals along with their marks distribution as per the latest CBSE Class 12 Computer Science Syllabus 2024-25.
- CBSE Class 12 Computer Science Syllabus
- CBSE Class 12 Computer Science Syllabus: Marks Distribution
- CBSE Class 12 Computer Science Practical Syllabus
- CBSE Class 12 Computer Science Practical Syllabus : Marks Distribution
- CBSE Class 12 Computer Science Project Work
- CBSE Class 12 Computer Science Deleted Syllabus
- Frequently Asked Questions
CBSE Class 12 Computer Science Syllabus
CBSE Class 12 Computer Science Syllabus contains 3 units. Students can check the detailed topics for each unit here.
Unit I: Computational Thinking and Programming – 2
| Topic | Content |
|---|---|
| Revision of Python topics covered in Class XI | Review of previously learned Python concepts and topics from Class XI. |
| Functions | Types of functions (built-in functions, functions defined in a module, user-defined functions), creating user-defined functions, arguments and parameters, default parameters, positional parameters, functions returning values, flow of execution, scope of a variable (global scope, local scope). |
| Exception Handling | Introduction to exception handling, handling exceptions using try-except-finally blocks. |
| Introduction to Files | Types of files (Text file, Binary file, CSV file), relative and absolute paths. |
| Text Files | Opening and closing text files, text file open modes (r, r+, w, w+, a, a+), working with text files using write() and writelines(), reading from text files using read(), readline(), and readlines(), seek and tell methods, data manipulation in text files. |
| Binary Files | Basic operations on binary files, file open modes (rb, rb+, wb, wb+, ab, ab+), import pickle module, dump() and load() methods, read, write/create, search, append, and update operations in binary files. |
| CSV Files | Importing the csv module, opening and closing csv files, writing to csv files using writer(), writerow(), writerows(), reading from csv files using reader(). |
| Data Structures - Stacks | Introduction to stacks, stack operations (push and pop), stack implementation using lists. |
Unit II: Computer Networks
| Topic | Content |
|---|---|
| Evolution of Networking | Introduction to computer networks, historical evolution (ARPANET, NSFNET, INTERNET). |
| Data Communication Terminologies | Communication concepts, components (sender, receiver, message, communication media, protocols), measuring communication media capacity (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 | Overview of network devices (Modem, Ethernet card, RJ45, Repeater, Hub, Switch, Router, Gateway, WIFI card). |
| Network Topologies and Types | Types of networks (PAN, LAN, MAN, WAN), networking topologies (Bus, Star, Tree). |
| Network Protocols | 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
| Topic | Content |
|---|---|
| Database Concepts | Introduction to database concepts and their significance. |
| Relational Data Model | Key concepts in the relational data model: relation, attribute, tuple, domain, degree, cardinality, keys (candidate key, primary key, alternate key, foreign key). |
| Structured Query Language (SQL) | Introduction to SQL, Data Definition Language (DDL) and Data Manipulation Language (DML), data types (char(n), varchar(n), int, float, date), constraints (not null, unique, primary key), database operations (create, use, show, drop), table operations (create, describe, alter, drop), data manipulation (insert, delete, select, update), operators, aliasing, distinct clause, where clause, in, between, order by, null, like, aggregate functions, group by, having, joins (cartesian product, equi-join, natural join). |
| Interface of Python with an SQL Database | Connecting Python with an SQL database, performing insert, update, delete queries using cursor, data retrieval using connect(), cursor(), execute(), commit(), fetchone(), fetchall(), rowcount, creating database connectivity applications, using format specifiers to perform queries. |
CBSE Class 12 Computer Science Syllabus: Marks Distribution
Check the marks distribution for CBSE Class 12 Computer Science Syllabus 2024-25 from the table below:
| Unit No. | Unit Name | Marks |
|---|---|---|
| I. | Computational Thinking and Programming – 2 | 40 |
| II. | Computer Networks | 10 |
| III. | Database Management | 20 |
| Total | 70 | |
CBSE Class 12 Computer Science Practical Syllabus
CBSE Class 12 Computer Science Practical Syllabus 2024-25 is given below:
1. Python Programming
- Read a text file line by line and display each word separated by a '#'.
- Analyze a text file and display the counts of vowels, consonants, uppercase, and lowercase characters.
- Remove lines containing the character 'a' in a file and save it to another file.
- Create a binary file with names and roll numbers, and search for a given roll number to display the name.
- Create a binary file with roll numbers, names, and marks. Input a roll number and update the marks.
- Develop a random number generator that simulates a dice, generating random numbers between 1 and 6.
- Implement a stack using a Python list.
- Create a CSV file with user IDs and passwords, read and search for passwords based on user ID.
2. Database Management
- Create a student table, insert data, and perform various SQL commands such as ALTER, UPDATE, ORDER BY, DELETE, and GROUP BY with aggregation functions.
- Integrate SQL with Python using a suitable module.
CBSE Class 12 Computer Science Practical Syllabus : Marks Distribution
The marks distribution for CBSE Class 12 Computer Science Practical 2024-25 is tabulated below:
| Units | Unit Name | Marks |
|---|---|---|
| 1. | Lab Test | |
| Python Program (60% logic + 20% documentation + 20% code quality) | 8 | |
| SQL Queries (4 queries based on one or two tables) | 4 | |
| 2. | Report File | |
| Minimum 15 Python Programs | 7 | |
| SQL Queries (Minimum 5 sets using one table/two tables) | ||
| - Minimum 4 programs based on Python - SQL connectivity | ||
| 3. | Project (Using concepts learnt in Classes 11 and 12) | 8 |
| 4. | Viva Voce | 3 |
| Total | 30 | |
CBSE Class 12 Computer Science Project Work
Here are some important guidelines for CBSE Class 12 Computer Science project work:
- The class project aims to create practical and useful applications using Python file handling or Python-SQL connectivity. It should be done in groups of two to three students and started at least 6 months before the submission deadline.
- Projects should address real-world problems by collaborating with local businesses or identifying valuable challenges. For example, creating software for invoice generation based on GST requirements.
- Encourage creativity and the use of Python libraries for various applications, including games, school software, accessibility tools for disabled students, and mobile apps.
- Students should be encouraged to learn independently and expand their knowledge as required.
- Emphasize the importance of avoiding plagiarism and respecting copyright while working on projects.
CBSE Class 12 Computer Science Deleted Syllabus
The topics that were excluded from the CBSE Class 12 Computer Science Syllabus in the academic year 2023-24 remain excluded this academic year also. Students can check out the deleted topics of the CBSE Class 12 Computer Science Syllabus from the below table:
| Chapters | Deleted Topics |
|---|---|
| Computational Thinking and Programming – 2 | Sorting Techniques |
| Computer Networks |
|
| Database Management | Table Creation and Data Manipulation Commands |
Frequently Asked Questions
Ques. What is the weightage of practicals in CBSE Class 12 Computer Science syllabus?
Ans. CBSE Class 12 Computer Science practical syllabus carry a weightage of 30 marks.
Ques. What are the key topics covered in Unit II (Computer Networks) of CBSE Class 12 Computer Science Syllabus?
Ans. Unit II of Computer Science covers topics such as the evolution of networking, data communication terminologies, transmission media, network devices, network topologies, network protocols, and web services.
Ques. What should I consider when selecting a project for CBSE Class 12 Computer Science project work?
Ans. Students should choose a project that address a real-world problem or challenge. Collaborate with local businesses if possible. Be creative and use Python to create practical and useful applications.
*The article might have information for the previous academic years, which will be updated soon subject to the notification issued by the University/College.
.jpeg?h=160&w=320&mode=crop)
.jpeg?h=160&w=320&mode=crop)
.jpeg?h=160&w=320&mode=crop)
Comments