SET-4

Series:SSJ/2)
Question paper Code No. ()90

Roll No.
Candidates must write / fill the Question Paper
OMR Sheet.
Code in the space allotted on

NOTE

) Please check that this question paper contains 16 printed pages.

Please check that this questions paper contains 55 multiple choice questions
(ii)
(MCQs).
written
ii) QP Code given on the hand side of the question paper should be
right
candidates.
the appropriate place of the OMR Sheet by the

20 minutes additional time has been allotted read this question paper
to prior
Civ)
to actual time of commencement of examination.

INFORMATICS PRACTICES

Term-I

Maximum Marks: 35
|Time allowed: 90 minutes

www.mycstutorial.in

090 Page 1 P.T.O.

General Instructions:
The paper is divided into 8 Section - A, B and C.

(ii) SectionA, consists of Question 1 to 25 and student need to attempt 20

questions.
(iii) Section B, consists of Question number 26 to 49 and student need to
attempt 20 questions.

(iv) Section - C, consists of Question number 50 to 55 and student need to

attempt 5 questions.

(u) All questions carry equal marks.

www.mycstutorial.in

090 Page 2
 SECTION - A

20 questions.
Section A consists of 25 questions, attempt any

1. Which of the following statement is wrong?

a) Can't change the index of the Series.
series.
and dictionary into a
(b) We can easily convert the list, tuple,

(c) A Series represents a single column in memory.

(d) We can create empty Series.

statement?
returned by the following
2 What type of error is
import pandas as pa

pa.Series ( [1,2,3,41,
index =
['a','b' ,'c'1)
b) Syntax Error
(a Value Error
(a) Logical error
(c) Name Error

Which is incorrect statement for the python package Numpy ?

3.
3.
package.
(a) It is a general-purpose array-processing
b) Numpy arrays are faster and more compact woilo

(c) It is multi-dimensional arrays 20as6s

(d) It is proprietary software

4. The data of any CSV file can be shown in which ofthe following software?
s(a) MS Word (b) Notepad
Spreadsheet (d) All of the above

5.
5. Which python library is not used for data science?
(a) Panda (b) Numpy
Matplotlib (d) Tkinterey

row(s) from DataFrame ?udedus

in
6.
6. Which method is used to Delete
(a) drop0 method (b) .del0 method ts(
(c).remove) method (d) delete) method

Page 3 P.T.O.
090
7. Consider the following
code:
import numpY as np
import pandas a s pd
L=np.array ([10,201)
xpd.Series ( #statement 1
print(x)
output of the above code is:
0
1 8000
1000
www.mycstutorial.in
dtype: int64
What is the correct
statement for the above output in the following
statement-1?
(a) d=L*3 (b) data=L**3
(c) L*3
(d) [10,20]**3
8. Which library is imported to draw charts in Python?
(a) cSv (b) matplotlib
(c) numpy (d) pandas

9. Which of the following would give the

DF1 are DataFrames.
same output as DF/DF1 where DF and

(a) DF.div(DFI)
(b) DFl.divDF
c) Divide(DF,DFI)
(d) Div(DF,DF)

10. Which of the following statement is wrong in context of

DataFrame ?
(a) Two dimensional size is Mutable.
(b) Can Perform Arithmetic operations on rows and columns..
(c) Homogeneous tabular data structure
(d) Create DataFrame from numpy ndarray

11. Which attribute is not used with DataFrame?

(a) size (b) type
(¢) empty Cd), columns

090 Page 4
12. With the
www.mycstutorial.in
outset of Covid-19 schools started
online classes but due
to
started. Health
health issues also
continuous online classes students Which of the
to follow a few health tips.
practitioner advised the parents
?
following health tip should not be suggested
correct
(a) The sitting posture should be
between the online classes.
(b) Breaks should be taken in above eye level.
To protect the eyesthe gadgets should be placed
(c)
(d) Wash the eyes regularly.
creator or owner of any
to the
The following is automatically granted
13.
invention
b) Copyright
(a) Patent
(c) Trademark
(d) License
range of
clothes on
to sell her own
Himanshi sets up her
own company
14. can she use to show that the
intellectual property
instagram. What type of
clothes are made by his company?
(6) Copyright
(a) Patents (d) Trademark
(c) Design

15. GPL stands for

(b) General Public License
(a) Guided Public License General Public Letter
(c) Global Public License (d)
environmental hazards in the
16. E-waste isbecoming one of the fastest growing serious
or disposed of it can c a u s e
world today. If it is not properly treated
health hazards, therefore The has issued a formal set of guidelines
handling and disposal of
e-waste.
for proper
(a) Central Pollution Control Board (CPCB)
(DIT)
(b) Department of Information Technology
()Electrical and Electronic Equipment (WEEE)
(d) Information Communication Technology1CT)

When we create a DataFrame from a list of Dictionaries the columns labels

17.
are formed by the
(a) Union of the keys of the dictionaries
(b) Intersection of the keys of the dictionaries
(c) Union of the values of the dictionaries
(d) Intersection of the values of the dictionaries

Page 5 P.T.O.
090
18. To change the width of bars in a bar chart, which of the following arguments
with a float value is used ?
(a) hwidth
b) width
(c) breath
d) barwidth

19. Identify the correct option to select first four rows and second to fourth
columns from a DataFrame 'Data'
(a) display(Data.iloc[l: 4, 2: 4])
(b) display(Data.iloc[l:5,2:5])
)print(Data.iloc[0 :4, 1:4])
(d) print(Data.iloc[l: 4, 2:4])

20. Which of the following command is used to import matplotlib for coding?
(a) import matplotlib.pyplot as plt
(b)
import plt.matplotlib as plt
(import py.matplotlib as plt
(d) import pyplot.matplotlib as plt

21. Consider the following statements with reference to Line charts

Statement -

A Line graphs is a tool for comparison and is created

by
plotting a series of several points and connecting them with a straight
line.
Statement - B You should never use line chart when the chart is in a
continuous data set.
(a) Statement A is correct
(b) Statement B is correct
(c) Statement A is correct but Statement B is incorrect
(d) Statement A is incorrect, but Statement B is correct

22. What is not true about Data Visualization?

(a) Graphical representation of information and data
(6) Helps users in analyzing a large amount of data in a simpler way.
(c) Data Visualization makes complex data
understandable, and usable.
more accessible,
(d) No library needs to be imported to create charts in Python language.
090 Page 6
 number of NaN values.
28. Which attribute is used with Series to count the total
(a) size (b) len
(d) count total
(c) count
24. Consider the following Series in Python:
data = pd.Series([5, 2, 3,7), index=['a', 'b', 'c, 'a'])
Which statement will display all odd values
(a) print(data%2==0) (b) print(data(data%2!=0))
mod 2!=0) (d) print(data|data%2!=0])
(c) print(data
user of internet
25. Priya is student of class 10 and she is a very frequent
a
an unpleasant message on her
instant
applications. One day she got
messenger. What
do you think she should do ?
unknown person.
(a) Start chatting with an let them know
b) talk her parents/teacher or other trusted adult and
to
that she is feeling uncomfortable.
(c) Ignore the conversation.
to know.
(d) She should delete the chat so that no one comes

SECTION- B
20 questions
Section B consists of 24 question (26-49). Attempt any
26. What will be the output of the following code?
import pandas as pd
import numpy
s=pd.Series (data=[31,54,34,89,12,23],dtype=numpy.int)
print (s>50)
(a) (b) (c) (d
0 False |1 54 0 31 True
1 True 3 89 1 54 3 True
2 False dtype: int64. |2 34 dtype:bool
3 True 3 89
4 False 4 12
5 False 5 23
dtype: bool dtype: int64

27. The primary law in India dealing with cybercrime and electronic commerce is
(a) India's Technology (IT) Act, 2008
2000
(b) India's Digital Information Technology (DIT) Act,
(c) India's Information Technology (IT) Act, 2000
(d) The Technology Act, 2008

090 Page 7 P.T.O.

 Z8.
Consider the following statement with reference to Trademark and Hacking 33. Consider the
Statement 1: Trademark is a document that provides legally binding
ser=pd.seri
guidelines for the use and distribution of software index=[l,2,
Statement 2: Hacking is the act of unauthorized access to a computeer print (ser[£
network or any digital system (a)
(a) Statement 1 is True but Statement 2 is False 4 F
(6) Statement 1 is False but Statement 2 is True
(b) 5 O
(c) Both the statements are True 6 R
(d) Both the statements are False T
8 A
29. Consider a following DataFrame 9 B
import pandas as pd 10 L
s=pd.Series (data=[31,54,34,89,12,231)
df=pd.DataFrame (s) 11 E
Which statement will be used to get the output as 2? dtype: obje-
a) print(df.index) (b) print(df.shape0) 34. Nowadays
(c) print(df.ndimn) (d) print(df.values) CSV files ra
30. Sandhya wants to display the last four rows of the dataframe df and she has (a) cSV car
(b) csv file
written the following command (c) csv file
df.tail ()
(d) csv is E
But the first 5 rows are being displayed. To reetify this problem, which of the
35. Companies
following statements should be written ?
(a) logos, -
(a) df.head0 b) df.last(4) (b) word,
(c) df.tail(4) (d) df.rows(4) (c) slogan
(d) compa
31. There is only 1 day left
for Ravisha to submit her Science project. Therefore 36. DataFrame
she performed the following activities to complete her task. Which of the
(a) lists
following activities can be considered as plagiarism? (c) series
(a) Downloaded the images that were marked as CC and pasted in her 37. Rohit forgc
project file. was missir-
(b)
6Copied the content from some website and pasted in her file.
(c)
Copied the content from the website and gave references about the samne
(a) Cyber-
c) Theft
in the project.
38. Considert
(d) Downloaded and installed the open source software for typing the Statemen
synopsis. row(s
Statemen
32. A contract between the creator and the user to allow the indice
user use his/her
work with some price is (a) State
(a) Agreement (b) Copyright (b) State-
(c) License (d) Patent (c) State-
(d) State

090 Page 8 090

83. Consider the following series
ser=pd. Series ([ 'C','o','M','F' , 'O','R','T','A','B','L', 'E'],
index=[1,2,3,4,5,6,7,8,9,10, 11])
print (ser [4:]1)
(a) (b)
4 F 4 F
(c)
4 F
(d)
5 O 5 O 5 6 R
6 R 6 R 6 R 7 T
7 T 7 T 7 T 8 A
8 A 8 A 8 A 9 B
9 B dtype: object 9 B 10 L
10 L 11 E
dtype: object |
11 E dtype: object
dtype: object
34. Nowadays for developing Machine learning projects programmers rely on
CSV files rather than databases. Why?
(a) csv can be used with proprietary softwares only.
(b) cSv files can be downloaded from open source websites free of cost.
(c) csv files need not be imported while creating the projects
(d) csv is a simple and well formatted mode for data storage
35. Companies get their Trademark registered to protect ?
(a) logos, names and brands
(b) word, phrase, or symbol
(c) slogans, stylized fonts, and colors
(d) company furniture, worker, brands
36. DataFrames can be created from ?
(a) lists (b) dictionaries
(c) series (d) all of the above
37. Rohit forgot his laptop in his car and when he came back he found his laptopP
was missing. This act is
(a) Cyber crime (b) Phishing
e) Theft (d) Plagiarism
38. Consider the following statements
Statement A : loc) is a label based data selecting method to select a specific
row(s) or column(s) which we want to select.
Statement B : iloc()can not be used with default indices if customized
indices are provided.
a) Statement A is True but Statement BB isis False
True
(b) Statement A is False but Statement
B both False
(c) Statement A and Statement B both are
are
True
(d) Statement A and Statement

090 Page 9 P.T.O.

 39. Abhay is a student of class XIT, and he is aware of some concepts of python.
He has created the DataFrame, but he is getting errors after executing the
code. Help him by identifying the correct statement that will create the
DataFrame:
Code
import pandas as pd
stuname=[ Muskan', 'Radhika', Gopar', 'Pihu']
terml=[70, 63,74,90]
term2=[67,70,86, 95]
(a) df=pd.DataFrame(("Name":stuname,"marks1":terml),"marks2":term2))
(b) df-pd.dataframe([stuname, terml,term2).columns=['stuName',"marksl
"marks2"))
(c) df-pd.DataFrame({stuname,terml,term2})
(d) df-PD.dataframe({stuname, terml,term2))

40. Ms. Kalpana is

working with an IT company, and she wants to create charts
from the data provided to her.
She generates the following graph
ipare
company profit per month
40000 month_number

350000

300000

250000

200000

month number 12

ilalalals
Which statement is used to mark the line
given in the above fig.:
as
(a) plt.plot(x,y, marker=#,markersize=10,color='red',linestyle='dashdot)
(b) plt.plot(x,y,marker='star,markersize=10,color=red')
(c)
plt.plotx,y,marker=@,markersize=10,color='red',linestyle='dashdot)
(d) plt.plot(x,y,marker=*", markersize=10,color="red)

90
Page 10
 Mr. Raman created a DataFrame from a Numpy array
41,
64]])
arr np.array([2, 4, 8], [3, 9, 271,[4,16,
,three'l
df-pd.DataFrame (arr,index=[ 'one','two'
print (df)
DataFrame
him to add a customized column labels to the above
Help
(a) columns='no', 'sq', 'cube'
b) column=[no', 'sq', 'cube'
()columns=[no','sqg, 'cube] www.mycstutorial.in
(d) columns=[['no', 'sq', 'cube']

42. What will be the output

of the following program
import pandas as pd

dic='Name' : ['Sapna', Anmol','Rishul','Sameep']

Agg':[56, 67,75, 761, 'Age' [16,18,16,19]}
df-pd.DataFrame (dic,columns=[ 'Name', 'Age'1)
print (df)

Name Agg Age b) Name Agg Age

(a)
101 Sapna 56 16 0 Sapna 56 16

67 18 1 Anmol 67 18
102 Anmol

103 Rishul 75 16 2 Rishul 75 16

76 19 3 Sameep 76 19
104 Sameep
(d) Name Age
(c) Name
0 Sapna 16
0 Sapna
1 Anmol1 1 Anmol 18

2 Rishul 2 Rishul 16
3 Sameep 19
3 Sameep

090 Page 11 P.T.O.

 43. Consider the following code
import pandas as pd
'b', 'c',d'])
Sl-pd.Series ([23,24,35,56], index=[ 'a',
$2pd.Series ( [27,12,14,15],
index=[ 'b','y' ,'c','ab'1)
df-pd.DataFrame (S1+$2))
print (df)
Output for the above code will be:
(a) (b)
a NaN a 50
ab NaN b 36
b 51.0 C 49
c 49.0 d 71
d NaN
y NaN

(c) O (d)
b 50 a NaN
y 36 ab NaNN
C 49 b NaN
ab 71 C NaN
d NaN
y NaN

44. Sudhanshu has written the following code to create. a DataFrame with
boolean index:
import numpy as np
import pandas as pd
df-pd.DataFrame(data=[[5,6,711,index=[true,false, true])
print (df)
While executing the code, she is getting an error, help her to rectify the code:
(a) df-pd.DataFrame((True,False,True),data=[5,6,7])
(b) df-pd.DataFrame(data=[5,6,7],index=[True,False,True])
cdf-pd.DataFrame([true,false, true],data=[6,6,7)
(d) df=pd.DataFrame(index=[true,false,true].data=[5,6,7]1)
45. The rights of the owner of information to decide how much information is to
be shared/exchanged/distributed, are collectively known as
(a) Intelligent Portable Rights (b) Intellectual Property Rights
(c) Interactive Property Rights (d) Instance Portability Rights
090 Page 12
46. Abhilasha forgot to sign out fnrom her gmail id and Aditi used Abhilasha's
gmail id to send mail. This act of Aditi is considered as
(a) Plagiarism (b) Identity Theft
(c) Phishing (d) Piracy

47. The trail that is automatically created when a person uses the internet on
any digital devices like Laptops, smart phones, tablets etc is called
(a) Cyberbullying (b) Phishing
(c) Digital Footprint (d) Digital Activity

48. operating system comes under FOSS.

(a) Windows (b) Ubuntu
c) Mac (d) Oracle

49. Sushila has created a DataFrame with the help ofthe following code;
import pandas
EMP=[EMPID': ['E01',E02, E03, E04',E05),
EMPNAME KISHORI,PRIYA', DAMODAR,REEMA', MANOJ],
EMP_SALARY: [67000,34000,68000,90000,43000]

df-pandas. DataFrame(EMP,index=[001',002,003,004',0057)
print(df.loc[0:3,:1)
and she wants to get the following output
EMPID EMPNAME EMP_SALARY
001 E01 KISHORI 67000
002 E02 PRIYA 34000
003 E03 DAMODAR 68000
Help her to correct the code
(a) print(df.iloc['001003',:]) (b) print(a£.locf001:003:1)
(c) print(EMP[loc[0:3,:11) (d) print(df.loe[001' 004',:)

090 Page 13 P.T.O.

 SECTION- C
5 questions
questions(50-55).
Attempt any
Section C consists of 6
Case Study
students of her class. She
maintains the records of all
Ms Ramdeep Kaur
wants to perform some operations on the data

Codeimport pandas as pd
t(Rollno':
[101,102,103,104,1005,106,107],

Gurpreet','Arpit',
Name' [Shubrato' 'Krishna','Pranshu','
Sanidhya', 'Aurobindo' ],
Age' [15,14,14,15,16,15,16],
Marks': [77.9,70.4,60.9, 80.3,86.5,67.7,85.01,
Grade' ['11B','11A','11B','11c','11E', '11a',
'11C'1}
70])
df= pd.DataFrame (t, index=[10,20,30,40,50,60,
print(df)
Output of the above code:
Rollno Name Age Marks Grade
10 101 Shubrato 15 77.9 | 11B
20 102 Krishna 14 70.4 11A
30 103 Pranshu 14 60.9 11B
40 104 Gurpreet 15 80.3 |11C
50 105 Arpit 16 86.5 11E
60 106 Sanidhya 15 67.7 11A

70 107 Aurobindo 16 85.0 11C

Based on the given information, answer questions No. 50-55.

50. Select the correct statement for the below output:

Name Krishna
Age 14
Marks 70.4
Grade 11A
Name 20, dtype: object
(a) print(df.iloc[2]) (b) print(df.loc[2])
(c)print(df.iloc[20]) (d) print(df.loc[20])
In given output, Rollno is missing, Otherwise D.

090 Page 14
51. The teacher wants to know the marks secured by the second last student
only. Which statement would help her to get the correct answer ?
(a) print(df.loc[60:70,Marks']) ) print(df.loe[60:60, Marks])
(c) print(df.iloc-2:-2],[Marks]) (d) print(df-2:-2||Marks])

52. Which of the following statement(s) will add a new column fee' at second
position with values [3200,3400,4500,3100,3200,4000,3700] in DataFrame df?
(a) df.insert(loc=2,colurnn=fee', value=[3200,3400,4500,3100,3200,4000,
3700))
(b) df.add(2,column='fee, [3200,3400,4500,3100,3200,4000,3700])
df.appendloc=2,fee'=[3200,3400,4500,3100,3200,4000,3700])
(d) dfinsertloc=2,fee,[3200,3400,4500,3100,3200,4000,37001)
53. Which of the following commands is used to delete the column 'Grade' in the
DataFrame df?
(a) df.drop(Grade',axis=l,inplace=True)
b) df.drop(Grade,axis=0,inplace=True)
(c)df.drop[Grade,axis=l,inplace=True]
(d) df.delete(Grade',axis=l,inplace=True)

54. Which of the following commands would rename the column Marks' to
Halfyearly' in the DataFrame df?
(a) df.rename((Marks,Halfyearly],inplace=True)
df.rename(Marks',Halfyearly},inplace=True)
(b)
(c)dfrename(columns=(Marks':Halfyearly'},inplace=True)
(d) df.rename((Marks' Halfyearly),inplace=True)
55. Which of the following commands will display the Names and Marks of all
students getting more than 80 marks?
(a) print(df.loc[Marks'>80,[Name,Marks])
(b) print(d£locjdf
Marks]<80, Name, Marks)
()print(df.loc(df|Marks]<80,[Name',Marks"]))
(d) print(d£loc[df[Marks']>80,[Name',Marks])

090 Page 15