I love what I do.

I love technology and education. Maybe you like knitting. Cool. My thing is educational technology.

Please feel free to leave a comment...

Excel gradebook templates

Wednesday, August 30, 2006

image

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!



Great Britain (UK)

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/



Commenting is not available in this weblog entry.

Avatar

Bill MacKenty, Chief Zuccini

I make a difference in the life of kids. You want to tell me what's more rewarding?

Avatar

Resume

This is my full resume. It has all my work experience since I graduated from college in 1992, including certifications, professional memberships, and descriptions of my work.

Avatar

Polish Resume

This is my full resume translated into Polish. My wife tells me it is a literal translation, and as such might convey a slightly different meaning to Polish speakers.