COMPUTER SCIENCE PRACTICAL LIST FOR CLASS XII

1. Write a python program to pass list to a function and double the odd values and half even
values of a list and display list element after changing.

2. Write a Python program input n numbers in tuple and pass it to function to count how many
even and odd numbers are entered.

3. Write a Python program to function with key and value, and update value at that key in
dictionary entered by user.

4. Write a program to pass a string to a function and count how many vowels and consonants
present in the string

5. Write a Python program to generator(Random Number) that generates random numbers

between 1 and 6 (simulates a dice) using user defined function.

6. Write a python program to implement python mathematical functions.

7. Write a python program to implement python string functions.

8. Write a python program to read and display file content line by line with each word separated
by #.

9. Write a python program to remove all the lines that contain the character ‘a’ in a file and write
it to another file.

10. Write a python program to read characters from keyboard one by one, all lower case letters
gets stored inside a file “LOWER”, all uppercase letters gets stored inside a file “UPPER”, and
all other characters get stored inside “OTHERS”
11. Write a python program to create a binary file with name and roll number. Search for a given
roll number and display name, if not found display appropriate message.

12. Write a python program to create a binary file with roll number, name and marks, input a roll
number and update the marks.

13. Write a python program to create a CSV file with empid, name and mobile no. and search
empid, update the record and display the records.

14. Write a Python program to create Lpush( ) and Lpop( ) function to do push and pop operation
on a stack using a list e.g. take a student information and push and pop the details.

15. Create a student table and insert data. Implement the following SQL commands on the student
table:
ALTER table to add new attributes / modify data type / drop attribute
UPDATE table to modify data ORDER By to display data in ascending / descending order
DELETE to remove tuple(s) GROUP BY and find the min, max, sum, count and average

16. Integrate SQL with Python by importing the MySQL module record of employee and display
the record.

17. Integrate SQL with Python by importing the MySQL module to search an employee using
empno and if present in table display the record, if not display appropriate method.

18. Integrate SQL with Python by importing the MySQL module to search a student using rollno,
update the record.

19. Integrate SQL with Python by importing the MySQL module to search a student using rollno,
delete the record.

[Link] webpage using urllib Library.

[Link] a python program to simulate graphic calculator using tkinter library in python.
 PRACTICAL- 1

AIM- Write a program to pass list to a function and double the odd
values and half even values of a list and display list element
after changing

SOFTWARE USED- IDLE (PYTHON 3.8 64-bit)

INPUT

OUTPUT
 PRACTICAL- 2

AIM- Write a program to input n numbers in tuple and pass it to

function to count how many even and odd numbers are entered

SOFTWARE USED- IDLE (PYTHON 3.8 64-bit)

INPUT
 PRACTICAL- 3

AIM- Write a program to function with key and value, and update value at that
key in dictionary entered by user SOFTWARE USED- IDLE (PYTHON 3.8 64-BIT)

INPUT
 PRACTICAL- 4

AIM

- Write a program to pass a string to a function and count how many

vowels and consonants are present in the string

SOFTWARE USED- IDLE (PYTHON 3.8 64-BIT)

INPUT

OUTPUT
 PRACTICAL- 5

AIM

Write a program to generator that generates random numbers between 1

and 6 using user defined function

SOFTWARE USED- IDLE (PYTHON 3.8 64-BIT)

INPUT

OUTPUT(S)
 PRACTICAL- 6

AIM

- Write a program to implement python mathematical functions.

SOFTWARE USED- IDLE (PYTHON 3.8 64-BIT)

INPUT
OUTPUT(S)
 PRACTICAL-7

AIM- Write a program to implement python string functions

SOFTWARE USED- IDLE (PYTHON 3.8 64-BIT)

INPUT

OUTPUT
 PRACTICAL- 8

AIM- Write a program to read and display file content line by line
with each word separated by #.

SOFTWARE USED- IDLE (PYTHON 3.8 64-BIT)

INPUT

OUTPUT

PRACTICAL- 9

AIM- Write a program to remove all the lines that contain the
character ‘a’ in a file and write it to another file.

SOFTWARE USED- IDLE (PYTHON 3.8 64-BIT)

INPUT

OUTPUT

PRACTICAL- 10

AIM- Write a program to read characters from keyboard one by one,

all lower case letters gets stored inside a file “LOWER”, all
uppercase letters gets stored inside a file “UPPER”, and all other
characters get stored inside “OTHERS”

SOFTWARE USED- IDLE (PYTHON 3.8 64-bit)

INPUT

OUTPUT
 PRACTICAL- 11

AIM- Write a program to create a binary file with name and roll number.
search for a given roll number and display name, if not found display
appropriate message SOFTWARE USED- IDLE (PYTHON 3.8 64-BIT)

INPUT

OUTPUT
 PRACTICAL- 12

AIM- Write a program to create a binary file with roll number, name
and marks, input a roll number and update the marks.

SOFTWARE USED- IDLE (PYTHON 3.8 64-bit)

INPUT

OUTPUT
 PRACTICAL- 13

AIM- Write a program to create a CSV file with empid, name and
mobile no. and search empid, update the record and display the
records

SOFTWARE USED- IDLE (PYTHON 3.8 64-BIT)

INPUT
OUTPUT
 PRACTICAL- 14

AIM- Write a program to create Lpush() and Lpop() function to do

push and pop operation on a stack using a list e.g. take a student
information and push and pop the details

SOFTWARE USED- IDLE (PYTHON 3.8 64-BIT)

INPUT
OUTPUT
 PRACTICAL- 15

AIM- Write a program to create a student table and insert data.

Implement the following SQL commands on the student table:
ALTER table to add new attributes / modify data type / drop attribute

UPDATE table to modify data ORDER By to display data in ascending / descending

order

DELETE to remove tuple(s) GROUP BY and find the min, max, sum, count and

average SOFTWARE USED- MySQL Workbench 8.0 CE INPUT use

studentdb;

Database changed CREATING TABLE

create table student (roll int

not null, studentname varchar(30)

not null, class char(5) not null,

section char(1) not null,

classstream char(20) not null);

desc student;

INSERTING VALUE insert

into student values

(1, "Akhil", "XII", "A", "Science"),

(2, "Satya", "XII", "C", "Science"),

(3, "Antony", "XII", "D", "Commerce"),

(4, "Vishal", "XII", "E", "Humanities"),

(5, "Deepak", "XII", "A", "Science"),

(6, "Brij", "XII", "B", "Science"); select

* from student;
ADDING COLUMN IN TABLE USING ALTER COMMAND

alter table student add(Substream char(20)

not null), (Percentage float not null);

desc student;

UPDATING VALUE update student set Substream = "Computer Science"

where roll = 1; update student set Substream = "Biology" where

roll = 2; update student set Substream = "Maths" where roll = 3;

update student set Substream = "NA" where roll = 4; update

student set Substream = "Computer Science" where roll = 5; update

student set Substream = "Computer Science" where roll = 6; select

* from student;

update student set Percentage = 81 where roll = 6; update

student set Percentage = 69 where roll = 6; update

student set Percentage = 92 where roll = 6; update

student set Percentage = 55 where roll = 6; update

student set Percentage = 85 where roll = 6; update

student set Percentage = 72 where roll = 6; select * from

student;

alter table student add(

Adhaar_card bigint not null);

desc student;

alter table student drop

column Adhaar_card;

desc student;

ORDER BY COMMAND select studentname,section from student

order by Percentage;
AVERAGE COMMAND select

avg(Percentage) from student;

COUNT COMMAND select count(*)

from student;

MIN, MAX AND SUM COMMAND select

min(Percentage) from student;

select max(Percentage) from student;

select sum(Percentage)/count(*) from student where substream = "Computer Science";

DELETE A TUPLE FROM TABLE

delete from student where classstream = "Science"; select

* from student;