Education In Pakistan

Papers, Notes, Books & Help For Students

UPDATED EDUCATIONAL NEWS INTERVIEW HELP FOR ALL JOBS ONLINE BOOKS SCHOLARSHIPS AVAILABLE INTERNSHIP JOBS

Tag: CS 101 – 4th Assignment Solution

CS 101 – 4th Assignment Solution

CS 101 – 4th Assignment Solution

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
  2. Total sale of Asif
  3. Average sale of Asif
  4. Total Number of Products sold by Asif
  5. 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

 

 

CS 101 – 4th Assignment Solution

Education In Pakistan © 2016