CENTRAL BOARD OF SECONDARY

EDUCATION
UNIVERSAL CONVENT SEN. SECONDARY SCHOOL

HALDWANI(NAINITAL)

A PRACTICAL RECORD FILE IS SUBMITTED TO DEPARTMENT OF COMPUTER

SCIENCE FOR THE PARTIAL FULLFILLMENT OF CLASS XI EXAMINATION.

SESSION – 2023-2024

COMPUTER SCIENCE-PRACTICAL FILE

SUBMITTED BY: ANUBHAV KIROULA

SUBMITTED TO: MR. SUNIL CHUPHAL SIR

CLASS: XI ‘A’

ROLL NO. : 3
 ACKNOWLEDGEMENT

I wish to express my deep sense of gratitude and

indebtedness to our learned teacher Mr. Sunil Chuphal
sir, PGT COMPUTER SCIENCE, Universal Convent Senior
Secondary School Haldwani(Nainital) for his invaluable
help, advice and guidance in the preparation of this
project. I am also greatly indebted to our principal Mrs.
Manju Joshi and school authorities for providing me
with the facilities and requisite laboratory conditions
for making this practical file. I also extend my thanks to
a number of teachers, my classmates and friends who
helped me to complete this practical file successfully.

Anubhav Kiroula.
 CERTIFICATE
This is to certify that Anubhav kiroula , student of Class
XI, Universal Convent Senior Secondary School
Haldwani(Nainital) has completed the PRACTICAL FILE
during the academic year 2023-2024 towards partial
fulfillment of credit for the Computer Science practical
evaluation of CBSE and submitted satisfactory report,
as compiled in the following pages, under my
supervision.
Total number of practical certified are: 25

Examiner Signature:-
 CONTENT

S.NO PRACTICAL SIGNATURE

1. 20 Python programs
2. 5 SQL query
1. Write a python program to input a welcome message and display it.
#Taking input

wl_msg = input(“Enter the welcome message:”)

#Printing Message

print(wl_msg)

2.Write a python program to input two numbers and display the larger / smaller number.

#Taking input

n1=int(input(“Enter number1 n1=input("Enter the first number to check:")

n2=input("Enter the second number to check:")

#Checking Larger

if n1>n2:

print(n1," is larger.")

elif n2>n1:

print(n2," is larger")

else:

print("You have entered equal number.")

#Checking Smaller

if n1<n2:

print(n1," is smaller.")

elif n2<n1:

print(n2," is smaller")

else:

print("You have entered equal number.")

3.Write a python program to input three numbers and display the largest / smallest
number.

n1=input("Enter the first number to check:")

n2=input("Enter the second number to check:")

n3=input("Enter the third number to check:")

#Checking Largest

if n1>n2 and n1>n3:

print(n1," is largest.")

elif n2>n1 and n2>n3:

print(n2," is largest")

elif n3>n1 and n3>n2:

print(n3," is largest")

else:

print("You have entered equal number.")

#Checking Smallest

if n1<n2 and n1<n3:

print(n1," is smallest.")

elif n2<n1 and n2<n3:

print(n2," is smallest")

elif n3<n1 and n3<n2:

print(n3," is smallest")

else:

print("You have entered equal number.")

4. Generate the following patterns using nested loop.

PATTERN 1 PATTERN 2 PATTERN 3

* 12345 A
** 1234 AB
*** 123 ABC
****
*****
12 ABCD
1 ABCDE
#Code For Pattern1

for i in range(1,6):

for j in range(1,i+1):

print("*",end=" ")

print()

#Code for Pattern2

for i in range(6,1,-1):

for j in range(1,i):

print(j,end=" ")

print()

#code for pattern 3

for i in range (65,70):

for j in range(65,i+1):

print(chr(j),end="")

print()
5. Write a program to input the value of x and n and print the sum of the following series:

a. 1 + x² + x³ + ... + xⁿ

b. x - x 2 /2! + x 3 /3! - x 4 /4! + x 5 /5! - x 6 /6!

x = float (input ("Enter value of x :"))

n = int (input ("Enter value of n :"))

s=0

#Series 1

for i in range (n+1) :

s += x**i

if i<n:

print(x**i,"+",end=" ")

else:

print(x**i,end=" ")

print ("=", s)

#Series 2

sum = 0

m=1

for i in range(1, 7) :

f=1

for j in range(1, i+1) :

f *= j

t = x ** i / f

if i==1:

print(int(t),end=" ")

elif i%2==0:

print("-",int(t),end=" ")
 else:

print("+",int(t),end=" ")

sum += t * m

m = m * -1

print(" =", sum)

Series 1:

Series 2:

6. Write a program to determine whether a number is a perfect number, an

Armstrong number or a palindrome.

n=int(input("Enter a number to check:"))

temp = n

cnt=0

rev=0

#Check for a perfect number

for i in range(1,n):

if n%i==0:

cnt+=i

if cnt==n:

print(n," is perfect number")

else:

print(n," is not a perfect number")

#Check for an armstrong number

while temp > 0:

digit = temp % 10

cnt += digit ** 3

temp //= 10 # Armstrong number is a number that is equal to the sum of cubes of
its digits

if n == cnt:

print(n, "is an Armstrong number")

else:

print(n, "is not an Armstrong number")

#Check for palindrome

while n > 0: #if n is greater than 0 this loop runs

dig = n % 10

rev = rev * 10 + dig #This loop calculates the reverse and matches it with input

n = n // 10

if temp == rev:

print(temp, "The number is a palindrome!")

else:

print(temp, "The number isn’t a palindrome!")

7. Write a program to input a number and check if the number is a prime or
composite number.

n=int(input("Enter number to check:"))

if n>1:

for i in range(2,n):

if n%i==0:

f=1

break

else:

f=0

elif n==0 or n==1:

print(n, " is not a prime number nor composite number")

else:

print(n," is a composite number")

if f==1:

print(n, " is not a prime number")

else:

print(n," is a prime number")

8. Write a program to display the n term Fibonacci series.

nterms = int(input("Enter no. of terms to display: "))

# first two terms

n1, n2 = 0, 1

count = 0

# check if the number of terms is valid

if nterms <= 0:

print("Please enter a positive integer")

# if there is only one term, return n1

elif nterms == 1:

print("Fibonacci sequence upto",nterms,":")

print(n1, end=” ”)

# generate fibonacci sequence

else:

print("Fibonacci sequence:")

while count < nterms:

print(n1)

nth = n1 + n2

# update values

n1 = n2

n2 = nth

count += 1
9. Write a python program to compute the greatest common divisor and
least common multiple of two integers.

# Reading two numbers from user

fn = int(input('Enter first number: '))

sn = int(input('Enter second number: '))

gcd = 1

for i in range(1,fn +1):

if fn%i==0 and sn%i==0:

gcd = i

# Displaying GCD

print('HCF or GCD of %d and %d is %d' %(fn, sn,gcd))

# Calculating LCM

lcm = fn * sn/ gcd

print('LCM of %d and %d is %d' %(fn, sn, lcm))

10. Write a program to count and display the number of vowels, consonants,
uppercase, lowercase characters in string.

txt = input("Enter Your String : ")

v = c = uc = lc = 0

v_list = ['a','e','i','o','u']

for i in txt:

if i in v_list:

v += 1
 if i not in v_list:

c += 1

if i.isupper():

uc += 1

if i.islower():

lc += 1

print("Number of Vowels in this text = ", v)

print("Number of Consonants in this text = ", c)

print("Number of Uppercase letters in this text=", uc)

print("Number of Lowercase letters in this text=", lc)

11. Write a menu driven program for list manipulation. Display menu as:

1. Add a record

2. View record

3. Delete Record

4. Modify record

5. Exit

l=[]
while True:

print('''1. Add a record

2. View record

3. Delete Record

4. Modify record

5. Exit''')

ch=int(input("Enter your choice:"))

if ch==1:

v=int(input("Enter value to add a record:"))

l.append(v)

print("Record Added...")

print("List after insertion:",l)

elif ch==2:

print(l)

elif ch==3:

n=int(input("Enter the value to delete:"))

l.remove(n)

print("Record Deleted...")

print("List after deletion:",l)

elif ch==4:

i=int(input("Enter position to modify the value:"))

nv=int(input("Enter new value to modify:"))

l[i]=nv

print("Record Modified...")

print("List after modification”)

 elif ch==5:

print(“Thank you! Good Bye”)

break

Output: Main Menu

1. Add record:

2. View Record:

3. Delete Record:

4. Modify Record:

5. Exit:

12. Write a menu drive program to the following from the list:
1. Maximum

2. Minimum

3. Sum

4. Sort in Ascending

5. Sort in Descending

6. Exit
l=[11,32,5,43,22,98,67,44]

while True:

print('''

1. Maximum

2. Minimum

3. Sum

4. Sorting (Ascending)

5. Sorting (Descending)

6. Exit

''')

ch=int(input("Enter your choice:"))

if ch==1:

print("Maximum:",max(l))

elif ch==2:

print("Minimum:",min(l))

elif ch==3:

print("Sum:",sum(l))

elif ch==4:

l.sort()
 print("Sorted list(Ascending):",l)

elif ch==5:

l.sort(reverse=True)

print("Sorted List(Descending:)",l)

elif ch==6:

print("Thank you! Good Bye")

break

Output: Main menu

Maximum:

Minimum:

Sum:

Sort (Ascending):

Sort(Descending):
Exit:

13. Write a program to input a list of numbers and swap elements at the
even location with the elements at the odd location.

l=eval(input("Enter a list: "))

print("Original List before swapping:”,l)

s=len(l)

if s%2!=0:

s=s-1

for i in range(0,s,2):

l[i],l[i+1]=l[i+1],l[i]

print("List after swapping the values :",l)

14. Write a program to input a list of number and interchange first element
to last element.

l=eval(input("Enter a list: "))

t=l[0]

l[0]=l[-1]

l[-1]=t

print(l)
15. Write a program to create a tuple with user input and search for given
element.

t=eval(input("Enter tuple here:"))

n=int(input("Enter element to search:"))

if n in t:

print("Found:",n)

else:

print("Tuple doesn't contain ",n)

16. Write a program to create tuple with user input and display the square of
numbers divisible by 3 and display cube of numbers divisible by 5.

t=eval(input("Enter tuple here:"))

for i in t:

if i%3==0:

print(i**2,end=' ')

if i%5==0:

print(i**3,end=' ')
17. Write a menu driven program to do the following using a
dictionary.

1. Display Contacts

2. Add Contact

3. Delete a Contact

4. Change a phone number

5. Search Contact

6. Exit

d={}

while True:

print('''

1. Display Contacts

2. Add Contact

3. Delete a Contact

4. Change a phone number

5. Search Contact

6. Exit

''')

ch=int(input("Enter your choice:"))

if ch==1:

print("Saved Contacts.......")

for i in d:

print('----------------')

print("Name:",i)

print("Phone.No:",d[i])
 print('----------------')

elif ch==2:

print("Add new contact")

name=input("Enter Name:")

ph=input("Enter Phone Number:")

#d[name]=ph

d.setdefault(name,ph)

print("Contact Saved...")

elif ch==3:

print("Delete existing contact")

n=input("Enter name to delete contact:")

#d.pop(n)

#d.popitem()

#del d[n]

d.clear()

print("Contact Deleted...")

elif ch==4:

print("Change a phone number")

n=input("Enter name to change phone no.:")

new_ph=input("Enter new phone number:")

d[n]=new_ph

print("Contact Saved...")

elif ch==5:

print("Search Contact")

n=input("Enter name to search:")

if n in d:
 print("Record Found...",d[n])

else:

print("Record not found...")

elif ch==6:

print("Quitting from App....")

input("Press Enter to Exit...")

break

Main Menu:

1. Display Contacts:

2. Add Contact:

3. Delete a contact:
 4. Change a phone number:

5. Search a contact:

6. Exit:

18. Write a program to create a dictionary with the roll number, name and
marks of n students in a class and display the names of students who have
scored marks above 75.

d={1:['Rudra',99],2:['Rushi',98],

3:['Prakash',65],4:['Jay',84]}

for i in d:

if d[i][1]>75:

print(d[i][0]," \tscored -", d[i][1])

19. Write a program to create a dictionary and store salesman name

as a key and sales of 3 months as values. Give the bonus to the
salesman according to the given criteria:

• Total Sales < 1K – No Bonus

• Total Sales 1K to 2K – 5%

• Total Sales 2.1K to 3K – 8%

• Total Sales 3.1K to 4K – 10%

• Total Sales >4K – 12%

d={'Rudra':[199,180,540],'Rushi':[543,876,453],

'Preet':[650,987,123],'Jay':[284,456,321]}

bonus=0

for i in d:

d[i]=sum(d[i])

for i in d:

if d[i]<1000:

d[i]=0

elif d[i]>=1000 and d[i]<=2000:

d[i]=d[i]*0.05

elif d[i]>=2001 and d[i]<=3000:

d[i]=d[i]*0.08

elif d[i]>=3001 and d[i]<=4000:

d[i]=d[i]*0.1

elif d[i]>=4001:

d[i]=d[i]*0.12

print("Bonus for salesman:")

for i in d:

print(i,"\t: %.2f"%d[i])
20. Write a program to enter a team name, wins and losses of a team.
Store them into a dictionary where teams names are key, wins and
losses are values stored as a list. Do the following based on the
dictionary created above:

• Find out the team’s winning percentage by their names

• Display the no. of games won by each team in a list

• Display the no. of games lost by each team in a list

di ={}

l_win = []

l_rec = []

while True :

t_name = input ("Enter name of team (q for quit): ")

if t_name in 'Qq' :

print()

break

else :

win = int (input("Enter the no.of win match: "))

loss = int(input("Enter the no.of loss match: "))

di [ t_name ] = [ win , loss ]

l_win += [ win ]

if win > 0 :

l_rec += [ t_name ]

n = input ("Enter name of team for winning percentage: ")

wp=di[n][0] *100 / (di[n][0] + di[n][1] )

print ("Winning percentage:%.2f"%wp)

print("Winning list of all team = ",l_win)

print("Team who has winning records are ",l_rec)
 SQL QUERIES
1. Observe the given Table TEACHER and give the output of question
(i) and (ii).

i. SELECT TEACHER_NAME, DOJ FROM TEACHER WHERE

TEACHER_NAME LIKE ‘%I%’;

Ans:

ii. SELECT* FROM TEACHER WHERE DOJ LIKE ‘%-09-%’;

Ans:

2. Write SQL queries for (i) to (iv) and find outputs for SQL queries (v)
to (viii) which are based on tables.
Ans:
3. Consider the following tables EMP and SALGRADE, write the query
for (i) to (vi) and output for (vii) to (x).

Ans:
4. In a database there are two tables : Write MYSQL queries for (i) to
(iii).

Ans:-

5. Considering the VISITOR table data, write the query for (i) to (iv)
and outputs for (v) to (viii).
Ans:-

********