CBSE Class 12 · Informatics Practices

CBSE Class 12 Informatics Practices Board Exam Preparation

Python, Pandas, SQL, and Networks — the data-science-focused alternative to Computer Science

Complete chapter-wise preparation guide for CBSE Class 12 Informatics Practices board exam 2025-26. Covers Python with Pandas, Matplotlib, MySQL, Computer Networks, and Society & Ethics with marks distribution and strategy.

Practice with AI Evaluation →

Theory Marks

Practical Marks

3 hours

Exam Duration

Total Chapters

Chapter-Wise Marks Breakdown

70 theory marks

Chapter	Marks	Difficulty	Key Topics
Python Revisited	5	Easy	Python Data Types · Lists, Tuples, Dictionaries · User-defined Functions
Data Handling using Pandas	15	Medium	Series and DataFrame · Data Import (CSV) · Filtering and Selection
Data Visualisation	10	Easy	Line Chart, Bar Chart, Histogram · Pie Chart, Scatter Plot · Chart Customisation
Database Concepts	8	Easy	DBMS vs RDBMS · Primary Key, Foreign Key · ER Diagram Basics
Structured Query Language (SQL)	15	Medium	DDL: CREATE, ALTER, DROP · DML: SELECT with WHERE, GROUP BY, ORDER BY, HAVING · Aggregate Functions
Computer Networks	10	Medium	OSI Model (7 layers) · TCP/IP Model · Network Devices (Hub, Switch, Router)
Society, Law and Ethics	7	Easy	Cybercrimes · IT Act 2000 · Digital Footprint

Topics That Appear Every Year

01Pandas — DataFrame creation, CSV import, filtering, groupby, missing values

02SQL — SELECT with WHERE, GROUP BY, HAVING, JOIN, aggregate functions

03Matplotlib — all chart types with axis labels and title customisation

04OSI model — 7 layers and function of each layer

05Network devices — hub vs switch vs router differences

06Cybercrime types and IT Act 2000 key provisions

Study Strategy for 90+

IP is data-science focused — 40% of theory marks come from Pandas, Matplotlib, and SQL combined

SQL questions (15 marks) — write complete queries with syntax, always test ORDER BY and HAVING conditions

Pandas (15 marks) — know all key methods: read_csv, loc, iloc, groupby, fillna, dropna, describe

Networks (10 marks) — memorise OSI layer names and functions; hub vs switch vs router is a guaranteed MCQ

Society and Ethics (7 marks) — pure memory; IT Act, digital footprint, FOSS vs proprietary are predictable

Practicals carry 30 marks — the hands-on skills directly translate to theory answers

Related Study Tips

All Study Tips →

Board Exam Hacks

How the CBSE Marking Scheme Works (And Why Most Students Don't Know)

5 min read Board Exam Hacks

The Exact Answer Format CBSE Examiners Want for Every Mark Value

5 min read

From guide to practice

Know what to study. Now practise it.

ClearSteps gives you CBSE Class 12 Informatics Practices mock papers, concept videos for every chapter, and AI evaluation against the real CBSE marking scheme.

Try ClearSteps Free →Read More Study Tips