80.2K

Verified Solution

Link Copied!

BUAN 132 - Intro to manage information systems. Alternate Grade Book, Excel assignment .

Alternate Grade Dook: the following figure displays a possble layout of your homework on Open the partially completed version of this worksheet given to you, and then complete the worksheet as follows: a The test average is computed by dropping the students 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 2 or 3. then taking the average of 60, 40, and 81. You will have to use the SUMMIN COUNT functions to meet this moment Students are required to complete a designated number of homework assignments (12 in the figurel. then receive a bonus or pay for every additional or missing home assignment. Andrea Carrion completed 9 homework assignments, rather than 12. and thus has a 6-point penalty points per each missing assignment Steve Weinstein however, receives a 3 point bonus (1 point for each extra assignment. The bonus or penalty s added to the test average to determine the semester avage you will have to use IF function here The grade for the course is based on the semester average and table of grading Cateria according to an HLOOKUP Nunction within the workshoot Poses the correct formulas for ALL of your cautions 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 cel E19 Save the result to a second worksheet (not another file. Please do not replace the first wonisteet Add your name to the end of each worksheet Add a custom header with your name, course you are taking and your instructor's name. Create a custom footer with today's date and the current time. Then submit on Blackboard to your instructor Insert Table Chart TEXT Skage w Grade no Professor's Grade Book . Alternate Grading Scheme Test Number Bonuser Semester Name Test Tessa Tests Test Average of We Penalty Average Canon And 0 O -40 70 030 570 Greente Y5 TO 35 DOO 780 OH 00 BO TO of Adam 78 05 84 10 Run Roberta 90 00 00 70 GOO 15 3 930 9 Scart 65 05 00 10 10 Sverman Ace 05 79 DO 9 11 00 50 00 92 68 12 y Steve 62 yo 000 12 Q B00 13 West Steve 70 30 50 100 000 930 14 35 Grading Criteria 60 70 80 BE 18 D 3 B. D A B 83 18 Home Work Information Required number of assignments 20 Penalty for each assignment missing 21 Bonus for each additional Lesignment start 10 A MacBook Air BO 828 00 DIN DD ODO F& F5 F6 F7 Fa FS % & 7 ( 9 ) 0 4 5 6 8 ist Format Arrange View Share Window Help AssignmentOneinstruction online Edited co Collaborate Table Chart Shape Media Comment 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: a. 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. d. 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. e. 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 I & Then submit it on Blackboard to your instructor MacBook Air DIA DD 19 FS F * S . Alternate Grade Dook: the following figure displays a possble layout of your homework on Open the partially completed version of this worksheet given to you, and then complete the worksheet as follows: a The test average is computed by dropping the students 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 2 or 3. then taking the average of 60, 40, and 81. You will have to use the SUMMIN COUNT functions to meet this moment Students are required to complete a designated number of homework assignments (12 in the figurel. then receive a bonus or pay for every additional or missing home assignment. Andrea Carrion completed 9 homework assignments, rather than 12. and thus has a 6-point penalty points per each missing assignment Steve Weinstein however, receives a 3 point bonus (1 point for each extra assignment. The bonus or penalty s added to the test average to determine the semester avage you will have to use IF function here The grade for the course is based on the semester average and table of grading Cateria according to an HLOOKUP Nunction within the workshoot Poses the correct formulas for ALL of your cautions 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 cel E19 Save the result to a second worksheet (not another file. Please do not replace the first wonisteet Add your name to the end of each worksheet Add a custom header with your name, course you are taking and your instructor's name. Create a custom footer with today's date and the current time. Then submit on Blackboard to your instructor Insert Table Chart TEXT Skage w Grade no Professor's Grade Book . Alternate Grading Scheme Test Number Bonuser Semester Name Test Tessa Tests Test Average of We Penalty Average Canon And 0 O -40 70 030 570 Greente Y5 TO 35 DOO 780 OH 00 BO TO of Adam 78 05 84 10 Run Roberta 90 00 00 70 GOO 15 3 930 9 Scart 65 05 00 10 10 Sverman Ace 05 79 DO 9 11 00 50 00 92 68 12 y Steve 62 yo 000 12 Q B00 13 West Steve 70 30 50 100 000 930 14 35 Grading Criteria 60 70 80 BE 18 D 3 B. D A B 83 18 Home Work Information Required number of assignments 20 Penalty for each assignment missing 21 Bonus for each additional Lesignment start 10 A MacBook Air BO 828 00 DIN DD ODO F& F5 F6 F7 Fa FS % & 7 ( 9 ) 0 4 5 6 8 ist Format Arrange View Share Window Help AssignmentOneinstruction online Edited co Collaborate Table Chart Shape Media Comment 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: a. 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. d. 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. e. 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 I & Then submit it on Blackboard to your instructor MacBook Air DIA DD 19 FS F * S

Answer & Explanation Solved by verified expert

See Answer