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.


9 Reviews

  • 4
    user avatarjoyceleigh2 months agoReport

    As I work with 16+ I will change 'effort' for 'feedback' but it looks a great template for me to get started.

  • 5
    user avatarzahrahalia year agoReport


  • 5

    This is great, but I don't know what the J K and L codes stand for. Can anyone help please?

  • 5

  • 5

    Great resource - straight forward to use and looks good too. Thank you - saved me hours and pounds!

Buy this lesson for $2.63
20% off - original price $3.29
Jun 24, 2011
Dec 22, 2016