This is a user-friendly mark book made in Excel. It automatically works out the student’s overall term grade based on work they have submitted, as both a percentage as well as a grade.
It provides students with the ability to see what grade they are currently working at based on work they have submitted so far in the term - they can see if they are on track for, or how far off they are from, an A or B for example.
By simply inputting the “%” symbol in the column headings, the grade for an assignment will be automatically included in working out the overall term grade.
Grade boundaries can be customized easily, and the mark book will update automatically. You won’t have to calculate grades or percentages again.
If students haven’t submitted work, or were absent, a simple code such as “x” or “as” can be entered into the cell which will then automatically become highlighted in a certain colour.
Students can see the result for each peace of work they have done as a percentage.
The spreadsheet can easily be uploaded to Google sheets also.
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
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.
£3.00