| 50% I need to know how to calculate the minimum score to achieve the letters grades 90,80,70,60 and how it is formulated in excel |
Problem 2 Name a worksheet "Grades" Create the grade computer for this class in Excel. Your submission should reflect the requirements on your syllabus. A student should be able to enter his/her scores into the dashed areas and see their current weighted average at the top of the page, as well as the average for each category of assignment type at the top of that category as shown. A B C D E F G H My MSIS3223 Grades 1 3 Syl Wt Score Weight 4 Overall 83.03 41% 90 94.89361702 You should also compute what minimum score would be needed on the remaining work to achieve the grade breakpoints for each letter grade (90,80,70,60) but you should be 80 77.87234043 5 L 25% 70 60.85106383 78 6 Exams 25.0% 78 60 43.82978723 7 X1 25% 25.0%, 8 X2 able to enter other values in those dashed 9 cells as well. 10% 85 10 Quizzes 5.0%, 11 Qz1 90 5.0% The dashed areas are for user entries. Any 80 12 Qz2 5.0%l 5.0% reasonable value should work in these areas 5.0% 13 Qz3 and any may be left blank. Outlined boxes should contain Excel formulas and reference values in other cells. Any of the individual item scores may be entered and deleted by the user. It should even correctly compute everything when nothing is entered in a category 5.0 %, 14 Qz4 15 Qz5 5.0%l 5.0% 16 Qz6 17 100 6.3% 18 HW 6.25% 19 HW1 100 6.3% 20 HW2 6.25% 21 HW3 6.25%l You should not have an error in computed cells, no matter what is entered into the dashed cells, even if they are blank. Think "IFERROR". 6.25% 22 HW4 BONUS: Modify the quiz average cell so that IF there are more than two quizzes recorded (CouNT), then you remove the lowest (MIN) score. You'll also need to remove the weighting of that, but since each quiz is the same weight, this should be fairly easy. Problem 2 Name a worksheet "Grades" Create the grade computer for this class in Excel. Your submission should reflect the requirements on your syllabus. A student should be able to enter his/her scores into the dashed areas and see their current weighted average at the top of the page, as well as the average for each category of assignment type at the top of that category as shown. A B C D E F G H My MSIS3223 Grades 1 3 Syl Wt Score Weight 4 Overall 83.03 41% 90 94.89361702 You should also compute what minimum score would be needed on the remaining work to achieve the grade breakpoints for each letter grade (90,80,70,60) but you should be 80 77.87234043 5 L 25% 70 60.85106383 78 6 Exams 25.0% 78 60 43.82978723 7 X1 25% 25.0%, 8 X2 able to enter other values in those dashed 9 cells as well. 10% 85 10 Quizzes 5.0%, 11 Qz1 90 5.0% The dashed areas are for user entries. Any 80 12 Qz2 5.0%l 5.0% reasonable value should work in these areas 5.0% 13 Qz3 and any may be left blank. Outlined boxes should contain Excel formulas and reference values in other cells. Any of the individual item scores may be entered and deleted by the user. It should even correctly compute everything when nothing is entered in a category 5.0 %, 14 Qz4 15 Qz5 5.0%l 5.0% 16 Qz6 17 100 6.3% 18 HW 6.25% 19 HW1 100 6.3% 20 HW2 6.25% 21 HW3 6.25%l You should not have an error in computed cells, no matter what is entered into the dashed cells, even if they are blank. Think "IFERROR". 6.25% 22 HW4 BONUS: Modify the quiz average cell so that IF there are more than two quizzes recorded (CouNT), then you remove the lowest (MIN) score. You'll also need to remove the weighting of that, but since each quiz is the same weight, this should be fairly easy
