Excel File Edit View insert Format Tools Data Window Help AS ABESU. AssignmentOneData online - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Tell me X Arial 10 - A A 19 Wrap Tel General Paste SIV A Ege Center $ - % ) ming Office Update To keep up-to-date with security updates, fres, and improvements, choose Check for updates AB xf Name A D Professor's Grade Book - Alternate Grading Scheme 3 Nm Test2 Testa Test Test Ave Number of our Peraly 4 Cadre Semes Average Grade 80 40 40 B1 Ob Sterve 75 70 66 DT Har 90 80 13 70 2 14 7 Model Mar 70 65 Hun obra te 90 NO 90 15 Sap Cart 35 ES 08 . Sa Ace 79 9 11 mm O NO 66 12 12 Surrey Steve 70 70 80 Westen Blue 70 NO 10 30 14 15 15 Gring Creu 0 70 30 35 98 D 18 None We Won 19 Rubens 20 Pay foreaching 2 21 Bonus och barat 1 23 24 A 22 30 30 20 14 Bott Se Feate 25 a MacBook Air esc 80 DO F! : 8 & # 1 2 $ 4 3 & 7 6 8 Q W E R T Y m Alternate Grade Book; the following figure displays a possible layout of your homework one. Open the partially completed version of this worksheet given to you, and then complete the worksheet as follows: The test average is computed by dropping the student's lowest score, then giving equal weight to the three remaining tests. Andrea Carrion's test average, for example, is computed by dropping a 40 on test 2 or 3, then taking the average of 60, 40, and 81. You will have to use the SUM, MIN and COUNT functions to meet this requirement. B. Students are required to complete a designated number of homework assignments (12 in the figure), then receive a bonus or penalty for every additional or missing homework assignment. Andrea Carrion completed 9 homework assignments, rather than 12, and thus has a 6-point penalty (2 points per each missing assignment). Steve Weinstein, however, receives a 3-point bonus (1 point for each extra assignment). The bonus or penalty is added to the test average to determine the semester average. You will have to use IF function here. The grade for the course is based on the semester average and table of grading criteria according to an HLOOKUP function within the worksheet. Please use the correct formulas for ALL of your calculations di Format the worksheet in an attractive manner. You do not have to duplicate our formatting exactly, but you are to display all failing grades and homework penalties in red. Process the worksheet a second time to reflect the comment in cell E19. Save the result to a second worksheet (not another file). Please do not replace the first worksheet. Add your name to the end of each worksheet Add a custom header with your name, the course you are taking and your instructor's name. Create a custom footer with today's date and the current time Then submit it on Blackboard to your instructor Test LE 10 Page 1 of 1 O Focus 100% T00% A P W Excel File Edit View insert Format Tools Data Window Help AS ABESU. AssignmentOneData online - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Tell me X Arial 10 - A A 19 Wrap Tel General Paste SIV A Ege Center $ - % ) ming Office Update To keep up-to-date with security updates, fres, and improvements, choose Check for updates AB xf Name A D Professor's Grade Book - Alternate Grading Scheme 3 Nm Test2 Testa Test Test Ave Number of our Peraly 4 Cadre Semes Average Grade 80 40 40 B1 Ob Sterve 75 70 66 DT Har 90 80 13 70 2 14 7 Model Mar 70 65 Hun obra te 90 NO 90 15 Sap Cart 35 ES 08 . Sa Ace 79 9 11 mm O NO 66 12 12 Surrey Steve 70 70 80 Westen Blue 70 NO 10 30 14 15 15 Gring Creu 0 70 30 35 98 D 18 None We Won 19 Rubens 20 Pay foreaching 2 21 Bonus och barat 1 23 24 A 22 30 30 20 14 Bott Se Feate 25 a MacBook Air esc 80 DO F! : 8 & # 1 2 $ 4 3 & 7 6 8 Q W E R T Y m Alternate Grade Book; the following figure displays a possible layout of your homework one. Open the partially completed version of this worksheet given to you, and then complete the worksheet as follows: The test average is computed by dropping the student's lowest score, then giving equal weight to the three remaining tests. Andrea Carrion's test average, for example, is computed by dropping a 40 on test 2 or 3, then taking the average of 60, 40, and 81. You will have to use the SUM, MIN and COUNT functions to meet this requirement. B. Students are required to complete a designated number of homework assignments (12 in the figure), then receive a bonus or penalty for every additional or missing homework assignment. Andrea Carrion completed 9 homework assignments, rather than 12, and thus has a 6-point penalty (2 points per each missing assignment). Steve Weinstein, however, receives a 3-point bonus (1 point for each extra assignment). The bonus or penalty is added to the test average to determine the semester average. You will have to use IF function here. The grade for the course is based on the semester average and table of grading criteria according to an HLOOKUP function within the worksheet. Please use the correct formulas for ALL of your calculations di Format the worksheet in an attractive manner. You do not have to duplicate our formatting exactly, but you are to display all failing grades and homework penalties in red. Process the worksheet a second time to reflect the comment in cell E19. Save the result to a second worksheet (not another file). Please do not replace the first worksheet. Add your name to the end of each worksheet Add a custom header with your name, the course you are taking and your instructor's name. Create a custom footer with today's date and the current time Then submit it on Blackboard to your instructor Test LE 10 Page 1 of 1 O Focus 100% T00% A P W