Gradebook

Quick Links

How to add external grade items to Moodle gradebook

Teachers can add external grade items to Moodle gradebook, e.g. attendance, midterm, etc.

  1. In the Moodle course content page, click “Grades” under Course administration block.
    Gradebook_1

  2. Under “Setup” and “Categories and items” tab, click “Add grade item”.
    Gradebook_2

  3. Enter the name, maximum grade and other information of the grade item, click “Save changes”.
    Gradebook_3

  4. The grade item is now added to the Moodle gradebook.
    Gradebook_4

Export Moodle gradebook in excel format

 Teachers can export a excel file from Moodle gradebook and enter grades in excel.

  1. In the Moodle course content page, click “Grades” under Course administration block.
    Gradebook_1

  2.  Under “Export” and “Excel Spreadsheet” tab, select the grade items you would like to export to excel, click “Download”.
    Gradebook_5

  3.  You can save the excel file on your local computer.
    Gradebook_6

Import .CSV file to Moodle gradebook

  1. Teachers can enter grades in the exported excel file.

  2. Save the excel file in .CSV format.
    Gradebook_7

  3. In the Moodle course content page, click “Grades” under Course administration block.
    Gradebook_1

  4. Under “Import” and “CSV file” tab, upload the .CSV file by clicking “Choose a file” button. Click “Upload grades”.
    Gradebook_8

  5. Select “Email address” under “Map from” and “Map to” to identify the user. Select the items you would like to map from the excel file, click “Upload grades”.
    Gradebook_9

  6. Click “Continue” button.
    Gradebook_10
  7. The grades has been imported to the Moodle gradebook.
    Gradebook_11
0
0