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? 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.

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter8: Working With Trendlines, Pivottables, Pivotcharts, And Slicers

Section: Chapter Questions

Problem 8EYW

See similar textbooks

Related questions

Question

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.

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?

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.