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).

Tags: &, 26-01-2012, 5, Assignment, CS101, Date:, Discussion, Due, No, Solution

Views: 5590

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

yaar is mein to kch b ni

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

RSS

Main Forum Discussions By Categories Wise

Latest Activity In Forum

Newest Discussions In Forum

Most Popular Discussion

Latest Activity

Member of The Month

1. + Cj Umar

Pujab, Pakistan

Picture of The Day

  • Add Photos
  • View All

Videos

  • Add Videos
  • View All

Site Info

About Us

47000+ Members

+ Top Points Members

VU Students Web Mail

Get Registered Web Mail

VUSTUDENTS Toolbar

Become a Team Member

Moderators Group

Safety Guidelines for New

Site FAQ & Rules

Safety Matters

Online Safety

Terms of Service

Disclaimer

+ Report an Issue

Advertise with Us

Rules For Blog Post

Management: Admins,Moderators

Awards Badges List

Points Ranking System

Public Us On Google

Like Our Facebook Page

© 2014   Created by + M.Tariq Malik.

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