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.example of grade book

  • Welcome to Web Applications Stack Exchange. Consider sharing a publicly editable sample spreadsheet with realistic-looking data, and showing your hand-entered expected results there. Jul 17 at 12:40
  • 1
    Welcome. Would you please explain whether you are calculating the weighted average for the entire class, for each student, or both; and, in the image in your question, which cell(s) contains the weighted average(s). Would you please also explain the meaning of the "4" beside "Class average" and also "Student 1". Would you also add an extra line of data to the image to show the result for student who gets less than 100% in each element of their assessments.
    – Tedinoz
    Jul 18 at 3:15

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%.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.