Table of Contents
In the last year of school, Class 12, students face big challenges. This year sets the stage for college life where they get to study what they love. But before that exciting step, they need to work really hard and stay dedicated to do well in the Class 12 board exams.
Computer Science is super important for these exams. To do great in this subject, students must completely understand the CBSE Class 12 Computer Science Syllabus. They’ve got to know all the topics in the CBSE Syllabus really well.
Also Check: CBSE Class 12 Physical Education Syllabus
CBSE Class 12 Computer Science Syllabus 2023-24 – Unit-Wise
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. |
Also Check: CBSE Class 12 Math Syllabus
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 Practical Syllabus
Students have the opportunity to review the complete syllabus for CBSE Class 12 Computer Science Practical below:
Also Check: CBSE Class 12 Chemistry Syllabus
1. Python Programming
- Open a text file and read it line by line. For each line, show each word separated by a ‘#’. Count the vowels, consonants, uppercase, and lowercase letters in the file.
- Remove any lines in the file that have the letter ‘a’ and save the updated content to a new file.
- Make a file with student names and roll numbers. Look up a roll number and display the associated name.
- Create a file containing roll numbers, names, and marks. Enter a roll number and update the marks.
- Make a random number generator that works like a dice, producing numbers from 1 to 6.
- Build a stack using a Python list.
- Prepare a CSV file with user IDs and passwords. Read it and find passwords using the user ID.
2. Database Management
- Set up a table for students, add information, and try different commands in SQL like changing, updating, arranging, removing, and grouping data with functions that combine details.
- Connect SQL with Python using a fitting tool.
Also Check: CBSE Class 12 Physics Syllabus
CBSE Class 12 Computer Science Syllabus with Marks Distribution
The syllabus for CBSE Class 12 Computer Science Theory for the 2023-24 academic year is listed below. It shows how many marks each unit carries and how long each part lasts.
Unit No. | Unit Name | Marks | Periods | |
Theory | Practicals | |||
1. | Computational Thinking and Programming – 2 |
40 | 70 | 50 |
2. | Computer Networks | 10 | 15 | – |
3. | Database Management | 20 | 25 | 20 |
Total | 70 | 110 | 70 |
Also Check: CBSE Class 12 Biology Syllabus
CBSE Class 12 Computer Science Practical Syllabus 2023-24
S.No. | Unit Name | Marks (Total=30) |
||
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 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. | Vice Voce | 3 |
CBSE Class 12 Computer Science Syllabus FAQs
What is the syllabus of English CBSE Class 12?
The CBSE Class 12 English syllabus includes sections on reading comprehension, writing skills, literature, and grammar.
What is the syllabus of Class 12 English 2023?
The Class 12 English syllabus for 2023 remains similar to previous years, covering prose, poetry, grammar, and writing skills.
How many chapters are there in English Class 12 CBSE?
CBSE Class 12 English typically comprises chapters from novels, poems, essays, and supplementary reading materials, totaling around 10-12 chapters.
How to prepare for Term 1 exam Class 12?
Prepare for the Class 12 Term 1 exam by focusing on understanding key concepts, practicing sample papers, and revising thoroughly from prescribed textbooks.
What are the topics for English Grammar Class 12?
English Grammar for Class 12 covers topics like tenses, clauses, direct and indirect speech, active and passive voice, and sentence structures.