Directions: If any student is missing an assignment, the cell should be red. This should update automatically $($don$\text{'}$t manually shade it red$).$ Calculate the finale grade as a percentage. The Final grade column treats all grades as being submitted $(0\text{'}$s are computed for omitted work$).$

Compute the students current letter grade. The Letter grade column is based off of the Current grade and should update automatically as assignments are graded.

Report the count for how many students fall into each grade cut point. This should update automatically as grades are input. Calculate Averages, ranges, and Medians for All assignments and percent grades.

Check your work:

Rose Sayer has a $64\mathrm{.}8\%$ for current and final grade and a D; her ID is $129$

Melanie Daniels has a C in her current grade but if she doesn't turn anything in$,$ she'd have a $16\mathrm{.}7\%$ in her final grade

Tommie DeVito has a $72\mathrm{.}4$ currently but if he doesn't make up his exam, his final grade would be a $56\mathrm{.}5$

$0$ Students have an $A$ in the course

$1$ Student is Failing$-$ but just barely.

The mode grade is a C$+,6$ Students have a $Ct$

The average counting blanks as $0$ for exam $2$ is $74\mathrm{.}9.$ The average noting counting zeros is $80\mathrm{.}6.$

The sum of all of the class ranks should equal $406$

Darth Vader is second in the class.

Ace Ventura is $22nd.$