1. Create a model that calculates the course grade for a student in in a class. Suppose the course grade is calculated as 30% Midterm, 30% Final and 40% Homework. As inputs for the model suppose a student had a 79 on the Midterm, a 85 on the Final, and a 90 on their Homework. In a blank cell, label and write the answer to question 1.
2. Answer the following question using Goal Seek, "What grade does a student need on the final exam to get a 80% overall in the course?". Assume 79 on Midterm and 90 on Homework. In a blank cell, label and write the answer to question 2.
Get Answers For Free
Most questions answered within 1 hours.