Gradebook

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 “Gradebook setup” on the left hand side menu in the administration block.
    GradebookSetup
  2. Click “Add grade item”.

  3. Enter the name, maximum grade and other information of the grade item, click “Save changes”.
    grade_item_settings
  4. The grade item will be added to the Moodle gradebook.

Export Moodle gradebook in excel format

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

  1. In the Moodle course content page, click “Gradebook setup” under administration block on the left hand side menu.

  2. Click “Export” and then select “Excel spreadsheet” under Gradebook Setup.
    ExportExcelGradebook
  3.  Select the grade items you would like to export to excel and click “Download”.

  4.  You can save the excel file on your local computer.

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 “Gradebook Setup” under administration block on the left hand side menu.

  4. Click “Import” and then select “CSV file” under “Gradebook Setup”.
    ImportCSV
  5. Upload a CSV file.
    Import_grade_CSV
  6. The next page shows preview of your uploaded CSV file.
  7. 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”.
  8. Click “Continue” button.

  9. The grades has been imported to the Moodle gradebook.
0
3