Important into copied from the syllabus: "...you must start with your own A B C D E F G H blank workbook or one provided by the instructor, and neither refer to the My MSIS3223 Grades spreadsheet of another person or allow N your spreadsheet to be referenced by any m Syl Wt Score Weight other person. Collaborating about process or concept with other without showing 4 Overall: 78.40 10% 90 91.288889 your actual spreadsheet is OK, but allowing 5 80 80.177778 others to see your work or copying any 6 0 Exams 0% 70 69.066667 formula, structure, or numbers is not." 7 X1 16.7%! 60 57.955556 Problem 1 (10 points) 8 X2 16.7%! Name a worksheet "Grades" Create the 9 X3 16.7%- grade computer for this class in Excel. Your 10 submission should reflect the requirements on your syllabus. A student should be able to 11 Quizzes 85 4% enter his/her scores into the dashed areas 12 Qz1 2.0%i 90 2.0% and see their current weighted average at 13 Qz2 2.0%! 80 2.0% the top of the page, as well as the average for each category. 14 Qz3 2.0%! 15 Qz4 2.0%- You should also compute what minimum 16 Qz5 2.0% score would be needed on the remaining work to achieve the grade breakpoints for 17 Qz6 2.0%i each letter grade (90,80,70,60) but you 18 Qz7 2.0%i should be able to enter other values in those 19 Qz8 2.0%! dashed cells as well. 20 Qz9 2.0%!The dashed areas are for user entries. Any 21 Qz10 2.0%- reasonable value should work in these areas 22 Qz11 2.0%; and any may be left blank. Outlined boxes 23 should contain Excel formulas and reference Qz12 2.0%) values in other cells. Any of the individual 24 item scores may be entered and deleted by 25 HW 100 4.0% the user. It should even correctly compute 26 HW1 4%! 100 4.0% everything when nothing is entered in a category. 27 HW2 4%! 28 HW3 4%- You should not have an error in computed 29 HW4 4%1 cells, no matter what is entered into the dashed cells, even if they are blank. Think 30 HW5 4%i "IFERROR". 31 HW6 4%1 L. 32 33 PI 22! 2%