Subject – Computer Science (083)
Class – XII
(Session:2025-2026)
List of Programs for Practical File
INDEX
Sl. Date Question Page Teac
No No. her’
. s
Sign
.
1 06.0 Write a python program using function NOVOWEL (N) which accepts
5.20 a list of strings as arguments N and appends all words of the strings
which have no vowels in it, into a new list named NV. The main
25
program will receive the list of words from user, and send the list
through calling function NOVOWEL().
2 07.0 Write a function dispBook(BOOKS) in Python, that takes a dictionary
5.20 BOOKS as an argument and displays the names in uppercase of
those books whose name starts with a consonant.
25
3 08.0 Write a program that checks for presence of a value inside a
5.20 dictionary and prints its key.
25
4 10.0 Write a program that reads a string and checks whether its
6.20 palindrome or not.
25
5 11.0 Write an user defined function that takes two numbers and returns the
6. number that has minimum one’s digit.
2025
6 12.0 Write a Python Program containing a function FindWord(STRING,
6. SEARCH), that accepts two arguments : STRING and SEARCH, and
prints the count of occurrence of SEARCH in STRING. Write
2025
appropriate statements to call the function.
7 16.0 Write a suitable Python statement for each of the following tasks
6. using built-in functions/methods only.
2025
8 17.0 Write a Python Program to display alternate characters of a string
6. my_str.
2025
9 18.0 You are working on a project where you need to calculate the
6. average of test scores for a class. You have decided to use a Python
function to perform this task. Write a user-defined function to calculate
2025
the average and explain how you would call this function to find the
average of five test scores.
1 19.0 Write a definition of a method COUNTNOW(PLACES) to find and
0 6. display those place names, in which here are more than 7 characters.
2025
1 25.0 Write a python program to read a text file line by line and display each
1 6. word separated by a #.
2025
1 26.0 Write a python program to read a text file and display the number of
2 6. vowels/consonant/uppercase/lowercase characters in the file
2025
1 30.0 Write a python program to create a binary file with name and roll
3 6. numbers. Search for a given roll number and display the name, if not
found display appropriate message.
2025
1 02.0 Write a random number generator that generates random numbers
4 7. between 1 and 6(simulates a dice).
2025
1 04.0 Write a python program to create a CSV file by entering user_id and
5 7. password, read and search the user_id and password for given
user_id.
2025
1 09.0 Write a python program to implement a stack using a list data
6 7. structure.
2025
1 17.0 SQL QUERIES (Table Names – ACCOUNT & TRANSACT)
7 7.
2025
1 18.0 SQL QUERIES (Table Names – EMPLOYEE & SALGRADE)
8 7.
2025
1 24.0 SQL QUERIES (Table Names – TRAINS & PASSENGERS)
9 7.
2025
2 28.0 SQL QUERIES (Table Names – SHOPPE & ACCESSORIES)
0 7.
2025
2 30.0 SQL QUERIES (Table Names – ITEM & VENDOR)
1 7.
2025
2 14.0 Write a python program to connect with database and store record of
2 8.20 employee and display records.
25
2 18.0 Write a python program to connect with database and search
3 8.20 employee number in table employee and display record, if employee
number is not found, it should display appropriate message.
25
2 20.0 Write a python program to connect with database and update the
4 8.20 employee record of entered empno.
25
2 26.0 Write a python program to connect with database and delete the
5 8.20 record of entered employee number.
25
DO NOT TAKE A PRINT OUT AND PASTE IN THE PRACTICAL FILE.
YOU NEED TO WRITE THE INDEX IN THE PRACTICAL FILE AS
EXPLAINED IN CLASS.