Scribd
Upload
8 views

xii ip practical computer question paper python 2024

The document outlines the practical examination format for Informatics Practices for Class XII at SSSS Modern School, Amritsar, scheduled for January 16, 2024. It includes two sets of questions focusing on programming with Pandas and Matplotlib, SQL queries based on student and teacher tables, and additional components like practical files, project work, and viva-voce. Each set has a maximum score of 30 marks and specifies various tasks and queries to be completed by the students.

Uploaded by

singhmahavir60576
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
8 views

xii ip practical computer question paper python 2024

The document outlines the practical examination format for Informatics Practices for Class XII at SSSS Modern School, Amritsar, scheduled for January 16, 2024. It includes two sets of questions focusing on programming with Pandas and Matplotlib, SQL queries based on student and teacher tables, and additional components like practical files, project work, and viva-voce. Each set has a maximum score of 30 marks and specifies various tasks and queries to be completed by the students.

Uploaded by

singhmahavir60576
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

SSSS MODERN SCHOOL ,AMRITSAR

A.I.S.S.C.E.(PRACTICAL EXAMINATION – 2023-2024)


SUBJECT : Informatics Practices (065) NEW(SET-1)
CLASS:XII DATE: 16 / 01 / 2024
TIME: 3 Hrs 9:00 a.m. to 12 p.m. MAX.MARKS:30

1. Programming Using Pandas and Matplotlib (Do any three) (8)


a) Write a program to locate the 3 largest values in a dataframe.
b) Write a program to replace all negative values in a dataframe.
c) Write a program to replace all missing values in a dataframe with a 999.
d) Write a program to import and export data between pandas and CSV file.
2. (SQL Queries ) Consider the following table STUDENT and answer the questions which are based on the
table: STUDENT given below: TABLE:STUDENT (6)
Roll No Name Class DOB Gender City Marks

1 Nanda X 06-06-1995 M Agra 551

2 Saurabh XII 07-05-1993 M Mumbai 462

3 Sanal XI 06-05-1994 F Delhi 400

4. Trisla XII 08-08-1995 F Mumbai 450

5. Store XII 08-10-1995 M Delhi 369

6. Marisla XI 12-12-1994 F Dubia 250

7. Neha X 08-12-1995 F Moscow 377

8. Nishant X 12-06-1995 M Moscow 489

( a) Write SQL query to display the records from table student in alphabetical order as per the name of the student.
(b) Write SQL query to display Name, Class and total number of students who have secured more than 450 marks, class
wise.
(c) Write SQL query to increase marks of all students by 20 whose class is “XII”
(d) SELECT COUNT(*), City FROM STUDENT GROUP BY CITY HAVING COUNT(*)>1;
(e) SELECT MAX(DOB),MIN(DOB) FROM STUDENT;
(f) SELECT NAME,GENDER FROM STUDENT WHERE CITY=”Delhi”;
(g) A Stationary Store is considering to maintain their inventory using SQL to store the data. (1)
As a database administer, Rajan has decided that:Name of the table - INVENTORY
The attributes of INVENTORY are as follows: ItemNo - numeric , ItemName - character of size 20,
Scode - numeric , Quantity – numeric .Write SQL query to create the above mentioned table

3.Practical File (5)


4.Project Work (5)
5.Viva -Voce (5)

INTERNAL EXAMINER : EXTERNAL EXAMINER :


SSSS MODERN SCHOOL ,AMRITSAR
A.I.S.S.C.E.(PRACTICAL EXAMINATION – 2023-2024)
SUBJECT : Informatics Practices (065) NEW(SET-2)
CLASS:XII DATE: 16 / 01 / 2024
TIME: 3 Hrs 12:00 p.m. to 3 p.m. MAX.MARKS:30

1.Programming Using Pandas and Matplotlib (Do any three) (8)


a) Write a program to create a pandas series from a dictionary of values and an ndarray..
b) Given the school result data,analyse the performance of the students on different parameters
e.g. subject wise or class-wise (Using Bar Graph)
c) Write a program to replace all missing values in a dataframe with a 999.
d) Write a program to import and export data between pandas and CSV file.
2. (SQL Queries ) Write SQL commands for the following queries (i) to (v) based on the Table Teacher
given below: (5)
Table:TEACHER
T_ID Name Age Department Date_of_join Salary Gender
1 Jugal 34 Computer Sci 10/01/2017 12000 M
2 Sharmila 31 History 24/03/2008 20000 F
3 Sandeep 32 Mathematics 12/12/2016 30000 M
4 Sangeeta 35 History 01/07/2015 40000 F
5 Rakesh 42 Mathematics 05/09/2007 25000 M
6 Shyam 50 History 27/06/2008 30000 M
7 Shiv Om 44 Computer Sc 25/02/2017 21000 M
8 Shalaskha 33 Mathematics 31/07/2018 20000 F
I. To show all information about the teacher of History department.
II. To list the names of female teachers who are in Mathematics department.
III. To list the names of all teachers with their date of joining in ascending order.
IV. To display teacher’s name, salary, age for male teachers only.
V. To display name , bonus for each teacher where bonus is 10% of salary.
2. Write SQL commands for the queries based on a table COMPANY and CUSTOMER. (2)
COMPANY
Customer
CustId Name Price Qty CID
101 Rohan Sharma 70000 20 222
102 Deepak Kumar 50000 10 666
103 Mohan Kumar 30000 5 111
104 Sahil Bansal 35000 3 333
105 Neha Soni 25000 7 444
106 Sonal Aggarwal 20000 5 333
107 Arun Singh 50000 15 666
VI SELECT MIN(PRICE), MAX(PRICE) FROM CUSTOMER WHERE QTY>10;
VII SELECT AVG(QTY) FROM CUSTOMER WHERE NAME LIKE “%r%;
3.Practical File (5)
4.Project Work ` (5)
5.Viva -Voce (5)

INTERNAL EXAMINER : EXTERNAL EXAMINER :

You might also like