SET-I

KENDRIYA VIDYALAYA SANGATHAN : BHUBANESWAR REGION

PRE-BOARD EXAMINATION 2022-23 CLASS XII INFORMATICS PRACTICES (065)
TIME: 3 HOURS M.M.70 MARKING SCHEME
Q SECTION-A Marks

1. Which device is used to regenerate the signals over long distance data transmission: 1
i. Switch
ii. Modem
iii. Repeater
iv. None of the above
Answer: (iii) Repeater , 1 mark for correct answer
2. Whenever we surf the Internet using smartphones we leave a trail of data reflecting the 1
activities performed by us online, which is our ?
i. Data print
ii. Digital activity
iii. Digital footprint
iv. Digital print
Answer: (iii) Digital Footprint, 1 mark for correct answer
3. Unsolicited commercial emails is known as …………..? 1
i. Spam
ii. Malware
iii. Virus
iv. Worms
Ans (i) , Spam 1 mark for correct answer

4. Find the output for the below sql statement: 1

Select substr(“BoardExam@2021”, 4, 7);
i. ardExam
ii. dExam@2
iii. rdExam
iv. rdExam@2
Answer: (iv) 1 mark for correct answer
5 What is the output of following : 1
Select Round(19999.299,-1);
i. 199999.3
ii. 20000.299
iii. 2000
iv. 20000
Answer :( iv) 1 mark for correct answer
6. Which of the following is Net Etiquette? 1
i. Be Ethical
ii. Be Responsible
iii. Be Respectful
iv. All of the above
Answer (iv) All of the above, 1 mark for correct answer
7. Which keyword is used to arrange the result of order by clause in descending order? 1
i. DSEC
ii. ASCE
iii. DESC
iv. ASC
Answer: (iii) DESC, 1 mark for correct answer

8. Which one of the following is a string function? 1

i. COUNT()
ii. SUBSTR()
iii. MOD()
iv. MAX()
Answer (ii) SUBSTR(), 1 mark for correct answer
9. Which one of the following functions is used to count the no of rows from the given table in MySQL? 1
i. COUNT(* )
ii. CARDINALITY( )
iii. COUNT(Column name )
iv. All the above
Answer: (i) COUNT(*), 1 mark for correct answer

10. To display First 15 rows of a series object ‘Ser1’, you may write: 1
i. Ser1.tail(15)
ii. Ser1.head()
iii. Ser1.head(15)
iv. Ser1.tail()
Answer : (iii) Ser1.head(15) , 1 mark for correct answer
11. Which of the following statement will install pandas library in python? 1
i. Pip install pandaspd
ii. pip install pandas as pd
iii. pip install pandas.pd
iv. pip install pandas
Answer: ( iv) pip install pandas, 1 mark for correct answer
12 Which protocol allow us to have voice calls over the internet? 1
i. HTTP
ii. VoIP
iii. Video Chat
iv. SMTP
Answer: (ii) VoIP , 1 mark for correct answer.
13 Which one is False about MAC address? 1
i. It is Physical Address of any device connected to the internet.
ii. We can change MAC address of a device.
iii. It is the address of NIC card install in network device.
iv. It is used for track the user’s over internet.
Answer: (ii) 1 mark for correct answer.
14 Which one of the following is an output for SQL statement given below: 1
SELECT DAYNAME('2022-12-07');
i. MONDAY
ii. WEDNESDAY
iii. SATURDAY
iv. FRIDAY
Answer: (ii) WEDNESDAY, 1 mark for the correct answer
15 The act of fraudulently acquiring someone’s personal and private information, such as online account names, 1
login information and passwordsis called as_____.
i. Phishing
ii. Identity Theft
iii. Plagiarism
iv. all the above
Answer: (ii) Identity Theft. 1 mark for correct answer.
16 The method used for X axis label a line graph is 1
i. plt.title()
ii. plt.ylabel()
iii. plt.xlabel()
iv. plt.line()
Q17 and 18 are ASSERTION AND REASONING based questions. Mark the correct choice as
i. Both A and R are true and R is the correct explanation for A
ii. Both A and R are true and R is not the correct explanation for A
iii. A is True but R is False
iv. A is false but R is True
17 Assertion (A): - E-waste cause of Damage to the immune system, Skin disease, Multi ailments and 1
Skin problems.
Reasoning (R):- Mostly all electronic waste comprises of toxic chemicals such as lead,beryllium, mercury
etc.
Answer: ( i) 1 mark for correct answer

18 Assertion (A): - When DataFrame is created by using Dictionary, keys of dictionary are set as columns of DataFrame. 1
Reasoning (R):- Boolean Indexing helps us to select the data from the DataFrames using a boolean vector.

Answer:- (ii) 1 mark for correct answer

SECTION-B
19 Define any 2 limitations of star topology? 2

OR

Write any 2 differences between Star and Bus topology?

Answer:
1. Requires more cable length than a linear topology.
2. Dependency on central node: If the hub, switch, or concentrator fails, nodes attached are disabled.
3. More expensive than linear bus topologies because of the cost of the hubs, etc.
4. Requires more cable to setup the network .
2 mark for any 2 correct points or any other relevant points.

STAR Topology BUS Topology

Star topology is a topology in which all Bus topology is a topology where each device is
devices are connected to a central hub connected to a single cable which is known as the
backbone.

In star topology, if the central hub fails then In a Bus topology, the failure of the network cable
the whole network fails. will cause the whole network to fail.

2 mark for any 2 correct differences or other relevant difference

20 Anjali writes the following commands with respect to a table employee having fields, empno, name, 2
department, commission.
Command1 : Select count(*) from employee;
Command2: Select count(commission) from employee;
She gets the output as 4 for the first command but gets an output 3 for the second command. Explain the
output with justification.

Answer:
This is because the column commission contains a NULL value and the aggregate functions do not take into
account NULL values. Thus Command1 returns the total number of records in the table whereas
Command2 returns the total number of non
NULL values in the column commission.
21 What is the difference between the order by and group by clause when used along with the select 2
statement. Explain with an example.

Answer:
The order by clause is used to show the contents of a table/relation in a sorted manner with 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 eg max(),
min() etc on the entire group.
(any other relevant answer)
1 mark for correct explanation 1 mark for appropriate example
22 Consider a given Series , M1. Write a program in Python Pandas to create the series. 2
Marks
Term1 67
Index Term2 56
Term3 77
Term4 89
Answer:
import pandas as pd
M1=pd.Series([45,65,24,89],index=['term1','term2','t erm3','term4'])

½ mark for import statement

½ mark for usage of Series ()
½ mark for stating index as a list
½ mark for creating object m1
23 List any two health hazards related to excessive use of Technology. 2

OR

Priya is using her internet connection to book a train ticket. This is a classic example of
leaving a trail of web activities carried by her. What do we call this type of activity? What is the
risk involved by such kind of activity?

Answer:
The continuous use of devices like smartphones, computer desktop, laptops, head phones etc cause a lot of
health hazards if not addressed. These are:
i. Impact on bones and joints: wrong posture or long hours of sitting in an uncomfortable position can
cause muscle or bone injury.
ii. Impact on hearing: using headphones or earphones for a prolonged time and on high volume can cause
hearing problems and in severe cases hearing impairments.
iii. Impact on eyes: This is the most common form of health hazard as prolonged hours of screen time can
lead to extreme strain in the eyes.
 iv. Sleep problem: Bright light from computer devices block a hormone called melatonin which helps us
sleep. Thus we can experience sleep disorders leading to short sleep cycles.

2 marks for any two correct points

OR
We call this type of activity as Digital Footprints

Risk involved :
It includes websites we visit emails we send, and any information we submit online,
etc., along with the computer’s IP address, location, and other device specific details. Such data could be used
for targeted advertisement or could also be misused or exploited.

1 mark for naming the activity

1 mark for mentioning any one risk
24 Given two series S1 and S2 2
S1 S2
A 39 A 10
B 41 B 10
C 42 D 10
D 44 F 10
Find the output for following python pandas statements?
a. S1[ : 2]*100
b. S1 * S2

Answer:

a. A 3900
B 4100

b. A 390
B 410
C NaN
D 440
F NaN

1 mark for each correct output

25 Consider the following DataFrame, DF 2

Rollno Name Class Section CGPA

St1 1 Aman IX E 8.7
St2 2 Preeti X F 8.9
St3 3 Kartikey IX D 9.2
St4 4 Lakshay X A 9.4
Write commands to :
i. Add a new column ‘Stream’ to the Dataframe with values (Science, Commerce, Arts, Science.)
ii. Add a new row with values ( 5 , Mridula ,X, F , 9.8, Science)

Answer:
i. DF[‘Activity’]=[‘Science’,’Commerce ’,’Arts’, ‘Science’]
ii. DF.loc[‘St5’]=[1,’Mridula’, ‘X’, ‘F’, 9.8, ‘Science’]
1 mark for each correct answer.
SECTION -C

26 TABLE NAME : PHARMADB 3

 DrugID DrugName Manufacture Price PharmacyName Location
Date
5476 Amlodipine 2019-02-11 100.97 Rx Pharmacy Delhi
2345 Paracetamol 2011-05-07 150.25 Raj Medicos Haryana
1236 NebiStar 2021-06-02 160.27 MyChemist Delhi
6512 VitaPlus 2019-03-01 150.81 MyChemist Goa
5631 Levocitrezine 2018-04-12 110.23 RxPharmacy Mumbai
Based on the above table “PHARMADB”, Write outputs for SQL commands to i to iii:

i. SELECT SUBSTR(DrugName ,5,4) FROM PHARMADB WHERE PRICE>160;

ii. SELECT DRUGNAME FROM PHARMADB WHERE DAY(ManufactureDate)>10;
iii. SELECT ROUND ( Price, -1) FROM PURCHASE
WHERE Location= ‘Delhi’

Answer:
i. Star
ii. Amlodipine
Levocitrezine
iii. 100
200
1 mark for each correct output

27 Consider the following DataFrame “HOSPITAL” 3

City Hospitals schools
0 Delhi 189 7916
1 Mumbai 208 8508
2 Kolkata 149 7226
3 Chennai 157 7617

Write python pandas code to create the above dataframe HOSPITAL

Answer:
Import pandas as pd
d1={‘City':[‘Delhi’,’Mumbai’,’Kolkata’,’Chennai’],
'Hospital':[189,208,149,157],'Schools':[7916,8508,7226,7617]}
HOSPITAL=pd.DataFrame(d1)
print(df)

Answer:
½ mark for correct import statement
1 mark for correct dictionary
1 mark for correct use Dataframe method
½ mark for printstatement
28 DataFrame ‘STU_DF’: 3
rollno name marks
0 115 Pavni 97.5
1 236 Rishi 98.0
2 307 Preet 98.5
3 422 Paul 98.0
Perform the following operations on the DataFrame stuDF:
i. Add a new row in dataframe STU_DF with values [444,’karan’,88.0]
ii. Print no of rows and columns in dataframe STU_DF
iii. Delete row for rollno 307.

Answer:
i. STU_DF.loc[4,:]= [444,’karan’,88.0] or STU_DF.loc[4]= [444,’karan’,88.0]
ii. print(STU_DF.shape)
iii. STU_DF.drop(2, axis = 0)
1 marks for each correct statement.
29 3
Identify the type of cybercrime for the following situations:
i. A person complains that Rs. 4.25 lacs have been fraudulently stolen from his/her
account online via some online transactions in two days using NET BANKING.
 ii. A person complains that his/her debit/credit card is safe with him still somebody
has done shopping /ATM transaction on this card.
iii. A person complains that somebody has created a fake profile of Facebook and defaming his/her
character with abusive comments and pictures
OR
As a citizen of India, what advice you should give to others for e-waste disposal ? Define them
In details.

Answer:

i. Bank Fraud
ii. Identity Theft
iii. Cyber Stalking
1 mark for each correct type
OR

As a citizen of india , We can advice the following principle of waste management:

Reduce , Reuse and Recycle.
1 mark for each correct advice with explanation.
30 3
Consider the following sql table ‘automobile’

wheel- num-of- Dateofmanufacture

index company body-style base cylinders price
0 bmw sedan 101.234 four 16925 1998-03-27
1 bmw sedan 101.261 six 20970 1999-05-23
2 honda sedan 96.538 four 12945 2000-03-02
3 honda sedan 96.519 four 10345 2001-02-01
4 toyota hatchback 95.727 four 5348 1999-03-01
5 toyota hatchback 95.173 four 6338 2000-05-11

Write SQL queries using SQL functions to perform the following operations:
i. Display company name and body wheel base after rounding off to nearest ten’s decimal places.
ii. Display the position of occurrence of the string “dan” in body style.
iii. Display the year of manufacturing for sedan;
OR
Helps Abhay to Compare Having clause and Order by clause with the help of example?
Answer:
i. Select company, round(wheel-base,-1) from automobile;
½ mark each for correct usage of Select and round()

ii. Select instr(body-style,’dan’) from automobile;

½ mark each for correct usage of Select and instr()

iii. Select year(dateofmanufacture) from automobile where body-style=’sedan’;

½ mark each for correct usage of Select and year()
OR
Having clause is used in conjunction with group by clause in MySQL. It is used to provide condition based
on grouped data. On the other hand, order by clause is an independent clause used to arrange records of a table
in either ascending or descending order on the basis of one or more columns
2 marks for correct explanation and 1 mark for example.
SECTION-D
31 Write the SQL functions which will perform the following operations: 5
i) To display the name of the month of the current date .
ii) To remove spaces from the beginning and end of a string, “ Panorama “.
iii) To display the name of the day eg, Friday or Sunday from your date of birth, dob.
iv) To display the starting position of your first name(fname) from your whole name (name).
v) To compute the remainder of division between two numbers, n1 and n2
OR
 Define the following functions
i. LTRIM()
ii. MID()
iii. MOD()
iv. NOW()
v. INSTR()
Answer:
i. Select monthname(date(now()));
ii. Select trim(“ Panaroma “):
iii. Select dayname(date(dob))
iv. Select instr(name, fname);
v. Select mod(n1,n2)
1 mark for each correct answer OR1 mark for each definition of MYSQL funcytion
32 SHARMA Medicos Center has set up its new center in Delhi . It has four buildings as shown in the diagram 5
given below:

Distance between various building are as follows:

As a network expert, provide the best possible answer for the following queries:
i. Suggest a cable layout of connections between the buildings.
ii. Suggest the most suitable place (i.e. buildings) to house the server of this organization.
iii. Suggest the placement of the following device with justification:
a) Repeater b) Hub/Switch
iv. Suggest a system (hardware/software) to prevent unauthorized access to or from the network.
v. The company is planning to link its head office situated in Delhi with the offices in hilly
areas. Suggest a way to connect it economically.
Answer:
i. 1 mark for correct layout
ii. Research Lab
iii. Repeater: Between Accounts and Store, Hub/Switch in each block
iv. Firewall
v. Radio Wave
1 mark for each correct answer or for any other relevant answer
33 Observe the following figure. Identify the coding for obtaining this as output. 5
 Also give suitable python statement to save this chart
OR
Write a Python program to display a bar chart of the popularity of programming Languages
Data:
Programming languages: Java, Python, PHP, JavaScript, C#, C++
Popularity: 22.2, 17.6, 8.8, 8, 7.7, 6.7
Also give suitable python statement to save this chart

Answer:
a) import matplotlib.pyplot as plt
eng_marks=[10,55,30,80,50]
st_name=["amit","dinesh","abhishek","piyush","rita"]
plt.plot(st_name,eng_marks)
plt.show()
plt.savefig("aa.jpg")
1 mark for correct import sattement
1 mark for correct declaration of marks and names
1 mark for correct use of plot method
1 mark for correct use of show method
1 mark for corect use of savefigmethod
OR
import matplotlib.pyplot as plt
x = ['Java', 'Python', 'PHP', 'JavaScript', 'C#', 'C++']
popularity = [22.2, 17.6, 8.8, 8, 7.7, 6.7]
plt.bar(x_pos, popularity)
plt.xlabel("Languages")
plt.ylabel("Popularity")
plt.title("PopularitY of Programming Language Worldwide")
plt.show()
plt.savefig(‘CS.jpg’)
½ mark for each correct statement
1 mark for correct savefig method
SECTION -E
34 Consider the Table CLUB given below:
1+1+
COACH_ID COACHNAME AGE SPORTS DATOFAPP PAY SEX 2
1 KUKREJA 35 KARATE 1996-03-27 10000 M
2 RAVINA 34 KARATE 1997-01-20 12000 F
3 KARAN 34 SQUASH 1998-02-19 20000 M
4 TARUN 33 BASKETBALL 1998-01-01 15000 M
5 ZUBIN 36 SWIMMING 1998-01-12 7500 M
Answer the followings based on the above mysql table ‘CLUB’
i. Write sql quesry to display the average pay for karate coach
ii. Write sql query to display month for date of appointment’DATEOFAPP
iii. Write sql query to display the details of male coach in ascending order of their age
OR
iv. Write SQL query to display game wise maximum pay of all caoches.

Answer:
i. SELECT AGV(PAY) FROM CLUB WHERE SPORTS=’KARATE’;
ii. SELECT MONTH(DATEOFAPP) FROM CLUB;
1 mark for each correct query
iii. SELECT * FROM CLUB WHERE SEX=’M’ ORDER BY AGE ASC;
OR
iii. SELECT SPORTS,MAX(PAY) ROM CLUB GROUP BY SPORTS;
2 mark for each correct query
35 Consider the following DataFrame, ClassDF with row index St1,St2,St3,St4 1+1+
2
 Rollno Name Class Section CGPA Stream
St1 1 Aman IX E 8.7 Science
St2 2 Preeti X F 8.9 Arts
St3 3 Kartikey IX D 9.2 Science
St4 4 Lakshay X A 9.4 Commerce
Based on the above
dataframe answer the following:
A. Predict the output
i. ClassDF.T ii) ClasDF [ : : -2]
B. Write python statement to print Name,class and CGPA for Student St2 and St3
OR
write python Statement to print the name and class of students having CGPA more
than 9.0
Answer:
A. 1 mark for each correct answer
B. ClassDF.loc[St2:St3 , [‘Name’,’Class’,CGPA’]
OR
ClassDF[[‘Name’,’Class’][ClassDF.CGPA>9.0]
2 marks for each correct answer
 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 ********************

 KENDRIYA VIDYALAYA SANGATHA
GUWHATI REGION
Pre – Board Examination: 2022-23
SET – I
Class: XII
SUBJECT: INFORMATICS PRACTICES (065)
MARKING SCHEME
1. (b) MAN 1
2. FALSE 1
3. (a) General Public License 1
4. (c) ADD() 1
5. (a) 76.43 1
6. (c) an old computer 1
7. (b) SELECT COUNT (*) FROM SALES; 1
8. (a) GROUP BY 1
9. (b) MIN( ) 1
10. (b) pd.Series( ) 1
11. (d) a and b both 1
12. (d) All of the above 1
13. (b) Chat 1
14. (b) Plagiarism 1
15. (a) matics Pr 1
16. (d) Any crime that involves computer and networks 1
17. (b) Both A and R are true and R is not the correct explanation for A 1
18. (a) Both A and R are true and R is the correct explanation for A 1
Web Site: 2
A collection of web pages related through hyperlinks, and saved on a web
server is known as web site.
website in general contains information organized in multiple pages about an
organization.
Web Server :
Used to store and deliver the contents of a website to clients such as a
browser that request it. A web server can be software or hardware.
The server needs to be connected to the Internet so that its contents can be
19.
made accessible to others
(1 mark for each correct explanation of each term)
OR
Four networking goals are:
i. Resource sharing
ii. Reliability
iii. Cost effective
iv. Fast data sharing
(½ mark for each goal)
Mr. Vinay missed the aggregate function in the query. The function he needs 2
to write is avg(salary). The correct statement is:
20.
SELECT Category, AVG(Salary) FROM Hotel GROUP BY Category;
Single row functions: 2
It operates on a single row
21.
It displays result per row
It can be used within select, where and order by clause
1|Page
 Examples: math, string, date etc.

Aggregate functions :
It operates on multiple rows
It displays one result for set of rows
It can be used only in select clause
Examples: min, max, avg, sum etc.

(1 mark for difference and 1 mark for example of each)

Emp={‘Ashok’ :10000, ‘Ravi’ :7500 , ‘Dinesh’ :12500, ‘Akram’ :8000} 2
22. S1=pd.Series(Emp)
(1 mark for each correct statement)
i. Bad Posture, Back Aches, Neck and Shoulder Strain 2
ii. Pain in Wrists — Carpal Tunnel Syndrome
iii. Eye Problem
iv. Impact on bones and Joints
v. Sleep Issues
vi. Mental Health Issues (or any valid answer)
23. (2 mark for any four correct options)
OR
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
(1/2 mark for each correct option)
15 2
0 15
24. 3 39
4 -90
(½ marks for each correct output line)
i. The index labels of df will include Qtr1,Qtr2,Qtr3,Qtr4,A,B,C 2
25. ii. The column names of df will be: 1,2
(1 mark for each correct answer)
i. 11 3
ii. RAKESH VERMA
26. iii. 16
4
(1 mark for each correct answer)
import pandas as pd 3
d=[[‘P101’,’COMPUTER’,50000],[‘P222’,’TABLE’,5000],[P201’,’MOUSE’,1000]]
27. df=pd.DataFrame(d,columns=[‘ProdID’,’PName’,’Price’])

(1 mark for each correct python statement)

i. Student[‘grade’]= [‘B1’,’A2’,’C2’,’D1’] 2+1
ii. Student.loc['4']=[‘Krishna’,80.5]
28.
iii. Student=Student.drop(‘grade’,axis=1)
(1 mark for each correct statement)
i. Namita has become a victim of cyber bullying and cyber stalking. 3
ii. She must immediately bring it into the notice of her parents and school
29.
authorities. And she must report this cyber crime to local police with the
help of her parents.

2|Page
 iii. Yes. The Information Technology Act, 2000 (also known as ITA-2000, or
the IT Act) is the primary law in India dealing with cybercrime and
electronic commerce.
(1 mark for each correct answer)
OR
Cybercrime or computer- oriented crime is a crime that includes a computer
and a network.
The computer may have been used in the execution of a crime or it may be
the target.
It is the use of a computer as a weapon for committing crimes such as
committing fraud, identity theft or breaching privacy.
It especially through the Internet, has grown in importance as the computer
has become central to every field like commerce, entertainment and
government.

[Hacking, Cyber Troll or Cyber Bullying, Illegal Downloads etc. are

examples of cyber crime]

Prevention of Cyber Crime:

Below are some points by means of which we can prevent cybercrime:
1. Use strong password:
Maintain different password and username combinations for each account and
resist the temptation to write them down. Weak passwords can be easily
cracked using certain attacking methods like Brute force attack, Rainbow
table attack etc.
2. Use trusted antivirus in devices:
Always use trustworthy and highly advanced antivirus software in mobile and
personal computers. This leads to the prevention of different virus attack on
devices.
3. Keep social media private:
Always keep your social media accounts data privacy only to your friends.
Also make sure only to make friend who are known to you.
4. Keep your device software updated:
Whenever you get the updates of the system software, update it at the same
time because sometimes the previous version can be easily attacked.

1 mark for correct definition

1 mark for correct example
½ mark each for any two ways to prevent from cyber crime
a. select avg(price),type from vehicle group by type having qty>20; 3
b. select count(type) from vehicle group by company;
c. select sum(price) from vehicle group by type;
(1 mark for each correct query)
OR
30. 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.

To Display the average price of each type of vehicle having quantity more than
20. We need to group the records based on the type and then find average
price using avg() function.

3|Page
 select avg(price),type from vehicle group by type having qty>20;
(1mark for correct significance & 2 mark for correct example
i. select mid(INFORMATICS PRACTICES',7,7);
ii. select INSTR('WELCOME WORLD','COME');
iii. select round(2334.78,1);
iv. select mod(200,7);
v. select trim(userid) from users;
1 mark for each correct query

OR

1. UCASE(): It converts the string into upper case.

Example:
SELECT UCASE(‘welcome world’);
Output:
WELCOME WORLD
2. TRIM(): It removes the leading and trailing spaces from the given string.
Example:
SELECT TRIM(‘ Welcome world ‘ );
Output:
31. Welcome world
3. MID(): It extracts the specified number of characters from given string.
Example:
SELECT MID(‘ Welcome world,4,,4);
Output:
Come
4. DAYNAME(): It returns the weekday name for a given date
Example:
SELECT DAYNAME(‘2022-07-22’);
Output:
Friday
5. POWER(): It returns the value of a number raised to the power of another
number.
Example:
SELECT POW(6,2);
Output:
36
½ mark for each correct explanation
½ mark for each correct example
i. The most suitable place to install server is building “JAMUNA” because 2+3
this building has maximum computer which reduce the communication
32.
delay.
ii. Cable layout. (Bus topology).

4|Page
 iii. (a) Since the cabling distance between buildings GANGA and JAMUNA
are quite large, so a repeater each, would ideally be needed along their
path to avoid loss of signals during the course of data flow in these
routes.
(b) In the layout a switch each would be needed in all the building, to
interconnect the group of cables from the different computers in each
building.
iv. Optical fiber
v. Video conferencing
(1 mark for the correct Answer)
import matplotlib.pyplot as plt 1+1+2
Category=['Gold','Silver','Bronze']
Medal=[20,15,18]
plt.bar(Category,Medal)
plt.ylabel('Medal')
plt.xlabel('Medal Type')
plt.title('Indian Medal tally in Olympics')
plt.show()

(½ mark for each correct statement)

33.
Python statement to save the chart:
plt.savefig("aa.jpg")
(1 mark for the correct statement)
OR
import matplotlib.pyplot as plt
Week=[1,2,3,4,5]
temp=[25,29.27.30,33]
plt.bar(Week, temp)
plt.show()
(1 mark for each correct statement)
i. SELECT UPPER(NAME) FROM Furniture; 1+1+2
ii. SELECT MAX(COST) FROM FURNITURE;
(1 mark for each correct query)
iii. SELECT COUNT(*) FROM FURNITURE GROUP BY DISCOUNT HAVING
34. DISCOUNT=10;
OR
SELECT YEAR(DOP),COUNT(*) FROM FURNITURE GROUP BY
YEAR(DATEOFPURCHASE);
(2 marks for correct query)
A. Output: 1+1+2
35. i. (5,4)

5|Page
 ii.
School tot_students Topper Runnerup
Cyb2 GPS 20 18 2
Cyb4 MPS 18 10 8
1 mark for each correct output
B. Python statement:
print(df.loc['Cyb2': 'Cyb5', 'Topper'])
OR
print(df.Total_students-df.Runnerup)
2 marks for correct Python statement
**************************

6|Page
 KENDRIYA VIDYALAYA SANGTHAN
JABALPUR REGION
FIRST PREBOARD EXAMINATION2022-23
CLASSXII
INFORMATICS PRACTICES(065)
TIME:3 HOURS M.M.70
General Instructions:
1. This question paper contains five sections, Section A to E.
2. All questions are compulsory.
3. Section A have18 questions carrying01 mark each.
4. Section B has 07 Very Short Answer type questions carrying02 marks each.
5. Section Chas 05 Short Answer type questionscarrying03markseach.
6. Section Dhas03 LongAnswertypequestionscarrying05markseach.
7. Section E has02 questionscarrying04marks each. One internal choice is
given in Q35 against part c only.
8. All programming questions are to be answered using Python Language only.

PARTA
1. a)Internet 1
1 mark for correct answer
2. c)Plagiarism 1
1 mark for correct answer
3. d) All of these 1
1 mark for correct answer
4. c)Null value 1
1 mark for correct answer
5. b) 2.8 1
1 mark for correct answer
6. d) Property 7
1 mark for correct answer
7. d) Arithmetic Functions
1 mark for correct answer
8. a) 460 1
1 mark for correct answer
9. c)LCASE(str/column_name) 1
1 mark for correct answer
10. b) S[2] 1
1 mark for correct answer
11. c)Homogeneous tabular data structure 1
1 mark for correct answer
12. d) type 1
1 mark for correct answer
13. c)Chat group 1
1 mark for correct answer
14. d)DATE() 1
1 mark for correct answer
15. c)India’s Information Technology(IT),Act ,2000 1
1 mark for correct answer
16. a) Copyright 1
1 mark for correct answer
Q17and18areASSERTIONANDREASONING based questions. Mark the correct
choice as
i. Both A and R are true and R is the correct explanation for A
ii. Both A and R are true and R is not the correct explanation for A
iii. A is True but R is False
iv. A is false but R is True
17. i) Both A and R are true and R is the correct explanation for A 1

18. i) Both A and R are true and R is the correct explanation for A 1
.
PARTB

19 Website: A group of related webpages that follow the same theme and 2
are connected together with hyperlinks is called a Website.
Webpage: web page is an electronic document designed using HTML.it
displays information in textual or graphical form.

1 mark for correct explanation of each term

OR
Network: A network is aninterconnected collection of autonomous computers that
can share and exchange information.
1 mark for correct explanation

Need of Networking:
i. Resource sharing
ii. Reliability
iii. Cost effective
iv. Fast data sharing
½ mark for each (any two)
20 SELECT Deptcode,MAX(Salary) FROM Employee GROUP BY Deptcode; 2

1 Mark for error identification

1 Mark for writing correct query
21. None of the aggregate functions takes NULL into consideration. NULL is simply 2
ignored by all the aggregate functions excepts COUNT(*).
2 marks for correct answer

22. import pandas as pd 2

d={‘English’:75,’Hindi’:78,’Math’:82,’Science’:88}
Subject=pd.Series(d)
print(Subject)
½ marks for import statement
½ marks for using dictionary
½ marks for uses of Series()
½ marks forcreating object Subject and print()
23. 1.Recycling/recovery of valuable material. 2
2.Dismantling
3.Refurbishment and reuse
4.Disposal of dangerous materials and waste

½ mark for each correct answer

OR
On the internet, a digital footprint is the word used to describe the train, traces or
footprints that people leave online. This is information transmitted online, such as
forum registration-mails and attachments, uploading videos or digital images.
1mark for each correct answer
Guidelines of Digital Footprint
1.know what your digital footprints is
2.keep your digital foot print clean
½ mark for each correct point

24. 2 8 2
4 7
1 mark for each correct answer
25. i) 3 columns 2
ii)import pandas as pd
1 mark for each correct answer

SECTIONC

26. import pandas as pd 3

data=[[201,’Gurmeet’,95],[202,’Praveen’,89],[203,’Suman’,97],[204.’Yogesh’,91]]
df=pd.DataFrame(data,columns=['Rno','Name', 'Marks'])
1 mark for each correct python statement

27. i. Fees['Section']= [‘A’,’B’,’C’,’D’] 3

ii. Fees.loc['4']=['IX',1800]
iii. Fees=Fees.drop('Section',axis=1)
1 mark for each correct statement
28. Write SQL commands for the statements (i) to (iii) which are based on the given 3
table MASTER.
i)132000
ii)GEN COUNT(*)
F 3
M 4
iii) 2000
2000

29 i. Cyber stalking 3
ii. He should bring to the notice of his parents and school authorities.
iii.Computer ethics

OR 3
Ans. Plagiarism is the act of using or stealing someone else’s intellectual work,
ideas etc. and passing it as your own work. In other words, plagiarism is a
failure in giving credit to its source.
Plagiarism is a fraud and violation of Intellectual Property Rights. Since IPR
holds a legal entity status, violating its owners right is a legally punishable
offence.
 Any two ways to avoid plagiarism:
 Be original
 Cite/acknowledge the source
1 mark for correct definition
1 mark for correct justification
½ mark each for any two ways to avoid plagiarism
30 ANS: 3
(i) SELECT Sname, ROUND(Bonus,0)FROM Salesman;
(ii) SELECT MONTHNAME(DOJ) FROM Salesman;
(iii) SELECT MIN(SALARY) FROM Salesman;
1 mark for each correct query
OR
The GROUP BY clause can be used to combine all those records that have identical
value in a particular field or a group of fields. Whereas, ORDER BY clause is used
to display the records either in ascending or descending order based on a particular
field. For ascending order ASC is used and for descending order, DESC is used. The
default order is ascending order.
1 mark for correct significance 2 marks for correct example

SECTIOND

31. 5
i. select mid('INDIA SHINING',7,7);
ii. select INSTR('WELCOME WORLD','COME');
iii. select round(78.779,2);
iv. select mod(149,6);
v. select trim(userid) from users;

1 mark for each correct query

OR
1.LENGTH():This function returns the length of the string in bytes. It includes the count of
blank spaces in the string.
Syntax
LENGTH(string/column_name)
EXAMPLE :
SELECT LENGTH('easycalculation');
Output:
15
2. TRIM(): It removes the leading and trailing spaces from the given string.
Example:
SELECT TRIM(‘ Welcome world ‘ );
Output:
Welcome world
3. This function returns the current date and time in the format ‘YYYY-MM-DD
HH:MM:SS’ or YYYYMMDDHHMMSS format.
Syntax NOW()
e.g. mysql> SELECT NOW()
Output:
‘YYYY-MM-DD HH:MM:SS’ or YYYYMMDDHHMMSS format of current date
4. DAYNAME(): It returns the weekday name for a given date
Example:
SELECT DAYNAME(‘2022-07-22’);
 Output:
Friday
5. POWER(): It returns the value of a number raised to the power of another number.
Example:
SELECT POW(6,2);
Output:
36
½ mark for each correct explanation
½ mark for each correct example
32. i) TTC should install its server in finance block as it is having maximum number of 5
computers.
ii) Human Resources Conference Block
Block

Finance Block

The above layout is based on minimum cable length required which is 120 meter in
the above case.
iii) Switch
iv)WAN
v) Satellite Link
33 import matplotlib.pyplot as plt
Games=["Subway Surfer","TempleRun","CandyCrush","BottleShot","RunnerBest"]
Rating=[4.2,4.8,5.0,3.8,4.1]
plt. bar(Games,Rating)
plt.xlabel("Games")
plt.ylabel("Rating”)
plt. show()
½ mark for each correct statement
Python statement to save the chart:
plt.savefig("aa.jpg")
1 mark for the correct statement

OR
import matplotlib.pyplot as plt
Year=[2015,2016,2017,2018]
Pass_Percentage=[82,83,85,90]
plt. plot(Year,Pass_Percentage)
plt.xlabel("Year")
plt.ylabel("Pass_Percentage”)
plt. show()

1 mark for each correct statement

SECTIONE

34 1+1+2
i. SELECT UPPER(PNAME) FROM STOCK;
ii. SELECT* FEOM STOCK ORDER BY PRICE DESC;

1 mark for each correct query

 iii. SELECT CATEGORY,MAX(PRICE) FROM STOCK GROUP BY CATEGORY;

OR
SELECT CATEGORY,SUM(QTY) FROM STOCK GROUP BY CATEGORY;
2 marks for correct query

35. A)
i) 2 2012 Jan 35 1+1+2
3 2010 Dec 55
4 2012 Dec 65
ii) 55
65
1 mark for each correct output
B )Python statement:
print(df.loc[1: 3, 'year'])
OR
df.rename(columns={‘Month’:’mon_name’)

2 marks for correct Python statement

 KENDRIYA VIDYALAYA SANGATHAN, JAIPUR REGION
HALF-YEARLY
CLASS XI (SESSION: 2022-23)
SUBJECT: INFORMATICS PRACTICES (065)
BLUE-PRINT
SECTION
MCQ VSA SA LA LA TOTAL
(1 (2 (3 (4 (5
Mark) Mark) Mark) Mark) Mark)
UNIT I
Introduction to computer and
1 (3) 5 (1) 8
computing
Computer Memory 1 (4) 2 (2) 8
Software 1 (3) 3 (1) 6
UNIT II
Basics of Python programming 1 (2) 2 (1) 3 (2) 4 (1) 14
Control Statements 1 (2) 2 (2) 3 (1) 4 (1) 13
Lists 1 (2) 2 (2) 3 (1) 5 (1) 14
Dictionary 1 (2) 5 (1) 7
Total 1 (18) 2 (7) 3 (5) 4 (2) 5 (3) 70 (35)

Syllabus
▪ Unit I:
❖ Introduction to computer and computing: evolution of computing devices, components of a
computer system and their interconnections, Input/output devices.
❖ Computer Memory: Units of memory, types of memory – primary and secondary, data deletion,
its recovery and related security concerns.
❖ Software: purpose and types – system and application software, generic and specific purpose
software.
▪ Unit II:
❖ Basics of Python programming, Python interpreter - interactive and script mode, the structure
of a program, indentation, identifiers, keywords, constants, variables, types of operators,
precedence of operators, data types, mutable and immutable data types, statements,
expressions, evaluation and comments, input and output statements, data type conversion,
debugging.
❖ Control Statements: if-else, for loop
❖ Lists: list operations - creating, initializing, traversing and manipulating lists, list methods and
built-in functions.
❖ Dictionary: concept of key-value pair, creating, initializing, traversing, updating and deleting
elements, dictionary methods and built-in functions.
 KENDRIYA VIDYALAYA SANGATHAN, JAIPUR REGION
HALF-YEARLY
CLASS XI (SESSION: 2022-23)
SUBJECT: INFORMATICS PRACTICES (065)
Time: 3 Hours Max. Marks: 70

General Instructions:
1. This question paper contains five sections, Section A to E.
2. All questions are compulsory.
3. Section A have 18 questions carrying 01 mark each.
4. Section B has 07 Very Short Answer type questions carrying 02 marks each.
5. Section C has 05 Short Answer type questions carrying 03 marks each.
6. Section D has 03 Long Answer type questions carrying 05 marks each.
7. Section E has 02 questions carrying 04 marks each.
8. Internal choices have been given in question number 19, 23, 29, 30, 32, 33, 34 and 35.
9. Internal choices given in question number 34 and 35 is for part (b) only.
Q.
Question Marks
N.
Section - A
Who is referred to as "father of computing."?
01 a. Tim Berners-Lee b. Alan Turing 1
c. Charles Babbage d. Mark Zuckerberg
Vacuum Tubes belongs to which generation of computers?
02 a. First b. Second 1
c. Third d. None of these
Which of the following is not the part of a Processor?
03 a. Arithmetic Logic Unit b. Cache 1
c. Control Unit d. None of these
____________ is not an example of secondary memory.
04 a. Solid state drive b. Digital Versatile Disk (DVD) 1
c. RAM d. Floppy Disk
Which is the correct arrangement of the memory devices in ascending order
of their speed?
05 1
a. HDD, RAM, Cache, Register b. Register, Cache, RAM, HDD
c. Cache, RAM, HDD, Register d. RAM, HDD, Cache, Register
Collection of 4 bits is called ___________.
06 a. Bit b. Kilo byte 1
c. Byte d. Nibble
______________ is the smallest unit of memory?
07 a. Bit b. Nibble 1
c. Byte d. Kilo byte
A business is using software A to generate bills, then to which category this
software belongs?
08 a. System b. Application 1
c. Language Processors d. Both a and b
 Antivirus belongs to which category of software?
09 a. System b. Application 1
c. Language Processors d. Utilities
________________ is not an example of Operating System?
10 a. Linux b. Windows 1
c. Adobe d. Android
Python is which type of language?
11 a. Compiler based b. Interpreter based 1
c. Assembler based d. None of these
Smallest unit of python programming language is called?
12 a. Literal b. Token 1
c. Identifier d. Operator
Which of the following is not an example of control statements?
13 a. int b. for 1
c. if d. while
Which statement is used to terminate the loop abruptly?
14 a. continue b. kill 1
c. break d. None of these
Which of the following commands will create a list?
15 a. list1 = list() b. list1 = [] 1
c. list1 = list([True, False, True]) d. All the mentioned
Which of the following statements create a dictionary?
16 a. my_dict = {} b. my_dict = {“a”:1: “b”:2} 1
c. my_dict = {1:“a”, 2:“b”} d. both a & c
Q17 and Q18 are ASSERTION AND REASONING 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
Assertion (A): The output of len(my_list) statement is 3 when, my_list = [‘K’, ’V’,
’S’].
17 1
Reasoning (R): len() function on list returns the no. of items present in that
list.

Assertion (A): Dictionary is an example of ordered collection.

18 1
Reasoning (R): Keys are used to retrieve values from a dictionary.
Section - B
How many Kilo-bytes are there in 5 Giga-Bits?
OR
19 2
What is the multiplication/division factor to convert Bits (b) to Megabytes
(MB).
20 Explain the concept of Primary and Secondary memory with suitable example. 2
Write 2-2 advantages and disadvantages of the Python programming
21 2
language.
 Predict the output of the following python code and explain with proper
justification.
22 2
While True:
print(‘KVS’)
Predict the output of the following python code and explain with proper
justification.
num = 52
if num % 2 == 0:
print(‘Hi’)
else:
print(‘Hello’)
23 2
OR
Predict the output of the following python code and explain with proper
justification.
if True:
print(‘This line will not be printed’)
else:
print(‘This is the correct answer’)
24 Differentiate between positive and negative index of a List with example. 2
Predict the output of the following python code with proper justification.
25 my_list = [52, -1, 34, 62, 78, True] 2
print(my_list[-1:-5:-1])
Section - C
26 Explain different type of Software with examples. 3
Which of the following identifiers are valid and invalid?
a. Serial_no3 b. Total_Marks
27 3
c. 1st_Room d. total-Marks
e. Hundred$ f. _Percentage
Which data type will be used to represent the following data values and why?
a. Number of months in a year b. Resident of Jaipur or not
28 3
c. Pocket money d. Volume of a sphere
e. Name of a student f. Address of a student
Write a python program to print the string ‘‘IP” n no. of times. The value of n
(an integer) should be read from the user.
OR
29 3
Write a python program to print all the odd numbers between 1 to n
(boundary values are also included) . The value of n (an integer) should be
read from the user.
Explain the concept of slicing in a list. How to print a list in reverse with the
help of slicing.
OR
30 3
Write a python program to create a new list of distinct items using below given
list.
Input: my_lst = [-45, 0, 34, False, -45, ‘False’, ‘This is not a list’, 34.0, 1]
Section - D
31 Explain 5 types of tokens with examples. 5
 Explain any 5 member functions of python list.
OR
Identify the member functions to perform following operations on a python
list.
32 i. Adds an element at the end of the list. 5
ii. Adds an element at the specified position.
iii. Removes all the elements from the list.
iv. Removes the element at the specified position.
v. Reverses the order of the list.

Explain any 5 member functions of python dictionary.

OR
Identify the member functions to perform following operations on a python
dictionary.
33 i. Returns a list containing the dictionary's keys. 5
ii. Returns a list of all the values in the dictionary.
iii. Returns the value of the specified key.
iv. Removes the element with the specified key.
v. Returns a list containing a tuple for each key value pair.
Section – E
Write the python code for the following.
a. Read the radius of a circle and print the area and circumference.
34 b. List any 2-2 Logical and Arithmetic operators 4
OR
b. List any 2-2 Comparison and Membership operators
Write the python code for the following.
a. Print factorial of a number n which is entered by the user.
35 b. Explain the concept of break and continue keywords with examples. 4
OR
b. Explain the two types of loops with examples.
 Downloaded from www.tutorialaicsip.com
Answer Key Sample Paper 1
Subject: Informatics Practices (065) Class 12
Time: 3:00 Hours Max. Marks: 70
General Instructions
1. This question paper contains five sections, Section A to E.
2. All questions are compulsory.
3. Section A have 18 questions carrying 01 mark each.
4. Section B has 07 Very Short Answer questions carrying 02 marks each.
5. Section C has 05 Short Answer type questions carrying 03 marks each.
6. Section D has 03 Long Answer type questions carrying 05 marks each.
7. Section E has 02 questions carrying 04 marks each. One internal choice is
given in Q35 against part c only.
8. All programming questions are to be answered in Python Language only.
Section –A
1. Two friends are working in the same office are transferring their files through
Bluetooth in their devices. Which type of network the have used?
a) LAN c) WAN
b) MAN d) PAN
2. Which of the following is an example of absolute URL?
a) samplepaper-ip-class12
b) https://www.tutorialaicsip.com
c) /Sample-Paper-2023/Samplepaper-ip-class12.html
d) All of these
3. Read the following statement and select an appropriate term for the same:
“It includes websites visited by user, emails sent by user, information submitted
online by user, IP address, location and other serviced online. “
a) Digital Footprint c) Plagiarism
b) IPR d) Cyber Stalking
4. Rama is working on MySQL. She wants to count the employees not earning
commission from the table emp. Which of the following is correct statement for her?
a) Select count(empno) from emp where commission is not null;
b) Select count(empno) from emp where commission = null;
c) Select count(empno) from emp where commission is null;
d) Select commission(empno) from emp where commission =’null’;
 Downloaded from www.tutorialaicsip.com
5. Krushn wants to display the unique departments from table emp. Which of the
following is correct statement for him?
a) Select unique department from emp;
b) Select distinct department from emp;
c) Select department from emp;
d) Select department(unique) from emp;
6. The software which are sold commercially and their source code not shared or
distributed to the users are known as _____________
a) Proprietary software c) GPL License software
b) FOSS software d) Pirated Software
7. Which function In SQL, we can use similarly as substr() or substring() ?
a) instr() c) middle()
b) mid() d) between()
8. Which of the following is not a multiple row function?
a) round() c) max()
b) sum() d) count()
9. Minakshi wants to sort the SQL query result in sorted form of a particular columns,
which of the following clause is correct for the same?
a) order by c) group by
b) sort by d) sorted by
10. Nirmal has written following code to get the last five records from Series object S,
but he is not getting the correct output.
print(s.bottom(5))
Help him by selecting an appropriate option from the following to get his desired
result?
a) s.last() c) s.tail()
b) s.trail() d) s.end()
11. NumPy stands for
a) Numbered Python c) Numeric Python
b) Number Python d) Numerical Python
12. The pandas Series can be considered as
a) Column in a spreadsheet
b) Row in a spreadsheet
c) Cell in a spreadsheet
d) Header in a spreadsheet
 Downloaded from www.tutorialaicsip.com
13. Which amongst from the following is used to identifies a resource by its location
or by its name or both?
a) URL c) URA
b) URI d) URR
14. Mehal wants to display name of day of his birthday. Select appropriate function
name for him.
a) day() c) weekday()
b) dayname() d) nameofday()
15. A patent protects an invention for _____ years and then it can be freely used.
a) 10 c) 20
b) 15 d) 25
16. Be secure refers to
a) Choose password wisely c) Beware of fake information
b) Know who you be friend d) All of these
Q17 & 18 are ASSERTION & REASONING 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
17. Assertion(A): User cannot download any image directly from google and use in
their content.
Reasoning(R):The images are subject to copyrights.
a) Both A and R are true and R is the correct explanation for A
18. Assertion(A): In python pandas at attribute is to select or access multiple values
from data frame.
Reasoning(R): In python pandas, loc attribute is used to select or access a
single/multiple value(s) from dataframe.
d) A is False but R is True
Section –B
19. List out any four services provided by internet.
Ans.: The services provided by internet are as follows:
i. The world wide web
ii. Electronic Mail
iii. Chat
iv. VoIP
(Reference: NCERT Text Book – P.G.No:149/(159/220))
 Downloaded from www.tutorialaicsip.com
OR
Differentiate between LAN and MAN. (Any two points)
Ans.:
LAN MAN
Full Form Local Area Network Metropolitan Area Network
Connection Connects small area Covers large regions like cities
Speed Offers High Speed Offers moderate speed
Uses Schools, Homes, Colleges etc. Government Sectors

For more points refers this link:Byjus.com

20. Write the output for the following:
a) Select mod(8/4,3);
b) Select power(2,-2);
Ans.: a) 2.0000 b) 0.25
21. Write MySQL for the following purposes for table invoice:
a) Compute GST as 18% of price and display the result with 2 decimal places.
b) Display the result in the multiple of hundreds and remaining amount
Ans.: a) select round(price*0.18,2) from invoice;
b) select mod(amt,100) from invoice
22. Write a panda’s code to create a series to store player details who played most
T20 World cup matches from Team India from following data:
Player No. of Matches
Rohit Sharma 39
M S Dhoni 33
Yuvraj Singh 31
Virat Kohli 27
R Ashwin 24
Store player name as index and no. of matches as data.
Ans.: import pandas as pd
L=[39,33,31,27,24]
S=pd.Series(L,index=[‘Rohit Sharma’,’M S Dhhoni’,’Yuvraj Singh’,’Virat Kohli’,’R
Ashwin’])
print(S)
23. Expand:
Ans.:
a) WEEE – Waste Electrical and Electronic Equipment
b) CPCB – Central Pollution Control Board
c) DIT – Department of Information Technology
d) CAT - Cyber Appellate Tribunal
 Downloaded from www.tutorialaicsip.com
OR
What do you mean by identity theft? Illustrate answer with example.
Ans.: On internet user’s identifiable personal data like demographic details, email ID,
banking credentials, passport, PAN, adhaar ID and some other important data
stolen and misused by hacker is known as identity theft.
For example: Financial identity theft done when stolen identity is used for
financial gain.
24. Consider the following series and write output for given statement:
S1 S2
1 20 0 10
2 30 1 30
0 40 2 20
a) S1 + S2
b) S1 < S2
Ans.: a)
0 50
1 50
2 50
dtype: int64
b) No output, as this statement will raise error because indexes are not identical.
25. Observe the following code and write statements for the below given questions:
import pandas as pd
player1={‘IG1’:34,’IG2’:0,’IG3’:23}
player2={‘IG1’:21,’IG2’:10,’IG3’:39}
pl={‘p1’:player1,’p2’:player2}
df=pd.DataFrame(pl)
a) Display data of player scored more than 30 runs
b) Display all rows of first inning of all players
Ans.: a) print(df[df>30])
b) print(df.loc['IG1',:]) or print(df.iloc[0,:])
Section – B
26. Consider the given table students and write the output of given queries:
Rno Name Stream Doa Percentage
1 Gayatri Arts ‘2018-04-01’ 78.2
2 Amit Commerce ‘2017-04-13’ 65.3
3 Sagar Science ‘2016-06-03’ 85.8
4 Manisha Arts ‘2015-07-01’ 53.5
5 MaheMahk Science ‘2018-07-05’ 79.6
6 Maulin Commerce ‘2018-06-05’ 82.3
 Downloaded from www.tutorialaicsip.com
a) Select length(name) from students where percentage between 80 and 90;
b) Select name, stream from students where month(doa) in (7,6);
c) Select power(len(stream),2) from students where stream=’Arts’
Ans.:
a) length(name)
---------------
5
6
b) name stream
-------------- -----------------
Sagar Science
Manisha Arts
Mahek Science
Maulin Commerce
c) power(len(stream),2)
---------------------------
16
16
27. Write python code to create a dataframe by using following data:
[[201,’Manoj’,4500],[202,’Dhara’,3200],[203,’Mohini’,2300]]
i. Dataframe name should be cust
ii. Use column headings as: cust_id,cust_name and amount
Ans.:
import pandas as pd
L=[[201,'Manoj',4500],[202,'Dhara',3200],[203,'Mohini',2300]]
cust=pd.DataFrame(L,columns=['cust_id','cust_name','amount'])
print(cust)
28. Consider the following dataframe ‘tempurature:
City max
0 Ahmedabad 31
1 Surat 29
2 Vapi 25
3 Vadodara 32
Write suitable python code to:
a) Add new column min with these data: [25,22,19,28]
Ans.: df.loc[:,'min']=[25,22,19,28] or
df.insert(2,’Min’,[25,22,19,28]) or
df.insert(loc=2,column='Min',value=[22,25,19,28])
 Downloaded from www.tutorialaicsip.com
b) Add new city Mahesana with 30 value
Ans.: df=df.append({'City':'Mahesana','Max':30},ignore_index=True) or
df.loc[4]=['Mahesana',30] or df.loc[len(df)]=['Mahesana',30]
c) Delete column min
Ans.: del df['Min'] or df=df.drop('Min',axis=1) or df=df.drop(columns='Min')
29. Write any three safety measures to reduce the risk of cybercrime.
Ans.:
1) Take regular backup for important data
2) Use updated antivirus software always
3) Avoid install pirated software
4) Use and download software from known and secured (https) source
5) Use strong passwords
6) Use or always secure wireless by a strong password
Reference: NCERT Textbook(Page No.:182/(192/220))
OR
Raj has created a group on social media to share and discuss about academics.
But his friend Mitul is posting rumours in the group.
i) What is the term used for the task done by Mitul?
Ans.: Cyber Bullying
ii) Any act by Indian Government imposed to protect and safeguard issues like
this? Explain in detail.
Ans.: Yes, Indian Government imposed IT Act 2000, amended in 2008. It provides
legal measures for protection of sensitive personal data and to safeguard the rights
of users. It provides guidelines to the user on the processing, storage and
transmission of sensitive information. It also provides a legal framework for
electronic governance by giving recognition to electronic records and digital
signatures.
Reference: NCERT Textbook (Page No.:182 & 183/(192&193/220))
30. Consider the following table transactions and write queries for given questions:
Cno Cname City Amount Modeofpay
101 Dinesh Anand 574 COD
102 Mahesh Petlad 630 UPI
103 Jayshree Anklav 145 Debit Card
104 Ketan Vasad 700 UPI
105 Mitesh Anand 595 Debit Card
 Downloaded from www.tutorialaicsip.com
106 Ramesh Anklav 680 UPI
108 Dhaval Vasad 900 COD
109 Zarna Petlad 150 COD
110 Manohar Anand 450 Debit Card
i. Display the maximum amount for each payment method.
Ans.: select modeofpay, max(amount) from transactions group by modeofpay;
ii. Display the lowest amount for each city.
Ans.: select city, min(amount) from transaction group by city;
iii. Display total amount of Orders for Anand city.
Ans.: select sum(amount) from transactions where city=’Anand’;
OR
Write output for following:
i. select instr(‘Pre-Board Exam 2023’,’2’);
Ans.: instr(‘Pre-Board Exam 2023’,’2’)
---------------------------------------
16
ii. select substr(‘Pre-Board Exam 2023’,5);
Ans.: substr(‘Pre-Board Exam 2023’,5)
--------------------------------------
Board Exam 2023
iii. select left(‘Pre-Board Exam 2023’,4)
Ans.: left(‘Pre-Board Exam 2023’,4)
-----------------------------------
Pre-
Section – D
31. Consider the following table (salesperson) and Write SQL queries for following:
SID Name PhoneNo DOB Salary Zone
S101 Ankit 9824532586 1981-01-22 65000 North
S102 Bhvya 9725412396 1984-10-19 75000 South
S103 Bhumi 9898457120 1983-12-04 64000 East
S104 Vruti 9324578695 1988-04-05 45000 West
S105 Vikas 9612574891 1987-05-02 58000 Soutch
i. Display the salesperson name’s first two letters whose name ends with ‘i’.
Ans.: select left(name) from salesperson where right(name,1)=’i’; or
select left(name) from salesperson where name like ‘%i’;
ii. Display the eldest salesperson name
Ans.: select name,min(DOB) from salesperson;
iii. Display the square of last 4 digits of phone number
 Downloaded from www.tutorialaicsip.com
Ans.: select power(right(phoneno,4)) from salesperson;
iv. Count the sales person area wise and display the details of salesperson in
which more than 2 sales persons are belonging.
Ans.: select zone, count(SID) from salesperson group by zone having
count(SID)>2;
v. Display the longest name of the sales person area wise.
Ans.: select zone, max(length(name)) from salesperson;
OR
Explain the following functions with suitable examples.
i) trim() iii) date() v) now()
ii) ucase() iv) day()
Ans.:
i) trim(): This function removes the extra space from the left (leading) and right
(trailing) from the text.
Ex.: select trim(‘ IP Class 12 ’)
ii) ucase(): Converts the text into upper case.
Ex.: select ucase(‘cbse’);
iii) date(): Returns the date part from the specified date.
Ex.: select date(now());
iv) day(): Returns day number of given date.
Ex.: select day(now());
v) now(): Returns current date along with time.
Ex.: select now();
32. Soft Infotech Software Development Company has set up its new centre at
Ahmedabad for its office and web based activities. It has 4 blocks of building
named Design, HR, Development, R & D.
It has following no. computers in each block.
Department Computers
HR 25
Design 50
Development 125
R&D 10
Shortest distances between various Blocks in meters are as follows:
Block HR to Design 60 m
Design to Development 40 m
Development to HR 30 m
R & D to Development 50 m
i. Suggest the most suitable place (i.e. block) to house the server of this
company with a suitable reason.
Ans.: Development block is best block to house the server for this company.
 Downloaded from www.tutorialaicsip.com
ii. Suggest the type of network to connect all the blocks with suitable reason.
Ans.: As the distance is given within 1 KM, LAN network will connect all the
blocks.
iii. The company is planning to link all the blocks through a secure and high speed
wired medium. Suggest a way to connect all the blocks.
Ans.:

Suggest the most suitable block to

place the following devices:
a) Hub/Switch b) Modem
Ans.: a) Hub/Switch must be placed in every block
b) Modem is placed in Development to provide the internet connection
iv. Company is planning to purchase a new hardware to protect the network from
network from unauthorised access from outside the network. Name the device.
Ans.: Firewall
33. Write python code to plot a bar chart for India’s runs in T20 World cup as shown
below:
 Downloaded from www.tutorialaicsip.com
Colours: Pakistan – Green, Netherlands – red, South Africa – Blue,
Bangladesh – Cyan, Zimbabve – Magenta, England - Black
Apply appropriate labels to the chart, x and y axis.
Ans.:
import matplotlib.pyplot as plt
teams=["Pakistan","Netherlands","South
Africa","Bangladesh","Zimbabwe","England"]
runs=[160,179,137,184,186,168]
plt.bar(teams,runs,color=['r','g','b','c','m','k'])
plt.title("India's T20W Cup 2022")
plt.xlabel("Teams")
plt.ylabel("Runs")
plt.show()

OR
Write python code to depict the data of India/England semi final runs by over on
line chart. The data as following:
Overs 5 10 15
India 31 62 100
England 52 98 156
i) Display the overs as same as given here on x-axis.
ii) Apply the line colours as – India : Blue, England: Red
iii) Apply appropriate labels
iv) Apply chart label – T20W Cup 2022 : Semi-final 2
Ans.:
import matplotlib.pyplot as plt

overs=[5,10,15]

ind=[31,62,100]

eng=[52,98,156]

plt.plot(overs,ind,'b')

plt.plot(overs,eng,'r')

plt.title("T20W Cup Semi-final 2")

plt.xlabel("Overs")

plt.xticks(overs)

plt.ylabel("Runs")

plt.show()
 Downloaded from www.tutorialaicsip.com

Section – E
34. Consider the below given table – SuperArcade:
SNo AgencyName Owner Opening_Date Rent FLR
1 Gujarat Gas Gujarat Gas 2021-01-01 35000 I
2 Padhai Classes Ankur Patel 2018-04-01 32000 II
3 Ram Enterprise Ram Patel 2018-06-15 38000 I
4 SP InfoTech Siraj Patel 2020-05-17 28000 II
5 Gallops Niraj Desai 2018-05-20 48000 III
6 GK Classes Geet Kapoor 2019-08-15 34000 I
7 Nishtha Couriers Nishtha Patel 2020-11-04 22000 G
Krunal joined as DBA and written following partial queries, complete the queries and
help him: (1 + 1 + 2)
a) Select _________, _________ from superarcade; (Maximum & Minimum Rent)
Ans.: max(rent), min(rent)
b) Select __________ from superarcade; (owner name into capital)
Ans.: ucase(owner)
c) Select FLR, avg(rent) from superarcade _________ having ______>=2;
(Floor wise average rent where shops are more than 2)
Ans.: group by, count(agencyname)
OR
Select AgencyName, Owner from superarcade ____________ opening_date
___________ (Display the shops as per by history (Latest to Oldest)).
Ans.: order by, desc
35. Consider the following dataframe:
AppName Category Rating Installs
Coloring Book Barbaie Entertainment 3.8 646456
Pocket Bowling 3D Sports 3.6 334144
Smart File Manager Productivity 4.4 3741253
Photo Collage Photography 3.6 2534748

NVIDIA Games Entertainment 3.2 2073437

Sudoku Free Puzzles 3.9 438756
World Soccer Challenge Sports 4.1 1358733
SIGMA LINK Sports 2.4 261568
Live Up Social 3.9 287092
Status Saver for WhatsApp Social 4.7 1060986
Write code to do the following: (1 + 1 + 2)
a) Display categories from dataframe
Ans.: df.category or df[‘category’] or df.loc[:,category] or df.iloc[:,1]
 Downloaded from www.tutorialaicsip.com
b) Display Appname, Category and Rating for app having rating more than 4
Ans.:
d1=df[df['Rating']>4] or d1=df[df.Rating>4] or d1=df[df.loc[:,'Rating']>4]
print(d1.loc[:,['AppName','Category','Rating']])
c) Display AppName and installs for sports category apps
Ans.:
d1=df[df['Category']=='Sports'] or d1=df[df.Category=='Sports'] or
d1=df[df.loc[:,'Category']=='Sports']
print(d1.loc[:,['App','Installs']])
OR
Display the dimensions and shape of given dataframe
Ans.:
d=df.ndim
s=df.shape
print(d,s)

-------------X-----------------

Follow this link for more Question Papers:

Download IP Sample Papers for 2023

For note & question bank follow this link:

Download PDF for complete notes

Thank You