Final Grade Calculation Midterm Final Homework Papers Quizzes Grading Scale 25% 30% 10% 25% 10% 90-100 80-89 70-79 60-69 0-59 A B C D F Activity Name...

I just need help answer the following question.

1.  An explanation of your process for using Excel to calculate the weighted average final grade. Were there any assumptions that you made about the scores provided?

2.     Analyze and reflect on the results for the student data provided. What is the predicted final course score based on the data provided. What letter grade is this?

3. What is the lowest grade the student would have had to score on the midterm to improve his final course score to the next higher letter grade?

4.  Some students and instructors feel that the weights for the course emphasize the exams too much. Come up with a new weighting system. Explain why you believe the new weights would be an improvement.

5.  How would you have to modify (if any) your spreadsheet to calculate grades in a class where scores are out of varying point values for each assignment? For example, in Professor Ivy’s class the individual homework grades are recorded as follows: HW1= 6/10, HW2= 36/54, HW3= 25/25... Professor Ivy prefers not want to turn these grades into percentages, because each is out of different points. How else could she find averages for homework in her class?

6.  How could you modify your spreadsheet to calculate a math 123 grade?