Study Groups By Subject code Wise (Click Below on your university link & Join Your Subject Group)

[ + VU Study Groups Subject Code Wise ]  [ + COMSATS Virtual Campus Study Groups Subject Code Wise ]

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

Assignment No.  05
Semester Fall 2011
Introduction to Computing-CS101

 

Objective: To understand the basic features of MS Excel Spreadsheet.

 

Instructions:

Please read the following instructions carefully before solving and submitting assignment:

 

  • Use only MS Excel to solve this assignment.
  • Assignment will not be accepted if it is submitted after due date.
  • Assignment will not be accepted if the submitted assignment does not open or file is corrupt.
  • Assignment will not be accepted if the assignment is copied (from other student or copied from handouts or internet).
  • Assignment will not be accepted if the assignment file is not in MS Excel format.

 

Note: It is recommended to use your VU ID as name of the assignment.

 

For any query about the assignment, contact at cs101@vu.edu.pk

 

GOOD LUCK

Assignment No.  05
Semester Fall 2011
Introduction to Computing-CS101

 

Objective: To understand the basic features of MS Excel Spreadsheet.

 

Instructions:

Please read the following instructions carefully before solving and submitting assignment:

 

  • Use only MS Excel to solve this assignment.
  • Assignment will not be accepted if it is submitted after due date.
  • Assignment will not be accepted if the submitted assignment does not open or file is corrupt.
  • Assignment will not be accepted if the assignment is copied (from other student or copied from handouts or internet).
  • Assignment will not be accepted if the assignment file is not in MS Excel format.

 

Note: It is recommended to use your VU ID as name of the assignment.

 

For any query about the assignment, contact at cs101@vu.edu.pk

 

GOOD LUCK

You are required to develop an MS Excel spreadsheet which fulfills the following requirements:

 

  1. Create two columns with headings Student Name and GPA.
  2. The Student Name column should contain the names of twenty students and GPA column should contain the GPAs of the students respectively.
  3. You can use any twenty names for Student Name column but all the values in GPA column must be in the range of 0.0 to 4.0 (0.0 ~ 4.0 both inclusive).

Views: 5873

Attachments:

Replies to This Discussion

Please check attached idea solution

Attachments:

ye idea solution hai???????

is me tu kuch b nahi hai. 

I can't see any guideline asking for categorizing students, this Excel assignment is just to make sure the basics of MS Excel, and in my solution i used strings by using values like 4.0 to view as 4.0, however if you type 4.0 in normal you will see it shown as 4 only and the ".0" will be hidden because of using number and you asked to format cells for GPA column. For Most efficient peoples, use formulas at your own risk. Thanks

CS101_5th Assignment Idea guidline

its SO Easy assignment....
Put These Formula...
A Grade Students =SUMPRODUCT(--($C$2:$C$21>=4))
B Grade Students =SUMPRODUCT(--($C$2:$C$21>=3),--($C$2:$C$21<4))
C Grade Students =SUMPRODUCT(--($C$2:$C$21>=2),--($C$2:$C$21<3))
D Grade Students =SUMPRODUCT(--($C$2:$C$21>=1),--($C$2:$C$21<2))
F Grade Students =SUMPRODUCT(--($C$2:$C$21>=0),--($C$2:$C$21<1))

And Pie chart is so much easy to put... its too much easy assignment...
and these formulas are 100% correct if u apply..

thnkssssssssss i had done using

this help

achha mazak he.serious effrts kro yaar

graph kasy bnana ha yaha

Salam main  nay ya formula laga kar kam kia ha but graph nahi bna please help me 

Download the Solution File of CS101 Assignment No 5 Solution Fall 2011

Attachments:

see attachment of cs 101 assignment solution

Attachments:

Ap Sub Ko Marwao Ge 2 Column Banane The Ap Ne Teen bana die.Baqi agey Kia Kro Ge Ap Hmare Saath

pta nahi hun ko cs101 ki smj kio nahi ati brooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo

RSS

QUICK ACCESS Links

Latest Activity In Main Forum

Newest Discussions In Main Forum

Most Popular Discussion

-----------------------------------------------

Latest Activity In Study Groups

Study Groups Subject Code Wise

Find Your Subject Study Group

Latest Activity

AQSA posted a discussion
6 minutes ago
chanda replied to +Umar Amin+'s discussion Happy Birthday to me!!!
8 minutes ago
Muhammad Abdullah added 2 discussions to the group MKT530 Consumer Behaviour
8 minutes ago
AR and +(✿◠‿◠)Shamza are now friends
10 minutes ago
Salman Sarfraz replied to + αтhεя вѕcѕ 7тн's discussion CS614 ALL Current Final Term Papers Spring 2016 And Past Final Term Papers at One Place from 20 August 2016 to 2 September 2016 in the group CS614 Data Warehousing
13 minutes ago
Ahnaf replied to + αтhεя вѕcѕ 7тн's discussion MGT101 ALL Current Final Term Papers Spring 2016 And Past Final Term Papers at One Place from 20 August 2016 to 2 September 2016 in the group MGT101 Financial Accounting
25 minutes ago
Ahnaf joined + M.Tariq Malik's group
25 minutes ago
jannat_MIT joined + M.Tariq Malik's group
27 minutes ago
jannat_MIT replied to + Ijaz's discussion CS604 ALL Current Final Term Papers Spring 2016 And Past Final Term Papers at One Place from 20 August 2016 to 2 September 2016 in the group CS604 Operating Systems
27 minutes ago
Qaiser Ali replied to + αтhεя вѕcѕ 7тн's discussion STA301 ALL Current Final Term Papers Spring 2016 And Past Final Term Papers at One Place from 20 August 2016 to 2 September 2016 in the group STA301 Statistics and Probability
33 minutes ago
JAni Dubai (MIT) liked Mehar Eng Shahzad Tufail's discussion 20 MORE OF THE MOST USELESS WEBSITES EVER
34 minutes ago
JAni Dubai (MIT) liked Mehar Eng Shahzad Tufail's discussion 3 Benefits and Risks to Human Health
34 minutes ago

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

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