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

Looking For Something at vustudents.ning.com? Click Here to Search

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

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

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

 

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

 


(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 Follow the New Added Discussions at Your Mail Address?

+ 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?


See Your Saved Posts Timeline

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)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)

Replies to This Discussion

Our main purpose here discussion not just Solution

Please Discuss here about this assignment.Thanks

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)

can you elaborate your point please

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,

RSS

© 2020   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service

.