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.
Export marks to file
Navigate to the Markbook and click Export marks to file, 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 place of the Export button 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.