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!