xlsx, 67.63 KB
xlsx, 67.63 KB

Mark book for my Periodic Table & Energy assessments (End of Module Tests, Homeworks and Quizzes).It will automatically generate update an overview page of each grade and keep a running average grade for the whole module. It also colour codes question marks in comparison to the total marks available to quickly see areas needed to be addressed during feedback.

To set it up enter student names and targets in the overview sheet, which will then get copied to all the other sheets.

For homework tasks with choices of tasks to answer just leave any questions not attempted blank, and the spreadsheet will generate a total based on the questions attempted for that student.

Creative Commons "Sharealike"

Review

5

Something went wrong, please try again later.

seashell1

4 years ago
5

This is really helpful to identify student strengths and weaknesses, thanks for sharing!

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.