Nav Uday Convent Senior

Secondary School

Computer Science
Program File
Name: Anamika Rai

Class: 12th A

Roll Number:

Subject Teacher: Mrs. Rani Saloni

1|P a g e
 I would like to express my gratitude to my Computer Science teacher
Mrs. Rani Saloni for her able guidance and support in completing my
project.

I would like to extend my gratitude to the honorable principle sir Mr.

Sandeep Kumar who gave me the golden opportunity to complete this
project.

Next, I would like to thanks my sister and my parents for all their
support, encouragement and help they gave me in completing this project
within the limited time frame.

2|P a g e
This is to certify that Anamika Rai, student of class XII-A of Nav Uday
Convent Senior Secondary School has successfully completed her Python
programming project under the guidance and supervision of Mrs. Saloni
Rani, her Computer Science teacher.

She has taken proper care and has shown utmost sincerity in the
completion of this project. I certify that this project is up to my expectations
and as per the guidance issued by C.B.S.E.

Mrs. Rani Saloni

Subject Teacher

3|P a g e
 Index
S. No. Name Of Practical Pg. No. Sign Of Teacher
1. Write a program to print the Fibonacci Series using 01
functions.
2. Write a program to check whether the string is a
palindrome or not using functions.
3. Write a random number generator that generates
random numbers between 1 and 6(stimulates 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 numbers of vowels,
consonants, uppercase and lowercase characters in the
file.
8. Write a program that reads a text file and create a
new file after adding “ing” to all the words ending
with “t”, “e” and “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.
4|P a g e
11, Write a program to create a file [Link]
having fields ModelNo, MegaPixel, Zoom and
Price using comma as a delimiter and display its
content.
12. Write a program to read [Link] file
containing VoterId, VoterName, VoterAge and
Status having comma as a delimiter. Also read and
display the contents of the file.
13. Write a Python program to implement a stack using
a list data-structure.
14. Write a Python program to implement a queue
using a list data-structure.
15. Create a student table and insert data. Implement the
following SQL commands on the student table:
a. Alter table to add a new attribute/ 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
min, max, sum, count and average.
16. Integrate SQL with Python by implementing the
MYSQL module.
a. Create A Table.
b. Insert Data.
c. Fetch Data.
d. Update Record.
e. Delete Record

5|P a g e
P rogram 1
Write a program to print the Fibonacci Series using functions.

***************Code***************

***************Output***************

6|P a g e
P rogram 2
Write a program to check whether the string is a palindrome or not
using functions.
***************Code***************

***************Output***************

7|P a g e
P rogram 3
Write a random number generator that generates random numbers
between 1 and 6(stimulates a dice).
***************Code***************

***************Output***************

8|P a g e
P rogram 4
Write a program to create a library in python and import it in a
program.
***************Code***************
#Creating A Library In Python

#Importing The Library In Python Program

9|P a g e
***************Output***************

10 | P a g e
P rogram 5
Read a text file line by line and display each word separated by a “#”.

***************Code***************

***************Output***************

11 | P a g e
P rogram 6
Remove all the lines that contain the character “a” in a file and write
it to another file.
***************Code***************

***************Output***************
#Original File:

#New File:

12 | P a g e
P rogram 7
Read a text file and display the numbers of vowels, consonants, uppercase and
lowercase characters in the file.
***************Cod
e***************

13 | P a g e
***************Output***************

14 | P a g e
P rogram 8
Write a program that reads a text file and create a new file after adding “ing”
to all the words ending with “t”, “e” and “d”.
**************Code***************

***************Output***************
#Original File:

#New File:

15 | P a g e
P rogram 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.
***************Code***************
#Creating Binary File

#Adding Student’s Details and Searching Roll No.

16 | P a g e
***************Output***************

17 | P a g e
P rogram 10
Create a binary file with roll number, name and marks. Input a roll
number and update the marks.

***************Code***************
#Creating Binary File

# Updating Student’s Marks

18 | P a g e
19 | P a g e
***************Output***************

20 | P a g e
P rogram 11
Write a program to create a file [Link] having fields ModelNo,
MegaPixel, Zoom and Price using comma as a delimiter and display its
content.

***************Code***************

21 | P a g e
***************Output***************

# .csv file in Microsoft Excel

22 | P a g e
P rogram 12
Write a program to read [Link] file containing VoterId, VoterName,
VoterAge and Status having comma as a delimiter. Also read and display the
contents of the file.

***************Code***************

23 | P a g e
***************Output***************

24 | P a g e
# .csv file in Microsoft Excel

25 | P a g e
 P rogram 13
Write a Python program to implement a stack using a list data-structure.

***************Code***************

26 | P a g e
***************Output***************

27 | P a g e
28 | P a g e
29 | P a g e
P rogram 14
Take a sample of ten phishing e-mails (or any text file) and find most
commonly occurring word(s).

***************Code***************

***************Output***************

30 | P a g e
SQL Queries
31 | P a g e
P rogram 15
Create a database “My_Database” and create tables – “Student_List” and
“Records” in it. Implement the following SQL commands on the table:-
a. Insert data
b. Alter table (add new attribute/modify data type/ drop attribute)
c. Update data
d. Delete record
e. Aggregate Functions
f. Order By Clause
g. Fetch data
h. Group By data
i. Join tables

32 | P a g e
 Create database:

 Create table:

 Describe table:

 Insert values in the table:

33 | P a g e
 Fetch Data:

 Alter Clause:
 Drop Attribute

34 | P a g e
Add Attribute

35 | P a g e
 Modify Attribute

 Update values:

36 | P a g e
 Delete Record:

 Aggregate Functions:
 Max

 Min

37 | P a g e
  Sum

 Count

 Average

 Order – by Clause:

38 | P a g e
 Group – By Clause:

 joining tables:
39 | P a g e
Connectivity Of
SQL With Python
40 | P a g e
P rogram 16
Integrate SQL with Python by importing the MySQL module to
implement:
a. Create a table
b. Insert data
c. Fetch data
d. Update data
e. Delete data

41 | P a g e
42 | P a g e
43 | P a g e
44 | P a g e
45 | P a g e
46 | P a g e