Directions: 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). If any student is missing an assignment, the cell should be red. This should update automatically (don’t manually shade it red). 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. Calculate the finale grade as a percentage. The Final grade column treats all grades as being submitted (0’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 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) Calculate Averages, ranges, and Medians for All assignments and percent grades.