Scribd
Upload
374 views

Class 12 CS - Program List

This document contains a list of 17 practical computer science exercises for Class XII. The exercises include writing programs to print Fibonacci series using functions, check for palindromes using functions, simulate a dice roll, create and import Python libraries, read and manipulate text files, implement stacks and queues using lists, perform SQL commands like ALTER, UPDATE, ORDER BY, DELETE, GROUP BY on a student database table, and integrate SQL with Python by importing the MySQL module to CREATE, INSERT, FETCH, UPDATE, and DELETE records.

Uploaded by

Abc
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
374 views

Class 12 CS - Program List

This document contains a list of 17 practical computer science exercises for Class XII. The exercises include writing programs to print Fibonacci series using functions, check for palindromes using functions, simulate a dice roll, create and import Python libraries, read and manipulate text files, implement stacks and queues using lists, perform SQL commands like ALTER, UPDATE, ORDER BY, DELETE, GROUP BY on a student database table, and integrate SQL with Python by importing the MySQL module to CREATE, INSERT, FETCH, UPDATE, and DELETE records.

Uploaded by

Abc
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

CLASS XII

COMPUTER SCIENCE (083)


LIST OF PRACTICALS

1. Write a program to print the Fibonacci series using function.


2. Write a program to check whether the string is palindrome or not using function.
3. Write a random number generator that generates random numbers between 1 and
6 (simulates a dice).
4. Write a program to create a library in python and import it in a program.
5. Read a text file line by line and display each word separated by a #.
6. Remove all the lines that contain the character `a' in a file and write it to another
file.
7. Read a text file and display the number of vowels/ consonants/ uppercase/
lowercase characters in the file.
8. Write a program that reads a text file and create a new file after adding “ing” to all
words ending with “t”, “p”, “d”.
9. Create a binary file with name and roll number. Search for a given roll number
and display the name, if not found display appropriate message.
10.Create a binary file with roll number, name and marks. Input a roll number and
update the marks.
11.Write a program to create a file CAMERA.csv having fields ModelNo,
MegaPixel, Zoom and Price using comma as a delimiter and display its content.
12.Write a program to read VOTERS.csv file containing VoterId, VoterName,
VoterAge, Status having comma as a delimiter. Update the status of the voter as
“Senior Citizen” whose age is above 60 years.
13.Write a Python program to implement a stack using a list data-structure.
14.Write a Python program to implement queue using a list data-structure.
15.Take a sample of ten phishing e-mails (or any text file) and find most commonly
occurring word(s).

[Page 1 of 2]
16.Create a student table and insert data. Implement the following SQL commands
on the student table:
a. ALTER table to add new attributes / modify data type / drop attribute
b. UPDATE table to modify data
c. ORDER By to display data in ascending / descending order
d. DELETE to remove tuple(s) GROUP BY and find the min, max, sum,
count and average
17.Integrate SQL with Python by importing the MySQL module.
a. CREATE A TABLE
b. INSERT DATA
c. FETCH DATA
d. UPDATE RECORD
e. DELETE RECORD

************

[Page 2 of 2]

You might also like