A B C D E F G H 1 Question # 1 3 In this assignment, you will be using various formulae to make your calculations. Please complete the gray shaded areas. Sort 4 student names by last name. Pay particular attention to the weighted test scores and the bonus mark. Students who did OKAY homework, get a bonus of an additional 3 marks on their Final Mark. Please use RED to indicate a letter grade less than 709 5 results. 6 8 Sowinski's Grade Book - Excel Tests Marks g 10 Name Student Number Test 1 Test 2 Test 3 Test 4 Test Mark Homework Final Mark 11 Adamson, John 111223333 80 71 70 84 305 Poo 305.0 12 Barber, BettyAnn 444556666 92 98 97 90 377 OK 380.0 13 Boone, Dan 777889999 78 81 70 78 307 OK 310.0 14 Borrow, Ineda 123456789 65 65 65 60 255 OK 258.0 15 Brown, James 999999999 92 95 79 80 346 OK 349.0 16 Carson, Kit 888888888 82 90 90 70 332 OK 335.0 17 Flinstone, Fred 200000000 90 90 80 90 350 Poor 350.0 18 Gerey, Richard 222222222 75 70 65 95 305 OK 308.0 19 Glassman, Kris 444444444 82 78 62 77 299 OK 302.0 20 Milgrom, Marion 999999999 94 92 86 84 356 OK 359.0 21 Mousette, Mickey 300000000 75 78 65 82 300 Poor 300.0 22 Smith, Adam 777777777 60 50 65 80 255 Poor 255.0 23 Sundine, Mathew 100000000 60 50 40 79 229 OK 232.0 24 Woods, Lion 555555555 66 88 65 78 297 OK 300.0 25 26 Homework Average 77.9 78.3 71.4 80.5 Bonus 3 Grading Criteria 27 Highest Grade 94.0 98.0 97.0 95.0 0 28 Lowest Grade 60.0 50.0 40.0 60.0 60 29 Range 70 30 80 31 Exam Weights 20% 20% 20% 40% 90