Scribd
Upload
5 views2 pages

SSCE Class XII Informatics Practices Exam

This document outlines a practical examination for Class XII in Informatics Practices, focusing on data manipulation using Python and SQL. It includes tasks such as creating and modifying a DataFrame with Pandas, generating a histogram, and executing SQL commands for managing a table of board toppers. The examination is structured to assess students' programming and database management skills with a total of 30 marks over a 3-hour duration.

Uploaded by

manavisinghh2009
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
5 views2 pages

SSCE Class XII Informatics Practices Exam

This document outlines a practical examination for Class XII in Informatics Practices, focusing on data manipulation using Python and SQL. It includes tasks such as creating and modifying a DataFrame with Pandas, generating a histogram, and executing SQL commands for managing a table of board toppers. The examination is structured to assess students' programming and database management skills with a total of 30 marks over a 3-hour duration.

Uploaded by

manavisinghh2009
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

SSCE Informatics Practices – Practical Examination (Practice Review Paper)

Class: XII
Subject Code: 065
Time: 3 Hours
Maximum Marks: 30
Pattern: Similar to Board Practical Examination

Question 1: [4 Marks]
Consider the following DataFrame Tech_Careers:
Course_ID Tech_Field Duration_Years
101 Data Analytics 3
102 Cyber Security 2
103 Cloud Computing 4
104 Artificial Intel. 3
Write Python statements to perform the following operations:
1. Create the above DataFrame using Pandas.
2. Rename the column Tech_Field to Career_Field.
3. Add a new column Job_Demand with values:
['High', 'Very High', 'High', 'Excellent']
4. Display only the last two rows of the DataFrame.

Question 2: [4 Marks]
Write a Python program to create a histogram for the following dataset:
Daily Internet Usage (in hours) of students:
[1, 1.5, 2, 2.5, 3, 3.5, 4, 4, 4.5, 5, 5.5, 6, 6.5]
Perform the following tasks:
1. Set the number of bins to 6.
2. Set the color of the histogram to green.
3. Label the x-axis as Internet Usage (hours) and the y-axis as Number of Students.
4. Add the title:
“Daily Internet Usage Pattern of Students”

Question 3: [7 Marks]
Consider the following table named Board_Toppers:
RollNo Name Stream Percentage
1 Sneha Gupta Science 96.2
2 Aman Verma Commerce 94.5
3 Riya Singh Humanities 95.1
4 Kunal Shah Science 97.0

Write SQL commands for the following:


1. Create the table Board_Toppers with RollNo as Primary Key.
2. Insert the above records into the table.
3. Display all student names in lower case.
4. Add a new column School_Name of VARCHAR type.
5. Display the maximum percentage stream-wise.
6. Display all records in ascending order of Percentage.
7. Remove the column School_Name from the table.

You might also like