1 Problem 3: Grades of several students on several assessments are given below. 2 a. There were 1100 possible points on the assessments. Compute the assessment percentages and give their values below. 3 4 Student 5 Addie 6 Bob 7 Cate 8 David 9 Emily 10 Frank 11 Gina 12 Total Assessments Scores 15 Student 16 Addie 17 Bob 18 Cate 19 David 20 Emily 21 Frank 22 Gina 3 1100 560 1075 1000 1100 300 950 Test 1 98 59 80 Assessment 13 b. Using the percentages that you determined and the "VLOOKUP" function, Compute the semester grades of the students.. 14 Grading scale should be as shown on your syllabus, 75 90 80 84 Percentages 100% 51% 98% 91% 100% 27% 86% Test 2 94 58 90 76 92 78 84 Assessment S Percentages 100% 51% 98% 91% 100% 27% 86% Semeste Semeste Total r Grade. 192.0 117.0 170.0 151.0 182.0 158.0 168.0 Grading Scale 0-59.5 F 59.5-69,5 D 69.5-79.5 C 79.5-89.5 B 89.5-100 A