I am trying to create a grade book using Google Sheets that produces a weighted average based on three grade categories; exams=45%, participation=30%, and homework=25%. I would like to do this be inserting a drop-down menu at the top of the column, then a formula that will keep a weighted average as grades are added.
Thank you for the responses.
I am only interested in calculating the weighted average for each student. The "4" represents the equivalent holistic grade (not relevant to this inquiry). "Student 1" represents an unnamed student in a class.
Here is a link to a sample worksheet file. There are three grades entered for each category (from the dropdown cell) and a filled in weighted average (not from a formula) based on exams=45%, participation=30%, and homework=25%.