Session: 2024-2025
PRACTICAL FILE
STUDENT NAME: ANMOL SINGH
CLASS: XII ‘A’
SUBJECT: COMPUTER SCIENCE(083)
CBSE ROLL NO.:
Submitted To: mr.Priyanshu gautam
CERTIFICATE
This is to certify that ANMOL SINGH 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.
Signature of External Examiner :
Signature of Internal Examiner :
Signature of 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 Mrs.
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.
TABLE OF CONTENT
S.No. Topic
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 of 3-4
vowels/consonants/uppercase/lowercase
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-10
name and marks. Input a roll number and
update the marks
6 Write a program which create random 11-11
number generator that generates random
numbers between 1 and 6 (simulates a
dice).
7 Write a Python program to implement a 12-13
stack using list.
8 Create a CSV file by entering user-id and 14-15
password, read and search the password
for given userid.
9 Write a function that receives two 16-16
number and generate a random number
from the range using this function the
main program should be able to print
three number randomly
10 Write a program that creates a tuple 17-17
storing first nine terms of Fibonacci series
11 Write a program that reads a date as an 18-18
integers in the format MMDDYYYY. The
program will call a function that prints
print out the date in the format <month
name > <day>,<year>.
12 Write a program that generates 4 terms of 19-19
an AP by providing initial and step values
to a function that returns first four terms
of the series.
13 Write a program that copies one file to 20-21
another. Have the program read the file
names from user.
14 Write function in python, 22-22
MakePush(Package) &MakePop(Package)
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.
15 Write a program to implement a stack for 23-24
these book details (book no.,book
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 / 25-26
modify data type / drop attribute
2 UPDATE table to modify data 27-27
3 ORDER By to display data in ascending / 28-28
descending order
4 DELETE to remove tuple(s) 29-29
5 GROUP BY and find the min, max, sum, 30-30
count and average
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-35
key in the table
4 Find the average and count of the given table 36-37
4 Bibliography 38-38
