Instead of entering marks directly on to the marksheet, you can upload them using a spreadsheet template.
- Click Import marks above the marksheet.
- Select Download template in the pop-up window.
- Open the template, enter your learners' test dates and marks, then save it. The test date will default to today's date. For questions that learners have left blank, enter a capital 'N' for 'not attempted'.
- Return to Boost Insights and click Import marks again.
- Select Upload your spreadsheet in the pop-up window to upload your completed template. After a short wait, you should see a green banner saying 'Upload successful'. Click Close to return to the the marksheet.
If the completed template fails to upload, an error message will highlight the invalid rows. Correct the template and reupload it to try again.
If there are learners on the template who have not sat the test, delete their row before uploading the spreadsheet. The upload will fail otherwise.
You cannot edit existing marks using the spreadsheet template.