Subject guides · BoardPrep blog
How to Score 90+ in CBSE Class 12 Informatics Practices (Pandas & SQL)
How to score 90+ in Class 12 Informatics Practices. SQL and Pandas carry most of the marks; here's how to practise queries, DataFrames and plotting.
Informatics Practices (IP) is mostly SQL and Pandas, with networks and societal impacts making up the rest.
Where the marks are
| Chapter | Avg marks per paper | Share |
|---|---|---|
| Database Query using SQL | 23.8 | 35% |
| Pandas: Series & DataFrame | 20.5 | 31% |
| Computer Networks | 11.2 | 17% |
| Data Visualisation | 6.2 | 9% |
| Societal Impacts | 5.2 | 8% |
Averaged across 4 CBSE Class 12 Informatics Practices (IP) board papers, 2023–2026. All chapters
SQL
- single-row functions (math, text, date) and aggregate functions
- GROUP BY with HAVING, ORDER BY
- predict the output of queries on a given table
Pandas
- creating and accessing Series and DataFrames
- selecting rows and columns (loc, iloc), adding and deleting columns
- reading and writing CSV files
- Matplotlib plotting: line, bar and histogram, with labels and titles
Practise by hand
Board questions ask you to write code or predict output on paper. Trace small DataFrame examples by hand.
Practise this free on BoardPrep
Open the free app →192 CBSE board papers split into single questions with official answers, chapter-wise practice and unlimited mock papers. 100% free: no ads, no paid plan, no hidden charges.