Before you import a file to Gradebook, you will need to ensure the file is compatible. Check that:

• the file type is a .CSV or .TXT file; and
• the file contains an Identifier field e.g. ID number and other grades column(s) e.g. Quiz: Week 2, Quiz: Week 3, Quiz: Week 4.

If your file has been exported from Gradebook and you wish to import it back into Gradebook, ensure that the Identifier field is not blank. If blank, you will need to delete the row(s).

1. Go to the Tools block and select Grades.
2. Click on the Import tab. Ensure that the CSV file tab is selected.
3. Click on the Choose a file… button.
4. Click Upload a file and click Browse… to search for the file you wish to import.
5. Click Upload this file.
6. If you are importing a .CSV file, select Comma for Separator. If you are importing a .TXT file, select Tab for Separator.
7. Click Upload grades.
8. Select ID number for Map from (this field is the Identifier field from your file).
9. Select useridnumber for Map to(this field is the Identifier field from iLearn).
10. The Grade item mapping section lists all the fields (i.e. columns) from the file you are importing. For each field, use the dropdown menu to:

• Select the name of a Gradebook column to map the field to; or
• Select new gradeitem to import the field to a new column in Gradebook (that will carry the field name); or
• Select ignore if you do not wish to import the field.

Other resources:

• Quick Guide
• Register for a Training workshop