1 B C D E F G H 2 HW Grade Due Date Completed Date Late/Early Late Points Early Points Adjusted HW Grade 3 5 6 901/29/19 801/28/19 1/21/19 601/27/19 1/30/19 501/23/19 1/20/19 481/25/19 1/27/19 801/26/19 1/24/19 90 1/25/19 85 1/24/19 1/28/19 1/28/19 Use the following instructions to complete this section 1. Complete the "Late/Early" column using the correct formula. If the completed date, is earlier than the due date, type "Early". If the Completed date is later than the due date, type "Late". 2. Complete the "Late Points" and "Early Points" column, using the correct formula. If the student's completed date is considered 'late', deducted 10 points under the "Late Points" column for the student. If the student's completed date is considered 'early', add 10 points to the "Early Points" column for the student. 3. Complete the "Adjusted HW Grade" column, using the SUM function to calculate the grade. 4. Complete the Weighted Average column by totaling the weighted averages (Adjusted HW Grade + Exam Grade) for the students' final grade, using the correct calculation. Calculate the Adjusted HW Grade to be 10\% of the weighted average and the Exam Grade to be 90% of the weighted average . 5. Complete the Letter Grade column, by using the correct formula. Use the following grading scale for issuing the student a letter grade based on their numerical "Weighted Average" score: 59 \& below F; 69-60-D;79-70 -C; 89-80 -B; 100-90 - A. 6. Use the correct formula to calculate the class Min, Max, \& Avg for the Weight Average column