BHARATIYA VIDYA BHAVAN, KOCHI

TERM END EVALUATION 2023-2024

INFORMATICS PRACTICES (065)
Std XII MARKS:70
TIME: 3 hrs
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. All programming questions are to be answered using Python Language only.

PART A
1. Which network topology connects all devices in a linear fashion? 1
a) Bus b) Star c) Ring d)Mesh
2. What is a pandas DataFrame? 1
a) A data structure for storing a single dimensional labeled array.
b) A 2-D, size-mutable and heterogenous tabular data structure.
c) A python module for mathematical operations.
d) A visualization library for data analysis.
3. Minimum number of arguments required in pandas Series function for creating a non-empty 1
series is ____________.
a) 0 b)1 c) 2 d) 3
4. In SQL, which function is used to display current date and time? 1
a) Date () b) Time () c) Current () d) Now ()
5. How many values will be there in array1, if given code is not returning any error? 1
>>> series4 = pd.Series(array1, index = [“Jan”, “Feb”, “Mar”, “Apr”])
a) 1 b) 2 c) 3 d) 4
6. To display the last 5 values of a dataframe df, you may write: 1
a) df.head(5) b) df.Tail() c) df.tail() d) df.Head()
7. Ananya wants to store her Term-I mark in a Series which is already stored in a NumPy array. 1
Choose the statement which will create the series with Subjects as indexes and Marks as
elements.

import pandas as pd
import numpy as np
Marks =np.array([30,32,34,28,30])
subjects = ['English','Maths','Chemistry','Physics','IP']
Series1= _______________________________

a) pd.Series(Marks,index=subjects) b) pd.Series(np.Marks,index=subjects)
c) pd.Series(index=Marks, subjects) d) pd.Series(Marks,index)
8. Which of the following attribute is used to assigns a name to the index of the Series. 1
a) name b) index c) index.name d) All of the above
9. In a DataFrame, Axis= 1 represents the elements 1
a) columns b)first column c) rows d) first row

1
10. Which of the following is the correct output for the following sql command : 1
Select round(6754.89)
a) 6754.9 b) 6750 c) 6754 d) 6755
11. Rajesh has purchased a new Smart TV and wants to cast a video from his mobile to his new 1
Smart TV. Identify the type of network he is using:
a) LAN b) WAN c) MAN d)PAN
12. The location of a resource on the internet is given by its _____ 1
a) Protocol b) URL c) e-mail address d) ICQ
13. It can be a software program or a hardware device that filters all data packets coming through 1
the internet or a network it is known as the_______:
a) Antivirus b) firewall c) cookies d) malware
14. What does the trim() function in mysql do? 1
a) Removes spaces from the beginning and end of a string
b) Adds spaces to a string
c) Counts the number of characters in a string
d) Replaces specific characters in a string
15. What will be the output of the following mysql command? 1
Select mod(pow(2,3),3);
a) 1 b) 2 c) 3 d) 4
16. Which module of matplotlib library is required for plotting a graph ? 1
a) Plot b) graphics c) matplot d) pyplot
Q. 17 and 18 are ASSERTION (A) and REASONING (R) based questions.
Mark the correct choice as
a) Both (A) and (R) are true and (R) is the correct explanation for (A).
b) Both (A) and (R) are true and (R) is not the correct explanation for (A).
c) (A) is true and (R) is false.
d) (A) is false but (R) is true.
17. Assertion (A) : The output of addition of two series will be NaN, if one of the elements or 1
both the elements have no value(s).
Reason (R) : While performing mathematical operations on a series, by default all missing
values are filled in with 0.
18. ASSERTION(A) : A histogram is basically used to represent data provided in the 1
form of groups spread in non-continuous ranges
REASON(R) : matplotlib.pyplot.hist() function is used to compute and create
histogram of a variable.
PART B

19. Explain the terms web page and home page? 2

20. What is the purpose of Order By clause in SQL? Explain with the help of suitable example. 2
21. Write a program to create a series object that stores the number of students in each division of 2
class 12 of your school.
Assume there are 4 divisions A,B,C,D and 40,44,42,41 students respectively.
22. What are plug-ins? Give examples of any 2 plug-ins 2
23. What are cookies? How can we disable cookies? 2
24. What is the function of a gateway? 2

2
25. Consider the dataframe rainfall 2

Write python statement for the following:

i. Set the row labels as 2018,2019,2020,2021,2022.
ii. List the column names of the dataframe rainfall.
SECTION - C

26. Consider the table Training 3

Predict the output for the following:

i. Select substr(City,2,4) from training where topic<> “Cyber security”;
ii. Select name from training where instr(email_id, “@”)>4;
iii. Select mod(fee,10) from training;
27. Write a Python code to create the following DataFrame df : 3
Population Schools Hospitals
Chennai 40 200 500
Delhi 10 250 200
Kolkata 30 400 100
Mumbai 20 350 300
28. Consider the dataframe Stock

Name Price 3
101 Fridge 50000
201 Washing Machine 24000
301 Microwave 20000
i. Add a column called Discount% with the following data: [20,20,5].
ii. Add a new item named ‘Air conditioner' having price 35000 and discount 10% at
index 401.
iii. Remove the column Discount.
29. Define the following: 3
i. Switch
ii. Repeater
iii. Modem
30. Write the output of the following SQL queries: 3
i. Select length(### “Vasudhaiva#Kutumbakam”); (# represent a space)
ii. Select pow(4,2);
iii. Select round(980.8,-2);

3
 SECTION D

31. Consider the table student: 5

Write SQL queries to perform the following operations:

i. Display the first 3 characters of all names in uppercase.
ii. Display the details of the students of commerce stream.
iii. Display the details of those students who are born in the month of June.
iv. Display the details of those students who pay fees between 10000 and 20000.
v. Display the names of the students whose marks are not available.
32. Prime Computer Services LTD is an international educational organization. It is planning to 5
set up its India campus at Mumbai with its head office in Delhi. The Mumbai office campus
has four main buildings – ADMIN, ACCOUNTS, EXAMINATION and RESULT.
You as a network expert have to suggest the best network related solutions for their problems
(i) to (v), keeping in mind the distances between the buildings and other given parameters.

Examination Admin
Delhi Head Office

Accounts Result

Shortest distances between various buildings:

Admin to Accounts 55m

Admin to Examination 90m
Admin to Result 50m
Accounts to Examination 55m
Accounts to Result 50m
Examination to Result 45m
Delhi head office to Mumbai Campus 2150m

Number of computers installed at various buildings are as follows:

Admin 110
Accounts 75
Examination 40
Result 12
Delhi Head Office 20

i. Suggest the most appropriate location of the server inside the Mumbai campus to
get the best connectivity for maximum number of computers. Justify your answer.

ii. Suggest and draw cable layout to efficiently connect various buildings within the
Mumbai campus for a wired connectivity.
4
 iii. Which networking device will you suggest to be procured by the company to
interconnect all the computers of various buildings of Mumbai campus?
iv. Company is planning to get its website designed which will allow students to see
their results after registering themselves on its server. Out of static or dynamic,
which type of website will you suggest?

v. Which of the following will you suggest to establish the online face to face
communication between the people in the admin office of Mumbai campus and
Delhi head office?
a) Cable TV
b) Email
c) Video Conferencing
d) Text chat

33. Write python code to plot a bar chart for India’s medal tally as shown below. Also give 5
suitable python statement to save this chart.

SECTION E

34. Consider the table Library. 4

Write SQL queries for the following:

i. Display the names of the books of category comedy and education.
ii. Display the details of the books in the ascending order of price.
iii. Display the details of the books purchased in the year 2006.
iv. Display the names of the books that starts with the letter “A”.

5
35. Consider the dataframe df: 4

Write python statements for the following:

i. Display the Name of student who has got more than 50 marks in UT1.
ii. Increase the marks in UT2 of all students by 5.
iii. Display the record of the student with roll no 13.
iv. Rename the column UT1 to PT1 and UT2 to PT2.

************************************

6
 ALL KERALA BHAVAN’S MODEL EXAMINATION

2022-23

Class : XII Max. Marks : 70

Subject : Informatics Practices (065) Time : 3 Hours

General Instructions

● This question paper contains five sections, Section A to E.

● All questions are compulsory.
● Section A has 18 questions carrying 01 mark each.
● Section B has 7 very short answer type questions carrying 2 marks each.
● Section C has 5 short answer type questions carrying 3 marks each.
● Section D has 2 questions carrying 4 marks each.
● Section E has 3 questions carrying 5 marks each.

SECTION A

1. Predict the output of the following query:

SELECT MOD (9, 0);
a) 0 b) NULL c) NaN d) 9
2. CSV stands for:
a) Column Separated Value b) Class Separated Value
c) Comma Separated Value d) Common Separated Value
3. When e-waste such as electronic circuit boards are burnt for disposal, the elements contained in
them create a harmful chemical called ________ which causes skin diseases, allergies and an
increased risk of lung cancer.
a) Hydrogen b) Beryllium c) Chlorine d) Oxygen
4. Computers connected to a LAN can
a) Run faster b) Go on line
c) E-mail d) Share information and/or share peripheral equipment
5. Which of the following is not a type of cybercrime?
a) Data theft b) Forgery
c) Damage to data and system d) Installing antivirus for protection
6. Write the output of the following:
S1=pd.Series (14, 7, index = [‘a’, ‘b’, ‘c’])
print(S1)
a) a 14 b) a 14 c) Error d) None of the above
b7 b7
7. Which of the following is generally used for performing tasks like creating the structure of the
relations, deleting relation?
a) DML (Data Manipulating Language) b) Query
c) Relational Scheme d) DDL (Data Definition Language)
8. Which type of topology is best suited for large businesses which carefully control and coordinated
the operation of distributed branch outlets?
a) Ring b) Bus c) Star d) Tree
9. Pyplot is a _________
a) Module b) Library c) Function d) Collection
10. To connect networks of similar protocols ___________ is used.
a) Routers b) Bridges c) Gateways d) Dial-up routers
11. How can you export DataFrame to a CSV file?
a) df.export_csv(‘file.csv’) b) df.save_csv(‘file.csv’)
c) df.to_csv(‘file.csv’) d) df.write_csv(‘file.csv’)
12. Which type of database management system Is MySQL?
a) Object-oriented b) Hierarchical c) Relational d) Network
13. How to add two pandas series together?
a) series1 + series2 b) pd.concat([series1, series2])
c) pd.merge(series1, series2) d) series1.append(series2)
14. What will be the output of the query:
SELECT LENGTH(“SUPREME”);
a) 7 b) 6 c) 8 d) 9
15. How can you group the result of a query by the column “Category” and calculate the average of
the column “Price”?
a) Using GROUP BY and AVG b) Using HAVING and SUM
c) Using ORDER BY and MIN d)Using MAX and COUNT
16. Which of the following is disadvantage of open source software?
a) Low quality software b) It is customizable
c) Might have bugs as not tested critically d) It is free
Q17 and 18 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.
17. Assertion (A) : Indexing using labels can be performed on a Pandas Data Frame.
Reasoning (R) : Indexing using labels can only be performed on a Pandas Series.
18. Assertion (A) : The Order By clause is used to sort the data in ascending or descending order
based on the values in specified columns.
Reasoning (R) : The Order By clause can be used with the SELECT statement.

SECTION B
19. Point-out the various ways to dispose the e-waste properly?
20. Name two threats to security in a network. What is the role of Firewall in Network security?
21. Differentiate between Bus Topology and Star Topology.
22. Consider the given SQL string:
“12#All the Best!”
Write suitable SQL queries for the following:
 i. Returns the position of the first occurrence of the substring “the” in the given string.
ii. To extract last five characters from the string.
23. Complete the given Python code to get the required output as:
Rajasthan import _________ as pd
di = {'Corbett': 'Uttarakhand', 'Sariska': 'Rajasthan', 'Kanha': 'Madhya Pradesh’, 'Gir':'Gujarat'}
NP = ___________. Series( _____ )
print(NP[ ___________ ])
24. What are aggregate functions in SQL? Name any two.
25. Write the advantages and disadvantages of ring topology.

SECTION C
26. Write MySQL statements for the following:
i. To create a database named FOOD.
ii. To create a table named Nutrients based on the following specification:

Column Name Data Type Constraints

Food_Item Varchar(20) Primary Key

Calorie Integer
27. Situ, recently started using her
social media account. Within a few days, she befriends many people she knows and some that
she does not know. After some time, she starts getting negative comments on her posts. She also
finds that her pictures are being shared online without her permission. Based on the given
information, answer the questions given below.
i. Identify the type of cybercrime she is a victim of.
ii. Under which act, she can lodge a complaint to the relevant authorities?
iii. Suggest her any two precautionary measures which she should take in future while
being online to avoid any such situations.
28. Consider the given DataFrame ‘Genre’:

Type Code
0 Fiction F
1 Non Fiction NF
2 Drama D
3 Poetry P

Write suitable Python statements for the following:

i. Add a column called Num_Copies with the following data: [400,390,650,560].
ii. Add a new genre of type ‘Folk Tale' having code as “FT” and 600 number of copies.
iii. Rename the column ‘Code’ to ‘Book_Code’.
29. What will be the output of the given code:
(i) SELECT MID(“INFORMATICS PRACTICES”, 3,2);
 (ii) SELECT POW(-2, 3);
(iii) SELECT REPEAT (“KEYS”,4)

30. Consider the given data frame ‘Employee’:

Empno Ename City

0 5 Rahul Delhi

1 4 Deepti Mumbai

2 6 Ansh Chandigarh

3 2 Gyan Delhi

4 3 Swati Chandigarh

(i). Display the shape of the above dataframe

(ii). Display the Ename and City column.
(iii). Remove City column.
SECTION D
31. Preeti manages database in a blockchain start-up. For business purposes, she created a table
named BLOCKCHAIN. Assist her by writing the following queries:

TABLE : BLOCKCHAIN

Id user value hash Transaction_date

1 Rahul 900 ERTYU 2020-09-19

2 Suma 145 @345r 2021-02-23
3 Anju 567 #wert5 2020-05-06
4 Keerti 678 %rtyu 2022-07-13
5 Birbal 768 rrt4% 2021-05-15
7 Jinu 534 wer@3 2022-11-29

i. Write a query to display the year of oldest transaction.

ii. Write a query to display the month of most recent transaction.
iii. Write a query to display all the transactions done in the month of May.
iv. Write a query to count total number of transactions in the year 2022.
32. Arun, a Data Analyst with a multinational brand has designed the DataFrame df that contains the
four quarter’s sales data of different stores as shown below:
Store Qtr1 Qtr2 Qtr3 Qtr4
0 Store1 300 240 450 230
1 Store2 350 340 403 210
2 Store3 250 180 145 160
Answer the following questions:
i. Predict the output of the following python statement:
a. print(df.size)
b. print(df[1:3])
ii. Delete the last row from the DataFrame.
iii. Write Python statement to add a new column Total_Sales which is the addition of all the 4 quarter
sales.

SECTION E

33. A company in Multi Enterprises has 4 wings of buildings as shown in the diagram:

Center to center distances between various Number of computers in each of the wing:
buildings:
W3 to W1 - 50 m W1 – 150
W1 to W2 - 60 m W2 – 15
W2 to W4 - 25 m W3 – 15
W4 to W3 - 170 m W4 – 25
W3 to W2 - 125 m
W1 to W4 - 90 m
Computers in each wing are networked but wings are not networked. The company has now decided to
connect the wings also.

a) Suggest a most suitable cable layout for the above connection.

b) Suggest the most appropriate topology of the connection between the wings.
c) The company wants internet accessibility in all the wings. Suggest a suitable technology.
d) Suggest the placement of the following devices with justification if the company wants
minimized network traffic
(i) Repeater (ii) Hub/Switch
e) The company is planning to link its head office situated in New Delhi with the offices in hilly
areas. Suggest a way to connect it economically.
34. Explain the following SQL functions using suitable examples:
(i) Now()
(ii) Substr()
(iii) Length()
(iv) Mod()
(v) Ucase()
35. The heights of 10 students of eighth grade are given below:
Height_cms=[145,141,142,142,143,144,141,140,143,144]
Write suitable Python code to generate a histogram based on the given data, along with an
appropriate chart title and both axis labels. Also give suitable python statement to save this chart.
 BHARATIYA VIDYA BHAVAN, KOCHI
First Model Examination
2023-2024
Std: XII Subject: Informatics Practices(065) Max. Marks:70
Set 4 Time: 3 Hours

SECTION A
1 Which of the following topologies connects each node to every other node in the network? 1
a) Star b) Mesh c) Tree d) Bus
2 By restricting the server and encrypting the data, a software company’s server is unethically 1
accessed in order to obtain sensitive information. The attacker blackmails the company to pay
money to get access to the data and threatens to publish sensitive information unless a price is
paid. This kind of attack is known as _______________.
a) Phishing b) Digital Footprint c) Ransomware d)Plagiarism
3 What is the maximum validity of a patent? 1
a) 30 years b) 5 years c) 20 years d) 10 years

4 What will be the output of the MySQL command: 1

Select round(6829.345,-2);
a) 6850 b)6800 c) 6829.34 d) 7000
5 Which of the following is used to display the data from a column after avoiding the 1
redundancy?
a) where b) unique c) distinct d) describe
6 Which of the following functions in MySql returns the number of characters in a string? 1
a) size( ) b) count( ) c)len() d) length( )
7 Which of the following is an open source software? 1
a) Audacity b)MS Word c) Adobe Photoshop d) Canva
8 Identify the aggregate function from the following. 1
a) instr() b) len() c)avg() d) mod()
9 Choose the correct MySQL query to display string ‘Hard work ’ in uppercase. 1
a) Select uppercase(‘Hard work’); b) Select ucase(Hard Work);
c) Select upper(‘Hard work’); d) Select largecase(‘’Hard work’);
10 Which of the following is not True with respect to group by clause? 1
a. The select statement containing a group by can contain any field name
b. The select statement containing a group by can use where clause

1
 c. Having clause cannot be used without group by clause
d. In a select statement, group by clause should be placed before the order by clause
11 Ashish wanted to delete a row labeled as ‘Term1’ from the dataframe exam. Which of the 1
following commands helps him to do the task?
a) exam.del(‘Term1’, axis=0)
b) exam.drop(‘Term1’)
c) exam.drop(‘Term1’, axis=1)
d) exam.remove(‘Term1’,axis=0)

12 Which of the following functions will create a horizontal bar chart? 1

a) hbar() b) barh() c) bar() d) histbar()

13 The part of the chart that identifies different sets of data plotted, by using different colours is 1
called ___________.
a) title b) xlabel c)legend d)show
14 Which of the following attributes will be used to display the size of a series object? 1
a) ndim b) size c) length d) nbytes

15 SELECT POW(INSTR(‘My_Database’,’_’),2); will give output as _________. 1

a) 4 b) 9 c) 16 d) 121
16 Presenting someone else’s idea or work as one’s own idea or work is called __________. 1
a) copyright infringement b) patent violation c) plagiarism d) hacking
Q17 and 18 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

17 Assertion: Email spoofing is an example for phishing. 1

Reasoning: Phishing is an unlawful activity where fake websites or emails that look original
or authentic are presented to the user to fraudulently collect sensitive and personal details.

18 Assertion: A natural join is an equi join 1

Reasoning: An equi join is a query that extracts the data from more than one table by
checking the equality of the common field.

SECTION B
19 Explain the term web hosting. Give examples of any two web hosting services. 2
OR
Alan is unable to understand the difference between static and dynamic websites. Help him by
explaining it with the help of examples.
20 2
Company Item Qty_purchased Unitprice

Chocolates Cadbury Diary Fruit ‘N’ Nut 10 42

Milk Amul Toned Taza 20 15

Biscuits Britannia Biscafe 15 24

Coffee Nescafe Gold Instant 1 490

2
 Consider the given dataframe products and write the output for the following.
a) print(products.iloc[1:3,2:])
b) print(products.loc['Chocolates'])
c) print(products.shape)
d) print(products.loc['Milk':'Coffee',['Item','Unitprice']])

21 Consider the given SQL string: 2

“FIRST MODEL EXAM”
Write SQL queries for the following
a) Extract the string ‘Model’ from the given string and print the same in lower case .
b) Display the length of the above string after removing the leading and trailing spaces.

22 Predict the output of the given Python code: 2

import pandas as pd
L1=[1,2]
x=pd.Series(L1+L1)
print(x)

23 Differentiate between the active digital footprint and passive digital footprint. 2

24 import pandas as pd 2
lst1=[10,20,30,40,50]
ser1=pd.Series(lst1)
print(ser1)
Rewrite the above given code to get the following outputs
a) ten 10
twenty 20
thirty 30
forty 40
fifty 50

b) twenty 20
thirty 30

2
25 What is the difference between where clause and having clause?
OR
Table emp contains 4 records and 3 columns. Table dept contains 6 rows and 2 columns.
What is the cardinality and degree of the cartesian product of the tables emp and dept?

3
 SECTION C

26 Based on the SQL table emp, write suitable queries for the following: 3

a) Display the names of all employees whose salary is greater than 25000 in alphabetical
order.
b) Display the job and the number of employees doing each job.
c) Display the deptno having more than 2 employees.
27 Write the Python code to create the data frame vehicle and print its contents. Also set the 3
column Vcode the row index and the first row(Vehiucle_type, Amt_per_km) as the column
headings.

Vcode Vehicle_type Amt_per_km

V01 VOLVO BUS 100

VO2 ORDINARY BUS 80

VO3 CAR 25

28 Write the SQL command to create the table STUDENT with the given structure. Also write 3
the sql command to display the structure of the table student.

COLUMNNAME DATA TYPE(SIZE) CONSTRAINT

Rollno int primary key

Name varchar(10) not null

Std char(3)

Division char(2)

Total_Mark int

29 Nirupama has recently shifted to a new school. Everyone in the school is new to her. She was 3
shocked to see someone posting negative comments on her social network profile. She found
someone following her online to defame her.
a) What is happening to Nirupama?
b) What should she do to stop these activities?
c) How can she avoid such situations not to happen in the future?
OR
4
 What is E-waste? Explain any two methods for management of E-waste.

30 Consider the dataframe student: 3

Name Class Division Fee_status

Ameera XII C yes

Bhavit XI A no

Priya XII A yes

Sunil XII B yes

Anand XI B no
i) Change the column heading Fee_status to Fee_paid.
ii) Retrieve the names of students who have paid the fees.
iii) Delete the column Division.

SECTION D
31 5
Consider the following table product and write SQL commands for the following

a) Add a new record to the table with suitable data.

b) Increase the price of all Samsung products by 2% of the existing price
c) Remove the details of all LG products whose qty is less than10
d) Add a new field taxamt into the table product
e) Display the name and month of manufacture of all products manufactured in the year
2022.

32 Consider the tables Employee and job given below. 5

Table: EMPLOYEE

CODE NAME SALARY ITCODE

1001 TANUSHA 60000.00 12

1002 SANJAY 70000.00 15

1003 ANEETA 45000.00 12

1004 USHA 50000.00 17

1005 ANJU NULL 17

5
 Table : JOB

ITCODE JOB

15 PROGRAMMER

17 ANALYST

12 ADMINISTRATOR

Write the SQL queries for the following

i) Display the name and job name of all employees
ii) Display the name, itcode and job of the employee whose salary is not given
Write the output of the following
iii) SELECT LEFT(NAME,3) FROM EMPLOYEE
WHERE LENGTH(NAME)>4 AND MOD (ITCODE,6 )<>0;
iv) SELECT NAME, SALARY+100 FROM EMPLOYEE WHERE NAME
LIKE ‘%U%’;
33 a) Write python code to create the following bar chart.Also give the python statement to 5
save this chart.

OR

b) Ms Sangeeta wants to plot a Line Chart for the given set of values of months on x
and number of participants who attended workshop in particular month on y-axis.
The number of participants for the months from Jan to June is as follows
participants=[15, 12, 20, 40, 60, 80]

6
 Give proper chart titles and labels. The color of the line should be green. Also give the
python statement to save this chart

SECTION E
34 Consider the given DataFrame sales. It shows the sales made by a few salesmen in two 4
different regions.

Write suitable Python statements for the following:

i) Add a new row to the Dataframe with relevant data.
ii)Add a new column “Total” which stores the sum total of the sales made in the two regions
iii)Display the sales made by Menuka in the region2
iv)Display the details of two salesmen whose sales were least in the region1
OR(Option for part iv only)
iv)Write a Python statement to import data from a csv file named players to the dataframe df8.
Assume necessary library files are imported.

7
35 Be Happy Corporation has set up its new centre at Noida, Uttar Pradesh for its office and 4
web-based activities. It has 4 blocks of buildings.

Distance between the various block is as shown below

A to B 40 m
B to C 120 m
C to D 100 m
A to D 170 m
B to D 150 m
A to C 70 m

Number of computers in each block

Block A 25
Block B 50
Block C 125
Block D 10

a) Suggest and draw the cable layout to efficiently connect various blocks of buildings
within the Noida center for connecting the digital devices.
b) Suggest the placement of the following device with justification
(i) Repeater
(ii) Hub/Switch
c) Which kind of network (PAN/LAN/WAN) will be formed if the Noida office is
connected to its head office in Mumbai?
d) Suggest the most appropriate location for the server to be placed to get the best
connectivity for the maximum number of computers. justify your statement.
8