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

Today Top Content On Site

1. cs408 Assignment 3

Posted by +''_Dua_''+ on July 18, 2016

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

Shanzay Butt replied to shoaib hussain's discussion Project management – MGMT627 ASSIGNMENT NO.1 -- Due Date: 21st July, 2016 --Extended Date 22 July in the group MGMT627 Project Management
30 minutes ago
Shanzay Butt replied to shoaib hussain's discussion Project management – MGMT627 ASSIGNMENT NO.1 -- Due Date: 21st July, 2016 --Extended Date 22 July in the group MGMT627 Project Management
32 minutes ago
Shanzay Butt joined + M.Tariq Malik's group
32 minutes ago
RooSe..! updated their profile
33 minutes ago
abdul hameed replied to +''_Dua_''+'s discussion cs408 Assignment 3 in the group CS408 Human Computer Interaction
39 minutes ago
Profile Iconabdul hameed, Amina Akram and bilal joined + M.Tariq Malik's group
39 minutes ago
HUMA MUGHAL replied to +*✿άñίqά ғάţίмά✿*'s discussion ایک شخص اکثر ایک بوڑھی عورت سے سنگترے خریدا کرتا تھا،
57 minutes ago
Arafat replied to Anjum Nawaz's discussion Cs301 assignment # 3 Due date 25/07/2016 in the group CS301 Data Structures
1 hour ago
hooria replied to Anjum Nawaz's discussion Cs301 assignment # 3 Due date 25/07/2016 in the group CS301 Data Structures
1 hour ago
Noor Jutt replied to Noor Jutt's discussion .....****.....Let's Start Poetry Competition.....****.....!!!!
1 hour ago
Noor Jutt replied to Noor Jutt's discussion .....****.....Let's Start Poetry Competition.....****.....!!!!
1 hour ago
zahid usman replied to +*✿άñίqά ғάţίмά✿*'s discussion ایک شخص اکثر ایک بوڑھی عورت سے سنگترے خریدا کرتا تھا،
1 hour ago

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

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