As I explain over on my ‘other’ blog, I’ve never been very happy with how electronic gradebooks deal with criterion-based assessment, particularly as it relates to the MYP. So over the years I gradually developed my own for my math classroom using Excel and a few macros. Since then I’ve created versions for most if not all of the MYP subject groups. (Downloads below as .xlsm files (Excel 2007/2010 macro enabled))
Each gradebook should use the correct criteria and attainment levels for your subject so make sure you download the right one. If there is a mistake, or if there isn’t one for your subject, let me know and I’ll try and fix it ASAP.
I’ve also created a few short screencasts using Screenr on how I envision the gradebooks being used. (If you click on the full screen icon, it’s much easier to see!) Because I believe sharing makes things better, feel free to hack away at these and adjust them for your own use. Because I see these as being covered by a Creative Commons license (Attribution, Non-Commercial, Share-Alike) all I ask for in return is that you attribute me, you don’t make any money off of them and you share what you create as well!
Adding Assessments to the Gradebook
Determining Quarter Scores
Collecting Formative and ATL Data