Practical File Format – Class 12 CS (083)
Total Practical Marks: 30
Python Programs (15 Marks)
You must prepare a practical file of at least 15 programs. Below are some
examples:
Suggested Python Programs:
1. Handle ZeroDivisionError using try-except.
2. Handle ValueError for invalid input using try-except.
3. Use multiple except blocks for different exceptions.
4. Use try-finally to ensure a file is closed.
5. Raise a custom exception using raise keyword.
6. Create and write a text file.
7. Read and display the contents of a file.
8. Count number of lines in a file.
9. Count vowels and consonants in a file.
10.Count total number of words.
11.Copy content from one file to another.
12.Append new data to an existing file.
13.Find and replace a word in a text file.
14.Function to check whether a number is prime.
15.Function to return factorial using loop.
16.Function to calculate area of rectangle.
17.Function to count vowels in a string.
18.Function to count frequency of each character in a string.
19.Function to return sum of digits of a number.
20.Implement push and pop operations using list as stack.
21.Reverse a string using stack.
22.Check balanced parentheses using stack.
23.Write student data to a CSV file.
24.Read and display contents of a CSV file.
25.Count number of records in a CSV file.
In each program:
Code (proper indentation)
Output Screenshot (if possible)
Short Explanation (comment lines or below the code)
✍️Tip: It is good to give output and code explanation below every program.
Python – SQL connectivity programs
1. Creating a python program to integrate mysql with python (creating database
and table)
2. Creating a python program to integrate mysql with python (inserting records
and displaying records)
3. Creating a python program to integrate mysql with python (searching and
displaying records)
4. Creating a python program to integrate mysql with python (updating records)
SQL Queries – Minimum 5 sets using one table / two tables.
1) Display the names of students who scored more than 75 marks.
2) Display all students sorted by marks in descending order.
3) Add a new column Email to the Student table.
4) Update marks of a student whose Roll No is 5 to 90.
5) Delete record of a student who scored less than 33.
6) Count the number of male and female students.
7) Display average marks of all students.
Project File – Class 12 CS (083)
Project Work: 8 Marks
Project Topic Suggestions (Choose One):
1. Library Book Management System
2. Student Attendance or Marks Record System
3. Billing System for Grocery/Stationery
4. Employee Database using Text/CSV files
5. Simple To-Do List Tracker (CLI based)
6. Complaint Registration System
What will be in the project file?
Title Page
Certificate (Signed by teacher)
Acknowledgment
Index
Introduction of Project
Objective
Tools/Technologies Used
Source Code with proper comments
Output Screenshots
Conclusion
Bibliography
Practical Exam Assessment Criteria
S.No Unit Name Marks
(Total=30)
Lab Test:
1. Python program (60% logic + 20% documentation + 20%
1 8+4
code quality)
2. SQL queries (4 queries based on one or two tables)
Report file:
Minimum 15 Python programs.
SQL Queries – Minimum 5 sets using one table / two
2 7
tables.
Minimum 4 programs based on Python – SQL
connectivity
3 Project Work (using concepts learnt in Classes 11 and 12) 8
4 Viva Voce (Based on project & theory) 3
Total 30
