Practical File Informatics Practices Class 11 Comprehensive Guide

In this article, I will discuss Practical File Informatics Practices Class 11. This is practical file is strictly prepared as per syllabus of Informatics Practices for session 2022-23. So here we begin!

Practical File Informatics Practices Class 11

The syllal has a python and database management system in the practical. To create Practical File Informatics Practices Class 11 you need to follow the practical assessment structure suggested by CBSE.

Practical Assessment Structure

It is as follows:

SNoTopicMarks
1Problem Solving using Python Programming Language11
2Creating database using MySQL and performing Queries7
3Practical File (Minimum of 14 programs and 14 MySQL Queries)7
4Viva-Voce5
Total30

As per the above table, you need to write 14 python programs and 14 MySQL queries for Practical File Informatics Practices Class 11. In the next section, we will see the suggested programs and queries given in your syllabus.

Suggested Practical List Practical File Informatics Practices Class 11

The suggested programs given in the syllabus for Informatics Practices Class 11 are as follows:

Python programs for class 11 Practicals

No.Practical
1Write a python program to find average and grade for given marks.
2Write a python program to find the sale price of an item with a given cost and discount (%).
3Write a python program to calculate perimeter/circumference and area of shapes such as triangle, rectangle, square and circle.
4Write a program to calculate Simple and Compound interest.
5Write a program to calculate profit-loss for a given Cost and Sell Price.
6Write a program to calculate EMI for Amount, Period and Interest.
7Write a program to calculate tax – GST / Income Tax
8Write a program to find the largest and smallest numbers in a list.
9Write a python program to find the third-largest/smallest number in a list.
10Write a program to find the sum of squares of the first 100 natural numbers.
11Write a program to print the first ‘n’ multiples of a given number.
12Write a program to count the number of vowels in a user-entered string.
13Write a program to print the words starting with a particular alphabet in a user-entered string.
14Create a dictionary of students to store names and marks obtained in 5 subjects.
15Create a dictionary to store the names of states and their capitals.

In CBSE syllabus the suggested MySQL queries will be given, they are as follows:

Suggested MySQL Queries for class 11 IP practicals

  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.

So let us begin now Practical File Informatics Practices Class 11. I will cover all the queries given above and few more additional queries as per given in the practical structure. So let us start now!

Python Practical Programs for Practical File Informatics Practices Class 11

So let us begiin with MySQL quries now. Here we go!

MySQL queries for Practical File Informatics Practices Class 11

[1] Create Database

Create a database as given in the suggested practical list. There is no name provided in the practical list. So I have created a database named Class11. The create database command is used to do so.

create database class11;
create database command - Practical File Term 2 Informatics Practices Class 11

[2] Open database

use class11;
use command in my sql class 11 practical file ip

[3] 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.

create table student 
(studentid int(4) primary key,
class char(2),
section char(1), 
gender char(1),
name varchar(20),
dob date,
marks decimal(5,2));
create table command class 11 ip practical file term 2

[4] View the structure of the table

desc student; OR
describe student
describe commadn in my sql IP class 11 practical file

Note: Use any of one command for your practical file.

[5] To insert the details of at least 10 students in the above table.

insert into student values
     (1101,'XI','A','M','Aksh','2005/12/23',88.21),
     (1102,'XI','B','F','Moksha','2005/03/24',77.90),
     (1103,'XI','A','F','Archi','2006/04/21',76.20),
     (1104,'XI','B','M','Bhavin','2005/09/15',68.23),
     (1105,'XI','C','M','Kevin','2005/08/23',66.33),
     (1106,'XI','C','F','Naadiya','2005/10/27',62.33),
     (1107,'XI','D','M','Krish','2005/01/23',84.33),
     (1108,'XI','D','M','Ayush','2005/04/23',55.33),
     (1109,'XI','C','F','Shruti','2005/06/01',74.33),
     (1110,'XI','D','F','Shivi','2005/10/19',72.30);
insert commadn in mysql class xi ip practical file class 11

[6] Display the details of the student table.

select * from student;
Practical File Informatics Practices Class 11 Comprehensive Guide

[7] To delete the details of a particular student in the above table.

Delete record of students who secured less than 65 marks.

delete from student where marks <65;
delete command class 11 ip practical file term 2

[8] To increase marks by 5% for those students who have studentid more than 1105.

update stduent set marks=makrs+(marks*0.05) where studentid>1105;
update command mysql class 11 ip practical file

[9] To display the content of the table of female students.

select * from student where gender = 'f';
Practical File Informatics Practices Class 11 Comprehensive Guide

[10] To display studentid, Name and Marks of those students who are scoring marks more than 50.

select studentid,name,marks from student where marks>50;
Practical File Informatics Practices Class 11 Comprehensive Guide

[11] To find the average of marks from the student table.

select avg(marks) from student;
Query 11 Class 11 IP Practical File

[12] To find the number of students, who are from section ‘A’.

select count(*) from student where section = 'A';
Query12 IP Class 11 Practical File

[13] To add a new column email in the above table with the appropriate data type.

alter table student add column email varchar(20);
Query13 Class 11 IP Practical File

[14] To add the email ids of each student in the previously created email column.

update student set email='a@a.com';
Query14 CLass 11 IP practical file

[15] To display the information of all the students, whose name contains ‘sh’

select * from student where name like 'sh%';
Practical File Informatics Practices Class 11 Comprehensive Guide

[16] To display the information of all the students, whose name starts with ‘sh’

select * from stduent where name like 'sh%';
Practical File Informatics Practices Class 11 Comprehensive Guide

[17] To display studentid, Name, DOB of those students who are born between ‘2005- 01-01’ and
‘2005-12-31’.

select studentif, name, dob from student where dob beetween '2005-01-01' and '2005-12-31';
query 17 ip practical file

[18] To display studentid, Name, DOB, Marks, Email of those male students in ascending order of their
names.

select studentid, name, dob from student order by name;
Query18 IP practical file class 11

[19] To display stduentid, Gender, Name, DOB, Marks, Email in descending order of their marks.

select studentid, gender, name, dob, marks, email from student order by marks desc;
Query 19 IP practical file class 11

[20] To display the unique section available in the table.

select distnict section from student;
Practical File Informatics Practices Class 11 Comprehensive Guide

Watch this video for more clarity:

Download PDF for Practical File Informatics Practices Class 11

Follow this link to download the pdf for Practical File Informatics Practices Class 11.

Download PDF Initial Pages
Practical File Informatics Practices Class 11
Dowload PDF for Practicals
Practical File Informtics Practice Class 11

Follow below-given link to access the contents of class 11 IP.

Inofrmatics Practices Class 11 contents

I hope this will help you to make your practical file. Kindly share your views, feedback, and thoughts about this article in the comment section. Feel free to share your views. Thank you for reading this article.

One thought on “Practical File Informatics Practices Class 11 Comprehensive Guide”

Leave a Reply