Given below is the grading scale and the mid term and final scores of students in course OM 455 The semester points is the average of the mid-term and final scores n. Determine the course average and then based on that determine the students' course grade using the VLOOKUP function b. Determine the number of students securing each course grade using the COUNTIF function Course Grade Number of Students D Course Grading Scale Based on Course Average: Lower Upper Course Limit Limit Grade 0 59 F 60 60 D 70 79 80 89 B 90 100 OO Course Average Course Grade Last Name Alt Amini Amoako Apland Bachman Corder Desi Dransman Duffuor Finkel Foster Fuss George Gerson Girling Greer Guerro Hager Heilman Hibbard Hills Hughes Hutchison Jackson Kasser Kelok Kom Kinner Midterm Score 70 95 82 45 08 91 87 60 80 97 00 74 72 83 61 05 70 05 82 05 62 78 38 85 87 74 48 55 00 88 67 78 74 65 50 Final Score 56 01 80 78 45 98 74 80 03 08 91 82 92 70 00 100 77 93 88 04 57 93 05 100 00 80 70 80 07 90 88 84 78 80 93 La Marsh Martin Mattiin McGough Miller Minnick Minster Moeier SA 87 00 78 45 98 74 80 93 98 01 82 92 76 66 Apland Bachman Gorder Desi Dransman Duffuor Finkel Foster Fuss George Gerson Girling Greer Guerro Hager Heilman Hibbard 90 100 Hills 88888888998228&&&&9%8888888888898988998 67 Hughes Hutchison Jackson Kassner Kelcik Kern Kinner Lair Marsh Martini Mattin McGough Miler Minnick Minster Mueller Munzo Nanko Owen Reth Reza Ridder Rodgers Ruschau Schneider Schniring Schwartz Scott Shaw Sims Steelman Tretman Vilans Wettee Weyer Whipky w 77 93 88 94 57 93 05 100 90 86 78 88 97 96 88 84 78 80 03 07 03 94 98 78 80 100 70 07 90 98 23 81 70 87 68 74 70 72 83 01 95 90 95