Skip navigation

Preparing your Final Course Grades in Moodle

Moodle displays a Course total (or final grade) to students.  The Course total can be based on calculated or aggregated grade items from the Moodle gradebook, or instructors can manually enter numeric grades, or import numeric grades from a spreadsheet. For more see Grade Calculation in Moodle.

At the end of the semester when grades are due, the Course total can be imported from Moodle into SPIRE on demand, in a single click.

Manual Input to Course Total Column

Moodle allows for manual input of the final course grade directly into the Course total column.

Please note: You must input a numerical grade to this column.

  1. Manually input the final course grade:
    1. To open the Moodle gradebook, from your main course page go to the Administration block and click Grades. The gradebook for the course will open.
    2. At the top-right corner click Turn Editing On.
    3. Scroll to the right to locate the Course total column, and enter a numeric grade for each student.
    4. Click Update at the bottom of the page.
  2. Letter grades in Moodle are automatically set to coincide with university standards.  If you would like to input your own numeric to letter grade conversion, you will need to set up a Letter conversion scheme. For more, see Letter Grades in Moodle.
  3. Import grades to SPIRE. For more, see Import Grades from Moodle to SPIRE.

Whole Course Aggregation

While you have the option to create your own formulas for calculations, Moodle comes with preset calculations for the gradebook. For information about the grade aggregation types, refer to Grade Calculation in Moodle.

The most common steps for Course total calculations in Moodle are as follows:

  1. (Optional) Set up course Categories. For more, see Create Grade Categories in Moodle.
  2. Select appropriate aggregation methods. For more, see Grade Calculation in Moodle.
  3. If not using the university standard, set up a Letter conversion scheme. For more, see Letter Grades in Moodle.
  4. Import grades to SPIRE. For more, see Import Grades from Moodle to SPIRE.

Import from a Spreadsheet

The Moodle gradebook  allows you to import grades from a spreadsheet, such as Excel.

  1. Convert score to be from a scale of 100 points in your spreadsheet.
  2. Upload to a new column in Moodle. For more, see Import Student Data into Moodle.
  3. Use the Calculator tool to make the Course total column equal to the newly imported column. For more, see Using the Calculator Tool in the Moodle Grade Book.
  4. If not using the university standard, set up a Letter conversion scheme. For more, see Letter Grades in Moodle.
  5. Import grades to SPIRE. For more, see Import Grades from Moodle to SPIRE.