EXCELEXERCISE : GradeSheet PROJECT
1. Create aspreadsheetsimilar to the one below.
|
|
A
|
B
|
C
|
D
|
E
|
F
|
G
|
|
1
|
BISI3230:Information Syst
|
|
|
|
|
|
|
|
2
|
Fall 2016
|
|
|
|
|
|
|
|
3
|
|
|
|
|
|
|
|
|
4
|
STUDENTNAMES
|
STUDENTID
|
EXAM#1
|
EXAM#2
|
EXAM#3
|
PART.
|
AVERAGE
|
|
5
|
Thomas,Steven
|
999-25-5683
|
94
|
65
|
89
|
90
|
|
|
6
|
Alexander,Suzette
|
999-52-6938
|
93
|
91
|
97
|
80
|
|
|
7
|
Richards,BillyJoe
|
998-71-2838
|
55
|
62
|
65
|
40
|
|
|
8
|
Rasmussen,Betty
|
997-74-4447
|
95
|
94
|
90
|
90
|
|
|
9
|
Your name
|
xxx-xx-xxxx
|
Xx
|
Xx
|
Xx
|
xx
|
|
a) In the last row, enter your name (Row 9) and make up values for STUDENT ID, EXAM #1, EXAM #2, EXAM #3, and PART.Highlight this row.
b) Calculate the AVERAGE in column G using the appropriate Excel Function. Assume that each EXAM and participation weights the same in calculating the average. Format the table to be visually appealing.
c) In a second worksheetof the workbook, reenter the same data.
d) This time, to calculate the AVERAGE score, assume that EXAM #1 weighs 20%, Exam # 2 weighs 25%, EXAM #3 is 30%, and PART is 25% of the average score.
Hint: Create Assumptions section of the different weights and use absolute references in the formula to calculate the AVERAGE.
e) In Column H of the second worksheet completed in c) above, create a label called GRADE (that is in Cell H4). Use and appropriate function to return the letter grade for each student based on the following Grade criteria: >=90.00: A, 80-89.99: B, 70-70.99: C, 60-60.99: D, and <60: D.