The Markbook can be downloaded as a spreadsheet.
From the Markbook, class marks can be downloaded as a CSV file (Comma Separated Values) or an XLSX file (Excel spreadsheet). The Excel option includes student responses and teacher feedback on a per-question basis.
Navigate to the Markbook and click Export, near the top right corner of the screen.
The export can take a few minutes, depending on the overall size of the Markbook (number of students and lessons) and the amount of feedback given. The CSV and Excel options will appear in at the bottom right of your screen when the file is ready for download.
An email notification will also be delivered with the same download options, so there is no need to linger on the page.
Choose the file to download
The CSV format contains a very basic breakdown of marks awarded per lesson and per question for each student. This format works well if the information will be incorporated into another spreadsheet.
The Excel format contains much more information and formatting, broken down into three tabs:
- Submissions Grid features the total marks per lesson, the marks awarded to each student, and the class high, low, and average scores.
- Submissions Feedback Grid records written summary feedback given to each student on a per-lesson basis.
- Per Question is the most comprehensive view. Each question is broken down per-student and includes the marks available and awarded, the student response, and the feedback given by the teacher. Each question is further analysed on a per-class basis for the lowest, highest, and average marks awarded. Note: Student responses are only recorded for written, multiple choice, and true/false answers.