DATAFile: OM455 Professor Rao would like to accurately calculate the grades for the 58 students in...

Transcribed Image Text:

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 ><|||||||||||||||||||||< < | A B D F A B с (b) Use the COUNTIF function to determine the number of students receiving each letter grade among all 58 students in the class. C B A E Course Grade ✓✓ ✓✓ ✓✓ ✓✓ ✓✓ ✓✓ ✓✓ ✓✓ ✓✓ F 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 ><|||||||||||||||||||||< < | A B D F A B с (b) Use the COUNTIF function to determine the number of students receiving each letter grade among all 58 students in the class. C B A E Course Grade ✓✓ ✓✓ ✓✓ ✓✓ ✓✓ ✓✓ ✓✓ ✓✓ ✓✓ F

Answer rating: 100% (QA)

Thus professor R... View the full answer