Vuhelper
01-19-2013, 02:43 PM
CS101 Introduction to Computing Assignment No.4 Fall Semester 2013 Due Date 24-1-2013
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).
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
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).
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