AMITY INTERNATIONAL SCHOOL
Session :2024-25
CLASS – XII
Computer SCIENCE(083)
Practical file
R0ll No. :______________
NAME : ______________
Practical File Index
Sno List of Program Page
no
Python Programs
1 Write a menu driven program to perform arithmetic operations.
2 Write a program to check a number whether it is palindrome or not
3 Write a program to display ASCII code of a character and vice versa.
4 Write a program to generate random number between 1 to 6
5 Write a program to accept a number from the user and display whether
it is a perfect number or not.
6 Write a program to accept a number from the user and display whether
it is Twisted Prime or not.
7 Write a program to print the flowing pattern.
1
10
101
1010
10101
8 Write a program to read a text file line by line and display each word
separated by '#'.
9 Write a program to count number of words in a file.
10 Write a program to copy lines of a text file into another text file.
11 Create a binary file with name and roll number of student and display
the data by reading the file.
12 Write a program to search a record in binary file using its roll number
and display the name of student. If record not found, then display
appropriate message.
13 Write a program to perform read and write operation with .csv file.
14 Write a program to create and search employee’s record in csv file.
15 Write a menu-based program to perform the operation on stack in
python.
Python – SQL connectivity programs
16 Write a program to integrate MYSQL with Python (Creating database
and table)
17 Write a program to integrate MYSQL with Python (Inserting records
and displaying records)
18 Write a program to integrate MYSQL with Python (Searching and
displaying records)
19 Write a program to integrate MYSQL with Python (Updating and
delete records)
SQL Queries
20 SQL COMMANDS EXERCISE – 1
21 SQL COMMANDS EXERCISE – 2
22 SQL COMMANDS EXERCISE – 3
23 SQL COMMANDS EXERCISE – 4
24 SQL COMMANDS EXERCISE – 5