All India Senior Secondary Certificate Examination

School Code: xxxxx

Time 3 Hours | Subject: Informatics Practices (065) | M.M. : 30
Q1. Problem Solving using PANDAS & MATPLOTLIB [5 + 3 = 8]
1. Write the code to create a DataFrame ‘df’ and answer the questions followed. (5)
Maths Science SST
Amit 100 100.0 60.0
Mohan 95 50.0 57.48
Sudha 85 90.0 53.58

1. Write a command to add one column Total = Maths + Science + SST

2. Write a command to add one row T5 with values 75.6, 98.6, 56.0
3. Write a command to print Score of Maths and Science only.
4. Write a command to update marks of Science of Sudha to 85.0
5. Write a command to delete a row - Mohan
2. Write a Python program to display the given Result using a BAR CHART (3)
Maths Science SST
Amit 100 100.0 60.0
Mohan 95 100.0 57.48
Sudha 85 100.0 53.58
(i) Set the title of graph is “Result Analysis”
(ii) Display the legends.
(iii) Display the label of x axis to “Name” and y axis to “Score”
Q2 SQL Queries: [7]

Write the commands in SQL for (i) to (vi) and output for (vii) and (viii).
1. To list the names of items and their unit price that have unit price less than 800 and discount more than 5%.
2. To display the number of items that have more than 10% as discount.
3. To display item code and unit price in decreasing order of unit price.
4. To increase the unit price of each item by 10% of their unit price.
5. To display the highest unit price of items.
6. To display the names of items that have ‘Baby’ anywhere in their item names.
Find Output :
7. SELECT MID (Item,1,2) FROM Infant;
8. SELECT AVG(UnitPrice) FROM Infant WHERE DATEPURCHASE ‘2015–01–01’;
Q3 Practical Records [5]
Q4 Project Work [5]
Q5 Viva voce [5]
External Examiner Internal Examiner
Name : _______________________ Name : _________________________
Sign : _______________________ Sign : _________________________
Examiner No: __________________ Examiner No: ____________________
 All India Senior Secondary Certificate Examination
School Code: xxxxx
Time 3 Hours | Subject: Informatics Practices (065) | M.M. : 30
Q1. Problem Solving using PANDAS & MATPLOTLIB [5 + 3 = 8]
1. Consider the following DataFrame df and answer the given questions (i)- (v)
Rollno Name UT1 UT2 UT3 UT4
1 Prerna Singh 24 24 20 22
2 Manish Arora 18 17 19 22
3 Tanish Goel 20 22 18 24
4 Falguni Jain 22 20 24 20
5 Kanika Bhatnagar 15 20 18 22
(i) Write the command to print top two rows.
(ii) Write the command to print last two rows.
(iii) Write the command to add one more column in dataframe df name total. Total = UT1+UT2+UT3+UT4
(iv) Write the command to display the rows having roll no is 4
(v) Write the command will display the column labels of the DataFrame?

B. Draw the following bar graph representing the number of students in each class.

1. Set the appropriate label to x-axis and y-axis.

2. Set the title of Graph “Number of Students”

Q2. SQL Queries:- Write the SQL Commands to perform the following:- [7]
1. Create a student table with the student_id, name, and marks as attributes where the student_id is
the primary key.
2. Insert the details of a new student in the above table.
3. Delete the details of a student in the above table.
4. Use the select command to get the details of the students with marks more than 80.
5. Write a SQL query to display names into capital letters, small letters, display first 3 letters of name,
display last 3 letters of name, display the position the letter 'A' in name.
6. Remove extra spaces from left, right and both sides from the text – “Informatics Practices Class XII”.
7. Display dayname, monthname, day, dayname, day of month, day of year for today’s date.

Q3 Practical Records [5]

Q4 Project Work [5]
Q5 Viva voce [5]

External Examiner Internal Examiner

Name : _______________________ Name : _________________________
Sign : _______________________ Sign : _________________________
Examiner No: __________________ Examiner No: ____________________
 All India Senior Secondary Certificate Examination
School Code: xxxxx
Time 3 Hours | Subject: Informatics Practices (065) | M.M. : 30
Q1. Problem Solving using PANDAS & MATPLOTLIB [5 + 3 = 8]
1. Write a program in Python Pandas to create the following DataFrame batsman from a Dictionary: (5)
B_NO Name Score1 Score2
1 Sunil Pillai 90 80
2 Gaurav Sharma 65 45
3 Piyush Goel 70 90
4 Kartik Thakur 80 76
Perform the following operations on the DataFrame :
1. Add both the scores of a batsman and assign to
column “Total”
2. Display the highest score in both Score1 and Score2
of the DataFrame.
3. Display the DataFrame.
4. Display the details of Piyush Goel

5. Write the code to draw the following line graph. (3)

6. Set the appropriate label to x-axis and y-axis.
7. Set the title of Graph “Number of Students”
8. Show the grid lines.
Q2. SQL Queries:- Consider the following tables CARDEN. Write SQL commands for the following
statements.

1. To display the names of all Silver colored Cars.

2. To display name of car, Company and capacity of Cars in descending order of their seating capacity
3. To display the highest charges at which a vehicle can be hired from Carden.
4. To increase the charges by 5% for Suzuki company
5. Write a SQL query to display CarName and Company together of those cars which name are having
'n' at anywhere or charges greater than 14
6. Write output for the following MYSQL queries:-
1. SELECT LEFT(CarName, 3) FROM CARDEN;
2. SELECT MID(CarName, 2,3) FROM CARDEN;
3. SELECT POW(CAPACITY, 2) FROM CARDEN WHERE CHARGES IN (12,14);
4. SELECT MAX(CHARGES), COMPANY FROM CARDEN GROUP BY COMPANY;
Q3 Practical Records [5]
Q4 Project Work [5]
Q5 Viva voce [5]
External Examiner Internal Examiner
Name : _______________________ Name : _________________________
Sign : _______________________ Sign : _________________________
Examiner No: __________________ Examiner No: ____________________
 All India Senior Secondary Certificate Examination
School Code: xxxxx
Time 3 Hours | Subject: Informatics Practices (065) | M.M. : 30
Q1. Problem Solving using PANDAS & MATPLOTLIB [5 + 3 = 8]
a) Write the code to create a DataFrame ‘RESULT’ and answer the questions followed. (5)
Col1 Col2 Col3
T1 50.0 98.0 60.0
T2 95.5 65.0 57.5
T3 NaN 75.0 69.5
T4 82.0 85.4 49.0
1. Write a command to add one column Total = col1+ col2 + col3
2. Write a command to add one row T5 with values 75.5, 98.0, 56.0
3. Write a command to change the column names Col1 to Maths, Col2 to Science, Col3 to SST.
4. Write a command to print Score of Moths and Science only.
5. Write a command to update a value of T3 Row and Col1 / update NaN to 85.0

b) Write a Python program to display the Result using a LINE PLOT (table is given in Q1 (a) ) (3)
Maths Science SST
Amit 100 100.0 60.0
Mohan 95 100.0 57.48
Sudha 85 100.0 53.58
(i) Set the title of graph is “Result Analysis”
(ii) Display the legends.
(iii) Display the label of x axis to “Name” and y axis to “Score”
Q2. SQL Queries:- Consider the following tables CARDEN. Write SQL commands for the following
statements.

5. To display the names of all Silver colored Cars.

6. To display name of car, Company and capacity of Cars in descending order of their seating capacity
7. To display the highest charges at which a vehicle can be hired from Carden.
8. To increase the charges by 5% for Suzuki company
9. Write a SQL query to display CarName and Company together of those cars which name are having
'n' at anywhere or charges greater than 14
10. Write output for the following MYSQL queries:-
11. SELECT LEFT(CarName, 3) FROM CARDEN;
12. SELECT MID(CarName, 2,3) FROM CARDEN;
13. SELECT POW(CAPACITY, 2) FROM CARDEN WHERE CHARGES IN (12,14);
14. SELECT MAX(CHARGES), COMPANY FROM CARDEN GROUP BY COMPANY;
Q3 Practical Records [5]
Q4 Project Work [5]
Q5 Viva voce [5]
External Examiner Internal Examiner
Name : _______________________ Name : _________________________
Sign : _______________________ Sign : _________________________
Examiner No: __________________ Examiner No: ____________________
 All India Senior Secondary Certificate Examination
School Code: xxxxx
Time 3 Hours | Subject: Informatics Practices (065) | M.M. : 30
Q1. Problem Solving using PYTHON [5 + 3 = 8]
1. Write the code to create the series ‘serObj’ and answer the questions followed. (5)
Jan 31
Feb 28
Mar 31
Apr 30
1. Write the command to add one row: ‘May’ – 31
2. Write the command to update Feb to 29
3. Write the command to change index to 1,2,3,4,5 in place of Jan, Feb, Mar, Apr and May.
4. Write a command to print a month name having number of days less than 31.
5. Write the output:
1. print(serObj < 30)
2. print(serObj + 3)

3. Write a Python program to display a BAR CHART of the number of students in a school. (3)
1. Use different colors for each bar.
2. Title for x axis should be ‘Groups’ and title for y axis should be ‘Number of Students’
3. Ensure the title of chart is “Group wise Students” and grid line must be shown.
Sample data: Group: I, II, III, IV and Strength: 38, 30, 45, 49

Q2 SQL Queries: [2+5=7]

1. Create a table DRUGDB with the fields given in below table and assuming data type of your own.
2. Consider the table DRUGDB. Write the SQL commands for queries given below:
1. To increase the price of “Paracetamol” by 35.
2. To display the drugid, Rxid and pharmacy name of all records in descending order of their price.
3. Display all the details of the drugs where name starts with ‘C’ and has ‘sh’ somewhere in the name.
4. Display the drug name in lower case along with price rounded off to nearest interger.
5. Delete the field name loc from drugdb table.
Q3 Practical Records [5]
Q4 Project Work [5]
Q5 Viva voce [5]

External Examiner Internal Examiner

Name : _______________________ Name : _________________________
Sign : _______________________ Sign : _________________________
Examiner No: __________________ Examiner No: ____________________
 SSCE Practical Examination – 2024
Sub: Informatics Practices (065)
Class : XII Set 5 Marks : 30 M
Time : 3 hrs Date :___/____/2024
Q1. (Programs using Pandas and Matplotlib)
a. Write a program to generate a series of 5 tourist places and distance in kilometers from
your city. Apply city name as label and display only those cities which are having
distance less than 250 kms. 2
b. Consider the following dataframe 'df' with default index (0,1,2,3,4) with following
details:
name Sales commission
0 Ansh 250 2500
1 Dev 275 2750
2 Henil 600 3000
3 Krish 300 1500
4 Kartvya 550 2500
i. Write a python script/program for the following with appropriate messages:
a. To create & display the dataframe 'df' with the given details. 1
b. To display data whose commission is less than 3000.
c. To insert a new row with data [‘Param’,325,3250] 1
c. To plot a line chart showing Name, Sales with following specifications:
x-axis label as 'Salesmen', y-axis label as 'Sales', Title of the chart is 'Sales
Analysis'. Also display the legends. 3
Q2. MySQL Queries
1. Create a database named Krish_Automobiles and open database. 1
2. Create following table - "cars" and insert records. 2
Carid Manufacturer Style Wheel Cylinders Manufacturedate
1212 BMW Sedan 101.234 4 2018/04/01
1213 Honda Sedan 101.261 4 2019/06/03
1214 Toyota Hatchback 96.253 6 2020/01/07
1215 Tata SUV 110.548 6 2021/12/01
1216 BMW Hatchback 101.459 4 2018/02/04
1217 Maruti Suzuki Sedan 103.856 4 2019/03/01
3. Write queries based on the table candidate 4
 Display manufacturer and wheel base after rounding off to two decimal points.
 Display carid, manufacturer, style and display the position of back in car style.
 Display maximum, minimum and sum of cylinders
 Display first three letters of manufacturers
Q3. Practical File 5
Q4. Project Work 5
Q5. Viva 5
 SSCE Practical Examination – 2024
Sub: Informatics Practices (065)
Class : XII Set 5 Marks : 30 M
Time : 3 hrs Date :___/____/2024
Q1. (Programs using Pandas and Matplotlib)
a. Write a program to generate a series of 5 tourist places and distance in kilometers from
your city. Apply city name as label and display only those cities which are having
distance less than 250 kms. 2
b. Consider the following dataframe 'df' with default index (0,1,2,3,4) with following
details:
name Sales commission
0 Ansh 250 2500
1 Dev 275 2750
2 Henil 600 3000
3 Krish 300 1500
4 Kartvya 550 2500
i. Write a python script/program for the following with appropriate messages:
a. To create & display the dataframe 'df' with the given details. 1
b. To display data whose commission is less than 3000. 1
c. To insert a new row with data [‘Param’,325,3250] 1
c. To plot a line chart showing Name, Sales with following specifications:
x-axis label as 'Salesmen', y-axis label as 'Sales', Title of the chart is 'Sales
Analysis'. Also display the legends. 3
Q2. MySQL Queries
1. Create a database named Krish_Automobiles and open database. 1
2. Create following table - "cars" and insert records. 2
Carid Manufacturer Style Wheel Cylinders Manufacturedate
1212 BMW Sedan 101.234 4 2018/04/01
1213 Honda Sedan 101.261 4 2019/06/03
1214 Toyota Hatchback 96.253 6 2020/01/07
1215 Tata SUV 110.548 6 2021/12/01
1216 BMW Hatchback 101.459 4 2018/02/04
1217 Maruti Suzuki Sedan 103.856 4 2019/03/01
3. Write queries based on the table candidate 4
 Display manufacturer and wheel base after rounding off to two decimal points.
 Display carid, manufacturer, style and display the position of back in car style.
 Display maximum, minimum and sum of cylinders
 Display first three letters of manufacturers
Q3. Practical File 5
Q4. Project Work 5
Q5. Viva 5

…………………………………………………………………………………………………………………………………………
Q:1 Consider the following scooter.csv file and write code for below given questions:
 ScooterID ScooterName Price Company Qty
S001 Activa 6 G 78000 Honda 18
S002 NTorq 88000 TVS 43
S003 Jupiter 77000 TVS 17
S004 Access 82000 Suzuki 24
S005 Burgman 95000 Suzuki 26
a) Read CSV scooter.csv file and create the pandas dataframe. [2]
b) Display only scooter names and price which qty is less than 30. [1]
c) Display top 3 records from the dataframe. [1]
d) Display scooter details manufactured by TVS and Suzuki [1]

e) Display the number of rows and columns of dataframe. [1]

f) Draw a line chart which represent scooter name on x-axis and price on y-axis. Label [2]
the chart properly and display legends.

Q:2 Consider the following Table ‘Store’with the records given in it. Write SQL queries
for the following:
Stid Name City Noofemploye Dateopened Salesamount
e
S10 India mart Delhi 12 2020-05-18 340000
1
S10 Super Mumbai 20 2021-08-22 390000
2 market
S10 Planetorium Delhi 17 2019-02-14 240000
3
S10 Gulnaz Delhi 10 2022-04-01 180000
4
S10 Libaas Mumbai 8 2020-11-24 20000
5
a. Create the above given table with appropriate data type and constraints. [1]

b. Display Name and city of the store open in year 2020. [1]

c. Count the store in different city. [1]

d. Display the table details in ascending order of salesamount. [1]

e) Display the total noofemployees for stores in each city. [1]

f) Calculate the discount value for all bikes as 8% of saleamount. [1]
g) Display the stores open in the month of August. [1]
Q:3 Practical file [5]
 Q:4 Project file [5]
Viva-voce [5]
Q:5

SSCE Practical Examination - 2024

Sub: Informatics Practices (065)
Class : XII Set 2 Marks : 30 M
Time : 3 hrs Date :___/___/2024
…………………………………………………………………………………………………………………………………………
Q:1 Write Python code for the following questions:

SNO Batsman Run

Innings SR
s
1 Virat Kohli 11 765 90.32
2 Rohit Sharma 11 597 125.95
3 Quinton de
10 594 107.03
Kock
4 Rachin Ravindra 10 578 106.45
5 Daryl Mitchell 8 418 111.07
a) Create a dataframe ‘Cric23’ using dictionary. [2]
b) Display the Batsman name along with runs scored. [1]
c) Add one more column ‘Average’ which contains the value as division of runs and [1]
innings. Add this column before SR column and after Runs column.
d) Change the data for Daryl Mitchell – Innings – 9 , Runs - 552. [1]
e) Convert the dataframe as ’TOP5.CSV’. [1]
f) Using a dataframe ‘Cric23’ ,plot a labelled bar chart to compare the runs for all [2]
batsmen with x axis having Batter name and customize the chart appropriately with
labels and legends.
Q:2 Consider the following Table ‘Garment’ with the records given in it. Write SQL
queries for the following:
Gcod Gname Qty Price Company
e
G100 Suiting 10 5000 Raymond
1
G100 Shirting 15 2200 Vardhman
2
G100 Jeans Pant 10 1500 Ruf n Tuf
3
G100 Krutas 50 4800 Fabindia
4
G100 Choli 30 1800 Arika
5 0
G100 Formal Pant 50 5500 Raymond
6
 a. Create above table garment [1]

b. Count the unique company from garment. [1]

c. Display maximum price of garment manufactured by raymond. [1]

d. Display the average price of Pant. [1]

e) Display the garment number, garment name and company in the descending order of [1]
their price.
f) Find the difference between maximum price and minimum price from the table. [1]
g) Display garment in upper case letters and ‘discountedprice’ which is price minus 5 % [1]
of price for price in between 2100 to 10000.
Q:3 Practical file [5]
Q:4 Project file [5]
Viva-voce [5]
Q:5
SSCE Practical Examination – 2024
Sub: Informatics Practices (065)
Class : XII Set 1 Marks : 30 M
Time : 3 hrs Date :__/____/2024
Q:1 Write Python code for the following questions:

ID Team Win Lost No Result Tie Total

00 Australia
78 25 1 1 105
1
00 India
63 30 1 1 95
2
00 West Indies
43 35 0 2 80
3
00 England
52 39 1 1 93
4
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, [2]
title)
Q:2 Consider the following Table ‘Patient’ with the records given in it.
Pno Pname Docno Date_adm Charges
P001 Vima Jani D201 2011-10-11 20000.00
P002 Isha Roma D506 2011-12-12 50000.00
P003 Vina Verma D201 2011-09-03 15000.00
P004 Rita Sharma D506 2011-08-05 18000.00
P005 Shiv Roy D210 2011-08-05 20000.00

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]
Q:3 Practical file [5]
Q:4 Project file [5]
Q:5 Viva-voce [5]