Given the data answer the question. 1 A 2 Points possible B C D E Exam 1

Given the data answer the question.

Transcribed Image Text:

1 A 2 Points possible B C D E Exam 1 100 Exam 2 100 Exam 3 100 100 73 78 84 82 F G H J K Exam 4 Homework Final Exam Total Points Overall % Overall (pre final) Lowest possible final 800 200 164 200 140 621 77.625 1. Enter a formula in cell H2 that will calculate the total points possible for this course. 3 Your scores 4 5 6 7 8 9 10 11 12 13 14 2. Enter a formula in cell H3 that will calculate the total points earned for this course. 3. Enter a formula in cell 13 that will calculate the overall percentage for this course. 4. To determine the grade for this student before 15 taking the final exam, you would need to calculate 16 17 18 19 20 the overall % WTIHOUT the final exam points included. What overall percentage does this student have before the final? Enter that formula in J3 5. Change the value in cell. G3 to determine the lowest overall percentage this student could earn on the final exam in order to pass the class? 70% is the lowest possible overall passing grade. Enter the value of the lowest possible final exam percentage in K3. When you are done please change the value in G3 back to 170 21 L M N 1 A 2 Points possible B C D E Exam 1 100 Exam 2 100 Exam 3 100 100 73 78 84 82 F G H J K Exam 4 Homework Final Exam Total Points Overall % Overall (pre final) Lowest possible final 800 200 164 200 140 621 77.625 1. Enter a formula in cell H2 that will calculate the total points possible for this course. 3 Your scores 4 5 6 7 8 9 10 11 12 13 14 2. Enter a formula in cell H3 that will calculate the total points earned for this course. 3. Enter a formula in cell 13 that will calculate the overall percentage for this course. 4. To determine the grade for this student before 15 taking the final exam, you would need to calculate 16 17 18 19 20 the overall % WTIHOUT the final exam points included. What overall percentage does this student have before the final? Enter that formula in J3 5. Change the value in cell. G3 to determine the lowest overall percentage this student could earn on the final exam in order to pass the class? 70% is the lowest possible overall passing grade. Enter the value of the lowest possible final exam percentage in K3. When you are done please change the value in G3 back to 170 21 L M N