# Solved IP Practical Paper for CBSE Board Exam 2021

Solved IP Practical Paper for CBSE Board Exam 2021 is dedicated to all class 12 IP students. In this article you will get a solved IP practical paper for CBSE board exam 2021. So here we go!

Topics Covered

## Solved IP Practical Paper for CBSE Board Exam 2021

CBSE has already released a detailed circular to conduct the practical exam 2021 smoothly. These exams can be conducted from 01/03/2021 to 11/06/2021. So I am writing this article to help students for the same. Here I will explain the Solved IP Practical Paper for CBSE Board Exam 2021. So let’s start!

If you want to download the practical file for IP class 12 follow this link to download and know the questions paper patter.

So as per the revised curriculum of Informatics Practices (065), The questions paper is divided into following parts:

1. Programs using Pandas and Matplotlib
2. MySQL

## Programs using Pandas and Matplotlib

In this part of Solved IP Practical Paper for CBSE Board Exam 2021, programs from Pandas and Matplotlib can be asked. Here I have added 3 programs.

1. Pandas Series
2. Pandas Dataframe
3. Matplotlib

### Pandas Series

I have taken the question for pandas series for 2 marks:

Write a program to generate a series of marks of 10 students. Give grace marks up to 3 marks of those who are having marks between 30 to 33 marks and print the new list of the marks.

Solution:

``````import pandas as pd
def Ser_stumarks():
std_marks = []
for i in range(1,11):
m = int(input("Enter the marks:"))
std_marks.append(m)
s = pd.Series(index=range(1201,1211),data=std_marks)
s[s==32]=s+1
s[s==31]=s+2
s[s==30]=s+3
print("New List is:")
print(s[s>=33])
Ser_stumarks()``````

If you are looking for pandas series programs follow the below given link:

### Pandas Dataframe

I have taken question from pandas dataframe for 3 marks. Here

Consider the following data for :

1. Create a dataframe using lists.                                                                                           1
2. Display books for class XII.                                                                                                         1
3. Display the books whose price is more than 250.                                                                         1
4. Plot these data on line chart.                                                                                                         3

Code for 1,2, and 3.

``````import pandas as pd
def books_q2():
data={'BookID':['B0001','B0002','B0003','B0004','B0005','B0006'],\
'Subject':['Computer Science','Computer Science','Computer Appllications',\
'Informatics Practices','Artificial Intelligence','Informatics Practices'],\
'Class':['XII','XII','X','XII','IX','XII'],'Publisher':['NCERT','Dhanpat Rai','BPB','NCERT','KIPS','Oswal books'],\
'Price':[270,340,120,270,340,299]}
books=pd.DataFrame(data)
print("Class XII Books:")
print("***********************************************************")
print("Books having price more than 250")
books_q2()
``````

Code for 4

``````import pandas as pd
import matplotlib.pyplot as mpp
def books_q2():
data={'BookID':['B0001','B0002','B0003','B0004','B0005','B0006'],\
'Subject':['Computer Science','Computer Science','Computer Appllications',\
'Informatics Practices','Artificial Intelligence','Informatics Practices'],\
'Class':['XII','XII','X','XII','IX','XII'],'Publisher':['NCERT','Dhanpat Rai','BPB','NCERT','KIPS','Oswal books'],\
'Price':[270,340,120,270,340,299]}
books=pd.DataFrame(data,columns=['BookId','Subject','Class','Price'])
books.plot(x='Subject',y='Price',kind='bar')
mpp.show()
books_q2()
``````

## MySQL

##### Write SQL statements for the following based on table Garments:
• Create above table in MySQL.
• Insert records.
• To display the detail of class XII students in descending order of their marks.

(b) Display all the details of students in ascending order of name.

• Find the maximum marks of the student for each class.
• Count the students class wise is display only those number who is more than 2.
• Display unique cities from the table.

Q3. Practical Records                                                                                                           5

The practical file needs to be checked and marks will be given accordingly.

Q4. Project Work                                                                                                                  5

The project work report should be made as per the guideline.

Q5. Viva Voce                                                                                                  5

Viva questions can be asked by the external examiner.

I hope hope you enjoyed this article -Solved IP Practical Paper for CBSE Board Exam 2021 . Download the files for Solved IP Practical Paper for CBSE Board Exam 2021 by following the below given links.

### 2 thoughts on “Solved IP Practical Paper for CBSE Board Exam 2021”

1. Dear Sir,

Can you tell me how to add explanation video during presentation or pdf file.

Thanking you

1. I am recording the screen and video at the same time afterwards mixing them.