| Optimum Final Exam Score to achieve maximum possible grade |
| Date |
Enter today's date here |
| Your Name |
Enter first name followed by last name |
| Section |
Enter your section number: 1, 4, or 6 |
| Section type |
Face to face or Virtual |
| Statement of the problem |
| In the following, a student's scores on various assignments are provided. All but the final exam scores are available. |
| Final exam has two parts. Part A and Part B. But the weight for final exam is 25% (combining Parts A and B). |
| Your goal is to perform a What-If analysis to understand how much the student has to score on each part to maximize the overall grade point (100 points max) |
| First, download the file and then save it as Final Grade Calculation |
| 1. Complete the range D13 to D31 with appropriate weights. Overall weights are available in the Weights table in A2:B8 |
| 2. Complete the range E13:E31 to calculate the actuate grade point for each assignment. For example, if a student gets 20 out of 30 in a quiz, and that quiz has a weight of 3% then the grade point would be 20*.03*100/30 |
| 3. The Calculation of grade point for the midterm was done as follows: Sum of scores obtained in parts A and B multiplied by weigth multiplied by 100 and then divided the whole thing by the total for parts A and B |
| 4a. Create a two variable Data Table with the folowing values for the Final Exam Part A (as column variable): 50, 60, 70, 80, 90, 100, 110, 120, 135 |
| 4b. And with the following values for Final Exam Part B (as row variable): 50, 60, 70, 80, 90, 100, 115 |
| 5. Plot the Data Table and label each series appropriately so it is easy to understand |
| 6. Add a meaningful title to the figure |
| 7. Upload it to Blackboard |
Jordanjameire
FInalGrade.xlsx
