DATAFile: OM455 Professor Rao would like to accurately calculate the grades for the 58 students in his Operations Planning and Scheduling class (OM 455). He has thus far constructed a spreadsheet, part of which follows. (a) The Course Average is calculated by weighting the Midterm Score and Final Score 50% each. Use the VLOOKUP function with the table shown to generate the Course Grade for each student in cells E14 through E24. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 73 74 75 76 77 78 79 Need Help? OM 455 Section 001 Course Grading Scale Based on Course Average: Alt Amini Amaako Apland Bachman Corder Desi Dransman Duffuar Finkel Foster A Course Grade A A B D F Read It Last Name Watch It B Number Lower Limit 0 58 68 79 90 B Midterm Score 70 95 82 45 68 91 87 60 80 97 90 Upper Limit 57.9 67.9 78.9 89.9 100 Final Score 56 91 80 78 45 98 74 80 93 98 91 D Course Grade F D B A Course Average 63.0 93.0 81.0 61.5 56.5 94.5 80.5 70.0 86.5 97.5 90.5 D >