Teacher Excel Markbook

This excel spreadsheet can be used to record student's grades. Using a 1-10 system you can record their marks and it will automatically average the grade. If you enter J, K or L in capitals (which is converted into a smiley face) in the effort column it will also average their effort grade. This provides formative feedback and allows progress to be monitored. This is a concept and could easily be adapted for specific use, i.e. Assessment without levels, BTEC etc.


Save for later