CBSE Class 12 Informatics Practices 2024-25 Sample Paper: Expert Analysis And Solutions | TutorialAICSIP

CBSE Class 12 Informatics Practices 2024-25 Sample Paper: A Comprehensive Guide

The Central Board of Secondary Education (CBSE) has released the sample papers on 5th September 2024 for Informatics Practices for Class 12 for the 2024-25 academic year. As students prepare for their board exams, these sample papers serve as an essential tool to help them to understand the exam pattern, types of questions, and marking schemes.

In this article, I’ll walk you through the key details of the sample paper and offer some tips to make the most of it during your preparation.

Overview of the CBSE Class 12 Informatics Practices 2024-25 Sample Paper

• The Class 12 Informatics Practices sample paper is designed to cover all the essential topics from the curriculum.
• The paper is divided into five sections (A,B,C,D,E), testing the theoretical understanding as well as practical knowledge of students.
• Here’s a quick breakdown:

1. Section A: Multiple-Choice Questions (1 Marks Questions) – This section typically comprises questions that test the conceptual understanding of various topics, including Python programming, databases, data visualization, and networking. There are 21 questions including MCQs, True or False, and Assertion and reasoning questions ranging from 1 to 21.
2. Section B: Short Answer Questions ( 2 marks questions) – These questions require concise, detailed responses, focusing on practical applications and conceptual clarity. Question 22 to 28 are 2 marks questions.
3. Section C: Short Answer Questions ( 3 marks questions) – These questions requires practical knowledge on Pandas, Matplotlib and MySQL. Question 29 to 32 are 3 marks questions.
4. Section D: Long Answer Questions: (4 marks questions) – These questions are based on case studies. There are two questions: 33 and 34.
5. Section C: Long Answer Questions (5 marks questions) – This section focuses on problem-solving skills, coding challenges, and in-depth understanding of database management and data analytics. There are 3 questions, 35 to 37.

Question wise Blueprint – CBSE Class 12 Informatics Practices 2024-25 Sample Paper

Here I am embedding the PDF for questions wise blue print:

Chapter Wise weightage – According to Sumita Arora Textbook

This PDF contains chapter wise weightage according to Sumita Arora textbook for Informatics Practices class 12.

Key Topics Covered in the Sample Paper

The sample paper for 2024-25 emphasizes the following core areas:

• Python Programming: Expect questions on basic and advanced Python concepts, including functions, file handling, libraries like NumPy and Pandas, and error handling.
• Data Handling & Visualization: Data manipulation with Pandas, creating data frames, data cleaning, and data visualization using Matplotlib are crucial topics.
• Database Management: SQL queries, database operations (CRUD), joins, and aggregation functions form the backbone of this section. Understanding relational databases and how to interact with them using Python is key.
• Computer Networks: Networking fundamentals like protocols, topologies, IP addressing, and security measures are also tested in the exam.
• Societal Impacts of Technology: Ethical issues related to technology, privacy concerns, data protection laws, and cybercrime prevention are vital theoretical questions.

Marking Scheme

• The paper is typically worth 70 marks.
• Section A (MCQs) carries 1 mark per question.
• Section B (Short Answer) may range from 2-3 marks per question, depending on the complexity.
• Section C (Long Answer) can be valued at 4-5 marks per question, testing the depth of your understanding and application skills.

Understanding the weightage of each section helps in organizing your study time effectively. Pay attention to high-mark questions in Sections B and C, as they can significantly impact your overall score.

So let’s begin answer discussion for CBSE Class 12 Informatics Practices 2024-25 Sample Paper.

Section A – CBSE Class 12 Informatics Practices 2024-25 Sample Paper

Section A contains 21 questions of 1 marks. It includes MCQs, True or False and Fill in the blanks type questions. Here we go!

[1] State whether the following statement is True or False: Slicing can be used to extract a specific portion from a Pandas Series.

Ans.: True
Slicing is used to extract a specific portion from a Pandas Series in this form: S[start:stop:step]

[2] The purpose of WHERE clause in a SQL statement is to:
(A) Create a table
(B) Filter rows based on a specific condition
(C) Specify the columns to be displayed
(D) Sort the result based on a column

Ans.: (B) Filter rows based on a specific condition
(A) Create table command is used to create a table, where clause is not required for this
(C) To Specify the columns to be displayed select clause is required
(D) To sort the result based on column order by clause is ised

[3] Identify the networking device responsible for routing data packets based on their destination addresses.
(A) Modem
(B) Hub
(C) Repeater
(D) Router

Ans.: (D) Router
(A) A modem is used to converts digital data signals to analogue signals and analogue signals to digital signals.
(B) Hub connects multiple computers in network to share data
(C) Repeater amplifies and retransmits signals that have been weakened or distorted over long distances

[4] Identify the SQL command used to delete a relation (table) from a relational database.
(A) DROP TABLE
(B) REMOVE TABLE
(C) DELETE TABLE
(D) ERASE TABLE

Ans.: (A) DROP TABLE
(B) REMOVE TABLE and (D) ERASE TABLE – There is no such command in SQL.
(C) DELETE command is used to delete row(s) from table.

[5] e-waste refers to:
(A) Software that has become obsolete
(B) Data that has been deleted from a storage device
(C) Viruses that infect computers
(D) Electronic devices that are no longer in use

Ans.: (D) Electronic devices that are no longer in use
Other options are not considered as e-waste they are coming under legacy systems

[6] Which of the following Python statements can be used to select a column column_name from a DataFrame df?
(A) df.getcolumn(‘column_name’)
(B) df[‘column_name’]
(C) df.select(‘column_name’)
(D) df(column_name)

Ans.: (B) df[‘column name’]
Rest options are not valid

[7] By default, the plot() function of Matplotlib draws a _____________ plot.
(A) histogram
(B) column
(C) bar
(D) line

Ans.: (D) line
(A) hist() function is used to draw histogram
(B) there is no such types of plot is available in matplotlib
(C) bar() function is used to draw bar plot

[8] State whether the following statement is True or False:
In SQL, the HAVING clause is used to apply a filter on groups formed by the GROUP BY clause.

Ans.: True

[9] Which of the following Python statements is used to import data from a CSV file into a Pandas DataFrame (Note: pd is an alias for pandas)?
(A) pd.open_csv(‘filename.csv’)
(B) pd.read_csv(‘filename.csv’)
(C) pd.load_csv(‘filename.csv’)
(D) pd.import_csv(‘filename.csv’)

Ans.: (B) pd.read_csv(‘filename.csv’)
Rest are invalid options

[10] What is plagiarism?
(A) Using copyrighted material without giving proper acknowledgement to the source
(B) Downloading illegal software.
(C) Spreading misinformation online.
(D) Hacking into computer systems.

Ans.: (A) Using copyrighted material without giving proper acknowledgement to the source
(B) Downloading illegal software is coming under Copyright or Software Piracy
(C) Spreading misinformation online and (D) Hacking are not coming plagiarism

[11] Fill in the Blank: The COUNT(*) function provides the total number of ___________ within a relation (table) in a relational database.
(A) Columns
(B) Unique values
(C) Not-null values
(D) Rows

Ans.: (D) Rows
(A) To display total columns * is used in select clause
(B) Unique values can be provided by distinct clause
(C) To display not-null values is not will be provided in where clause

[12] In which of the network topologies do all devices connect to a central point, such as a switch or hub?
(A) Star
(B) Bus
(C) Tree
(D) Mesh

Ans.: (A) Star
(B) In Bus topology, all devices are connected to a single cable
(C) In Tree topology all devices are connected to root node and forms a tree structure
(D) Mesh topology all devices are connected to each and every device

[13] In a Pandas DataFrame, if the tail() function is used without specifying the optional argument indicating the number of rows to display, what is the default number of rows displayed, considering the DataFrame has 10 entries?
(A) 0
(B) 1
(C) 4
(D) 5

Ans.: (D) 5
tail() function displays 5 rows from bottom

[14] Identify the type of cybercrime that involves sending fraudulent emails to deceive individuals into revealing sensitive information.
(A) Hacking
(B) Phishing
(C) Cyberbullying
(D) Cyberstalking

Ans.: (B) Phishing
(A) Hacking is the act of unauthorised access to a computer, computer network or any digital system.
(C) Any insulting, degrading or intimidating online behaviour like repeated posting of rumours, giving threats online, posting the victim’s personal information, sexual harassment or comments aimed to publicly
ridicule a victim is termed as cyber bullying.

[15] While creating a Series using a dictionary, the keys of the dictionary become:
(A) Values of the Series

(B) Indices of the Series
(C) Data type of the Series
(D) Name of the Series

Ans.: (B) Indices of the Series
(A) Dictionary Values becomes the values of series
(C) Data type of the series depends on values of dictionaries
(D) Names of the series will be given after using name attribute

[16] Match the following SQL functions/clauses with their descriptions:

(A) P-2, Q-4, R-3, S-1
(B) P-2, Q-4, R-1, S-3
(C) P-4, Q-3, R-2, S-1
(D) P-4, Q-2, R-1, S-3

Ans.: (B) P-2, Q-4, R-1, S-3

[17] Fill in the Blank: Boolean indexing in Pandas DataFrame can be used for _____________
(A) Creating a new DataFrame
(B) Sorting data based on index labels
(C) Joining data using labels
(D) Filtering data based on condition

Ans.: (D) Filtering data based on Condition
Rest are invalid options

[18] Which Matplotlib plot is best suited to represent changes in data over time?
(A) Bar plot
(B) Histogram
(C) Line plot
(D) Histogram & Bar plot

Ans.: (C) Line Plot
(A) Bar plot is best suite to compare data of between groups, displaying distribution of data points or track changes over the time
(B) Histogram is best suited for displaying the distribution of numerical data
(D) Histogram & Bar plot are best suited for the distribution of numerical data

[19] Which type of network covers a small geographical area like a single office, building, or school campus?
(A) PAN
(B) MAN
(C) LAN
(D) WAN

Ans.: (C) LAN
(A) An individual shares data using Bluetooth or any other media from his PDAs
(B) MAN covers a city or multiple cities or large area within a city
(D) WAN covers a global area overs countries or continents

Q-20 and Q-21 are Assertion (A) and Reason (R) Type questions. Choose the correct option as:

(A) Both Assertion (A) and Reason (R) are true, and Reason (R) is the correct explanation of Assertion (A)
(B) Both Assertion (A) and Reason (R) are true, but Reason (R) is not the correct explanation of Assertion (A)

(C) Assertion (A) is True, but Reason (R) is False
(D) Assertion (A) is False, but Reason (R) is True

[20] Assertion (A): We can add a new column in an existing DataFrame.
Reason (R): DataFrames are size mutable.

Ans.: (A) Both Assertion (A) and Reason (R) are true, and Reason (R) is the correct explanation for Assertion (A)

[21] Assertion (A): In SQL, INSERT INTO is a Data Definition Language (DDL) Command.
Reason (R): DDL commands are used to create, modify, or remove database structures, such as tables.

Ans.: (D) A is False, R is True

Section B – CBSE Class 12 Informatics Practices 2024-25 Sample Paper

[22] (A) What is a Series in Python Pandas? Also, give a suitable example to support your answer.

OR

(B) What does the term ‘library’ signify in Python? Mention one use for each of the following libraries:

1. Matplotlib
2. Pandas

[23] What are intellectual property rights (IPR), and why are they important in the digital world?

Ans.: Intellectual Property Rights (IPR) protects the creations of the human which are artistic, literary or any technical.
Importance:
IPR helps to protect and prevent unauthorized use or reproduction of digital content and ensure that creators are fairly compensated and incentivised for their original work.
1 mark for correct definition
1 mark for correct importance

[24] Consider the string: “Database Management System”. Write suitable SQL queries for the following:

1. To extract and display “Manage” from the string.
2. Display the position of the first occurrence of “base” in the given string.

[25] (A) What is Internet and how does it differ from World Wide Web (WWW)?

Internet is a public network provides the vast services of communication and data exchange.

OR

(B) Explain the concept of browser cookies and mention one advantage of using them.

Ans.:
Cookies are small text files which keep track of basic information about websites visited by user and improve user experience by remembering them. It offers following advantages:
1. Remembering Preferences
2. Track input details on websites (Auto Complete)
3. Count Visitors of a webpage and clicks
4. Remember users login information
5. Provide relevant content
1 mark for definition
1 mark for advantage

[26] Define the term Primary Key in a database. Explain how it is different from a Candidate Key.

Ans.: A primary key is a field or attribute or column of table that identifies each row uniquely. It does not have any duplicate values and does not have null values.
Candidate key is a filed(s) contains unique data and eligible to be a primary key. Every table has only one primary key where as multiple candidate keys.
1 mark for definition
1 mark for difference

Watch this video for more understanding about keys in SQL:

[27] Mention two health concerns associated with excessive use of Digital Devices.

Ans.:
1. Physical Injuries – Repetitive motions like typing, texting can cause hand pain, trigger finger and carpal tunnel syndrome. Sitting long hours can also causes neck pain, shoulder pain or back pain.
2. Eye Strain – Looking at screen constantly cause dry eyes, headaches, blurred vision, and red eye problem.
3. Sleeping Disorder – Working long hours on computers cab disturb the sleeping pattern.
4. Obesity – Sitting at one place can cause obesity and make lees physically active
5. Mental Health – More screen time can lead to depression, anxiety and mental health
6. Hearing Loss – Long hours use of headphones or earphones or earbuds leads to hearing issues
7. ADHD – Longer screen time lead to ADHD symptoms
1 mark for 1 correct health concern, write any two

[28] [A] Sneha is writing a Python program to create a DataFrame using a list of dictionaries. However, her code contains some mistakes. Identify the errors, rewrite the correct code, and underline the corrections made.

import Pandas as pd 
D1 = {'Name': 'Rakshit', 'Age': 25} 
D2 = {'Name': 'Paul', 'Age': 30} 
D3 = {'Name': 'Ayesha", 'Age': 28} 
data = [D1,D2,D3) 
df = pd.Dataframe(data) 
print(df)

import pandas as pd 
D1 = {'Name': 'Rakshit', 'Age': 25} 
D2 = {'Name': 'Paul', 'Age': 30} 
D3 = {'Name': 'Ayesha', 'Age': 28} 
data = [D1,D2,D3] 
df = pd.DataFrame(data) 
print(df)

OR

[B] Complete the given Python code to get the required output (ignore the dtype attribute) as Output:

Output

Code:

import __________ as pd
data = ['Chennai','____________','Imphal']
indx = ['Tamil Nadu','Uttar Pradesh','Manipur']
s = pd.Series(__________, indx)
print(_____________)

import pandas as pd
data = ['Chennai','Lucknow','Imphal']
indx = ['Tamil Nadu','Uttar Pradesh','Manipur']
s = pd.Series(data, indx)
print(s)

Section C – CBSE Class 12 Informatics Practices 2024-25 Sample Paper

[29] Ayesha’s family is replacing their old computer with a new one. They decide to throw the old computer in a nearby empty field/plot.
I. Explain any one potential environmental hazard associated with improper e-waste disposal.
II. Suggest one responsible way to Ayesha’s family for proper disposal of their old computer.
III. Describe the importance of recycling in e-waste management.

[30] (A) Write a Python program to create the following DataFrame using a list of dictionaries.

import pandas as pd
d1={'Product':'Laptop','Price':60000}
d2={'Product':'Desktop','Price':45000}
d3={'Product':'Monitor','Price':15000}
d4={'Product':'Tablet','Price':30000}
l=[d1,d2,d3,d4]
df=pd.DataFrame(l)
print(df)

[B] Write a Python Program to create a Pandas Series as shown below using a dictionary. Note that the left column indicates the indices and the right column displays the data.

import pandas as pd
d={'Russia':'Moscow','Hungary':'Budapest','Switzerland':'Bern'}
df=pd.Series(d)
print(s)

[31] I. Write an SQL statement to create a table named STUDENTS, with the following specifications:

CREATE TABLE STUDENTS (
StudentID NUMERIC PRIMARY KEY,
FirstName VARCHAR(20),
LastName VARCHAR(10),
DateOfBirth DATE,
Percentage FLOAT(10,2)
);

II. Write SQL Query to insert the following data in the Students Table: 1, Supriya, Singh, 2010-08-18, 75.5

insert into student values (1, 'Supriya', 'Singh', '2010-08-18', 75.5);

[32] (A) Consider the following table:

Table 1:
EMPLOYEE which stores Employee ID (EMP_ID), Employee Name (EMP_NAME), Employee City (EMP_CITY)
Table 2:
PAYROLL which stores Employee ID (EMP_ID), Department (DEPARTMENT), Designation (DESIGNATION), and Salary (SALARY) for various employees.
Note: Attribute names are written within brackets.

Table: EMPLOYEE

Table: PAYROLL

Write appropriate SQL queries for the following:
I. Display department-wise average Salary.
II. List all designations in the decreasing order of Salary.
III. Display employee name along with their corresponding departments.

Ans.:
I. select department, avg(salary) from payroll;
II. SELECT DESIGNATION FROM PAYROLL ORDER BY SALARY DESC;
III.SELECT EMP_NAME, DEPARTMENT FROM EMPLOYEE E, PAYROLL P WHERE E.EMP_ID=P.EMP_ID;
OR
select emp-name, department from employee natural join payroll;
(1 mark for each correct query)

OR

(B) Consider the following tables:
Table 1:
ATHLETE, which stores AthleteID, Name, Country. The table displays basic information of the athletes
Table 2:
MEDALS, which stores AthleteID, Sport, and Medals. The table displays the number of medals won by each athlete in their respective sports.
Table: ATHLETE

Table: MEDALS

Write appropriate SQL queries for the following:

I. Display the sports-wise total number of medals won.
II. Display the names of all the Indian athletes in uppercase.
III. Display the athlete name along with their corresponding sports

Ans.:
I. SELECT SPORT,SUM(Medals) FROM MEDALS GROUP BY SPORT;
II. SELECT UPPER(Name) FROM ATHLETE WHERE COUNTRY = ‘INDIA’;
III. SELECT NAME, SPORT FROM ATHLETE A, MEDALS M WHERE A.AthleteID= M.AthleteID;
(1 mark for each correct query)

[33] During a practical exam, a student Ankita has to fill in the blanks in a Python program that generates a bar chart. This bar chart represents the number of books read by four students in one month.

Help Ankita to complete the code.

import _____ as plt #Statement-1 
students = ['Karan', 'Lina', 'Raj', 'Simran'] 
books_read = [12, 9, 5, 3] 
plt.bar( students, _____, label="Books Read") #Statement-2 
plt.xlabel('Student Name') 
plt._____('Books Read') #Statement-3 
plt.legend() 
plt.title('_____') #Statement-4 
plt.show()

Ans.:
I. matplotlib.pyplot
II. books_read
III. ylabel
IV. Number of Books Read by Students
(1 mark for each correct query)

[34] [A] Rahul, who works as a database designer, has developed a database for a bookshop. This database includes a table BOOK whose column (attribute) names are mentioned below:

• BCODE: Shows the unique code for each book.

• TITLE: Indicates the book’s title.
• AUTHOR: Specifies the author’s name.
• PRICE: Lists the cost of the book.

Table: BOOK

I. Write SQL query to display book titles in lowercase.
II. Write SQL query to display the highest price among the books.
III. rite SQL query to display the number of characters in each book title.
IV. Write SQL query to display the Book Code and Price sorted by Price in descending order.

Ans.:
I. SELECT LOWER(TITLE) FROM BOOK; OR select lcase(title) from book;
II. SELECT MAX(PRICE) FROM BOOK;
III. SELECT LENGTH(TITLE) FROM BOOK;
IV. SELECT BCODE, PRICE FROM BOOK ORDER BY PRICE DESC;
(1 mark for each correct answer)

OR

[B] Dr. Kavita has created a database for a hospital’s pharmacy. The database includes a table named MEDICINE whose column (attribute) names are mentioned below:

• MID: Shows the unique code for each medicine.
• MED_NAME: Specifies the medicine name
• SUPP_CITY: Specifies the city where the supplier is located.
• STOCK: Indicates the quantity of medicine available.
• DEL_DATE: Specifies the date when the medicine was delivered.

Table: MEDICINE

Write the output of the following SQL Queries.
I. Select LENGTH(MED_NAME) from MEDICINE where STOCK > 100;
II. Select MED_NAME from MEDICINE where month(DEL_DATE) = 4;
III. Select MED_NAME from MEDICINE where STOCK between 120 and 200;
IV. Select max(DEL_DATE) from MEDICINE;

SECTION E – CBSE Class 12 Informatics Practices 2024-25 Sample Paper

[35] ABC Pvt. Ltd., a multinational technology company, is looking to establish its Indian Head Office in Bengaluru, and a regional office branch in Lucknow. The Bengaluru head office will be organized into four departments: HR, FINANCE, TECHNICAL, AND SUPPORT. As a network engineer, you have to propose solutions for various queries listed from I to V.

The shortest distances between the departments/offices are as follows:

The number of computers in each department/office is as follows:

I. Suggest the most suitable department in the Bengaluru Office Setup, to install the server. Also, give a reason to justify your suggested location.
II. Draw a suitable cable layout of wired network connectivity between the departments in the Bengaluru Office.
III. Which networking device would you suggest the company to purchase to interconnect all the computers within a department in Bengaluru Office?
IV. The company is considering establishing a network connection between its Bengaluru Head Office and Lucknow regional office. Whichtype of network—LAN, MAN, or WAN—will be created? Justify your answer.
V. The company plans to develop an interactive website that will enable its employees to monitor their performance after login. Would you recommend a static or dynamic website, and why?

ANSWER:

I. The server should be installed in the HR department as it has the most number of computers.
II. Star topology

III. Switch/Hub
IV. WAN (Wide Area Network) will be created as the offices are located in different cities.
V. A dynamic website is recommended as it can display the dynamic performance data (which differs from employee to employee) of each employee.
(1 mark for each correct answer)

[36] Consider the DataFrame df shown below.

Write Python statements for the DataFrame df to:

I. Print the first two rows of the DataFrame df.
II. Display titles of all the movies.
III. Remove the column rating.
IV. Display the data of the ‘Title’ column from indexes 2 to 4 (both included)
V. Rename the column name ‘Title’ to ‘Name’.

Ans.:
I. print(df.head(2)) or print(df[:2]) or print(df.loc[:1]) or print(df.iloc[:2])
II. print(df.Title) or print(df[‘Title’]) or print(df.loc[:,’Title’]) or print(df.iloc[:,1])
III. df=df.drop(‘Rating’,axis=1) or del df[‘Rating’] or df=df.drop(columns=’Rating’)
IV. print(df.loc[2:4,’Title’]) or print(df.Title[2:]) or print(df.iloc[2:5,1])
V. df.rename(columns={‘Title’:’Name’}, inplace=True)
(1 mark for each correct answer)

[37] (A) Write suitable SQL query for the following:

I. To display the average score from the test_results column (attribute) in the Exams table
II. To display the last three characters of the registration_number column (attribute) in the Vehicles table. (Note: The registration numbers are stored in the format DL-01-AV-1234)
III. To display the data from the column (attribute) username in the Users table, after eliminating any leading and trailing spaces.
IV. To display the maximum value in the salary column (attribute) of the Employees table.
V. To determine the count of rows in the Suppliers table.

Ans.:
I. SELECT AVG(test_results) FROM Exams;
II. SELECT RIGHT(registration_number, 3) FROM Vehicles;
III. SELECT TRIM(username) FROM Users;
IV. SELECT MAX(salary) FROM Employees;
V. SELECT COUNT(*) FROM Suppliers;
(1 mark for each correct query)

OR

Write suitable SQL query for the following:
I. Round the value of pi (3.14159) to two decimal places.

II. Calculate the remainder when 125 is divided by 8.
III. Display the number of characters in the word ‘NewDelhi’.
IV. Display the first 5 characters from the word ‘Informatics Practices’.
V. Display details from ’email’ column (attribute), in the ‘Students’ table, after removing any leading and trailing spaces.

Ans.:
I. SELECT ROUND(3.14159, 2);
II. SELECT MOD(125, 8);
III. SELECT LENGTH(‘NewDelhi’);
IV. SELECT LEFT(‘Informatics Practices’, 5);
V. SELECT TRIM(email) FROM Students;
(1 mark for each correct query)

Download CBSE Class 12 Informatics Practices 2024-25 Sample Paper from CBSE website: