Session: 2024-2025
Computer science
PROJECT file
Class:XII –A
PRACTICAL FILE
Cbse Roll no:
Submitted To: Submitted
By:
mr.Priyanshu Gautam JANMEJAY NAGER
CERTIFICATE
This is to certify that JANMEJAY NAGER of class: XII -
A of EXCELLIA SCHOOL LUCKNOW has performed his
practical under my supervision. He has taken
interest and has shown at most sincerity in
completion of this project.
I certify this project up to my expectation & as per
guidelines issued by CBSE, NEW DELHI.
Student name: JANMEJAY NAGER
Class: XII
CBSE roll no.:
Internal Examiner
External Examiner
Principal
ACKNOWLEDGMENT
It is with pleasure that I acknowledge my sincere
gratitude to our teacher, MR.PRIYANSHU GAUTAM,
PGT (CS) who taught and undertook the
responsibility of teaching the subject computer
science. I have been greatly benefited from his
classes.
I am especially indebted to our Principal MR.
PRIYANKA DUBEY who has always been a source of
encouragement and support and without whose
inspiration this project would not have been a
successful I would like to place on record heartfelt
thanks to him.
Finally, I would like to express my sincere
appreciation for all the other students for my batch
their friendship & the fine time that we all shared
together.
CBSE roll no.:
INDEX
S.N Topic
o.
1 Python program
1-24
1 Read a text file line by line and display 2-2
each word separated by a #.
2 Read a text file and display the number 3-4
of
vowels/consonants/uppercase/lowercas
e characters in the file.
3 Remove all the lines that contain the 5-5
character 'a' in a file and write it to
another file.
4 Create a binary file with name and roll 6-7
number. Search for a given roll number
and display the name, if not found
display appropriate message.
5 Create a binary file with roll number, 8-
name and marks. Input a roll number and 10
update the marks
6 Write a program which create random 11-
number generator that generates 11
random numbers between 1 and 6
(simulates a dice).
7 Write a Python program to implement a 12-
stack using list. 13
8 Create a CSV file by entering user-id and 14-
password, read and search the password 15
for given userid.
9 Write a function that receives two 16-
number and generate a random number 16
from the range using this function the
main program should be able to print
three number randomly
1 Write a program that creates a tuple 17-
0 storing first nine terms of Fibonacci 17
series
1 Write a program that reads a date as an 18-
1 integers in the format MMDDYYYY. The 18
program will call a function that prints
print out the date in the format <month
name > <day>,<year>.
1 Write a program that generates 4 terms 19-
2 of an AP by providing initial and step 19
values to a function that returns first four
terms of the series.
1 Write a program that copies one file to 20-
3 another. Have the program read the file 21
names from user.
1 Write function in python, 22-
4 MakePush(Package) &MakePop(Package) 22
to add a new Package and delete a
Package from a List of Package
Description, considering them to act as
push and pop operations of the Stack
data structure.
1 Write a program to implement a stack for 23-
5 these book details (book no.,book 24
name).That is now each item node of the
stack contains two type of information-a
book no. and its name.just implement
pusk and display operation
2 SQL Queries 24-30
1 ALTER table to add new attributes / modify 25
data type / drop attribute -
26
2 UPDATE table to modify data 27
-
27
3 ORDER By to display data in ascending / 28
descending order -
28
4 DELETE to remove tuple(s) 29
-
29
5 GROUP BY and find the min, max, sum, 30
count and average -
30
3 Python-SQL connectivity
31-36
1 Insert values in the given table 32-33
2 Retrieve all the records from the table 34-
34
3 Add a column name student id as a primary 35-
key in the table 35
5 Find the average and count of the given table 36-
36
