5. CoA. If the student failed every Exam, but had a perfect score in all other assignments? OR B. If the student failed all assignments, but had a perfect score on every Exam? Justify which scenario is best using a quantitative argument in your response by making sure to address the number of failed assignments for each scenario and what the student’s final score and grade would be for each scenario if 59 is the failing score used for each scenario. Use the following parameters and scores in your Excel spreadsheet: Methods of Evaluation: There are 3 exam, 20 homework, 10 quiz, 2 projects, and 3 online test review scores listed. Grading Scale: Category Weights: 90 - 100 A Midterm exam: 30% Test Reviews: 5% 80 - 89 B Final exam: 30% Project: 10% 70 - 79 C Quiz: 15% 60 - 69 D Homework: 10% 0 - 59 F A student has the following scores in each category: Category Scores Midterm 95 Final 80 Online Test Review 85 0 80 Project 85 0 Quiz 90 95 100 97 80 88 0 0 80 60 100 95 100 7 95 80 75 76 95 83Homework 80 0 65 90 92 0 0 55 40 0nsider the following scenarios A and B. Which scenario is best for this student