MfL Markbook Template

I thought I’d share this mark book template which I created this year for my new groups.  I created it as I wanted a mark book which let me filter student’s grades by skill.

It is pretty simple to set up – to get started all you need to do is to put the student names in in the row at the top of the sheet (currently filled with numbers 1-30).  Then to put in a grades for a piece simply chose a skill from the drop down menu (L (listening), R (reading), W (writing), O (oral), G (grammar), V (vocabulary), M (mock)), and then in the task column chose either ‘C’ for classwork and ‘H’ for homework.  The rest is self-explanatory.

To see student grades either by skill or by task type, click on the down arrow next to the skill or task heading, select the skill/type you want displayed, click on OK and that is it.

I hope you find it useful!

2 thoughts on “MfL Markbook Template

Leave your thoughts