We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

www.vustudents.ning.com

 www.bit.ly/vucodes + Link For Assignments, GDBs & Online Quizzes Solution www.bit.ly/papersvu + Link For Past Papers, Solved MCQs, Short Notes & More

Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

# CS 101 Introduction to Computing Assignment No. 04 Fall Due Date 24-1-2013

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

Total Marks: 15

Due Date:24/01/2013

Instructions:

• 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

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

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

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

BEST OF LUCK

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?

Views: 2781

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

### Replies to This Discussion

Our main purpose here discussion not just Solution

Q1 solution

Total Sale: 129000  ==>>
=SUM(B6:B15)

Total sale of Asif: 78000 ==>>  =SUM(B6,B8,B10,B12)

Average sale of Asif: 195000 ==>>  =AVERAGE(B6,B8,B10,B12)

Total Number of Product sold by Asif:  4 ==>> =COUNT(B6,B8,B10,B12)

Maximum Price:  55000 ==>> =MAX(B6:B14)

its not logically solution yaar,,,,,think a while... if teacher give you an assignment which contains over one million records and you have to fulfill above requirement then "would you perform said action" Of course not otherwise it would take couple of days to find where is asif and its product sold-out figures:::::try sumif equal to formulas by giving specific range....Am sorry Its my suggestion not discouraging you all....Its looking very simple solution but professionlizum required to fill it with future references,,,,, try it like this (=SUMIF(K8:K16,"=Asif",J8:J16)

sir i think star topology is the best for asked setup. on switch is required

All students must share points and also your problems.... so it can discussed and solution can prepare.

Don’t wait for solutions just participate in Discussions because after discussions a correct solution will prepare...

2nd: star topology.

qus1:

total number of product of asif =COUNTIF(C6:C14,"=Asif")

u just write formulas in word format.

Question: 01

Solution:

• Total sale: =SUM(B6:B14)
• Total sale of Asif: =SUM(B6,B8, B10,B12)
• Average sale of Asif: =AVERAGE(B6,B8,B10,B12)
• Total number of products sold by Asif: =COUNT(B6,B8,B10,B12)
• Maximum Price: =MAX(B6:B14)

I am a bit confuse about the 4th one, ap logon me sy kisi ne ye likha he k, =countif(c6:c14,"=asif") ka function use hoga lekin meri knowledge k mutabiq, ye function to is liay use hona chahiye k data men name Asif kitni bar aya he? answer to same hoga lekin formula men, I think kuch garbar he.. Kyunk hmen to no. of products batani he..nai?

Please somebody guide in this area and correct me if i am wrong...

Aur 2nd question men I think star hoga....

Uper wali diagram sy bhe yehi prove hota...

Thanks...

for solution of second question (those don't have enough knowledge about networking) make your house electricity board planning on simple paper, and you have to give connection to all rooms, all appliances and may be extended on upper portion in future.....This typically paper work lead you how to fll gap in networking by focusing extension in future...it means you have to focus on "Main boards" where all electricity connections having plug in and out with some extra switches for extension.....

thaaaaaaaaaaaaaaaaaaaaaaaaaaanx a lot for sharing samara...

Ist question ma mja b doubt ha plz any one guide correct solution,

## Latest Activity

+ ! ! ! ❣ maho ❣ ! + added a discussion to the group MTH603 Numerical Analysis

### mth603 past paper

1 minute ago
3 minutes ago
+ ! ! ! ❣ maho ❣ ! + joined + M.Tariq Malik's group

### MTH603 Numerical Analysis

7 minutes ago
+ ! ! ! ❣ maho ❣ ! + posted a discussion

### Ary kia krti ho??????????????????

9 minutes ago
11 minutes ago
+ıllıllı \$µǥąя ǥ€ɲɨµ\$ ıllıllı+ liked Isha Chuhdary's discussion paka
14 minutes ago
15 minutes ago
17 minutes ago
Alisha Noor replied to Isha Chuhdary's discussion Bari
18 minutes ago
Isha Chuhdary replied to Isha Chuhdary's discussion Mera sher
20 minutes ago
Isha Chuhdary replied to Isha Chuhdary's discussion paka
21 minutes ago
+ıllıllı \$µǥąя ǥ€ɲɨµ\$ ıllıllı+ liked Isha Chuhdary's discussion Mera sher
27 minutes ago

1

2

3