Skip to content

Weighted Formulas in Gradebook (Part 2)

October 3, 2013

This is yet another guest post by our chat agent – Anna

This article is an elaboration/addition to our previously discussed “Weighted Grades and Gradebook Formulas”. You can read it here:

https://blog.quickschools.com/2013/10/01/weighted-grades-and-gradebook-formulas/


As awesome as automatically generated weighted final grades are in the Gradebook, there are many different features available with formulas, depending on how you would like to use it. Here are some other ideas for using formulas for weighted averages:

Extra Credit

Want extra credit to be, say, a flat 10% of a student’s grade? To do this, add an extra weight factor for the category “extra credit” and set its weight percent at 10%. Of course, you can set extra credit to be any percent of the final grade that you choose.For example in the screenshot below, Stewart’s final grade is a 100%.  

In order to count extra credit, we use a formula like the one below that includes extra credit as 10% of the final grade.Once the extra credit is taken into account, Stewart’s actual grade increases to 110%.

By using weighted formula for weight percent-based extra credit, as students excel in class, their grade can be scaled up to reflect the extra credit they have earned.

Partial Grades

Additional formulas are helpful for times when you might want to average just a few categories together. For example, if you you are looking for an “assessments” average, which finds an average of exams, tests, and quizzes, you could use a weighted average that is not a final grade. For this, average, be sure to uncheck “is final grade?” The formula will appear in the gradebook for teachers, students, and parents, but it’s grade will not appear on a student’s Report Card.

Single-Category Averages

You can also use formulas to average all of a student’s grades in one category. To do this, set the weight percent to 100% and only select the category you want to average.

Combinations of Categories

The grades for a few different categories can combined so that a student’s grades on assignments from these categories are averaged and weighted together in the final grade. For example, if Bellwork and Homework together were supposed to be 20% of a student’s final grade, then you could use one weight factor for these two categories. Simply add a weight factor for 20% and check both categories Bellwork and Homework in the same box.

“What-If” Final Grades

What if the semester ended right now, or between now and the end of the semester, students’ grades did not change? Because final grade formulas can be added at any time during the semester, teachers, students, and parents can see what the final grades for a course might look like if student’s average grades were the same through the rest of the semester.

Using formulas for all sorts of weighted averages is a great way to make Gradebook work for your grading system and your class. Although teachers are the only ones who can set up formulas in their classes’ gradebooks, anyone who can see the gradebooks will be able to see these averages. As part of this, weighted averages and formulas in Gradebook can be a great tool for getting good feedback on how well students are learning in class.

That’s all for now on weighted averages, formulas, and Gradebook. Of course, if you have any questions, please chat in – we would love to help.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s