Page 25 - IPP-12-2025

The number of computers in each department/office is as follows:
IT 80
SALES 50
HR 20
ENGINEERING 200
HYDERABAD REGIONAL OFFICE 90

(a) Suggest the most suitable department in the Bengaluru office to install the server. Give a reason to
justify your suggested location.
(b) Draw a suitable cable layout of wired network connectivity between the departments at the
Bengaluru office.
(c) Which networking device would you suggest the college to purchase to interconnect all the computers
within a department at the Bengaluru campus?
(d) The company is considering establishing a network connection between its Bengaluru office and Hyderabad
regional office. Which type of network—LAN, MAN or WAN—will be created? Justify your answer.
(e) The company plans to develop an online portal where employees can log in to check attendance, view
scores and projects. Would you recommend a static or dynamic website for this purpose? Justify your
recommendation.
Ans. (a) The server should be installed in Engineering block due to the presence of maximum number of
computers.
(b)

IT

Sales HR

Engineering

(c) Hub/Switch
(d) WAN will be created as the distance between Bengaluru office and Hyderabad regional office is more
than 50 km.
(e) Dynamic website is recommended as it displays dynamic data for each employee.
36. Consider the given dataframe df1. [5]

TeacherID TeacherName Class Experience NoOfPeriods
0 1001 Ms. Nisha 12 25 17
1 2003 Mr. Rahul 11 9 16
2 3009 Ms. Nidhi 12 12 18
3 4007 Mr. Manoj 10 8 15
4 5003 Ms. Veena 11 10 16
Write Python statements for the dataframe df1 to:
(a) Print the first four rows of the dataframe df1.
(b) Display the names of all the teachers in the dataframe.
(c) Add a new column Subject and set its value as ‘IT’ for all teachers.
(d) Retrieve and display TeacherName and Experience columns for teachers who are teaching Class 12.
(e) Rename the column name Experience to Experience(in years).

Model Test Paper M.22
41