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.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

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.

 

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

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Array
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education