CBSE IP Board Practical Paper 1 Solution 2026

In this article, I am going to discuss CBSE IP Board Practical Paper 1 Solution 2026. CBSE has already released the guidelines for the board practical exam for the current academic year. Let us start!

CBSE IP Board Practical Paper 1 Solution 2026

The CBSE IP Board Practical Paper 1 Solution 2026 contains 2 questions. Question 1 is based on Python Pandas and Matplotlib as question 2 is based on MySQL Queries. Here we go!

Question 1 Python Pandas and Matplotlib

Q:1    Write Python code for the following questions:

a)         Create a dataframe named CWC.   [2]

b)         Display the team having more than 50 wins.    [1]

c)         Add a new row values as(005, New Zealand, 59, 38, 1, 1, 99)       [1]

d)         Add new column ‘Title Won’ with data (6,2,2,1,0)                                                  [1]

e)         Display Total no. of rows in dataframe.                                                                  [1]

f)         Draw a bar chart to visual performances of wins of teams. (Add labels, legend, title)     [2]

Solution

import pandas as pd
#Answer 1
d={'ID':['001','002','003','004'],
   'Team':['Australia','India','West Indies','England'],
   'Win':[78,63,43,52],
   'Lost':[25,30,35,39],
   'No Result':[1,1,0,1],
   'Tie':[1,1,2,1],
   'Total':[105,95,80,93]
   }
CWC=pd.DataFrame(d)
print(CWC)

#Answer 2
print(CWC[CWC.Win>50].loc[:,'Team'])

#Answer 3
#CWC.loc[CWC.shape[0],:]=['005',' New Zealand', 59, 38, 1, 1, 99]
CWC.loc[len(CWC),:]=['005',' New Zealand', 59, 38, 1, 1, 99]
#d1={'ID':'005','Team':'New Zealand','Win':59,'Lost':38,'No Result':1,'Tie':1,'Total':99}
#CWC.append(d1,ignore_index=True)
print(CWC)

#Answer 4
#CWC['Title Won']=[6,2,2,1,0]
#CWC.loc[:,'Title Won']=[6,2,2,1,0]
CWC.insert(CWC.shape[1],'Title Won',[6,2,2,1,0])
print(CWC)

#Answer 5
print(len(CWC))
print(CWC.shape[0])

#Answer 6
import matplotlib.pyplot as plt
plt.bar(CWC.Team,CWC.Win)
plt.title("World Cup Summary")
plt.legend(["Win"])
plt.xlabel("Teams")
plt.ylabel("Wins")
plt.show()

Question 2 MySQL Queries

Q:2     Consider the following Table ‘Patient’ with the records given in it.

a) Create the above given table with appropriate data type and constraints.                                             [1]

b) Count the number of patients belongs to doctor no D201.  [1]

c) Display name of patient paying highest charge. [1]

 d) Display pno, name of patient in descending order of date of admission.                                             [1]

e)  Display the last name of patients from pname with date of admission.             [1]

f)  Display the patients details with charges converted to whole number.                                                 [1]

g) Display details of the patient paying minimum charge. [1]

Solution

Answer 1
create table patient
(pno char(4) primary key,
pname varchar(20) not null,
docno varchar(20),
date_adm date,
charges decimal(7,2));

insert into patient values
(‘P001′,’Vimal Jani’,’D201′,’2011-10-11′,20000.00),
(‘P002′,’Isha Roma’,’D506′,’2011-12-12′,50000.00),
(‘P003′,’Vina Verma’,’D201′,’2011-09-13′,15000.00),
(‘P004′,’Rita Sharma’,’D506′,’2011-08-05′,18000.00),
(‘P005′,’Shiv Roy’,’D210′,’2011-08-05′,20000.00);

Answer 2:
select count(*) from patient where docno=’D201′;

Answer 3:
select pname from patient where charges=(select max(charges) from patient);

Answer 4:
select pno,pname from patient order by date_adm desc;

Answer 5:
select substr(pname,instr(pname,’ ‘)),date_adm from patient;

Answer 6:
select pno,pname,docno,date_adm,round(charges) from patient;

Answer 7:
select * from patient where charges = (select min(charges) from patient);

Watch this video to understand it: