The CBSE Class 12 Informatics Practices Syllabus 2026-27 covers data handling, data visualization, SQL, computer networks, and the societal impact of technology. The subject is divided into four theory units, along with project work and practical activities. Students are expected to have studied Informatics Practices in Class XI as a prerequisite.
The CBSE Class 12 Informatics Practices Syllabus 2026-27 carries 100 marks in total. The theory units account for 70 marks, while practical work carries 30 marks. The syllabus also includes learning outcomes related to Pandas, data visualization, SQL queries, networking, internet security, and the impact of technology on society.
The subject code for Informatics Practices is 065. The course requires Informatics Practices in Class XI as a prerequisite.
|
Unit |
Unit Name |
|
1 |
Data Handling using Pandas and Data Visualization |
|
2 |
Database Query using SQL |
|
3 |
Introduction to Computer Networks |
|
4 |
Societal Impacts |
| - |
Project |
| - |
Practical |
| - |
Total |
The CBSE 12th IP syllabus includes four theory units. Data Handling using Pandas and Data Visualization and Database Query using SQL carry 25 marks each. Computer Networks and Societal Impacts carry 10 marks each. Practical work carries 30 marks.
The syllabus contains four main units. Each unit covers specific concepts that students need to study during the academic session.
This unit introduces Python libraries such as Pandas and Matplotlib. Students learn about Series and Data Frames and work with different operations on data.
The topics include:
Introduction to Python libraries, Pandas and Matplotlib
Data structures in Pandas
Series and Data Frames
Creation of Series from ndarray, dictionary, and scalar value
Mathematical operations on Series
Head() and Tail() functions
Selection, indexing, and slicing
Creation of Data Frames from a dictionary of Series, list of dictionaries, and Text/CSV files
Display and iteration of Data Frames
Adding, selecting, deleting, and renaming rows and columns
Head and Tail functions
Indexing using labels
Boolean indexing
Importing and exporting data between CSV files and Data Frames
Purpose of plotting
Line plot, bar graph, and histogram using Matplotlib
Saving plots
Adding labels, titles, and legends to plots
This unit carries 25 marks under the theory distribution.
The second unit focuses on database concepts and SQL queries. It begins with a revision of database concepts and SQL commands covered in Class XI.
Students study the following topics:
Revision of database concepts and SQL commands
Mathematical functions such as POWER(), ROUND(), and MOD()
Text functions such as UCASE()/UPPER(), LCASE()/LOWER(), MID()/SUBSTRING()/SUBSTR(), LENGTH(), LEFT(), RIGHT(), INSTR(), LTRIM(), RTRIM(), and TRIM()
Date functions such as NOW(), DATE(), MONTH(), MONTHNAME(), YEAR(), DAY(), and DAYNAME()
Aggregate functions such as MAX(), MIN(), AVG(), SUM(), and COUNT()
COUNT(*)
Group By
Having
Order By
Working with two tables using equi-join
The unit carries 25 marks and forms a major part of the theory syllabus.
This unit introduces students to computer networks and the internet. It covers network types, devices, topologies, and common internet applications.
The topics include:
Introduction to networks
PAN, LAN, MAN, and WAN
Modem, hub, switch, repeater, router, and gateway
Star, Bus, Tree, and Mesh topologies
Introduction to the Internet
URL and WWW
Web, email, Chat, and VoIP
Website and webpage
Static and dynamic web pages
Web server and hosting of a website
Web browsers
Commonly used browsers
Browser settings
Add-ons and plug-ins
Cookies
This unit carries 10 marks.
The fourth unit focuses on the impact of technology on society and responsible technology usage.
The topics include:
Digital footprint
Net and communication etiquettes
Data protection
Intellectual Property Rights (IPR)
Plagiarism
Licensing and copyright
Free and Open Source Software (FOSS)
Cybercrime and cyber laws
Hacking
Phishing
Cyber bullying
Overview of the Indian IT Act
E-waste, its hazards, and management
Health concerns related to the usage of technology
This unit carries 10 marks.
The CBSE Class 12 IP marks distribution is divided between theory and practical work. The four theory units together carry 70 marks, while practical work carries 30 marks.
The theory distribution is:
|
Unit |
Marks |
|
Data Handling using Pandas and Data Visualization |
25 |
|
Database Query using SQL |
25 |
|
Introduction to Computer Networks |
10 |
|
Societal Impacts |
10 |
|
Practical |
30 |
|
Total |
100 |
The Class 12 IP marking scheme also includes project work under the practical component. The syllabus specifies separate marks for Pandas and Matplotlib programs, SQL queries, the practical file, project work, and viva-voce.
The practical component carries 30 marks. Its distribution is given below:
|
Practical Component |
Marks |
|
Programs using Pandas and Matplotlib |
8 |
|
SQL Queries |
7 |
|
Practical file |
5 |
|
Project Work |
5 |
|
Viva-Voce |
5 |
|
Total |
30 |
The practical file must include a minimum of 15 programs based on Pandas, 4 based on Matplotlib, and 15 SQL queries.
The Class XII project aims to create a tangible and useful IT application. Students can work on the project as follows:
Identify a real-world problem: Students may explore their surroundings and identify a problem related to shops, business places, communities, or other organisations.
Study data management: Students can enquire about how data is generated, stored, and managed in the organisation.
Analyse data: Students can use data stored in CSV or database files and analyse it using Python libraries.
Create visualizations: Students can generate appropriate charts to visualize the analysed data.
Develop software: Students can use Python libraries of their choice to develop software for their school or for social good.
Choose the project format: The project can be completed individually or in groups of 2 to 3 students.
Start the project early: Students should start the project at least 6 months before the submission deadline.
Reference resources: Any resources such as data and images used in the project must be suitably referenced.
Avoid plagiarism: Students should avoid plagiarism and violation of copyright issues while working on the project.
Students looking for the Class 12 Informatics Practices syllabus 2026-27 PDF can refer to the official syllabus document for the complete unit-wise topics, marks distribution, practical requirements, project guidelines, and suggested practical activities.
2026-27
The CBSE Class 12 Informatics Practices Syllabus 2026-27 includes four theory units and a practical component. Students should cover Pandas and Matplotlib, SQL, computer networks, and societal impacts as specified in the syllabus. The practical work also requires attention to the practical file, project work, SQL queries, Pandas and Matplotlib programs, and viva-voce.
