CBSE Computer Science Class 12 Syllabus

Computer Science is a subject of choice for many who have a fascination for computers and programming. Those who want to build a successful career in the domain, choose it earlier in Senior Secondary Education. With CBSE board examination 2023–24 around the corner, it is important for students to know the Computer Science class 12 syllabus along with the course structure. Take a look at the important units and corresponding topics to boost your preparations. 

Also Read: Scope of Computer Science

CBSE Computer Science Class 12th Paper Pattern

Understanding the paper pattern is central to the preparations. Having a pattern allows you to divide your time according to the marks that each chapter contains. The Computer Science Class 12 Syllabus contains 5 chapters which carry 70 marks. The first chapter of the syllabus contains 30 marks and it needs to be studied in detail.

Given below in a table is the paper pattern for Class 12th Computer Science:

Given below in a table is the paper pattern for Class 12th Computer Science:

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 Read: Computer Courses List

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.	Viva	3

Also Read: Best Computer Science Colleges in India

Unit 1: Computational Thinking and Programming – II

The Unit 1 of the Computer Science Class 12 Syllabus focuses on advanced-level computational thinking and programming including concepts like basic python, function, python libraries, etc. Let’s take a look at the syllabus for Unit 1:

• Functions
  Scope, parameter passing, mutable/immutable properties of data objects, passing strings, lists, tuples, dictionaries to functions, default parameters, positional parameters, return values, functions using libraries: mathematical and string functions.
• Basic revision of the fundamental topics of python studied in 11th class.
• Data File Handling:
  Types of data files; need for a data file
• Using Python Libraries:
  How to import python libraries
• Data Structures:
  Stacks-Push, Pop with a list as well as lists studied in Class 11th.

Also Read: BSc Computer Science

Unit 2: Computer Networks

The 2nd unit of the Computer Science Class 12 syllabus studies computer networks, their history and evolution, how they work, and so on. Here is the reduced syllabus for Unit 2 Computer Science in Class 12:

• Evolution of Networking
  ARPANET, Internet, Interspace Different ways of sending data across the network with reference to switching techniques (Circuit and Packet switching)
• Network Topologies and types
  Bus, Star, Tree, PAN, LAN, WAN, MAN
• Data Communication terminologies 
  Concept of Channel, Bandwidth; Data transfer rate (bps, Kbps, Mbps, Gbps, Tbps). 
• Network Protocol
  TCP/IP, File Transfer Protocol (FTP), PPP, HTTP, SMTP, POP3, Remote Login (Telnet) and Internet; Wireless / Mobile Communication protocol such as GSM, GPRS and WLL. 
• Transmission media
  Twisted pair cable, coaxial cable, optical fiber, etc.
• Network devices
  Modem, RJ45 connector, Ethernet Card, Router, Switch, Gateway, WiFi card
• Mobile Telecommunication Technologies
  1G, 2G, 3G, etc.; Mobile Processors, Electronic mail protocols, Chat & Video conferencing protocols; wireless technologies, network security topics and concepts
• Introduction To Web services
  WWW, HyperText Markup Language (HTML); Extensible Markup Language (XML); HTTP; Domain Names; URL; Website, Web browser, Web Server and Web Hosting

Also Read: How to Become a Mobile App Developer?

Unit 3: Database Management System  

Unit 3 of the Computer Science Class 12 Syllabus focuses on database concepts, relation algebra, data models, and so on. Here are the topics you need to study for this unit:

• Database Concepts & their need
• Relational Data Model: What is domain, tuple, relation, key, primary key, the alternate key candidate key
• Relational Algebra: Selection, Projection, Union and Cartesian product
• Structured Query Language
• General Concepts: Advantages of using SQL, Data Definition Language, Data Manipulation, Language
• Data Types: Number/Decimal, Character/Varchar/Varchar 2, Date
• SQL Commands: Create Table, Drop Table, Alter Table, Update, Insert, Delete; Select, Distinct, From, Where, In, Between, Group By, Having, Order By;
• SQL Functions: SUM ( ), AVG ( ),COUNT ( ), MAX ( ) AND MIN ( ) 
• Interface of Python with an SQL database: Connecting SQL with Python; Creating Database connectivity Applications – Performing Insert, Update, Delete queries – Display data by using fetch one(),fetch(),rowcount

Also Read: Components of Computer

Class 12 Computer Science Project (30 Marks)

Take a look at the breakup of marks for Class 12 Computer Science Syllabus:

1. Lab Test (12 marks)
   • Python program (60% logic + 20% documentation + 20% code quality) [7 marks]
   • Small Python program that sends a SQL query to a database and displays the result. A stub program can be provided. [5 marks]
2. Report file (7 marks)
   • Minimum 20 Python programs
   • Out of this at least 4 programs should send SQL commands to a database and retrieve the result
3. Project (8 marks)
   With concepts combined of Class 11 and Class 12 syllabus
4. Viva Voce (3 marks)

Recommended Read:

• Basic Computer Courses List
• Computer Courses List
• Computer Science Subjects

FAQs

To score well in your CBSE exams, it becomes crucial to have Computer Science Class 12 Syllabus by your side. If you are planning to go for higher studies abroad, then there are a number of universities that offer the best courses in Computer Science. To know more, reach out to our counsellors at Leverage Edu who will help you plan your career beforehand.