Education template
Grade book
Weighted grades for a whole class with letter grades, ranks and class statistics. Change the weights or the grading scale and every grade updates.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
2 sheets
- Grades
- Scale
101 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 249 filled cells in all.
Built in
- Charts
- Conditional formatting
- Frozen headers
- 1 chart
- 6 conditional format rules
A look at the Grades sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Grade book | |||||||
| 2 | Enter scores out of 100. Weights in row 5 must add up to 100%. The grading scale is on the Scale tab. | |||||||
| 3 | Class | Biology 101, Section B | ||||||
| 4 | ||||||||
| 5 | Weight | 20% | 15% | 20% | 20% | 25% | 100% | |
| 6 | Student | Homework | Quizzes | Midterm | Project | Final | Weighted | |
| 7 | Ari Bloom | 63 | 72 | 66 | 68 | 62 | 65.7 | |
| 8 | Bex Carrow | 70 | 84 | 86 | 84 | 77 | 79.9 | |
| 9 | Cam Duarte | 90 | 86 | 76 | 77 | 92 | 84.5 | |
| 10 | Devin Esposito | 100 | 94 | 88 | 94 | 89 | 92.8 | |
| 11 | Eden Farrow | 100 | 88 | 100 | 93 | 86 | 93.3 | |
| 12 | Fin Galloway | 63 | 69 | 69 | 66 | 61 | 65.2 | |
- grades
- teacher
- class
- school
- weighted average
More education templates
EducationAttendance trackerMark each student present, late or absent for every class date. Attendance rates per student and per session are calculated for you.
EducationClass scheduleA weekly class timetable with color coded courses and a course list with rooms and instructors. Sessions, hours and credits are counted for you.
EducationSurvey results summarySummarize course feedback survey responses with counts, percentages and charts. Paste new responses and the summary updates.
FinancePersonal monthly budgetPlan income and spending for the month and see what is left at a glance. Compare planned and actual amounts by category with a chart.
Start your grade book now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.