, RYAN INTERNATIONAL SCHOOL
FARIDABAD
PRACTICAL FILE
PYTHON
All student's contribution
This file describes and analyzes the Python and MySql programming languages,which includes Functions, Sorting, Searching ,
Random Module, Text file, Binary file, CSV files, Stacks and Database connectivity.
, PRACTICAL FILE-COMPUTER SCIENCE(083)
LIST OF PRACTICALS (2023-24) CLASS-XII
Programming Language: Python
S.
Date NAME OF PRACTICAL Page Teacher’s
No.
No. Signature
1 Write a python functions in (x,n) to calculate the
value of sin(x) using its taylor series expansion
upto n terms.
2 Write a program for linear search.
3 Write a program for binary search.
4 Write a program for bubble sort.
5 Write a program to read a text file named xii.txt
and count the number of vowels
6 Write a program to write those lines which have
the character 'p' from one text file to another text
file.
7 Write a program to count number of words in a
file.
8 Write a program to find the most common words
in a file.
9 Write a program to generate random numbers
between 1 to 6 and check whether a user won a
lottery or not.
10 Write a program to perform read and write
operation with .csv file.
11 Write a program to perform write, delete,
, modification, search and display operation with
Binary file.
12 Write a menu based program to perform the
operation on stack in python
SQL Queries:
13 Queries using DISTINCT, BETWEEN, IN,
LIKE, ISNULL,
ORDERBY,GROUPBY,HAVING
14 Queries for Aggregate functions-
SUM(),AVG(),MIN(),MAX(),COUNT()
15 Write a program to connect Python with MySQL
using database connectivity and display all
databases name .
16 Write a program to connect Python with MySQL
using database connectivity and create table
student in students database .
17 Write a program to connect Python with MySQL
using database connectivity and add data in
table student of students database .
18 Write a program to connect Python with MySQL
using database connectivity and update data in
table student of students database .
19 Write a program to connect Python with MySQL
using database connectivity and delete data from
table student of students database .
20 Write a program to connect Python with MySQL
using database connectivity and fetch data from
table student of students database .
FARIDABAD
PRACTICAL FILE
PYTHON
All student's contribution
This file describes and analyzes the Python and MySql programming languages,which includes Functions, Sorting, Searching ,
Random Module, Text file, Binary file, CSV files, Stacks and Database connectivity.
, PRACTICAL FILE-COMPUTER SCIENCE(083)
LIST OF PRACTICALS (2023-24) CLASS-XII
Programming Language: Python
S.
Date NAME OF PRACTICAL Page Teacher’s
No.
No. Signature
1 Write a python functions in (x,n) to calculate the
value of sin(x) using its taylor series expansion
upto n terms.
2 Write a program for linear search.
3 Write a program for binary search.
4 Write a program for bubble sort.
5 Write a program to read a text file named xii.txt
and count the number of vowels
6 Write a program to write those lines which have
the character 'p' from one text file to another text
file.
7 Write a program to count number of words in a
file.
8 Write a program to find the most common words
in a file.
9 Write a program to generate random numbers
between 1 to 6 and check whether a user won a
lottery or not.
10 Write a program to perform read and write
operation with .csv file.
11 Write a program to perform write, delete,
, modification, search and display operation with
Binary file.
12 Write a menu based program to perform the
operation on stack in python
SQL Queries:
13 Queries using DISTINCT, BETWEEN, IN,
LIKE, ISNULL,
ORDERBY,GROUPBY,HAVING
14 Queries for Aggregate functions-
SUM(),AVG(),MIN(),MAX(),COUNT()
15 Write a program to connect Python with MySQL
using database connectivity and display all
databases name .
16 Write a program to connect Python with MySQL
using database connectivity and create table
student in students database .
17 Write a program to connect Python with MySQL
using database connectivity and add data in
table student of students database .
18 Write a program to connect Python with MySQL
using database connectivity and update data in
table student of students database .
19 Write a program to connect Python with MySQL
using database connectivity and delete data from
table student of students database .
20 Write a program to connect Python with MySQL
using database connectivity and fetch data from
table student of students database .
