Class 12 Informatics PracticesImportant Questions for Board Exams
14
Total Questions
14
Long Answer
0
Short Answer
Data Handling with Pandas — I
2 questionsCreate a Pandas DataFrame from a dictionary of lists and display the first 3 rows, shape, and data types.
Explain the difference between loc[] and iloc[] with an example.
Data Handling with Pandas — II
2 questionsWrite a Pandas program to merge two DataFrames on a common column 'EmpID' using inner join and display the result.
Write code to group a DataFrame by 'Department' and find the average 'Salary' for each department.
Data Visualisation using Matplotlib
2 questionsWrite a Python program to draw a bar chart showing the marks of 5 students in three subjects.
Write code to plot a pie chart showing the percentage distribution of budget across five departments.
Database Management using MySQL
2 questionsWrite SQL queries to: create a table EMPLOYEE, insert 3 records, and display employees earning more than ₹50,000.
Write an SQL query to find the department with the highest average salary using GROUP BY and HAVING.
Networking and Internet
2 questionsDistinguish between LAN, MAN, and WAN with two examples each.
Explain the concept of cloud computing. What are the three service models? Give one example of each.
Emerging Trends
2 questionsWhat is Internet of Things (IoT)? List four applications of IoT in everyday life.
What is Machine Learning? Describe supervised and unsupervised learning with one example each.
Societal Impacts of IT
2 questionsWhat is meant by digital footprint? How can you minimise your digital footprint?
What is phishing? How is it different from vishing? How can you protect yourself?