This test requires a course with a gradebook containing a few grade items (either from activities such as assignments or manually created grade items).
- Log in as a teacher and go to the course gradebook.
- Try exporting the gradebook either as an OpenDocument or an Excel spreadsheet.
- Download the spreadsheet, open it and add or edit some grades, then save the spreadsheet.
- Return to the course gradebook, then select 'Import' and select 'Paste from spreadsheet' in the second dropdown menu.
- Copy and paste the data from the spreadsheet into the data box in the form.
- Click the 'Upload grades' button.
- Check that the grades shown in the import preview are correct.
- Set column mappings appropriately and click the 'Upload grades' button.
- Check that the grades are correctly uploaded.