Excel Templates

Excel Marks Template

This template allows teachers to record marks for a class or year group, and can accomodate a maximum of 10 assessments for up to 259 students. It provides a ranking for each assessment and total ranking, and converts marks for all assessments to percentages. It calculates total percentages and ranking based on assessments of various weightings (eg: a bookmark worth 10%, an essay worth 50%, and a test worth 40%). Simply plug in your student names, the weight of each assessment, what the actual assessment is scored out of,and the student mark, and the rest of the information will be calculated for you.

Download the template here:
Watch the explanatory video here: