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 Grade book, or instructors can manually enter numeric grades, or import numeric grades from a spreadsheet.

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 Grade book, from your course homepage go to the Settings block and click Grades. The Grade book 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. 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 Grade book. 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. 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 Grade book  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. 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.