Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Part 3 The instructor uses a standard 10-point grading scale, but again may choose to change the scale later. Enhance your spreadsheet to include the
Part 3 The instructor uses a standard 10-point grading scale, but again may choose to change the scale later. Enhance your spreadsheet to include the calculation of the letter grades using the IF function. Include the grading scale limits as problem parameters (similar to the ay we did for the weighting percentages earlier), so these limits can be easily changed. Of course, any changes in numerical grades within the spreadsheet should result in automatic recalculation of the grades assigned. And a change in the grade scale limits should be automatically accounted for in the computation of the letter grades. Tests = Projects = Exam = 25% 10% 30% A scale is 90 through 100 B scale is 80 up to 90 C scale is 70 up to 80 D scale is 60 up to 70 F scale is O up to 60 Test 1 Exam 83 80 75 88 Name Bill Jones Nan Knox Jill Smith Joe Timms Average St. Dev 83 77 78.75 3 Test 2 70 65 99 92 80.50 14 Project 1 90 80 89 82 87.25 5 Project 2 85 90 89 76 85.00 6 90 82 85.75 3 Average Grade 79.90 78.40 C 90.10 A 82.65 B 82.76 5 Part 3 The instructor uses a standard 10-point grading scale, but again may choose to change the scale later. Enhance your spreadsheet to include the calculation of the letter grades using the IF function. Include the grading scale limits as problem parameters (similar to the ay we did for the weighting percentages earlier), so these limits can be easily changed. Of course, any changes in numerical grades within the spreadsheet should result in automatic recalculation of the grades assigned. And a change in the grade scale limits should be automatically accounted for in the computation of the letter grades. Tests = Projects = Exam = 25% 10% 30% A scale is 90 through 100 B scale is 80 up to 90 C scale is 70 up to 80 D scale is 60 up to 70 F scale is O up to 60 Test 1 Exam 83 80 75 88 Name Bill Jones Nan Knox Jill Smith Joe Timms Average St. Dev 83 77 78.75 3 Test 2 70 65 99 92 80.50 14 Project 1 90 80 89 82 87.25 5 Project 2 85 90 89 76 85.00 6 90 82 85.75 3 Average Grade 79.90 78.40 C 90.10 A 82.65 B 82.76 5
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started