Weighted Grade Book - Project 1

Understanding how weighted averages work will be a very important topic for you in this course, since your grades are determined in this way. In this project, you will create an Excel spreadsheet that can calculate a math 123 student's final grade. You will also answer several questions regarding your project within your Excel file.

Suppose a student received the following grades in MATH123:

Homework:25, 74, 54, 68, 77, 80, 82, 84, 84, 90, 92, 92, 90, 94

Quiz:65, 72, 78, 82, 84, 87, 88, 96, 98, 100

Projects:64, 66, 96

Review Quiz:60, 87, 98

Exam 1:55

Exam 2:70

Exam 3(final):95