GD GOENKA SCHOOL
DWARKA SEC - 10
COMPUTER SCIENCE
PRACTICAL FILE
SESSION: 2025-2026
COMPUTER SCIENCE (083)
TOPIC:- Python Programming and SQL
SUBMITTED BY: MALLAIKA ARORA
CLASS: 12-A1
ROLL NO: _____________________
PYTHON PROGRAMS
1. Creating a menu driven program to perform arithmetic
Operations.
————————————————-INPUT————————————————-
———————————————OUTPUT————————————————-
2. Creating a python program to display Fibonacci series.
————————————————-INPUT————————————————-
————————————————OUTPUT————————————————-
3. Creating a menu driven program to find factorial and sum of
list of numbers using function.
————————————————-INPUT————————————————-
————————————————OUTPUT————————————————-
4. Creating a python program to implement returning values
from function.
————————————————-INPUT————————————————-
————————————————OUTPUT————————————————-
5. Creating a python program to implement mathematical
functions.
————————————————-INPUT————————————————-
————————————————OUTPUT————————————————-
6. Creating a python program to generate random numbers be-
tween 1 to 6.
————————————————-INPUT————————————————-
————————————————OUTPUT————————————————-
7. Creating a python program to read a text file line by line and
display each word separated by “#”.
————————————————-INPUT————————————————-
TEXT FILE-
————————————————OUTPUT————————————————-
8.Creating a python program to read a text file and display the
number of vowels/consonants/lower case/ upper case charac-
ters.
————————————————-INPUT————————————————-
————————————————OUTPUT————————————————-
9.Creating a python program to display short words from a
text file.
————————————————-INPUT————————————————-
————————————————OUTPUT————————————————-
10.Creating a python program to copy particular lines of a text
file into another text file.
————————————————-INPUT————————————————-
————————————————OUTPUT————————————————-
FILE:-
11.Creating a python program to create and search records in
binary file.
————————————————-INPUT————————————————-
————————————————OUTPUT————————————————-
12.Creating a python program to create and update/modify
records in binary file.
————————————————-INPUT—————————————————
————————————————OUTPUT————————————————
13.Creating a python program to create and search employ-
ee’s record in csv file.
————————————————-INPUT—————————————————
————————————————OUTPUT————————————————
14.Creating a python program to implement stack
operations(list).
————————————————-INPUT—————————————————
————————————————OUTPUT————————————————
15.Creating a python program to implement stack
operations(dictionary).
————————————————-INPUT—————————————————
————————————————OUTPUT————————————————
PYTHON- MY SQL CONNECTIVITY PROGRAMS
16.Creating a python program to integrate MYSQL with python
(creating database and table).
——————————————————————————————————
17.Creating a python program to integrate MYSQL with python
(inserting & displaying records ).
——————————————————————————————————
18.Creating a python program to integrate MYSQL with python
(searching & displaying records ).
——————————————————————————————————
19.Creating a python program to integrate MYSQL with python
(update & delete records ).
——————————————DELETE———————————————
——————————————UPDATE———————————————
