Class 12 IP Sample Paper 2024-25 with Solutions, Download PDF

The Central Board of Secondary Education has released the Class 12 IP Sample Paper 2024-25 with Solutions on its academic portal. Practice Class 12 Informatics Practices Sample Paper 2024-25 CBSE Board assists students in achieving high scores on the CBSE 12th Informatics Practices Board Examination. Students studying for the CBSE 12th Informatics Practices Exam are recommended to download and practice the previous year’s as well as CBSE’s Class 12 IP Sample Paper 2024-25 numerous times in order to become familiar with the exam pattern.

Class 12 IP Sample Paper 2024-25 with Solutions

The CBSE Class 12 Informatics Practices curriculum teaches students computer science and information technology fundamentals. It covers the fundamentals of programming languages such as Python and emphasizes problem-solving abilities through discussions of data types, variables, operators, and control structures. As this subject differs slightly from our traditional subjects, students may be confused about the types of questions that will be asked in the board exam.

In this scenario, the Class 12 IP Sample Paper 2024-25 with Solutions comes to play its crucial role. These Class 12 Informatics Practices Sample Paper 2024-25 show the types of questions you can expect on the exam, the difficulty level of the Informatics Practices exam, the number of MCQ or subjective questions, and the key chapters and questions to focus on for the Class 12 Informatics Practices exam.

CBSE Class 12 IP Sample Paper 2024-25 with Solutions PDF Download

The CBSE Class 12 Informatics Practices Sample Paper 2024-25 in the form of Pdf on the official website at https://cbseacademic.nic.in/. Along with that, the board has released the marking scheme so that students can understand the method of scoring pattern. Students may download the Class 12 IP Sample Paper 2024-25 with Solutions Pdf by referring to the table below.

Class 12 Informatics Practices Question Paper Pattern

Before analyzing the sample paper of the class 12 Informatics Practices students are recommended to go through the general instructions listed below,

• Time allowed: 3 Hours
• Maximum Marks:70
• his question paper contains 37 questions.
• All questions are compulsory. However, internal choices have been provided in some questions. Attempt only one of the choices in such questions
• The paper is divided into 5 Sections- A, B, C, D and E.
• Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
• Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
• Section C consists of 4 questions (29 to 32). Each question carries 3 Marks.
• Section D consists of 2 case study-type questions (33 to 34). Each question carries 4 Marks.
• Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
• All programming questions are to be answered using Python Language only.
• In the case of MCQ, the text of the correct answer should also be written.

Class 12 Informatics Practices Sample Paper 2024-25

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

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

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

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

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

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)

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

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

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’)

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.

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

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

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

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

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

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

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

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

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

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.

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.

Section-B (7 x 2 = 14 Marks) Marks

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:
• Pandas
• Matplotlib

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

24 Consider the string: “Database Management System”. Write suitable SQL queries for the following:
I. To extract and display “Manage” from the string.
II. 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)?
OR
(B) Explain the concept of browser cookies and mention one advantage of using them.

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

27 Mention two health concerns associated with excessive use of Digital Devices. 2
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

OR
(B)  Complete the given Python code to get the required output (ignore the type attribute) as
Output:
Tamil Nadu   Chennai
Uttar Pradesh  Lucknow
Manipur   Imphal

Informatics Practices Class 12 Sample Paper 2024-25

Section-C (4 x 3 = 12 Marks) Marks

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 Data Frame using a list of dictionaries.

OR

(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.

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

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

32 (A) Consider the following tables:
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

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.

OR

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.

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

Sharing is caring!