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