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!

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.

IP Practical exam guide

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 Series practical programs

Pandas Dataframe

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

Consider the following data for :      

BookIDSubjectBookTitleClassPublisherPrice
B0001Computer ScienceNCERT Computer ScienceXIINCERT270
B0002Computer ScienceMove fast with computer scienceXIIDhanpat Rai340
B0003Computer ApplicationsSample PapersXBPB120
B0004Informatics PracticesNCERT Computer ScienceXIINCERT270
B0005Artificial IntelligenceArtificial IntelligenceIXKIPS340
B0006Informatics PracticesCBSE Questions BankXIIOswal Books299
  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(books[books['Class']=='XII'].to_string(header=False,index=False))
    print("***********************************************************")
    print("Books having price more than 250")
    print(books[books['Price']>250].to_string(header=False,index=False))
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

Consider the following table and write answers for given questions below:
RollNoNameClassDOBGenderCityMarks
1NamanXII1995-05-09MAnand453
2NandiniX1997-04-08FBaroda551
3NakshatraX1997-03-02FBaroda553
4ShaileshXI1995-04-07MSurat458
5TrishaXII1996-04-01FAnand430
6ManishaXII1995-02-05FAnand530
7HetveeXII1995-08-17FJunagadh555
8NeelX1997-10-19MGodhara559
9MayurXII1996-12-04MSurat570
10DolinXII1994-11-02MAnand585
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

Comment Your Views

%d bloggers like this: