Gradebook should allow averaging of grades across worksheets

[Jeffrey Elkner]

I setup my grade book with quarter with the following worksheets:

1. Practice
2. Quizzes
3. Tests
4. Summary

I want to compute a grade that has tests (the average of all tests) count for 50% of the total, quizzes (the average of all quizzes) count for 40% of the total, and practice (the average of all practice) count for 10% of the total.

As of now, SchoolTool can not compute averages among worksheets, which greatly diminishes the usefulness of this otherwise amazingly useful feature.

At least two possible scenarios would work for me:

1. Make it possible to assign weighted averages to each worksheet column in the summary worksheet (this would be the easiest for me, and best fit my use case).
2. Make it possible to compute weighted averages of all activities on all worksheets (in this case I would have to have the discipline to setup weighted categories and to make sure I only put tests in the Tests worksheet, and quizzes in the Quizzes worksheet, etc).

I can image some teachers using worksheets not to separate activities into weighted categories, but to separate by other things such as time (a March worksheet and an April worksheet, for example). They may want to have different categories of activities within each worksheet, making the first scenario not work for them.

Worksheets are a wonderfully useful tool within the gradebook, but their usefulness is greatly diminished if the gradebook can not compute a grade among them.

[Tom Hoffman (tom-hoffman)]

We should discuss this at the sprint.