Vand C Patel English School
COMPUTER SCIENCE PRACTICAL LIST FOR CLASS XII
1. Write a python program to search an element in a list and display the frequency of
element present in list and their location using Linear search by using user defined
function. [List and search element should be entered by user]
2. Write a python program to search an element in a list and display the frequency of
element present in list and their location using binary search by using user defined
function. [List and search element should be entered by user]
3. 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.
4. Write a Python program input n numbers in tuple and pass it to function to count how
many even and odd numbers are entered.
5. Write a Python program to function with key and value, and update value at that
key in dictionary entered by user.
6. Write a Python program to pass a string to a function and count how many vowels
present in the string.
7. Write a Python program to generator(Random Number) that generates random
numbers between 1 and 6 (simulates a dice) using user defined function.
8. Write a python program to implement python mathematical functions.
9. Write a python program to implement python string functions.
10. Write a python program to read and display file content line by line with each word
separated by #.
11. Write a python program to remove all the lines that contain the character ‘a’ in a file
and write it to another file.
12. 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”
13. 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.
14. Write a python program to create a binary file with roll number, name and marks,
input a roll number and update the marks.
15. 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.
16. 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.
17. 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
18. Integrate SQL with Python by importing the MySQL module record of employee and
display the record.
19. 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.
20. Integrate SQL with Python by importing the MySQL module to search a student
using rollno, update the record.
21. Integrate SQL with Python by importing the MySQL module to search a student
using rollno, delete the record.
22. Take a sample of ten phishing e-mails (or any text file) and find most commonly
occurring word(s)
PRACTICAL- 1
AIM- Write a program to search an element in a list and display the
frequency of element present in list and their location using
Linear search
SOFTWARE USED- IDLE(PYTHON 3.8 64-bit)
INPUT
OUTPUT
PRACTICAL- 2
AIM- Write a to search an element in a list and display the frequency
of element present in list and their location using Binary Search
SOFTWARE USED- IDLE (PYTHON 3.8 64-bit)
INPUT
OUTPUT
PRACTICAL- 3
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- 4
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
OUTPUT
PRACTICAL- 5
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
OUTPUT
PRACTICAL- 6
AIM- Write a program to pass a string to a function and count how
many vowels present in the string
SOFTWARE USED- IDLE (PYTHON 3.8 64-BIT)
INPUT
OUTPUT
PRACTICAL- 7
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- 8
AIM- Write a program to implement python mathematical functions.
SOFTWARE USED- IDLE (PYTHON 3.8 64-BIT)
INPUT
sqzt = x**(1/2)
zetuzn sqzt
pzint(sqzt(a))"""
#2
a=int(input("Entez a nua/bez:'r ))
i zange(O r a)
x=i*(i-1)
i-=1
psi.nt (x)
a=int(input("Entez a numbez: "))
b=int(input("Entez powez:"))
pzint(math.pow(a r b))
#4
a=int(input("Entez a numbez:r))
b=int(input("Entez base:"))
pzint(math.log(a, b))
#5
angle=int(input("Entez angle in degrees: "))
angle_new = (3.14 / 180)*angle
pzint(math.sin(angle_new))
#6
angle=int(input("Entez angle in degrees: "))
angle_new = (3.14 / 1B0)*angle
#7
angle=int(input("Entez angle in degrees: "))
angle_new = (3.14 / 1B0)*angle
pzint(math.tan(angle_new))
pain t (e)
pzint(pi)
point ( tau)
pzint("Please entez a valid operation nuzibez.")
OUTPUT(S)
PRACTICAL- 9
AIM- Write a program to implement python string functions
SOFTWARE USED- IDLE (PYTHON 3.8 64-BIT)
INPUT
OUTPUT
PRACTICAL- 10
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- 11
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- 12
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
Enter a single character
Enter a single character
Enter a single character
Enter a single character
Enter a single character
Enter a single character
Enter a single character
Enter a single character
Enter a single character
Enter a single character
Enter a single character
Enter a single character
Enter a single character
Enter a single character
Enter a single character :5
Enter a single character :6
Enter a single character :7
Enter a single character :B
Enter a single character
Enter a single character
Enter a single character
OTHERS.Dt - Notepad
Fite Edit °oriat View Hetp
abcdefghijklmnopqnstuvwxyz ABCDEF GHI JKLNN0PQRS!U XYZ !@#$%’&’()-= +123456789B
Ln 1, C ol 1 100ââ Wind owe (CRL\ UTF-8 Ln 1, C ol 1 100ââ Wind owe (CRL\ UTF-8 Ln 1, Col ZS 100ââ Windows (CRL\ UTF-8
PRACTICAL- 13
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
SOFTWARE USED- IDLE (PYTHON 3.8 64-BIT)
INPUT
OUTPUT
PRACTICAL- 14
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- 15
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- 16
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- 17
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;
PRACTICAL- 18
AIM- Write a program to Integrate SQL with Python by importing the
MySQL module record of employee and display the record.
SOFTWARE USED- IDLE (PYTHON 3.8 64-BIT)
MySQL Workbench 8.0 CE
INPUT
OUTPUT
PRACTICAL- 19
AIM- Write a program to 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.
SOFTWARE USED- IDLE (PYTHON 3.8 64-BIT)
MySQL Workbench 8.0 CE
INPUT
OUTPUT
PRACTICAL- 20
AIM- Write a program to Integrate SQL with Python by importing the
MySQL module to search a student using roll no, update the record
SOFTWARE USED- IDLE (PYTHON 3.8 64-BIT)
MySQL Workbench 8.0 CE
INPUT
OUTPUT
PRACTICAL- 21
AIM- Write a program to Integrate SQL with Python by importing the
MySQL module to search a student using roll no, delete the record.
SOFTWARE USED- IDLE (PYTHON 3.8 64-BIT)
MySQL Workbench 8.0 CE
INPUT
OUTPUT
PRACTICAL- 22
AIM- Write a program to Take a sample of ten phishing e-mails (or
any text file) and find most commonly occurring word(s)
SOFTWARE USED- IDLE (PYTHON 3.8 64-BIT)
INPUT
OUTPUT
