By Geethika Reddy ·

Class 12 IP Project Ideas: Python, Pandas and SQL for 2026-27

Choose a manageable Class 12 Informatics Practices project with useful data, clear analysis and charts. See original topic ideas, a file plan and viva preparation.

Class 12 IP Project Ideas: Python, Pandas and SQL for 2026-27

A good Class 12 IP project starts with a question you can answer using data. Choose a topic small enough to build yourself, then show how you cleaned the data, analysed it and explained the result. A working project you understand is more useful than a long downloaded file you cannot demonstrate.

The CBSE Informatics Practices syllabus for 2026-27 asks for a useful IT application based on a real-world problem. It allows analysis of CSV or database data with Python libraries and suitable charts. For Class 12, project work carries 5 marks within the 30-mark practical assessment; viva voce carries a separate 5 marks.

Five project ideas you can keep manageable

These are suggested starting points, not a board-approved topic list. Discuss the scope with your teacher before collecting data.

1. School canteen demand

Question: which items sell most on different days? Use a small dataset with date, item, quantity and price. Calculate item-wise sales, check for missing entries and compare demand with a labelled bar chart. Use sample data if the canteen cannot share records, and clearly label it as simulated.

2. Library borrowing patterns

Question: which book categories are borrowed most? Work with book category, issue date and return date. Summarise borrowing by month and identify overdue durations. Use anonymous record IDs instead of student names; the analysis does not need personal contact details.

3. Household electricity use

Question: how does monthly electricity consumption change? Record billing month and units consumed from bills you have permission to use. Plot units over time and discuss unusual changes. Keep tariff calculations outside your scope unless you can explain the applicable rules accurately.

4. A small shop’s stock movement

Question: which products need attention because sales are high or stock is low? Create product and sales tables, use SQL to retrieve the records you need and compare categories in Python. Start with a few products and a clear date range rather than trying to build a complete billing system.

5. Daily temperature patterns

Question: how does temperature vary across a selected month? Use a public dataset with a stated source and units. Check missing dates, calculate summary values and draw a line chart. Describe observed patterns; this analysis is not a weather forecast.

Build a small version before adding features

  1. Write one question and identify the columns needed to answer it.

  2. Prepare a small CSV or database table and explain each field.

  3. Check missing values, duplicate records and inconsistent units.

  4. Run the analysis and create a chart with a readable title and axis labels.

  5. Test the result on a few rows you can calculate manually.

  6. Write what the result shows and what the dataset cannot tell you.

Keep an unchanged copy of the original data. If you correct or remove a record, note why. That makes your analysis easier to explain and repeat.

What to put in your project file

Follow your school’s required cover-page and certificate format. For the main report, a useful order is: problem, dataset and source, tools, cleaning decisions, code, outputs, findings, limitations and references. This is a suggested structure, not a compulsory CBSE page template.

Reference any borrowed data, images or code. The syllabus permits individual work or groups of two to three students. In a group, keep a short record of each member’s contribution and make sure everyone can explain the complete result.

Prepare to explain your own work

Practise answering why you selected a chart, how you treated a missing value and what a SQL query returns. Then change one input row and explain what should happen to the output. A business plan or accounting file becomes an IP project only when the computing and data work is clearly demonstrated; a topic name alone does not satisfy that purpose.

Keep revision of theory and practical work moving together. For board-examination planning, see the CBSE 2027 date-sheet guide.