Q.
SET -1
SENIOR SECONDARY PRACTICAL EXAMINATION
INFORMATICS PRACTICES(065)
SCHOOL CODE: 75657
TIME:3hrs MAXIMUMMARK:30
Q1.a.Create a dataframe using a dictionary with the given data display it : (1)
‘2015’:[256,452,635,965],’2016’:[745,785,478,547],
‘2017’:[452,474,725,854],’2018’:[1021,958,528,425]
Index=[‘qtr1’,’qtr2’,’qtr3’,’qtr4’]
Find the following:
i) Sales in qtr4 during the year 2018 (1)
ii)Sales of 2017 (1)
iii) Sales in quarter2 (1)
b.Draw the double bar graph for the data given below using matplotlib
[1,3,6,7,9],[5,2,7,8,2] and [2,4,6,8,10],[8,6,2,5,6] with appropriate Graph title, x-axis title, y-axis title,
legends and color etc. (4)
Q2. Consider the following table RESULT and write answers for given questions below: (7)
studentid name stream Marks
1 Miya Science 98
2 Riya Commerce 90
3 Arya Humanities 80
4 Niya Science 96
5 Siya Commerce 97
6 Anu Science 92
7 Kavya Science 96
8 Manju Commerce 92
Write SQL statements for the following based on table Result:
a) Write sql query to insert the details of new student in the below table.
b) Write MySQL query to list the details of all the students who have secured more than 80
marks. c)Write MySQL query to find the min,max of marks of students in RESULT table. d)
Write MySQL query to display the name of student in the commerce stream. e) Write MySQL
query to display the student details in the descending order of marks. g) Write MySQL query
to display the student name in the ascending order.
f) Display the stream where the number of students is greater than 2.
Q3. Practical Records (5)
Q4. Project Work (5)
Q5. Viva Voce (5)
Q.SET -2
SENIOR SECONDARY PRACTICAL EXAMINATION 2024-25
INFORMATICS PRACTICES (065)
SCHOOL CODE: 75657
TIME:3hrs MAXIMUMMARK:30
Q1. a) Consider a series and object ‘s’ that stores the charity combination (in Rs) of
each section of a school as shown below create and display it: - (1)
XI A 6700
XI B 5600
XI C 5000
XI D 5200
XI E 6200
XI F 5800
i) Display third and fourth elements (using iloc) (1)
ii) Display second, third and fourth elements (using loc) (1)
iii) Modify the amount of section ‘XI A’ as 7600 and for sections ‘XI C’ and ‘XI D’ as 7000 (1)
b) Represent the popularity of different beverages: ‘Coffee’, ‘Tea’, ‘Soda’, ‘Juice’, ‘Water’, ‘Milk’ based
on ratings from different people as 8, 6, 5, 7, 9, 4 respectively using a horizontal bar chart with
appropriate Graph title, x-axis title, y-axis title,legends and color etc. (4)
Q2. Consider the following table STUDETNTZ and write answers for given questions below: (7)
rollno name class marks DOB
104 Ali 12a 6 2004-12-10
105 Arsiya 12d 9 2006-03-11
101 Ruhani 12c 7 2005-07-10
104 Kushal 12b 5 2007-02-05
103 Simran 12a 9 2006-03-04
a) Display day of year from each student.
b) Display the names of student in lower case.
c) Write MySQL query to display the name of students with marks 9. d) Write MySQL
query to display the student details in the ascending order of the Marks e) Display
the class where the marks are greater than 6.
f) Write MySQL query to find the avg marks of student in each
class. g) Write MySQL query to find the number of students in
each class. Q3. Practical Records (5)
Q4. Project Work (5)
Q5. Viva Voce (5)
Q.SET - 3
SENIOR SECONDARY PRACTICAL EXAMINATION 2024-25
INFORMATICS PRACTICES (065)
SCHOOL CODE: 75657
TIME:3hrs MAXIMUMMARK:30
Q1. a).Create a student record dataframe from the given data and display (1)
Name Age Stream Percentage
Ankit 21 Maths 88
Amit 19 Commerce 92
Aishwarya 20 Science 95
Priyanka 18 Maths 70
Priya 17 Maths 65
Shaurya 21 Science 78
i) Display the records where age greater than or equal to 20 (1)
ii) Display the first 3 records in the DataFrame. (1)
iii) Display the records where the stream is Maths
b) Create a Histogram to show the performance of the monthly income of employees in a company (in
thousands of dollars). Males = [45, 48, 52, 55, 59, 61, 70, 72, 85, 90, 105, 110] Females = [40, 42, 47, 51,
55, 58, 65, 68, 80, 85, 95, 100] (4)
Q2. Consider the following table RESULT and write answers for given questions below: (7)
studentid name stream Marks
1 Miya Science 98
2 Riya Commerce 90
3 Arya Humanities 80
4 Niya Science 96
5 Siya Commerce 97
6 Anu Science 92
7 Kavya Science 96
8 Manju Commerce 92
Write SQL statements for the following based on table Result:
a) Display the names of student in Uppercase.
b)Display the number of characters of each student name from table RESULT.
c) Display first three characters from name field of student.
d) Display first occurrence of letter a in name field of student.
e) Write mysql query to display the student details in the decending order of marks
f) Write mysql query to display the name of student in the commerce stream.
g)Write mysql query to display the details of student with their name starting with “M”.
Q3. Practical Records (5)
Q4. Project Work (5)
Q5. Viva Voce (5)
Q.SET -4
SENIOR SECONDARY PRACTICAL EXAMINATION 2024-25
INFORMATICS PRACTICES (065)
SCHOOL CODE: 75657
TIME:3hrs MAXIMUMMARK:30
Q1. a. Consider 3 series and create it:
i) s1= [11,12,13,14], index = [1,2,3,4]
ii) s2= [21,22,23,24], index=[1,2,3,4]
iii) s3= [21,22,23,24], index= [101,102,103,104] (2)
iv) Perform all mathematical operations (+,-, *, /) with series s1 and s2 (1)
v) Also Perform addition with series s1 and s3. (1)
b. Program to plot line chart to solve the following algebraic expression y=10*x+14 ] with appropriate
Graph title, x-axis title, y-axis title, legends and color etc. (4)
Q2. Consider the following table STUDETNTZ and write answers for given questions
below(7)
rollno name class marks DOB
104 Ali 12a 6 2004-12-10
105 Arsiya 12d 9 2006-03-11
101 Ruhani 12c 7 2005-07-10
104 Kushal 12b 5 2007-02-05
103 Simran 12a 9 2006-03-04
a) Display the names from STUDENTZ table in uppercase.
b) Display the names of student starting from 3rd character.
c) Display names of student starting from 2rd character and no: of letter be displayed is 4.
d) Display the number of characters of each student name from table STUDENTZ.
e) Display year from DOB field of student
f) Display student name after removing leading and trailing space.
g) Display first occurrence of letter a in name field of student.
Q3. Practical Records (5)
Q4. Project Work (5)
Q5. Viva Voce (5)
