DOON VALLEY PUBLIC
SCHOOL
CHEMISTRY PRACTICAL FILE
FO R
INTERNAL ASSESMENT 2024- 2025
[AS A PART O F CHEMISTRY CO URSE(043)]
SESSIO N: 2024 – 2025
CLASS: XII – SCI (A)
SUBMITTED BY: SUBMITTED TO:
NAME: Shivam Sharma Mrs.Binita Pandey
ROLL NO: 35 (P.G.T. CHEMISTRY)
CERTIFICATE
This is to certify that the Practical File work is a bonafide work done
by Shivam Sharma of class XII – Sc. session 2024- 25 in partial
fulfillment of Internal Assesment ‘2025 and has been carried out under
my direct supervision and guidance. This Practical report or a similar
report has not been submitted for any other examination and does not
form a part of any other course undergone by the candidate.
… … … ..… … … … … … … … … … … … … … … … … ..
Signature of Student Signature of Teacher/Guide
Name: Shivam Sharma Name: Mrs.Binita Pandey
Roll No.: 35 Designation: (Chemistry) PGT
… … .… … … .… … … … … … …
Signature of Principal
Name: Mr. G. K. Shimal
Place: … … … … … .
Date: … … … … … ..
ACKNOWLEDGEMENT
I undertook this Practical File work, as the part of my XII – Chemistry
course. I had tried to apply my best of knowledge and experience,
gained during the study and class work experience. It requires a
systematic study, insight vision and professional approach during the
design and development. Moreover, the developer always feels the need,
the help and good wishes of the people near you, who have considerable
experience and idea.
I would like to extend my sincere thanks and gratitude to my
teacher Mrs. Binita Pandey. I am very much thankful to our
Principal Mr. G. K. Shimal.
(_______________)
___________________
Class: XI – SC.
PYTHO
Program1: To calculate average and grade of given marks.
Coding:
import statistics
Physics=79
Maths=99
IP=100
Chemistry=87
English=97
print(statistics.mean([Physics, Maths, IP, Chemistry, English]))
Output:
Program2:To find sale price on item with given cost and discount(%).
Coding:
cp=1000
dp=cp- cp*10/100
sp=dp
print("The sale prie is:",sp)
Output:
Program3:To calculate perimeter/circumference and area of shapes such as
triangle,rectangle,square and circle.
Coding:
print("Enter number to select shape:")
print("1.Triangle")
print("2.Rectangle")
print("3.Square")
print("4.Circle")
n = int(input("Enter your choice 1,2,3,4 :"))
if (n==1):
S1= int(input("Enter the length of Side 1:"))
S2 = int(input("Enter the length of Base :" ))
S3 = int(input("Enter the length of Side 3 :"))
h = int(input("Enter the height of the triangle : "))
print ("Perimeter of trinagle is ",(S1+S2+S3))
print ("Area of triangle is ",(1/2*S2*h))
elif (n==2):
l = int(input("Enter the length of the rectangle : "))
b = int(input("Enter the base of the rectangle : "))
print("Perimeter of the rectangle is : ",(2*(l+b)))
print("Area of the rectangle is : ",(l*b))
elif(n==3):
s = int(input("Enter the length of the side of square : "))
print("Perimeter of square is ",(4*s))
print("Area of square is ",(s*s))
elif(n==4):
r = int(input("Enter the radius of the circle : "))
print("Circumference of the circle is ",(2*3.14*r))
print("Area of the circle is ",(3.14*r*r))
Output:
Program4:To calculate simple and compound interest.
Coding:
principal = float(input('Enter amount: '))
time = float(input('Enter time: '))
rate = float(input('Enter rate: '))
simple_interest = (principal*time*rate)/100
compound_interest = principal * ( (1+rate/100)**time - 1)
print('Simple interest is: %f' % (simple_interest))
print('Compound interest is: %f' %(compound_interest))
Output:
Program5:To calculate profit,loss for given cost and sell price.
Coding:
cp=2500
sp=1500
if sp > cp :
profit = sp- cp
profit_per = (profit * 100)//cp
print("The Profit is :- ",profit)
print("The Profit percentage is :- ",profit_per)
elif sp <cp:
loss = cp - sp
loss_per = (loss * 100)//cp
print("The Loss is :- ",loss)
print("The Loss percentage is :- ",loss_per)
else:
print("No Profit No Loss")
Output:
Program6:Calculate emi for amount,period and interest.
Coding:
amount = float(input("Enter the base amount :- "))
period = float(input("Enter the time period :- "))
rate = float(input("Enter rate of Interest :- "))
interest = amount * period * rate /100
total = amount + interest
emi = total /(period * 12)
print("EMI amount is ",emi)
Output:
Program7:To calculate tax- GST/Income tax.
Coding:
cost = float(input("Enter cost of the product/service:- "))
gstper = float(input("Enter the % charged for gst :- "))
gst = cost * gstper/100
amount = cost + gst
print("GST is :- ",gst)
print("Amount to Pay is :- ",amount)
# Income Tax
income = float(input("Enter total annual income :- "))
if income <20000:
tax = 0
elif income <400000:
tax = (income- 200000)*0.05
elif income <800000:
tax = (income- 400000)*0.07 + 10000
else :
tax = (income- 800000)*0.1+38000
print("Income Tax to pay",tax)
Output:
Program8:To find the largest and smallest number in a list.
Coding:
lst = [ ]
num = int(input('How many numbers: '))
for n in range(num):
numbers = int(input('Enter number '))
lst.append(numbers)
print("Largest element in the list is :", max(lst), "\nSmallest element in the list is :", min(lst))
Output:
Program9:To find the third largest number In a list.
Coding:
l=[5,8,2,9,4,10,7]
for j in range(3):
max=l[0]
for i in l:
if i>max: max=i
if j==2: print(max)
else: l.remove(max)
Output:
Program10:To find the sum of squares of the first 100 natural numbers.
Coding:
total = 0
for num in range(1,101):
sq = num **2
total += sq
print("Sum of Square of Natural number from 1to 100 is :- ",total)
Output:
Program11:To print the first ‘n’ multiples of a given number.
Coding:
num = 45
mul = int(input("Enter no. of multiples : "))
print("First ", mul, "multiples of ", num, "are : ")
for i in range(mul) :
print(num*(i+1))
Output:
Program12:To count the number of vowels in user entered string.
Coding:
String = input('Enter the string :')
count = 0
String = String.lower()
for i in String:
if i == 'a' or i == 'e' or i == 'i' or i == 'o' or i == 'u':
count+=1
if count == 0:
print('No vowels found')
else:
print('Total vowels are :' + str(count))
Output:
Program13:To print the words staring with ‘a’ alphabet in user entered string.
Coding:
text=input("Enter a string:")
alpha=input("Enter an alphabet:")
words=text.split(" ")
for word in words:
if word[0]==alpha:
print(word)
Output:
Program14:To print the number of occurences of a given alphabet in each string.
Coding:
count = 0
my_string = "Rizzler"
my_alpha = "z"
for i in my_string:
if i == my_alpha:
count += 1
print(count)
Output:
Program15:Create a dictionary to store names of states and their capitals.
Coding:
state_capitals = {
"California": "Sacramento",
"Texas": "Austin",
"New York": "Albany",}
for state, capital in state_capitals.items():
print(f"The capital of {state} is {capital}.")
Output:
Program16:Create a dictionary of students to store names and marks obtained in 5 subjects.
Coding:
students_marks = {
"Ranveer": {"Math": 85, "English": 90, "Physics": 92, "Chem": 88, "IP": 78},
"Shivam": {"Math": 78, "English": 85, "Physics": 80, "Chem": 75, "IP": 82},
"Sameer": {"Math": 92, "English": 88, "Physics": 94, "Chem": 90, "IP": 80},
"Montu": {"Math": 76, "English": 80, "Physics": 79, "Chem": 82, "IP": 85},
"Om": {"Math": 89, "English": 91, "Physics": 87, "Chem": 93, "IP": 80}}
student_name = "Ranveer"
marks = students_marks.get(student_name)
if marks:
print(f"Marks for {student_name}:")
for subject, mark in marks.items():
print(f"{subject}: {mark}")
else:
print(f"Student {student_name} not found.")
Output:
Program17:To print the highest and lowest value in a dictionary.
Coding:
value={"v1":78 , "v2":89 , "v3":64 , "v4":35 , "v5":71}
m = value.values()
highest = max(m)
lowest = min(m)
print("Higehst :",highest)
print("Lowest :",lowest)
Output:
SQL
Commands
&
OUTPUTS
Q1 Consider the following table SHOP and answer (A) & (B) parts of the
question;
(A) Write SQL command for the following statements;
1) To create the above table with required fields and constraints.
2) To display the structure of the given table.
3) Insert last row in the table with details mention.
4) To display all the records of table shop.
5) To display names and customer percentage of all shops whose
cust_percent is more than 80.
6) To display names and customer percentage of all shops of the south
area.
7) To display list of all the shops whose sale is more than 300000 in
ascending order of shop name.
8) To display a report with shop name , area and rating for each shop in
the table whose sale is between 350000 and 400000 (both inclusive).
9) To display all the details of shop whose shop name last letter is ‘S’.
10)To update the sales of the shop 'Ripple' to 400000
11)To display the average sales of all shops in each area
12)To display the count of shops in each city
13)To display the details of shops that have a rating 'A' and are in the 'North'
area
14)To update the customer percentage for the shop named "Krishi Art" to
85.5
15)To display the names and sales of the shops with the highest sales to the
lowest sales
