Teacher Excel Markbook

4.8(9)
author avatar

Created byInformingEducation

in English language arts

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.

  • Assessment_TES.xlsx
Download Icon

Assessment

Assessment_TES

xlsx, 136 KB

About this resource
CreatedJun 24, 2011
UpdatedDec 22, 2016

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.

9 Reviews

4.84.8
  • 4
    user avatarjoyceleigh5 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 avatarzahrahali2 years agoreport

    Excellent!!!

  • 5

    Hi
    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!