CS101 Assignment no 04 Fall 2012 Solution By Virtual University of Pakistan

Assignment No. 04
Semester: Fall 2012
Introduction to Computing-CS101

Total Marks: 15

Due Date:24/01/2013

Instructions:

Please read the following instructions carefully before submitting assignment:

• You will submit your assignment before or on due date on VU-LMS.
• Assignment should be completed by your own efforts it should not be copied from internet, handouts or books.
• You should submit your MS Word File via assignment interface at VU-LMS.
• Assignment sent via Email will not be replied and accepted/graded in any case.
• If the submitted assignment does not open or file is corrupt, it will not be graded.
• You will submit solution only in MS Word file (.doc or .docx) file.

Objectives:

• To understand the fundamental concepts of Spread sheet and Network topologies

For any query about the assignment, contact at cs101@vu.edu.pk

Assignment Questions

Suppose given is a worksheet of MS Excel. (Figure 1)

Apply the Most appropriate formulas in MS Excel using the same data given in the below diagram, to find the result (same as shown in the diagram) of the below mentioned requirements and just write down the formulas in the solution file (MS word file).

(Figure 1)

Question: 2                                                                                                                                                   Marks 5     

The “HaseebSoft” organization launches a project for 1 year. Now the Project Manger wants to build a computer network for the project smooth running of the project. The project details are given below:

Project Duration: 1 year (Extendable)

Required Resources: 12 computers+ 1 printer+1 scanner

Future enhancements: 8 to 10 computers may be added

For such type of scenario, which topology is most suitable for network and why? Justify your answer.

Answer:

Suitable topology: Star topology

Justification:

• Easy to extend

ü  New computers/ nodes can be added/ removed  easily without affecting the rest of network

• Centralized Management

ü  The problems can be easily located logically and therefore it is easy to troubleshoot also.

• Better performance

ü  It passes the data packets through small number of nodes. At most, 3 devices and 2 links are involved in any communication between any two devices.

• Less chances of network failure

ü  Failure of one node or link doesn’t affect the rest of network. At the same time it is easy to detect the failure and troubleshoot it

BEST OF LUCK