Recently redesigned for extra simplicity and ease of use. Get the gradebook:
|Assessment Types - Points||Directly - Points|
|Assessment Types - Percents||Directly - Percents|
|Assessment Types||has fixed percentages for all the homeworks, classworks, tests, etc|
|Directly||has all assignments directly go towards the running average|
|By Points||assignments each out of so many points; more points = bigger weight|
|By Percents||assignments each out of 100%; you can still weight assignments|
With the gradebook you can:
- Calculate the running average
- Chart distributions of scores
- Print grade printouts for one student or everyone
- Weight grades
- Customize curve, excuse, and allow retakes
- Instructions in the grade tracker
For Windows Excel 2007+ or Mac Excel 2011+. The pretty sparkline charts show in Excel 2010+.
If using Excel online: colors may appear off till Microsoft supports conditional formatting with formulas. You can disable colors on the options sheet. -Noted March 2020
Please like and share if this is helpful!The workbooks are macro (code) free. You can safely ignore "formula references blank cells" warnings.
Charts and Grade Distributions
Easily graph distributions and chart scores. There's a prebuilt distribution for the overall running average:
The PrintoutsThe gradebooks have an easy-to-customize printout you can print for everyone or just one student. See video directions.
Be Creative!You can chart scores across gender, race, absences, or any other custom category.
- Try a boys vs. girls challenge.
- Use data to get $$ to help your low income minority students.
- Show how showing up and doing work relates to outcomes.
Video Tutorial Help
- How to use the printouts, 4 minutes
- How to add more assessment types, 3 minutes
- How to graph grade distributions, 5 minutes
- How the older printouts work, 4 minutes