OM 455 Section 001 Course Grading Scale Based on Course Average: LowerUpperCourse LimitLimitGrade 059F 6069D 7079C 8089B 90100A MidtermFinalCourseLast NameScoreScoreAverageAlt695160.0Amini908989.5Amoako827880.0Apland437760.0Bachman664455.0Corder889692.0Desi827478.0Dransman587667.0Duffuor758982.0Finkel959896.5Foster908889.0Fuss747775.5George679078.5Gerson797275.5Girling586662.0Greer929694.0Guerro677772.0Hager649077.0Heilman798582.0Hibbard949494.0Hills625257.0Hughes769284.0Hutchison839388.0Jackson819588.0Kassner859087.5Kelcik698476.5Kern417558.0Kinner518668.5Lair869691.0Marsh889491.0Martini658575.0Mattlin768279.0McGough737473.5Miller618070.5Minnick588873.0Minster666465.0Mueller689179.5Munzo819286.5Nanko829488.0Owen527865.0Reth678274.5Rezai929895.0Ridder807678.0Rodgers859791.0Ruschau678676.5Schneider749383.5Schnirring708979.5Schwartz477862.5Scott417558.0Shaw588270.0Sims746871.0Steelman787476.0Trentman616864.5Villaris767977.5Wettee625759.5Weyer919392.0Whipky888988.5Willis869389.5 Professor Rao would like to accurately calculate the grades for the 58 students in hisOperations Planning and Scheduling class (OM 455). He has thus far constructed aO spreadsheet, part of which is provided following the link below.Click on the datafile logo to reference the data.DATA file(a) The Course Average is calculated by weighting the Midterm and Final Score 50%each. Use VLOOKUP with the table shown to generate the Course Grade for eachstudent in cells E14 through E24. Complete the table below.Last nameCourse GradeAltSelect your answer -AminiSelect your answer -AmoakoSelect your answerAplandSelect your answerBachman- Select your answerCorderSelect your answerDesi·Select your answerDransmanSelect your answer -DuffuorSelect your answerFinkelSelect your answerFosterSelect your answer(b) Use the COUNTIF function to determine the number of students receiving eachletter grade.Course GradeNo. of StudentsАВDF

Answered: The Course Average is calculated by…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

OM 455
Section 001
Course Grading Scale Based on Course Average:
	Lower	Upper	Course
	Limit	Limit	Grade
	0	59	F
	60	69	D
	70	79	C
	80	89	B
	90	100	A

	Midterm	Final	Course
Last Name	Score	Score	Average
Alt	69	51	60.0
Amini	90	89	89.5
Amoako	82	78	80.0
Apland	43	77	60.0
Bachman	66	44	55.0
Corder	88	96	92.0
Desi	82	74	78.0
Dransman	58	76	67.0
Duffuor	75	89	82.0
Finkel	95	98	96.5
Foster	90	88	89.0
Fuss	74	77	75.5
George	67	90	78.5
Gerson	79	72	75.5
Girling	58	66	62.0
Greer	92	96	94.0
Guerro	67	77	72.0
Hager	64	90	77.0
Heilman	79	85	82.0
Hibbard	94	94	94.0
Hills	62	52	57.0
Hughes	76	92	84.0
Hutchison	83	93	88.0
Jackson	81	95	88.0
Kassner	85	90	87.5
Kelcik	69	84	76.5
Kern	41	75	58.0
Kinner	51	86	68.5
Lair	86	96	91.0
Marsh	88	94	91.0
Martini	65	85	75.0
Mattlin	76	82	79.0
McGough	73	74	73.5
Miller	61	80	70.5
Minnick	58	88	73.0
Minster	66	64	65.0
Mueller	68	91	79.5
Munzo	81	92	86.5
Nanko	82	94	88.0
Owen	52	78	65.0
Reth	67	82	74.5
Rezai	92	98	95.0
Ridder	80	76	78.0
Rodgers	85	97	91.0
Ruschau	67	86	76.5
Schneider	74	93	83.5
Schnirring	70	89	79.5
Schwartz	47	78	62.5
Scott	41	75	58.0
Shaw	58	82	70.0
Sims	74	68	71.0
Steelman	78	74	76.0
Trentman	61	68	64.5
Villaris	76	79	77.5
Wettee	62	57	59.5
Weyer	91	93	92.0
Whipky	88	89	88.5
Willis	86	93	89.5

Transcribed Image Text: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 O spreadsheet, part of which is provided following the link below. Click on the datafile logo to reference the data. DATA file (a) The Course Average is calculated by weighting the Midterm and Final Score 50% each. Use VLOOKUP with the table shown to generate the Course Grade for each student in cells E14 through E24. Complete the table below. Last name Course Grade Alt Select your answer - Amini Select your answer - Amoako Select your answer Apland Select your answer Bachman - Select your answer Corder Select your answer Desi ·Select your answer Dransman Select your answer - Duffuor Select your answer Finkel Select your answer Foster Select your answer (b) Use the COUNTIF function to determine the number of students receiving each letter grade. Course Grade No. of Students А В D F

Expert Solution

Step 1

a) Given that: The Course Average is calculated by weighting the Midterm Score and Final Score 50 percent each. Use the VLOOKUP function with the table shown to generate the Course Grade for each student in cells E14 through E24.