Importing marks into Gradebook

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

    import-1.gif  
    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.  

    import-2.gif
    Fig 2.

  3. Click on Excel spreadsheet (Fig 3).
     
    import-3.gif
    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).
     
    import-4.gif
    Fig 4.

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

    import-5.gif
    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.
     
    import-6.gif
    Fig 6.

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

    import-7.gif
    Fig 7.

    import-8.gif
    Fig 8.

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

    import-9.gif
    Fig 9.

  10. Click Choose a file (Fig 10).  

    import-10.gif
    Fig 10.

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

    import-11.gif
    Fig 11.

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

    import-12.gif
    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.  

    import2-1.gif
    Fig 1.

  2. Select Format cells (Fig 2).  

    import2-2.gif
    Fig 2.


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

    import2-3.gif
    Fig 3.

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

    import2-4.gif  
    Fig 4.

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

    import2-5.gif
    Fig 5.

Feedback

Please send feedback to stream@massey.ac.nz

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