ACTUAL CBSE Practical Examination for Computer Science

COMPUTER SCIENCE (083)
PRACTICAL FILE
CLASS 12TH (CBSE)




SUBMITTED BY: OMAR HAREEZ MOHAMMED



IN PARTIAL FULFILLMENT OF THE REQUIREMENT OF
THE ALL INDIA SENIOR SECONDARY CERTIFICATE EXAMINATION
(AISSCE)
BATCH: 2025 - 2026

, CBSE Practical Examination for Computer Science

Session :2025-2026

CERTIFICATE
Certified that the entries in this practical file is the bonafide work of Miss / Master

OMAR HAREEZ MOHAMMED

Class: XII Roll No:
Completed during the Academic year 2025-2026.
This practical file was submitted for the CBSE (CLASS XII) Practical
Examination in Computer Science conducted on January 2026 and
as per the guidelines issued by CBSE.



Signature of Teacher in charge Principal’s Signature




Signature of Examiner Date

, INDEX
S.NO Contents Page
no:
1 To write a python program to input any number from
user and calculate factorial of a number using function
2 To write a python program to input any number from
user and check it is Prime number or not using function.
3 To write a python program to find the sum of all
elements of a list using function.
4 Count odd and even numbers in a tuple
5 Occurrence of any word in a string
6 Display contents of text file
7 Display vowels,consonants,lowercase,uppercase and
other characters
8 To write a python program to create a binary file to store
Roll no and Name, Search any Roll no and display name
if Roll no found otherwise “Roll no not found”
9 To write a python program to create a binary file to store
Roll no, Name and Marks, and update marks of entered
Roll no.
10 To write a python program to read the content of file line
by line and write another file except for the lines
contains “a” letter in it.
11 To write a python program to create CSV file and store
empno, name, salary and search any empno and display
name, salary and if not found appropriate message.
12 To write a python program to generate a random number
(1-6), simulating a dice.
13 To write a python program to implement Stack using
List
14 To write a python program to implement Queue using
List.
15 To write a python program to take 10 Sample phishing

, email, and fine the most common word occurring.
16 To write a python program to create 21 Stick Game so
that computer always wins.
17 Program to connect with a database and store records of
employees and display records.
18 Program to connect with a database and search employee
number in the table "employee" and display records; if
empno is not found, display an appropriate message.
19 Program to connect with a database and update the
employee record of the entered empno.
20 Program to connect with a database and delete the record
of the entered employee number
21 Write SQL queries to create a database "student_db"
22 Write SQL queries to insert records into the database
“student_db”.
23 Consider a table "Employee" to create a database
"employee_db".
24 Given a table "Item" and "Vendor", write SQL
commands.
25 Create a table "student" in database "school" and insert 3
rows with attributes: rollno, name, gender, class, and
mark.
26 Read records from a student table and display/search
student details based on marks.
27 Create a table "emp" with fields empno, ename, dept,
salary in "employee_db", and insert data.
28 Update record from a table “emp” based on the details
given by the user.