Operations template
Grade Book Template
Enter scores and weights once. Each student's weighted average and grade update automatically.
Opening a template uses no credits.
What's inside
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Student | Test 1 | Test 2 | Project | Average | Grade |
| 2 | Weight | 0.3 | 0.3 | 0.4 | ||
| 3 | Anna | 88 | 92 | 95 | =SUMPRODUCT(B3:D3,$B$2:$D$2) | =IFS(E3>=90,"A",E3>=75,"B",TRUE,"C") |
| 4 | Ben | 72 | 80 | 78 | =SUMPRODUCT(B4:D4,$B$2:$D$2) | =IFS(E4>=90,"A",E4>=75,"B",TRUE,"C") |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
E3 =SUMPRODUCT(B3:D3,$B$2:$D$2)
SUMPRODUCT multiplies each score by its weight and adds them up.
F3 =IFS(E3>=90,"A",E3>=75,"B",TRUE,"C")
Letter grade from the average.
Make it yours by asking
Try a request like this in Tabstra:
"Create a grade book with students, assignment scores, weights, weighted average and letter grade"