Overview
Create a Formula using an AVERAGE to calculate the final grade for a student based on given first, second, and final tests.
Round your final grade (e.g., 90.51 to 91 and 90.49 to 90)
- Create a Formula using conditionals to return PASS if a student's grade is greater than 60. If not, your formula should return FAIL.
- Using conditional formatting, make the PASS cells to a GREEN color and FAIL cells to RED color.
- Create a nested if formula to return a letter grade based on student's final grade.
- A = 100–90; B = 89–80; C = 79–70; D = 69–60; F = 59–0
- Greater than or equal to 90 = A
Greater than or equal to 80 and less than 90 = B
Greater than or equal to 70 and less than 80 = C
- Greater than or equal to 60 and less than 70 = D
- Anything less than 60 = F
- Plot a Bar chart showing each student three tests. Add each student's final grade into the previous chart as a Line chart (2-D line).
- Using COUNTIF, calculate how many students received A, B, C, D, and F.
- Plot a Pie chart to percentagewise demonstrate how many students received A, B, C, D, and F grades