The accompanying spreadsheet model, which is designed to compute student grades, contains some errors. a. Show and

Question:

The accompanying spreadsheet model, which is designed to compute student grades, contains some errors.
a. Show and review the formulas in the spreadsheet model. Which cells are most likely to contain formulas with errors?
b. For each of the suspected cells, identify the precedents and dependents of the formula in the cell. Use the Error Checking tool to inspect the cells. Are the errors due to circular reference, incorrect cell reference, or invalid user inputs?
c. Repair the errors and use the Watch Window tool to monitor the values in E20, F21, I10, and I15. What are the values in those cells after the errors have been fixed? Show the repaired formulas in the spreadsheet model.

 

Gradebook














Student IDExam 1Exam 2Exam 3Homework 1Homework 2Homework 3Course Number GradeCourse Letter Grade
Grading Criteria
000-01-55626050407992.07658.7F
0F
000-01-26678071708481.0900#N/A
60D
000-01-73766565656090.0940#N/A
70C
000-01-198690908090100.0850#N/A
80B
000-01-19367570659594.0850#N/A
90A
000-01-23069278658482.0730#N/A


000-01-97198278627798.0740#N/A


000-01-97139698979077.0830#N/A


000-01-97979288657894.0890#N/A


000-01-76869492868475.0730#N/A


000-01-79056050658086.0740#N/A


000-01-44477881707875.0990#N/A


000-01-39819090907087.0860#N/A


000-01-53599295798081.0710#N/A














Average81.8571478.2857171.3571480.642857186.571428682.2857143




Maximum9698979510099




Minimum606060606060




Grade allocation:20%20%30%10%10%10%
















Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Business Analytics

ISBN: 9781265897109

2nd Edition

Authors: Sanjiv Jaggia, Alison Kelly, Kevin Lertwachara, Leida Chen

Question Posted: