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.


 Worry free guarantee
  • Assessment_TES.xlsx

About this resource


Created: Jun 24, 2011

Updated: Jun 20, 2017

Report a problem

By adding a School licence it allows you to share this resource with colleagues at your school. Without it, this resource is licensed for use only by you. Read licence details

9 Reviews

  • 4

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

  • 5
    user avatarzahrahali2 years 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!