CBSE 2026-27 · Class 12 · Code 065

Informatics Practices Syllabus

Official CBSE curriculum for Class 12 Informatics Practices (065), academic session 2026-27. Read the full syllabus PDF below, download it to study offline, or see the units and marks at a glance.

Official syllabus PDF

Download PDF

CBSE Class XII Informatics Practices (065) syllabus 2026-27 at a glance

Subject code 065 · Class XII · Session 2026-27. The course carries 100 marks: a 70-mark theory paper and 30 marks of practical work. Prerequisite: Informatics Practices, Class XI.

Units and marks (theory)

UnitUnit nameMarks
1Data Handling using Pandas and Data Visualization25
2Database Query using SQL25
3Introduction to Computer Networks10
4Societal Impacts10
Theory total70

Major topics

Unit 1: Data Handling using Pandas and Data Visualization (25 marks)

Pandas Series (creation from ndarray, dictionary and scalar values; head(), tail(), indexing and slicing); DataFrames (creation, iteration, adding, selecting, deleting and renaming rows and columns, label and Boolean indexing); importing and exporting data between CSV files and DataFrames; Matplotlib line plots, bar graphs and histograms with labels, titles and legends.

Unit 2: Database Query using SQL (25 marks)

Revision of Class XI SQL; math functions (POWER, ROUND, MOD); text functions (UPPER, LOWER, SUBSTR, LENGTH, LEFT, RIGHT, INSTR, TRIM and more); date functions (NOW, DATE, MONTH, MONTHNAME, YEAR, DAY, DAYNAME); aggregate functions including COUNT(*); GROUP BY, HAVING and ORDER BY; working with two tables using an equi-join.

Unit 3: Introduction to Computer Networks (10 marks)

PAN, LAN, MAN and WAN; network devices (modem, hub, switch, repeater, router, gateway); star, bus, tree and mesh topologies; the Internet, URL, WWW, email, chat and VoIP; websites, static and dynamic web pages, web servers and hosting; web browsers, settings, add-ons, plug-ins and cookies.

Unit 4: Societal Impacts (10 marks)

Digital footprint; net and communication etiquettes; data protection; intellectual property rights, plagiarism, licensing and copyright; free and open source software; cyber crime and cyber laws (hacking, phishing, cyber bullying, Indian IT Act); e-waste hazards and management; health concerns related to using technology.

Practical (30 marks)

Programs using Pandas and Matplotlib8
SQL queries7
Practical file: at least 15 Pandas programs, 4 Matplotlib programs and 15 SQL queries5
Project work using concepts learnt in Classes 11 and 125
Viva voce5

Source: official CBSE Senior Secondary curriculum 2026-27 for Class XII Informatics Practices (065), published by CBSE on cbseacademic.nic.in. This summary is for quick reference; the official syllabus PDF shown above is the complete document.