Assignment
Dr Fencil gives 5 exams during the semester, but throws out the lowest grade when determining the final grade.
- Calculate the average, min and max for each exam.
- Use formula to show total for each student based on four best exam scores.
- Use formula (vlookup or Nested IF) to find grade
- Create a clustered column chart to show student grades for each exam.
|
Dr Fencil's Gradebook
|
|
Assignment
|
Exam1
|
Exam2
|
Exam3
|
Exam4
|
Exam5
|
Total
|
Percent
|
Grade
|
|
Points
|
100
|
100
|
100
|
100
|
100
|
|
|
|
|
Student
|
|
|
|
|
|
|
|
|
|
Alice
|
87
|
100
|
80
|
88
|
97
|
|
|
|
|
Bob
|
76
|
97
|
87
|
88
|
90
|
|
|
|
|
Carol
|
84
|
82
|
73
|
87
|
0
|
|
|
|
|
David
|
65
|
70
|
0
|
68
|
56
|
|
|
|
|
Edith
|
78
|
100
|
75
|
87
|
0
|
|
|
|
|
Fred
|
89
|
90
|
87
|
74
|
80
|
|
|
|
|
Gwen
|
75
|
80
|
65
|
65
|
88
|
|
|
|
|
Henry
|
86
|
88
|
92
|
78
|
90
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Average
|
|
|
|
|
|
|
|
|
|
Max
|
|
|
|
|
|
|
|
|
|
Min
|
|
|
|
|
|
|
|
|
|
Percent Range
|
Grade
|
|
90-100
|
A
|
|
80-89.9
|
B
|
|
70-79.9
|
C
|
|
60-69.9
|
D
|
|
below 60
|
F
|