.... How to Find Your Subject Study Group & Join ....   .... Find Your Subject Study Group & Join ....  

We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

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: 5895

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

Main Discussion Forum

Latest Activity In Main Forum

Newest Discussions In Main Forum

Most Popular Discussion

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

Study Zone

Latest Activity In Study Groups

Study Groups Subject Code Wise

Find Your Subject Study Group

Latest Activity

+ M.Tariq Malik liked Sameera Kharal's discussion Lady Home Tutor for VU Subjects
3 minutes ago
Asma Zafar replied to Hira's discussion Assignment No. 02 Semester: Fall 2016 CS609 – System Programming in the group CS609 System Programming
3 minutes ago
Asma Zafar replied to Hira's discussion Assignment No. 02 Semester: Fall 2016 CS609 – System Programming in the group CS609 System Programming
4 minutes ago
Profile IconImhum MCS and Asif Sadiqi joined + M.Tariq Malik's group
5 minutes ago
Imhum MCS replied to Ayesha Ahmad's discussion CS302 Assignment no#2 / Due Date: 5 Dec, 2016 in the group CS302 Digital Logic Design
5 minutes ago
+ M.Tariq Malik liked + USA's discussion National Book Foundation... ( 50% discount on each book)
7 minutes ago
Atiqa Farhat joined + M.Tariq Malik's group
8 minutes ago
Atiqa Farhat replied to + M.Tariq Malik's discussion MTH401 Assignment No 01 Solution & Discussion Due date: 07/12/2016 in the group MTH401 Differential Equations
8 minutes ago
+ Ansa Pari posted photos
9 minutes ago
+ M.Tariq Malik liked Shining Star's discussion bheega bheega sa ye december ha
9 minutes ago
+ M.Tariq Malik replied to Asad Ashraf's discussion ENG001 Assignment No 02 Solution & Discussion Due Date: Dec 06, 2016 in the group ENG001 Elementary English
11 minutes ago
+ zεε left a comment for + "Nåÿåβ♥
12 minutes ago
+ zεε left a comment for + "Nåÿåβ♥
12 minutes ago
+ zεε left a comment for + "Nåÿåβ♥
12 minutes ago
+ zεε left a comment for + "Nåÿåβ♥
13 minutes ago
+ мυsкαη left a comment for + "Nåÿåβ♥
13 minutes ago
+ M.Tariq Malik replied to Muhammad Tahir Rafiq's discussion Fall Eng001 Soved Assignment 2 in the group ENG001 Elementary English
13 minutes ago
+ мυsкαη left a comment for + "Nåÿåβ♥
13 minutes ago
+ M.Tariq Malik replied to Muhammad Tahir Rafiq's discussion Fall Eng001 Soved Assignment 2 in the group ENG001 Elementary English
13 minutes ago
+ M.Tariq Malik replied to Muhammad Tahir Rafiq's discussion Fall Eng001 Soved Assignment 2 in the group ENG001 Elementary English
13 minutes ago

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

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