The accompanying Gradebook spreadsheet contains a partially completed spreadsheet model for computing and summarizing the grades for a class. Complete the spreadsheet model by entering and copying the formulas in the appropriate cells. Cell range H4:H17 should contain the course number grades using the grades from exams and homework assignments and the grade allocation in row 22. Cell range I4:I17 should contain the course letter grades based on the grading criteria in cell range K4:L8. Rows 19, 20, and 21 should contain the average, maximum, and minimum exam, homework, and course number grades. You should only enter each formula once and copy the formulas to other cells. Gradebook Student ID Exam 1 Exam 2 Exam 3 Homework 1 Homework 2 Homework 3 Course Number Grade Course Letter Grade Grading Criteria 000-01-5562 60 50 40 79 92.0 76 0 F 000-01-2667 80 71 70 84 81.0 90 60 D 000-01-7376 65 65 65 60 90.0 94 70 C 000-01-1986 90 90 80 90 100.0 85 80 B 000-01-1936 75 70 65 95 94.0 85 90 A 000-01-2306 92 78 65 84 82.0 73 000-01-9719 82 78 62 77 98.0 74 000-01-9713 96 98 97 90 77.0 83 000-01-9797 92 88 65 78 94.0 89 000-01-7686 94 92 86 84 75.0 73 000-01-7905 60 50 65 80 86.0 74 000-01-4447 78 81 70 78 75.0 99 000-01-3981 90 90 90 70 87.0 86 000-01-5359 92 95 79 80 81.0 71 Average Maximum Minimum Grade allocation: 20% 20% 30% 10% 10% 10% 1. Is this a deterministic or stochastic model? 2. Which of the following is NOT an input of the spreadsheet model? A. Exam B. Course grades C. Grade allocation D. Homework grades 3. What is the course number grade for student 000-01-1936? What is the student’s course letter grade? Note: Round "Course number grade" to 2 decimal places.
The accompanying Gradebook spreadsheet contains a partially completed spreadsheet model for computing and summarizing the grades for a class. Complete the spreadsheet model by entering and copying the formulas in the appropriate cells. Cell range H4:H17 should contain the course number grades using the grades from exams and homework assignments and the grade allocation in row 22. Cell range I4:I17 should contain the course letter grades based on the grading criteria in cell range K4:L8. Rows 19, 20, and 21 should contain the average, maximum, and minimum exam, homework, and course number grades. You should only enter each formula once and copy the formulas to other cells.
Gradebook | |||||||||||
Student ID | Exam 1 | Exam 2 | Exam 3 | Homework 1 | Homework 2 | Homework 3 | Course Number Grade | Course Letter Grade | Grading Criteria | ||
000-01-5562 | 60 | 50 | 40 | 79 | 92.0 | 76 | 0 | F | |||
000-01-2667 | 80 | 71 | 70 | 84 | 81.0 | 90 | 60 | D | |||
000-01-7376 | 65 | 65 | 65 | 60 | 90.0 | 94 | 70 | C | |||
000-01-1986 | 90 | 90 | 80 | 90 | 100.0 | 85 | 80 | B | |||
000-01-1936 | 75 | 70 | 65 | 95 | 94.0 | 85 | 90 | A | |||
000-01-2306 | 92 | 78 | 65 | 84 | 82.0 | 73 | |||||
000-01-9719 | 82 | 78 | 62 | 77 | 98.0 | 74 | |||||
000-01-9713 | 96 | 98 | 97 | 90 | 77.0 | 83 | |||||
000-01-9797 | 92 | 88 | 65 | 78 | 94.0 | 89 | |||||
000-01-7686 | 94 | 92 | 86 | 84 | 75.0 | 73 | |||||
000-01-7905 | 60 | 50 | 65 | 80 | 86.0 | 74 | |||||
000-01-4447 | 78 | 81 | 70 | 78 | 75.0 | 99 | |||||
000-01-3981 | 90 | 90 | 90 | 70 | 87.0 | 86 | |||||
000-01-5359 | 92 | 95 | 79 | 80 | 81.0 | 71 | |||||
Average | |||||||||||
Maximum | |||||||||||
Minimum | |||||||||||
Grade allocation: | 20% | 20% | 30% | 10% | 10% | 10% |
1. Is this a deterministic or stochastic model?
2. Which of the following is NOT an input of the spreadsheet model?
3. What is the course number grade for student 000-01-1936? What is the student’s course letter grade?
Note: Round "Course number grade" to 2 decimal places.
4. What is the average course number grade for the class?
Note: Round your answer to 2 decimal places.
5. What is the highest grade for Exam 3? What is the lowest grade for Homework 3?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps