Weighted Average with Drop-Down List
Hello everyone! I am a new teacher trying to create a gradebook in Google Sheets, but I am struggling with how to obtain the final grade calculation. I have inserted a drop-down menu to identify whether a task was a quiz, assignment, test, etc. and want to calculate the weighted average based on this selection (i.e. quizzes total 5% of the grade, assignments 20%, etc.). I have a separate sheet titled 'settings' where I have specified each of these weightings in case they change in the future so I won't have to mess with the formula again.
I am mostly wondering if this is even possible, and if it is then how. I am definitely open to reformatting the gradebook as well if that is where the issue is stemming from. I suspect that I might need to have a separate 'input' sheet for the points and have just the percentages on this sheet here.
Any insights would be very much appreciated!!!
