Bill MacKenty

Technology strengthens, deepens, and broadens our learning...

Excel gradebook templates

This is an excel gradebook template I just finished.  I grabbed the basic layout (and some formulas) from here, and then added some cool features:

1) there are 5 different categories of assignments
2) each assignment can be weighted
3) the gradebook dynamically calculates the score depending on the category (which is cool, imho).

PLEASE tell me if you find any bugs and/or problems.

Thanks!

On 05 September 2006, Steve Beard inscribed the following thoughts about this post:

Bill, that is a nice gradebook.  Last year I spent several days working with schools on tracking pupil progress and that would have made a nice starting point.  I can’t find any of the examples we produced, but we had included the following:
Special Educational Needs (level)
Average Level of attainment at the end of primary school
Target level for the end of the year
Target level for the end of the key stage

I have just come across another markbook at: http://www.learnblog.net/ict/2006/08/20/how-to-use-a-markbook-in-ict/