XII IP CBSE SAMPLE PAPER BLUEPRINT 2024-25

SECTIONS TOTAL QUES [Link] MARKS TOTAL MARKS

SECTION A 21 1-21 1 21
SECTION B 07 22-28 2 14
SECTION C 04 29-32 3 12
SECTION D 02 33-34 4 08
SECTION E 03 35-37 5 15
37 70

SECTIONS A B C D E
Unit 1: Data Handling using Pandas -I
Introduction to Python libraries- Pandas, Matplotlib. Data 22(b)
structures in Pandas
Series: 22(a)
1,15
28(b)
Data Frames: 6,13,17, 28(a) 30(a) 36
20 30(b)
Importing/Exporting Data between CSV files and Data
9
Frames.
Data Visualization 7,18 33
Unit 2: Database Query using SQL
Revision of database concepts and SQL commands covered 2,4,21 26 31 34(a)
in class XI 34(b)
Math functions: 37(a)
Text functions: 16 24 37(b)
Date Functions:
Aggregate Functions: 11 32
Group by, Having, Order by 8 32
Equi-Join 32
Unit 3: Introduction to Computer Networks
Introduction to networks, Types of network: PAN,LAN, 35
19
MAN, WAN.
Network Devices: modem, hub, switch, repeater, router,
3
gateway
Network Topologies: Star, Bus, Tree, Mesh. 12
Introduction to Internet, URL, WWW, and its applications- 25(a)
Web, email, Chat, VoIP.
Website:
Web Browsers: 25(b)
Unit 4: Societal Impacts
Digital footprint, net and communication etiquettes, data 23
protection, intellectual property rights (IPR), plagiarism,
licensing and copyright, free and open-source software 10,14
(FOSS), cybercrime and cyber laws, hacking, phishing, cyber
bullying, overview of Indian IT Act.
E-waste: hazards and management. 27 29
Awareness about health concerns related to the usage of 5
technology.
NUMBER OF QUESTION 21 7 4 2 3
TOTAL MARKS 21 14 12 08 15
 QUESTION PAPER PATTERNS FOR BOARD EXAM 2025
Class: XII Informatics Practices (065)
Time: 3 Hours Marks: 70
__________________________________________________________________________
General Instructions:
● Please check this question paper contains 37 questions.
● All questions are compulsory. However, internal choices have been provided in some questions. Attempt one
● 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 case of MCQ, text of the correct answer should also be written.

Q No. Marks
Section-A (21 x 1 = 21 Marks)
1 True or False based on Series 1
2 SQL MCQ (condition) 1
3 Network device MCQ 1
4 DDL based MCQ 1
5 e-Waste based MCQ 1
6 DataFrame Column based MCQ 1
7 Matplotlib MCQ 1
8 True False based on having/group by 1
9 CSV DataFrame MCQ 1
10 Plagiarism MCQ 1
11 Count(*) Fill in the Blank MCQ 1
12 Topologies MCQ 1
13 DataFrame(Head/Tail) MCQ 1
14 Cybercrime MCQ 1
15 Series MCQ 1
16 SQL functions cross mapping MCQ 1
17 Boolean Indexing DataFrame Fill in the blank MCQ 1
18 Plotting based MCQ 1
19 Type of Network based MCQ 1
Q20 and Q21 are Assertion(A) and Reason(R) based questions. Mark the correct choice
as:
(A) Both A and R are true and R is the correct explanation for A
(B) Both A and R are true and R is not the correct explanation for A
(C) A is True but R is False
(D) A is False but R is True
20 Dataframe based 1
21 DDL based

Q No. Marks
Section-B ( 7 x 2=14 Marks)
22 (A) Question on Series 2
OR
(B) Question on python libraries matplotlib/pandas
23 Question based on IPR, Plagiarism, Copyright etc 2
24 Question based on 02 string functions (a sample string to be given) 2
(i)
(ii)
25 (A)Question based on Website 2
OR
(B)Question based on Web browser
26 Question based on Keys & their differences 2
27 Question based on E-waste health concern 2
28 (A) Correct code of creating dataframe using list of dictionaries 2
OR
(B) Complete the code based on creating Series

Q No. Marks
Section-C ( 4 x 3 = 12 Marks)
29 Question based on E-waste 3
(i)
(ii)
(iii)
30 (A) Create dataframe using list of dictionaries 3
OR
(B) Create a Series using Dictionary
31 (i) Create a table with specified columns/datatypes/constraints 3
(ii) Write query to insert a record (sample data)
32 (A)Question based on 2 tables 3
(i) query based on aggregate function
(ii) query based on orderby
(iii) Query based on two tables
OR
(B)
(i) query based on aggregate function
(ii) Query based on text function
(iii) Query based on two tables

Q Marks
Section-D ( 2 x 4 = 08 Marks)
No.
33 Bar chart questions, sample chart and code provided (fill in the blanks) 4
(i)
(ii)
(iii)
(iv)
34 (A)SQL table-based questions to write queries 4
(i) lower
(ii)max
(iii)length
(iv)orderby
OR
(B) SQL table-based questions to predict output
(i) length
(ii)month
(iii)between
(iv)max
 Q Marks
Section-E ( 3 x 5 = 15 Marks)
No.
35 Networking question 5
(i) Server
(ii) Cable layout
(iii) Hub/Switch
(iv) PAN/LAN/MAN/WAN
(v) Web service
36 Data frame question 5
(i) based on showing rows
(ii) based on showing column
(iii) remove column
(iv) Based on column with some rows
(v) rename column
37 A Write suitable query for the following 5
(i) based on aggregate function
(ii) based on text function
(iii) based on text function
(iv) based on aggregate function
(v) based on aggregate function
OR
B Write suitable query for the following
(i) based on math function
(ii) based on math function
(iii) based on text function
(iv) based on text function
(v) based on text function