KENDRIYA VIDYALAYA SANGATHAN, CHANDIGARH REGION 2022-23

PREBOARD-I
CLASS - XII
INFORMATICS PRACTICES(065)
MARKING SCHEME

Q.NO ANSWER Marks

SECTION-A (1 MARKS)
1 a. LAN 1
1 mark for correct answer
2 c. digital property 1
1 mark for correct answer
3 a Copyright 1
1 mark for correct answer
4 c3 1
1 mark for correct answer
5 c. 190 1
1 mark for correct answer
6 d. Pharming 1
1 mark for correct answer
7 c option (i) & (iv) 1
1 mark for correct answer
8 a. Text function 1
1 mark for correct answer
9 c 61 1
1 mark for correct answer
10 c. print (p_series.tail(4)) 1
1 mark for correct answer
11 d. plt.title() 1
1 mark for the correct answer
12 D shape 1
1 mark for correct answer
13 d. repeater 1
14 d. Now( ) 1
1 mark for correct answer
15 c Plagiarism 1
1 mark for correct answer
16 d. Phishing 1
1 mark for correct answer
17 a. Both A and R are true and R is the correct explanation for A 1
1 mark for correct answer
18 c A is True but R is False 1
1 mark for correct answer
SECTION-B (2 MARKS)
19 (i) Cyber bullying: It is the act of intimidating, threatening, or coercing people online 2
through the use of social media, email, text messages, blog posts, or other digital or
electronic methods.
(ii) Cyber Stalking: It is the act of using the internet to consistently threaten
somebody. This crime is often perpetrated through email, social media, and the
other online medium.
OR
a. SMTP: Simple Mail Transfer Protocol
b. POP: Point to Point Protocol
c. FTP: File Transfer Protocol
d. VoIP: Voice over Internet Protocol
½ marks for each correct full form

20 The problem with the given SQL query is that group by clause is missing in the query. 2
Corrected Query:
SELECT DEPT, MAX(SALARY) FROM EMPLOYEE GROUP BY DEPT;
21 The order by clause is used to show the contents of a table/relation in a sorted manner with 2
respect to the column mentioned after the order by clause. The contents of the column can be
arranged in ascending or descending order.
The group by clause is used to group rows in a given column and then apply an aggregate
function e.g. max(), min() etc. on the entire group.
(any other relevant answer)
22. St={‘Science’ :27, ‘arts’ :38 , ‘commerce’:42} 2
S1=pd.Series(St)
1 mark for each correct python statement
23. The e-waste management- 2
i. Saves the environment and natural resources
 ii. Allows for recovery of precious metals
iii. Protects public health and water quality
iv. Saves landfill space
½ mark for each benefit
OR
Intellectual property rights are the rights given to persons over the creations of their minds like
creativity concepts, inventions, industrial models, trademarks, songs, literature, symbols, names,
brands,....etc. They also entitle him/her to prevent others from using, dealing or tampering with
his/her product without prior permission from him/her.
It should be protected since:
1. New innovations in all IPR domains lead to Human progress and advancement.
2. Legal protection of new innovations encourages safe spending on other innovations.
3. Caring for and protecting IPR contribute to achieving economic and social development.
24 a. [10,20,10,20] – Replication 2
b. [20,40] - Multiplication
25 i. Shape of Dataframe is (4,3) 2
ii. Name of index are: 0,1,2,3 and column names are: ID, Name, Marks
1 mark for each correct statement
SECTION-C (3 MARKS)
26 (a) 3
Avg(exp)
9
(b)
Id Name Doj Dept Gen Exp
der
6 Danish 11-09-2013 Personnel M 8
(c)
Name
AMAN
CHRISTINA
SHEM

(1 mark for each correct output)

27 import pandas as pd ½ mark
D={'Arnab':[90,91,97],'Ramit':[92,81,96],'Samridhi':[89,91,88] } 1 mark
Df=pd.DataFrame(D,index=['Maths','Science','Hindi']) 1 mark
print(Df) ½
mark
28 a. Column3 Res 3
T1 60.00 True
T2 59.22 True
 T3 46.04 False
T4 58.62 False
b. Column1 Column2 Column3
T3 49.090140 100.0 46.04
T4 38.487265 85.4 58.62
c. Column3
T2 59.22
T3 46.04
1 mark for each correct output.
29 Identity theft is the crime of obtaining the personal or financial information of another person 3
for the sole purpose of assuming that person's name or identity to make transactions or use it to
post inappropriate remarks, comments etc.
Example:
Alex likes to do his homework late at night. He uses the Internet a lot and also sends useful
data through email to many of his friends. One Day he forgot to sign out from his email
account. In the morning, his twin brother, Flex started using the computer. He used Flex’s
email account to send inappropriate messages to his contacts
Or any other relevant example
1 ½ mark for explaining Identity theft
1 ½ mark for suitable example
OR
Net Etiquettes refers to the proper manners and behavior we need to exhibit while being online.
These include :
1. No copyright violation: we should not use copyrighted materials without the permission
of the creator or owner. We should give proper credit to owners/creators of open source
content when using them.
2. Avoid cyber bullying: Avoid any insulting, degrading or intimidating online
behavior like repeated
posting of rumours, giving threats online,
posting the victim’s personal information,
or comments aimed to publicly ridicule a victim. Or any other relevant
answer.
1 ½ marks for definitions of Net Etiquettes
 1 ½ mark each for the example with explanation

30 a) Select substr(description,1,3) from cloth; 3

b) select fabric , count(*) from cloth group by fabric;
c) select fabric , avg(price) from cloth group by fabric;
OR
GROUP BY clause is used in a SELECT statement in combination with aggregate functions to
group the result based on distinct values in a column.
For example:
To display total number of formal shirt and frock Description from the table CLOTH, we need to
first group records based on the description then we should count records with the help of
count() function.
1 Mark for each correct answer
SECTION-D(5 MARKS)
31 i. select substr("Computer Lab", 3, 4); 5
ii. Select round(2.372,1);
iii. Select dayname(now()) ;
iv. Select trim(" Python is Dangerous ");
v. Select mod(37,10);
OR
i. Return the string after removing leading spaces from the string.
ii. Return the string in Capital letters
iii. Return the value after calculating m to the power n
iv. Return the rightmost number of characters as specified
v. Return the number of the month like 3 for ‘march’
1 Mark for each correct answer
32 a) Administrative Office 5
b)

c) Switch

d) STAR and Ethernet Cable

e) LAN
33 import matplotlib.pyplot as plt 5
sub=['ENGLISH','ACCOUNTS','BST','ECONOMICS','IP']
per=[85,98,70,82,100]
plt.bar(sub,per,color='green', align='center') #1 mark
plt.xlabel("SUBJECT")
plt.ylabel("PERCENTAGE")
plt.title("SUBJECTWISE RESULT ANALYSIS")
plt.show()
plt.savefig(‘Result.png’)
OR
import matplotlib.pyplot as plt
import numpy as np
programming_languages=['Python', 'Java', 'PHP', 'JavaScript']
popularity=[8.6, 8, 7.8, 6.4]
plt.bar(programming_languages,popularity)
plt.xlabel('Programming_languages', fontsize=10)
plt.ylabel('Popularity', fontsize=10)
plt.title('Programming language Popularity')
plt.show()

Correct program 5 marks

34 i. Select color, count(*) from cloths where color =’green’; 1+1+2
ii. Select cname, dayname(dob) from cloth;
iii. Select sum(Price),size from cloth Group by size ;
OR
Select cname from cloth where month(dop) = 11 and price < 1200
35 A. (a) 1+1+2

(b)

B. print(df.loc[ 'Tuesday': 'Thursday', 'No_of_classes'])

OR
print("Total Attendance in a day:")
print(df['Atten'] * df['No_of_classes'])

************ End of Marking Scheme ********************