CS101 ASSINGMENT 4 FALL 24-1-2013 FINAL SOLUTION

[AATII]

MUJAY ATTACHMENT KA OPTION NEHI MIL RAHA PLEASE TELL ME PHER MAY ASSIGNMENT UPLOAD KAR SAKO CHALAY ASY PLAIN TEXT HE LY LAY



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
=SUM(B6:B14)

2. Total sale of Asif
=SUMIF(C6:C14,"Asif",B6:B14)

3. Average sale of Asif
=AVERAGE(IF(C6:C14="asif",B6:B14))

4. Total Number of Products sold by Asif
=COUNTIF(C6:C14,"Asif")

5. Maximum Price
=MAX(B6:B14)






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