SSCE PRACTICAL EXAMINATION 2024-2025

School Code : 75062

School Name : AIRPORT SENIOR SECONDARY SCHOOL
Class : XII
Subject Code : 065
Subject : INFORMATICS PRACTICES
Reg.No :
Date : 21/1/25
Max.Marks : 30
Time : 3:00 HRS
Q.No Description Marks

SECTION - A (Programs using Pandas and Matplotlib)

Q1. To write a Python program to create a panda’s DataFrame called DF for [4]
the following table Using Dictionary of List and perform the following
operations:

(i) To Display only column 'Toys' from DataFrame DF.

(ii) To Display the row details of 'AP' and 'OD' from DataFrame DF.

(iii) To Display the column 'Books' and 'Uniform' for 'M.P' and 'U.P' from
DataFrame DF.

(iv) To Display consecutive 3 rows and 3 columns from DataFrame DF.

Q2. Write a Python program to plot a Line chart to depict the changing weekly [4]
Onion and Brinjal prices for four weeks. Also, give appropriate axes labels,
title and color keep marker style as Diamond and marker edge color as
'red' for Onion, keep marker style as X and marker edge color as 'green' for
Brinjal

Weeks=[1,2,3,4]

Onion=[45,25,32,80]

Brinjal=[16,18,45,50]
 SECTION - B (SQL Queries)

Q3. Based on table STOCK given here, write suitable SQL queries and outputs
for the following:
[7]
TABLE : STOCK

(a) Write a SQL command to create the table Stock with given
attributes .
(b) Write a SQL command to update the quantity of Office 2007 from 2
to 4
(c) Write a SQL command to display Name, DOPURCHASE of Stock
whose Quantity is more than 2.
(d) Write a SQL command to display minimum Quantity and
maximum Quantity.
(e) Write a SQL command to display the year of date of purchase of
Mother Board
(f) Write a SQL command to display the Stock name
in lower case and length of Stock Name.
(g) Write a SQL command to display the position of occurrence of the
string "o" in Stock Name.

Q4. Practical Record [5]

Q5. Project file [5]
Q6. Viva Voce [5]

Internal Examiner External Examiner

[ ] [ ]
[EXTERNAL NUMBER:]
 SSCE PRACTICAL EXAMINATION 2024-2025
SET B

School Code : 75062

School Name : AIRPORT SENIOR SECONDARY SCHOOL
Class : XII
Subject Code : 065
Subject : INFORMATICS PRACTICES
Reg.No :
Date : 21/1/25
Max.Marks : 30
Time : 3:00 HRS
Q.No Description Marks

SECTION - A (Programs using Pandas and Matplotlib)

Q1.
Write a Python program to create a panda’s DataFrame called DF for the [4]
following table Using Dictionary of List and perform the following operations:

(i) To Display only column 'Degree' from DataFrame DF.

(ii) To Display the Shape and Size of the Dataframe DF
(iii) Insert a new column "City" with values as:
["Chennai","Delhi","Goa",'Chennai',’Bangalore’]
(iv) Delete the row details of "S4" from DataFrame DF.

Q2. [4]
Write a Python program to plot a bar chart for the following data
representing the number of people and their hobbies. Specify each bar with
different colors. Provide appropriate titles and axis labels for the bar chart.
 SECTION - B (SQL Queries)
Q3. Based on table Salesman given here, write suitable SQL queries and [7]
outputs for the following:
TABLE: SALESMAN

(a) Display the total salary drawn by salesmen.

(b) Write a SQL command to display Sname and Salary of salesman
whose bonus is NULL.
(c) Write a SQL command to display the minimum salary of the
Salesman.
(d) Write a SQL command to display the month name for the date of
join of salesman.
(e) Write a SQL command to display Salesman name in descending
order.
(f) Write a SQL command to display four characters from salesman
name starting from second character.
(g) Write a SQL command to Display salesman name and bonus after
rounding off to zero decimal places.

Q4. Practical Record [5]

Q5. Project file [5]
Q6. Viva Voce [5]

Internal Examiner External Examiner

[ ] [ ]
[EXTERNAL NUMBER:]
 SSCE PRACTICAL EXAMINATION 2024-2025

School Code : 75062

School Name : AIRPORT SENIOR SECONDARY SCHOOL
Class : XII
Subject Code : 065
Subject : INFORMATICS PRACTICES
Reg.No :
Date : 21/1/25
Max.Marks : 30
Time : 3:00 HRS
Q.No Description Marks

SECTION - A (Programs using Pandas and Matplotlib)

Q1. [4]
Write a program in python to create the following dataframe named
“weather” storing the following details:

City MaxTemp MinTemp Rainfall

1001 Delhi 40 32 24.1
1002 Bangalore 31 25 36.2
1003 Chennai 35 27 40.8
1004 Mumbai 23 21 35.2
1005 Kolkata 39 22 41.8

i. Display the last 2 rows of the dataframe.

ii. Display the rows having rainfall less than 40
iii. Add the information of a new city with index 1006 and
data [’Pune’,34,26,34.9]
iv. Display the MaxTemp and MinTemp of Bangalore and Mumbai.

Q2. [4]
Plot a bar chart depicting the city on x-axis and rainfall on y-axis,
with appropriate Graph title, x-label ,y-label and different color for
each city .

City = [‘Delhi’,’Bangalore’,’Chennai’,’Mumbai’,’Kolkata’]

Rainfall = [24.1,36.2,40.8,35.2,41.8]
 SECTION - B (SQL Queries)

Q3. [7]
Based on table STUDENT table given here, write suitable SQL queries and
outputs for the following:

(a) Write a SQL command to create the table STUDENTS with given
attributes .
(b) Write a SQL command to display Remainder of column Marks
divided by 3.
(c) Write a SQL command to display first 2 characters of the column
Dept.
(d) Write a SQL command to display the average marks department
wise.
(e) Write a SQL command to display name of all the students where
marks less than 80.
(f) Write a SQL command to display Student name and month name
of the students ’ DOA’ .
(g) Write a SQL command to display student name and marks after
rounding off to zero decimal places.

Q4. Practical Record [5]

Q5. Project file [5]
Q6. Viva Voce [5]

Internal Examiner External Examiner

[ ] [ ]

[EXTERNAL NUMBER:]
 SSCE PRACTICAL EXAMINATION 2024-2025 SET D

School Code : 75062

School Name : AIRPORT SENIOR SECONDARY SCHOOL
Class : XII
Subject Code : 065
Subject : INFORMATICS PRACTICES
Reg.No :
Date : 21/1/25
Max.Marks : 30
Time : 3:00 HRS

Q.No Description Marks

SECTION - A (Programs using Pandas and Matplotlib)

Q1. Write a program in python to create the following dataframe named
[4]
“customer” storing the following details:

cname City billamt Tran_date

1001 Shruti Ahmedabad 9500 2010-10-01
1002 Tushar Baroda 5300 2010-01-04
1003 Jay Surat 4550 2009-03-01
1004 Sameer Ahmedabad 4000 2009-04-01
1005 Mayank Surat 8500 2008-08-05

1. Add a row with row index 1006 and data as

[‘Rohan’, ‘Bharuch’, 6000, ‘2011-04-01’]

2. Add a new column named discount which is 10% of their bill amount.
3. Display the details of Tushar and Sameer.
4. Delete the details of Mayank

Q2. Write a program to visualize the temperatures in various cities based on

the following: [4]

Temp = [42,45,49,47]

City = [‘Oman’,’UAE’,’Kuwait’,’Manama’]

1. Create a Line chart showing the temperature of each city.

2. Give the title of the chart as ‘Temperature’, xlabel as ‘City’ and ylabel as
‘Temp’
3. Give line color as ‘green’ and marker as ‘X‘ with size 15.
 SECTION - B (SQL Queries)

Q3. Write Sql commands and outputs for the following on the basis of the [7]
Employee table given below:

No Name Salary Zone Age Grade Dept

1 Mukul 30000 West 28 A 10
2 Kritika 35000 Centre 30 A 10
3 Naveen 32000 West 40 NULL 20
4 Uday 38000 North 38 C 30
5 Nupur 32000 East 26 NULL 20
6 Moksh 37000 South 28 B 10

(a) Display the details of all employees who are below 30 years of age
(b) Display the details of all the employees whose Grade is A.
(c) Display the details of all the employees whose salary is between
32000 and 38000.
(d) Display the total salary of the employees zone wise.
(e) Display the name, salary, and age of all the employees whose
name starts with “M”.
(f) Display all the details in descending order of salary.
(g) To display the employees who work in West Zone.

Q4. Practical Record [5]

Q5. Project file [5]
Q6. Viva Voce [5]

Internal Examiner External Examiner

[ ] [ ]

[EXTERNAL NUMBER:]
 SSCE PRACTICAL EXAMINATION 2024-2025

SET E
School Code : 75062
School Name : AIRPORT SENIOR SECONDARY SCHOOL
Class : XII
Subject Code : 065
Subject : INFORMATICS PRACTICES
Reg.No : ___________________________
Date : 21/1/25
Max.Marks : 30
Time : 3:00 HRS

Q.No Description Marks

SECTION - A (Programs using Pandas and Matplotlib)

Q1. Create a series to store the amount of sales made by a salesperson
[4]
for the last year (whole months).

{"jan":20000,"feb":10000,"mar":15000,"apr":22000,"may":7000,"jun":
8000,"jul":9900,"aug":22000,"sep":10000,"oct":5600,"nov":9000,"dec"
:8900}

a) Display the sales amount which is greater than 10000.

b) Display the sales amount in the first four months.
c) Display the sales amount in the last four months.

The list of IQ scores of students of a class are:

Q2. [118, 123, 124, 125, 127, 128, 129, 130, 130, 133, 136, 138, 141, 142, [4]
149, 150, 154].
Write code to create a histogram for 4 equal bins. Add appropriate labels
for better understanding
 SECTION - B (SQL Queries)

Q3. Write Sql commands and corresponding outputs for (a) to (g) on the basis of [7]
tables given below.

(a) Create the above 2 tables with the specified attributes

(b) Display name and salary of all faculties in alphabetical order of their
names.
(c) Display details of faculties who joined on Monday.
(d) Display names of faculties, their salary and BatchName from both the
tables.
(e) Display the details of all faculties whose salary is more than 60000
and have joined before the year 2007.
(f) Display the name of faculty who is taking TXAlpha Batch.
(g) Display the faculty name and qualification of those faculties whose
name has the letter i anywhere in their names.

Q4. Practical Record (Report File) [5]

Q5. Project file [5]
Q6. Viva Voce [5]

Internal Examiner External Examiner

[ ] [ ]