$9$ Directions:

$10$ In column B$,$ labeled ID#$,$ assign each student a unique ID#$.$ These numbers should start at $123$ and run consecutively through $150.$ You should not type each number individually $($use$.$fill$).$

$11$ If any student is missing an assignment, the cell should be red. This should update automatically $($don$\text{'}$t manually shade it red$).$

$12$ Calculate the current grade as a percentage. The Current grade column should only look at grades that have been submitted to the gradebook. $($ignore empty cells$)$ Note: All assignments are not equally weighted.

$13$ Calculate the finale grade as a percentage. The Final grade column treats all grades as being submitted $($o$\text{'}$s are computed for omitted work$).$

$14$ 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.

$14$ Report the count for how many students fall into each grade cut point. This should update automatically as grades are input.

$15$ Calculate the class rank. Rank should be calculated such that each student has a unique rating based off of current grade and ties should be broken based on location. $($Whatever is listed first is ranked first$)$

$16$ Calculate Averages, ranges, and Medians for All assignments and percent grades.