NPS School, TechCbse
Term-I Mock Test 2021-22
Subject: Informatics Practices (Code-065)
Class – XII Time Allowed: 90 minutes Maximum Marks: 35
General Instructions:
∙ The paper is divided into 3 Sections- A, B and C.
∙ Section A, consists of Question 1 to 25 and student need to attempt 20 questions.
∙ Section B, consists of Question number 26 to 49 and student need to attempt 20 questions.
∙ Section C, consists of Question number 50 to 55 and student need to attempt 5 questions.
∙ All questions carry equal marks. Section – A Section A consists of 25 questions, attempt any 20 questions.
—————————————————————————————————————————–
Section-A
Q.1 What is the correct syntax to return both the first row and the second row in a Pandas DataFrame df?
A. df.loc[[0,1]] B. df.[[0,1]] C. df.loc[[0-1]] D. df.[[0-1]]
Q.2 If df is a dataframe then print(df) will print
A. The first ten rows
B. The first five rows
C. The first five and last five rows
D. The first ten and the last ten rows
Q.3 The following table shows the python code and its expected output. Choose the correct word for blank space in line 3 for printing the column:
A. index B. column C. col D. heads
Q.4 What is the correct output for following Python code:
import pandas as pd
data = {“Marks1”: 90, “Marks2”: 95, “Marks3”: 97}
ser = pd.Series(data)
print(ser)
A. Marks1 90 Marks2 95 Marks3 97 dtype: int64 B. Marks1 90 Marks2 95 Marks3 97 dtype: int16
C. Marks1 Marks2 Marks3 90 95 97 D. Marks1 Marks2 Marks3 90 95 97 dtype: int64
Q.5 Pandas Series can be created from:
A. Scalar values B. NumPy arrays C. dictionary D. All of the above
Q.6. Which is the best analogy of digital footprint:
A. Our foot print when we walk over sand of sea beach
B. Our foot print when we walk over the cement road constructed few minutes back
C. our foot print when we enter inside our home with dirty feets.
D. All of the above Ans B (since after drying, foot prints are retained for years)
Q.7 . Digital footprint are not created :
A. when we do online shopping B. when we create our e-mail address
C. when we watch youtube videos D. When we send e-mail
Q. 8: Statement A : Data visualization refers to the graphical representation of information and data using visual elements like charts, graphs and maps etc.
Statement B : To install matplotlib library we can use the command pip install matplotlib.
a. Both statements are correct.
b. Both statements are incorrect.
c. Statement A is correct, but Statement B is incorrect
d. Statement A is incorrect, but Statement B is correct
Q. 9: Statement A : Digital footprint is the trail of data we leave behind when we visit any website (or use any online application or portal) to fill-in data or perform any transaction.
Statement B : While online, all of us need to be aware of how to conduct ourselves, how best to relate with others and what ethics, morals and values to maintain.
a. Both statements are correct. b. Both statements are incorrect.
c. Statement A is correct, but Statement B is incorrect d. Statement A is incorrect, but Statement B is correct
Q. 10: Statement A : An Internet troll is a person who deliberately sows discord on the Internet by starting quarrels or upsetting people.
Statement B : We can download and use any material available on the Internet.
a. Both statements are correct. b. Both statements are incorrect.
c. Statement A is correct, but Statement B is incorrect d. Statement A is incorrect, but Statement B is correct
Q. 11: Statement A : Social media are websites or applications that enable their users to participate in social networking but they cannot create and share content with others in the community.
Statement B : We should not waste precious time in responding to unnecessary emails or comments unless they have some relevance for us.
a. Both statements are correct. b. Both statements are incorrect
c. Statement A is correct, but Statement B is incorrect d. Statement A is incorrect, but Statement B is correct
Q.12. Pushp, a student of class-XII, has been assigned a code to create a pandas series S1, as shown below.
a 100 b 200 c 300 d 400 e 500 dtype: int64
With reference to the above, answer the given questions:
i. Choose the command that will give the following output: b 200 c 300 dtype: int64
a. print(S1[:3]) b. print(S1[0:3])
c. print(S1[2:4]) d. print(S1[1:3])
Q.13. Help him to identify the correct statement that can be used to extract the value with the index ‘c’:
a. print(S1[c]) b. print(S1(c))
c. print(‘S1’ [‘c’]) d. print(S1 [‘c’])
Q.14. Which of the following command will give the following output: b 200 d 400 dtype: int64
a. print(S1.iloc[1:4]) b. print(S1.iloc[2:4])
c. print(S1.iloc(1:4)) d. print(S1.iloc[1:4:2])
Q.15. Which of the following command will display the series by adding 10 in each value.
a. print(S1 [+10]) b. print(S1+10) c. print(S1)+10 d. print(S1)+print(10)
Q.16. Pushp wants to delete the value against index ‘d’. Help him to choose the suitable option to do so:
a. S1=S1.drop(d) b. S1=S1.drop(‘d’) c. S1=drop(‘d’) d. S1=S1.drop[‘d’]
Q.17. Answer the question based on the Assertion A and Reason R given.
A:A Series is a one-dimensional array containing a sequence of values of any data type (int, float, list, string, etc).
R:Pandas Series can be imagined as a column in a spreadsheet.
a. Both A and R are true and R is the correct explanation of A.
b. Both A and R are true but R is not the correct explanation of A.
c. A is true but R is false.
d. A is false but R is true.
e. Both A and R are false.
Q.18. _____________ takes an integer value that corresponds to its position in the series starting from 0.
a. Positional index b. Labelled index c. Both d. None of the above
Q.19. Which of the following statement is wrong?
a. We can create Series from Dictionary in Python.
b. Keys of dictionary become index of the series.
c. Order of indexes created from Keys may not be in the same order as typed in dictionary.
d. All are correct.
Q.20. Which of the following is/are threats for electronic payment systems?
a). Computer worms b). Computer virus
c). Trojan horse d). All of the above
Q.21. Firewalls are used to protect against ——–
a). data driven attacks b) fire attacks
c) virus attacks d) unauthorized access
Q.22. the act of copying another person’s ideas, words or work and pretending they are your own is known as
a. Plagiarism b. Licensing c. Open Source d. Bullying
Q.23. Denoting software for which the original source code is made freely available and may be redistributed and modified is known as
a. Proprietary S/W b. Open Source S/W c. Freeware d. Custom S/W
Q.24. Which of the following is True in case of Cyber stalkers
Statement I: Cyber stalkers collect all personal information of the victim
Statement II: Cyber stalkers keep on sending emails to threaten the victim
Statement III: Cyber stalkers are people who save us from hackers
Statement IV: Cyber stalkers post the email of victim on numerous filthy, obscene or illegal websites
a) Statements I, II are True b) Statements I is only True
c) Statements I, II and IV are True d) None of the above are True
Q.25. The practice of sending fraudulent communications that appear to come from a reputable source. It is usually done through email. The goal is to steal sensitive data like credit card and login information. a. Bullying b. Plagiarism c. Phishing. d. Licensing
Section-B
Q.26. Electronic products that are unwanted, not working, and nearing or at the end of their “useful life.”, known as
a. Computer Waste b. E- Waste c. Biological Waste d. Chemical waste.
Q.27. Which of the following comes under cyber crime?
a. Theft of a brand new sealed Laptop
b. Access to a bank account for an unauthorized money transaction
c. Modification in a company’s data with unauthorized access.
d. Photocopying a printed report.
Q.28. Which is not a measure to recycle your e- waste safely.
a. Use certified e-waste recycler b. Visit Civic institutions for recycling options.
c. Through it in water or dig them in earth. d. Donate your electronics.
Q.29. ________________ is an electronic discovery technique used to determine and reveal technical criminal evidence.
a). Cyber forensics b).. Auction Fraud c) Identity theft d) . Spoofing
Q.30. Open source S/w out of the following.
a. Python b. MS office c. Windows d. Kaspersk
Q.31. Data visualization tools provide an accessible way to see and understand……………….in data.
a) Trends b) Outliers c) Patterns d) All of these d
Q.32. Which Python library programmer can use to create chart?
a) pyplot b) pandas c) numpy d) None of these
Q.33. A chart created using python library can be exported to image form or not?
a) Yes b) No
Q.34. Can the same data series be used to draw multiple charts?
a) Yes B) No
Q.35. If manager asks to create a chart with explode feature, which chart can be created by programmer in that case?
a) Bar Graph b) Line Chart c) Pie Chart d) All of these
Q.36. Which of the following method can be used to plot a Pie chart of the given case?
a) Pl. Plot() b) Pl. Pie() c) Pl. Chart() d) Pl. Disc ()
Q.37. Which of the following function can be used to set the title of the pie chart?
a) plt. set Title() b) plt. heading() c) plt. title() d) none of these
Q.38. School have 6 sections in Class XI Namely A, B, C, D, E and F. Students have voluntarily decided to collect amount section wise separately. Amounts collected by sections A to F are 5000, 6000, 5600, 7000, 6500 and 4900. Which of the data types can be used to arrange the collection amount and sections to be used with plotting function
a) list b) dictionary c) stack d) none of these
Q.39. Which of the following method can be used to add formatted slice percentage to Pie Chart?
a) autopct b) slice c) labels d) colors
Q.40. Which attribute of Pie chart is used to set the color of each slice?
a) color b) colors c. cols d. autocolor
Q.41.The garbage of electronic gadgets such as computer peripherals, laptop accessories, mobiles is known as _________.
(a) Electronic waste (b) Electrical waste
(c) Garbage of Goods (d)None of the above
Q.42. In India, E-Waste management assumes greater significance because
(a) generation of own e-waste (b)dumping of e-waste from developed countries
(c)lack of awareness (d)All of these
Q.43. Which of the following is one of the impacts of e-waste on the environment?
(a) Global Warming (b) deforestation
(c)soil erosion (d)emission of gases
Q.44. Which of the following is/are threats for electronic payment systems?
a). Computer worms b). Computer virus
c). Trojan horse d). All of the above
Q.45. Firewalls are used to protect against ——–
a). data driven attacks b) fire attacks
c) virus attacks d) unauthorized access
Q.46. the act of copying another person’s ideas, words or work and pretending they are your own is known as
a. Plagiarism b. Licensing
c. Open Source d. Bullying
Q.47. Which attribute of a dataframe is used to convert rowa into columns and columns into rows in a dataframe?
a) T b) ndim c) empty d) shape 1
Q.48. df.index properties can be used to
i. rename rows ii. rename columns
iii. rename rows and columns both iv. None of these
Q.49.To display 2 rows from the top in the dataframe,
which of the following statement is correct:
i. df.head()=2 ii. df.head(n=2) iii. df.head(range(2)) iv. All of the above
Section-C
Case 1 ABC Enterprises is selling its products through three salesmen and keeping the records of sales done quarterly of each salesman as shown below:
Quarter 1 Quarter 2 Quarter 3 Quarter 4
Salesman 1 23000 18000 30000 35000
Salesman 2 11000 15000 20000 22000
Salesman 3 60000 40000 35000 55000
Company is storing the above information in a CSV file “Qtrly_Sales.csv”. Mr. Rohit is a programmer. Company has given him the responsibility to create the program to visualise the above data. He wrote Python code but he is facing some difficulties. Help him by giving the solutions of following situation:
Python code:
1 import pandas as pd
2 import ________________ as plt
3 df=__________(“Qtrly_Sales.csv”)
4 df.plot(__________=’bar’, color=[‘red’,’blue’,’brown’,’green’])
5 plt.___________(‘Quarterly Report’)
6 plt.xlabel(‘Salesman’)
7 plt.ylabel(‘Sales’)
8 plt._________()
Q.50: Choose the correct Python library out of following options in line 2
A. matplotlib B. matplotlib.plot C. py.plot D. matplotlib.pyplot
Q.51: Choose the correct option to read the csv file in line 3
A. read_csv B. pd.read_csv C. pd.get_csv D. get_csv
Q.52: Choose the correct option to select the type of graph in line 4
A. type B. kind C. style D. graph
Q.53: Choose the correct word to give the heading in line 5
A. label B. heading C. title D. caption
Case 2: Abhishek uses computer and mobile for his personal use. Study the following cases and answer the questions given below.
(1) Once he got the message in Whatsapp that CBSE is announcing the result of class XII tomorrow at 12:00 pm. He forwarded the message to his few friends. But later he came to know that no such announcement was there in CBSE official web-site.
(2) He is visiting several web-sites.
(3) He is getting abuse messages from an unknown number due to which he is thinking of quarrelling with that person.
(4) He registered himself in one website by giving his email id and phone number but later his friend told him about the concept of digital footprint. He is now thinking about cancelling the registration so that his personal information can be deleted from that website.
(5) He uploaded one video in his youtube channel where he used one background music downloaded from somewhere on Internet
Q.54: In case (1), he is violating :
A. net etiquettes B. Communication etiquettes
C. copyright D. None of the above
Q.55: In case (2) , he is leaving:
A. Active digital footprint B. Passive digital footprint
C. There is no chance of any digital footprint D. None of the above
