Class 11 Informatics Practices
Suggested practical list
session 2022-2023
Python programs for class 11 Practicals.Write any 10 practical from this
list
No. Practical
1 Write a python program to find
average and grade for given marks.
2 Write a python program to find the
sale price of an item with a given cost and discount (%).
3 Write a python program to calculate
perimeter/circumference and area of shapes such as triangle, rectangle, square
and circle.
4 Write a program to calculate Simple
and Compound interest.
5 Write a program to calculate
profit-loss for a given Cost and Sell Price.
6 Write a program to calculate EMI
for Amount, Period and Interest.
7 Write a program to calculate tax –
GST / Income Tax
8 Write a program to find the largest
and smallest numbers in a list.
9 Write a python program to find the
third-largest/smallest number in a list.
10 Write a program to find the sum of
squares of the first 100 natural numbers.
11 Write a program to print the first
‘n’ multiples of a given number.
12 Write a program to count the number
of vowels in a user-entered string.
13 Write a program to print the words
starting with a particular alphabet in a user-entered string.
14 Create a dictionary of students to
store names and marks obtained in 5 subjects.
15 Create a dictionary to store the
names of states and their capitals.
Suggested MySQL Queries for class 11 IP practicals Write any 8 Practicals
from this list
1. To create a student table with the
student id, class, section, gender, name, dob, and marks as attributes where
the student id is the primary key.
2. To insert the details of at least 10
students in the above table.
3. To delete the details of a
particular student in the above table.
4. To increase marks by 5% for those
students who have Rno more than 20.
5. To display the entire content of the
table.
6. To display Rno, Name and Marks of
those students who are scoring marks more than 50.
7. To find the average of marks from
the student table.
8. To find the number of students, who
are from section ‘A’.
9. To add a new column email in the
above table with appropriate data type.
10. To add the email ids of each student in
the previously created email column.
11. To display the information of all the
students, whose name starts with ‘AN’ (Examples: ANAND, ANGAD,..)
12. To display Rno, Name, DOB of those
students who are born between ‘2005- 01-01’ and ‘2005-12-31’.
13. To display Rno, Name, DOB, Marks, Email
of those male students in ascending order of their names.
14. To display Rno, Gender, Name, DOB,
Marks, Email in descending order of their marks.
15. To display the unique section available
in the table.
.png)
.png)
.png)
.png)
.png)
0 Comments