SNTINIKETAN WORLD SCHOOL(10+2), ALIGARH
CLASS 12
PROGRAM LIST (2023-24)
COMPUTER SCIENCE (083)
S. No. PROGRAMS Date
1. Write a Program to sort a string using bubble sort.
2. Write a program to sort a sequence using insertion sort.
3. Write a program with function that generates 4 terms of an AP by providing initial
and step values to a function that returns first four terms of the series.
4. Write a function LShift(Arr, n) in Python, which accepts a list Arr of numbers and n
is a numeric value by which all elements of the list are shifted to left.
5. Write a program for random number generator that generates random numbers
between 1 and 6 (simulates a dice).
6. Write a program to display the size of a file after removing EOL characters, leading
and trailing white space and blank lines.
7. Write a program to display the number of the lines in the file.
8. Write a program to get roll numbers, names and marks of the students of a class (get
from user) and store these details in a file called “Marks.txt”.
9. Write a program to add two more students’ details to the file created in program 8.
10. Write a program to read a Text file line by line and display each word separated by a
‘#’.
11. Write a program to read a text file and display the count of vowels and consonants in
the file.
12. Write a program to get student data (roll no, name, marks) from user and write onto a
binary file.
13. Write a program to append student records to file created in previous program, by
getting data from user.
14. Write a program to open the file created in program 12 and 13 and display the student
records stored in it.
15. Write a program to open a file Stu.dat and search for records with roll numbers as 12
or 14. If found, display the records.
16. Read file Stu.dat created in earlier and display records having >81.
17. Write a program to create a CSV file to store student data (Rollno, Name, Marks).
obtain data from user and write 5 records into the file.
18. Write a program to create a csv file(compresult.csv) and write the below data into it.
The data of wines of four rounds of a competitive programming competition is given
as:
['Name', 'Points', 'Rank']
['Shradha', 4500, 23]
['Nishchay', 4800, 31]
['Ali', 4500, 25]
['Adi', 5100, 14]
19. a. Write a program to create a CSV file by suppressing the EOL translation.
b. Write a program to read and display the contents of Employee.csv created in the
previous program.
20. Write a Program to implement stack operations.
21. Write a program to implement a stack for these book-details (bookno, bookname).
That is, now each item node of the stack contains two types of information- a bookno
and its name. just implement Push and display operations.
22. SQL Query SET 1
23. SQL Query SET 2
24. SQL Query SET 3
25. SQL Query SET 4
26. SQL Query SET 5
27. Write Python program that display first three rows fetch from SQL.
28. Write a program to insert a new row in a table from Python.
29. Write a program to update a table from Python.
30. Write a Program in python to delete a record in a Table.
