Posted by : Anonymous Sunday, 20 January 2013

Assignment Questions
Question: 1 Marks 10 

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).

  1. Total sale
  1. Total sale of Asif
  1. Average sale of Asif
  1. Total Number of Products sold by Asif
  1. Maximum Price

[IMG]file:///C:/DOCUME~1/ADMINI~1/LOCALS~1/Temp/msohtmlclip1/01/clip_image003.jpg[/IMG]
(Figure 1)
Notes for question # 1: 

1) While writing formulas; only use the given range in formulas, other range should not be accepted
2) Do not send excel file, send us the word file only
3) Do not paste the excel file in the word file.
4) You are to only write down formulas in the word file.
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.
Solution:
Answer:
              The most suitable topology for such a network is “Star Topology”. By this type of topology the computers will be connected with each other using a “central hub” by which we can connect more computers with the network at any time without any breakage or any problem in the network. So, Star Topology is more reliable than that of other like “Ring Topology” because if a computer failed to work or have any problem it will not affect the entire network. So, We can replace computer at any time or can also add computers without any failure of the network. We can also share printer or scanner with entire work.

Explanation:
Comparison of all Topologies.
Ring Topology:
                  If we establish a network using Ring Topology it will stop entire network in case of a single node or computer failure. So, it is not so reliable to use in such an office.
Bus Topology:
                If we install a Bus Topology for such a network it will be more reliable but it will be very slow in performance.
Star Topology:
                If we use a “Star Topology” it will reduce all such problems and the network performance will be faster and reliable and in case of fault of a computer or node the entire network will not affected and we can easily replace or can add more computers in this network using central hub.



Product Price Agent
Washing Machine 15000 Asif
Microwave Own 7000 Asad
Refrigerator 55000 Asif
TV 30000 Asad
Fan 3000 Asif
Iron 2000 Asad
Juicer 5000 Asif
Tea set 4000 Asad
Dinner set 8000 Asad

Leave a Reply

Subscribe to Posts | Subscribe to Comments

- Copyright © virtual university of pakistan - Skyblue - Powered by Blogger - Designed by Johanes Djogan -