Importing marks into Gradebook

  1. Go to Settings in the left hand column. Under Course administration, click on Grades (Fig 1).

    Fig 1.

  2. Click on the Export tab at the top of the page (Fig 2). Exporting the file first will ensure that you have the correct set up for the file.  

    Fig 2.

  3. Click on Excel spreadsheet (Fig 3).
    Fig 3.  

  4. Scroll down to the bottom of the page and click the Submit button.

  5. Click the Download button and save the file to your computer, or you can open straight away with Microsoft Excel (Fig 4).
    Fig 4.

  6. Open the file and enter the marks in the appropriate column (Fig 5).  

    Fig 5.

    Note: The ID number column needs to be formatted to accept a zero in the front of any 7 digit student ID number. See Formatting ID number column below.

  7. From the File menu in the Excel Menu select Save as.
    Fig 6.

  8. Select .csv file (Fig 7 and 8). The spreadsheet will be ready to import into Gradebook.  

    Fig 7.

    Fig 8.

  9. Go back to Grades in the Course administration and click on the Import tab and then CSV file beneath that.  

    Fig 9.

  10. Click Choose a file (Fig 10).  

    Fig 10.

  11. Click on the Browse button to find the .csv file and then the Upload this file button (Fig 11).  

    Fig 11.

  12. Click on the Upload grades button (Fig 12).  

    Fig 12.

  13. Change the selection box to id number and map to useridnumber (Fig 13).  

    Fig 13.

  14. Click the Upload grades button to finish.  

Formatting the ID Number Column

  1. Select the column you wish to format to eight characters.  

    Fig 1.

  2. Select Format cells (Fig 2).  

    Fig 2.

  3. Select Custom and delete General (Fig 3).  

    Fig 3.

  4. Enter eight zeros in the box General was deleted and click the OK button (Fig 4).

    Fig 4.

  5. The numbering should now look like this (Fig 5).

    Fig 5.


Please send feedback to

Massey Contact Centre Mon - Fri 8:30am to 4:30pm 0800 MASSEY (+64 6 350 5701) TXT 5222 Web chat Staff Alumni News Māori @ Massey