Fully Automated Grading Book | Excel

This Excel Grading Book is fully automated meaning it will update simultaneously when you input data.

Each student's marks are automatically averaged. Cells, tables, and charts will automatically update when new data is entered.

The Grading Book Features:

• A Place for Achievement Standards and Content Descriptors to be put in.
• Adjustments for support drop-down list with 10 adjustments for differentiation.
• Averaged marks and A-E Grades are automatically calculated.
• Colour-coded grading.
• Identifies which students need action based on the data.
• A place for a comment for each student.
• The ability to filter students' marks.
• The ability to sort students based on marks.
• An automatically generated Class Data Summary table that categorizes how many students are getting each grade.
• An automatically generated pie chart to visually show the percentage of each grade.

This grade book is suitable for all countries and all grades. If you have multiple grades, you can make 'copy' the template to a new page, for a separate grade. A how-to guide is included.

It can be successfully uploaded to Google Sheets.