ARMY PUBLIC SCHOOL, RANCHI
CENTRAL BOARD OF SECONDARY EDUCATION
PRACTICAL EXAMINATION
2025-2026
INFORMATICS PRACTICES (065)
LAB FILE
SUBMITTED TO:- SUBMITTED
BY:-
[Link] AGRAWAL AVINASH KUMAR
(PGT IP) CLASS-XII A
ROLL NUM-
……………………
Army Public School Ranchi, Jharkhand
Dipatoli cantt - 834012
CERTIFICATE
This is to certify that
Avinash Kumar
Of class XIIth A has successfully completed Informatics practices Lab file as per
the guidelines of XIIth Board Examination Conducted by CBSE. It is Further Certified
That This Project is the Individual and Bonafide work of the Candidate
under the supervision and guidance of
Mr. Gaurav Agrawal
EXTERNAL EXAMINER TEACHER IN CHARGE PRINCIPAL SIGN
ACKNOWLEDGEMENT
I would like to express my immense gratitude to my
Informatics Practices teacher Mr. Gaurav Agrawal for the
help and guidance he provided for completing this project.
I also thank my parents who gave their ideas and inputs in
making this project. Most of all I thank our school
management, for providing us the facilities and
opportunity to do this project.
- Avinash Kumar
INDEX
CONTENT PAGE NO.
CERTIFICATE 2
ACKNOWLEDGEMENT 3
SERIES 5 -7
DATAFRAME 7-9
VISULISATION 10-15
CSV 16
SQL 17-24
Series 1: Track daily steps
Problem: Record and display the number of steps walked by a person in a
week using a Pandas Series.
Solution:
Series 2: Calculate daily expenses
Problem: Store and display daily expenses for a week and find the total
expense.
Solution:
Series 3: Temperature readings
Problem: Store daily temperature readings and find the average
temperature for the week.
Solution:
Series 4: Favorite fruit quantities
Problem: Keep track of quantities of fruits bought by a person on a day.
Solution:
Series 5: Weekly water consumption
Problem: Record and display liters of water consumed each day in a week.
Solution:
DataFrame 1: Grocery shopping list
Problem: Create a shopping list DataFrame with items, quantity, and price
per unit.
Solution:
DataFrame 2: Employee attendance record
Problem: Create a DataFrame for 3 employees and their attendance status
for 5 days.
Solution:
DataFrame 3: Movie rating DataFrame
Problem: Create a DataFrame to store movie names and ratings given by 3
friends.
Solution:
DataFrame 4: Daily calorie intake tracker
Problem: Store meals with calories consumed each day for 3 days and
calculate total calories per day.
Solution:
DataFrame 5: Book reading progress
Problem: Track books, total pages, and pages read so far in a DataFrame.
Solution:
Visualization 1: Line plot of daily water consumption
Problem: Plot a line graph showing water consumption (liters) for a week.
Solution:
Output:
Visualization 2: Bar chart of daily expenses
Problem: Plot a bar graph showing daily expenses for a week.
Solution:
Output:
Visualization 3: Pie chart of fruit quantities bought
Problem: Plot a pie chart showing percentage of fruits bought.
Solution:
Output:
Visualization 4: Scatter plot comparing marks
Problem: Plot scatter plot comparing marks of two students in Math and
Physics.
Solution:
Output:
Visualization 5: Histogram of daily steps taken
Problem: Plot histogram showing frequency distribution of daily steps
walked in a week.
Solution:
Output:
Visualization 6: Multiple line plot for calorie intake
Problem: Plot multiple line graphs showing calories consumed for three
days during breakfast, lunch, and dinner.
Solution:
Output:
CSV 1: Write data to a CSV file
Problem: Write a Python program to save a list of students and their marks
into a CSV file.
Solution:
CSV 2: Read data from a CSV file
Problem: Write a Python program to read and display the data from the CSV
file students_marks.csv.
Solution:
SQL 1: Create a Student Table
Problem: Create a table called Students with columns for student ID, name,
age, and city.
Solution:
SQL 2: Insert Data into Students Table
Problem: Insert 3 student records into the Students table.
Solution:
SQL 3: Select all Students from a City
Problem: Write a query to select all students who live in 'Delhi'.
Solution:
SQL 4: Update Student City
Problem: Update the city of the student with StudentID 3 to 'Chennai'.
Solution:
SQL 5: Delete a Student Record
Problem: Delete the record of the student whose StudentID is 2.
Solution:
SQL Mathematical Functions
1. ABS() — Absolute Value
Problem: Find absolute values in a column.
2. ROUND() — Round a number
Problem: Round a decimal number to 2 decimal places.
3. CEILING() — Smallest integer greater than or equal to a number
Problem: Find the ceiling of 9.2.
SQL Text Functions
Assuming a table Students with a column Name.
1. UPPER()
2. LENGTH()
Problem: Find the length of student names.
3. CONCAT()
Problem: Concatenate first and last names stored separately.
SQL Date Functions
1. CURRENT_DATE
Problem: Get today's date.
2. DATE_ADD()
Problem: Find the date 10 days from today.
3. YEAR()
Problem: Extract year from a date.
SQL Aggregate Functions
Assuming a Sales table with column Amount.
1. SUM()
Problem: Calculate total sales amount.
2. AVG()
Problem: Find average sales amount.
3. COUNT()
Problem: Count number of sales.
GROUP BY Example
Problem: Find total sales grouped by sales region. Assume Region column
in Sales table.
ORDER BY Example
Problem: List students ordered by marks descending.
Assume Name and Marks columns in Students.
EQUIJOIN Example
Assuming Students table with StudentID and Name, and Marks table
with StudentID and Marks.
Problem: Join Students and Marks to get student names with their marks.