Gradebook

Overview

The Gradebook function on Moodle allows professors to manage class course grades online. Here are a few benefits of using the Moodle Gradebook:

  • Students can track their progress and have access to their grades over the course.
  • Gradebook automatically creates grade items that correspond to assignments, quizzes, or other graded activities that you have created for your Moodle class.
  • Gradebook allows you to hide grades if they are not ready to display.
  • Gradebook allows you to give personalized feedback to your students.

Click here to access CETL's "Gradebook: Best Practices" handout for guidelines about how to most effectively utilize Gradebook.

Click here to access CETL's "Gradebook: Quick Start" handout if you would like a brief tutorial on using Gradebook.

gradebook setup link in gear menu

Return to Top

Navigation

In order to populate your Gradebook with assignments and activities you must first create them in your course. To do so follow these steps:

  1. Login to your Moodle course.
  2. Click Grades, located in the Navigation drawer.
  3. You will be taken to the Grader Report View.

Navigating the Gradebook

layout of the grader report view

  1. View dropdown menu
  2. Turn editing on button
  3. Gradebook options tabs
  4. Gradebook navigation tabs
  5. Alphabetical sorting
  6. Course and Category listing of Grade Items
  7. Scroll left or right with scrollbar.

Return to Top

Creating Grade Items

In order to populate your Gradebook with assignments and activities you must first create them in your course. To do so follow these steps:

  1. Login to your Moodle course.
  2. Click on Gear menu on the top right of your course.
  3. Click Turn editing on, located in the dropdown menu.
  4. Click the Add an activity or resource link on the section you wish to add your graded activity.
  5. From the Activity Picker, select the activity you wish to add.

add an activity or resource chooser window

  1. Complete the parameters for the activity you are adding.
  2. Click Save and Return to course.

Return to Top

Grouping Assignments in the Gradebook

In Gradebook you will have the ability to group assignments by type into categories. To do so follow these steps:

  1. Login to your Moodle course.
  2. Click on Gear menu on top right of your course.
  3. Click Gradebook setup, located in the dropdown menu.

location of Add category button in gradebook setup screen.

  1. Click on Add category.
  2. Name and set the parameters for your category.
  3. Click Save changes.

Return to Top

Determining the Assignment and Category Weight Percentages

It is important to determine the weight of each assignment and category to use a percentage system for your grading.  When performing your calculations ensure that the total percentage equals 100%.

Moodle Gradebook Course

Return to Top

Entering Percentage Values into Gradebook

After completing the above steps for Gradebook, you will be able to enter your calculated values in order to complete our Gradebook setup. In order to finalize your Gradebook follow these steps:

  1. Login to your Moodle course.
  2. Click on Gear menu on the top right of your course.
  3. Click Gradebook setup, located in the dropdown menu.

Editing Values in Moodle Gradebook:

edit weight values in gradebook setup

  1. Weights Column: Displays the weight applied to each category and assignment.
  2. Max Grade: Displays the max point value for each assignment you have created.
    • Note: This point value can be changed at the Assignment level.
  3. Actions: Displays an Edit menu with actions available to each assignment and category.
  4. Select: Displays selection button for each assignment or grade items within a category.
    • Note: This will allow you to interact with the Move dropdown menu at the bottom.
  5. Weight Checkbox: Allows you to Enable the weight field for a desired item.
  6. Weight Textbox: Available AFTER enabling weight, allows you to enter the desired weight for the selected item.
  7. Move dropdown menu: allows you to move the selected items into a catergory that you have created.

Return to Top

Disabling Grade Overrides

The Moodle Gradebook allows you to manually edit and override grades. Once an override is saved, these items become highlighted to indicate that the grade has been manually overridden. The override prevents further updates to the grade from outside the Gradebook.

Potential issues when grades are overridden:

  • If you edit a calculated column such as a Category total, it will not recalculate if graded items are changed.
  • If you override a grade within the Grader Report, you will not be able to change a grade or add a comment within the activity. To reinstate your ability to edit comments or grades within the activity, you must first disable the override.

Follow the instructions below to disable an overridden grade:

  1. Log in to your Moodle course.
  2. Click Grades, located in the Navigation drawer.
  3. Click on the Turn editing on button
  4. Find the overridden grade and click the Edit grade icon (small gear).
  5. Uncheck the Overridden box.
  6. Click Save Changes.

Return to Top

Displaying Letter Grades

Moodle supports only the input of numerical grades into the Gradebook. However, it is possible to have Moodle display numerical values as letter grades. Moodle features also allow you to adjust your grade boundaries.

NOTE: It is not possible to import letter grades from a spreadsheet application (e.g., Excel).

Please follow the instructions below to display letter grades:

  1. Login to your Moodle course.
  2. Click on Gear menu on the top right of your course.
  3. Click Gradebook setup, located in the dropdown menu.
  4. Click on Course Grade Settings tab.
  5. Click on Grade display type dropdown menu and select Letter.

Note: If you would like to display two grade types, select Letter (percentage). For example this would display an 85/100 grade as B (85%).

Please follow the instructions below to customize your letter grade boundaries (e.g., 93%-95% = A):

  1. Login to your Moodle course.
  2. Click on Gear menu on the top right of your course.
  3. Click Gradebook setup, located in the dropdown menu.
  4. Click Letters tab.
  5. At the top of the Grade Letters table, click Edit grade letters.
  6. Click on the Override site defaults checkbox.
  7. Change your letter grade boundaries.
  8. Click Save Changes.

Return to Top

Dropping the Lowest Score

If your Gradebook is set up with your assignments placed into categories, it will allow you to drop the lowest score for an activity (such as an essay or quiz).

NOTE: In order to drop the lowest score, all assignments should be placed in a category. Every assignment MUST have the same Max Grade value. Refer to the Creating Grade Categories and Grade Item Percentages support page for instructions on creating categories for your assignments.

Follow the instructions below to set up the “drop the lowest score” option:

  1. Log in to your Moodle course.
  2. Click on Gear menu on the top right of your course.
  3. Click Gradebook setup, located in the dropdown menu.
  4. Click Turn editing on in the upper right-hand corner of the Grader report view.
  5. In your Gradebook, click the Settings icon (gear) for the category you wish to edit.
  6. Click the Show More link under the Grade Category section.
  7. Under the Drop the lowest section, choose the desired number of activities you wish to drop.
  8. Click Save Changes.

Return to Top

Enabling Extra Credit

Moodle allows for extra credit items to be added into your Gradebook. In the Gradebook, extra credit appears as a check box, not a number.

Follow the instructions below to enable extra credit:

  1. Log in to your Moodle course.
  2. Click on Gear menu on the top right of your course.
  3. Click Gradebook setup, located in the dropdown menu.
  4. Click the Edit link and select Edit settings for the extra credit assignment.
  5. Click on the Extra Credit checkbox under the Parent Category section.
  6. Click Save Changes.

Return to Top

Exporting Moodle Gradebook to Excel

Moodle allows you to export data from your Gradebook to your own computer so you can modify values or calculate them with your own grading system (i.e., if you use advanced formulas to compute grades and prefer to work in a program like Excel).

NOTE: It’s recommended to download your Gradebook every 2-3 weeks during the quarter to help prevent issues later. For instance, if a student is unexpectedly dropped from your course, his or her grades within Moodle will disappear. If you regularly backup your grade book, you will have recent documentation of that student’s grades.

Follow the instructions below to export your grade book as an Excel File:

  1. Log in to your Moodle course.
  2. Click on Gear menu on the top right of your course.
  3. Click Gradebook setup, located in the dropdown menu.
  4. Click the Export tab to click on Excel spreadsheet link.
  5. Choose the appropriate options for your export. CETL recommend the default settings. 
  6. Click Submit when done.
  7. Click Download and save the file to your computer. You may now open the file using Microsoft Excel.

NOTE: After editing the file, save as a CSV file. This is the only file type Moodle will accept when importing the file back into Moodle.

Return to Top

Single View

Single view allows you to isolate assignments or individual students in order to grade more easily. The Single view allows you to batch grade, giving the entire class desired activity points.

Follow the instructions below access Single View:

  1. Log in to your Moodle course.
  2. Click on Gear menu on the top right of your course.
  3. Click Gradebook setup, located in the dropdown menu.
  4. Click the Single view tab.

Using Single View:

  1. On the Single View window select a Grade Item to view.
    • Note: To view that grade item for a single user select a user in the User dropdown menu.
  2. In the Override Column you may select a Grade Item to override.
    • Note: This allows you to override the grade value and leave feedback.
  3. In the Exclude Column you may select a Grade Item to exclude in the Gradebook calculation.
  4. At the bottom you may Bulk Insert a single value to override all the grades or empty grades.
  5. Click Update at the bottom to save changes.

Return to Top

Grade History

The Grade history report allows teachers to select specific students, grade items and/or graders and view the grading history for certain dates.  It is possible to view only revised grades and to download the data in various format such as .csv or an Excel Office spreadsheet.

Follow the instructions below access Grade History:

  1. Log in to your Moodle course.
  2. Click on Gear menu on the top right of your course.
  3. Click Gradebook setup, located in the dropdown menu.
  4. Click the Grade history tab.
  5. Select a user by clicking on the Select user button.
  6. click on the Submit button after desired options have been made
  7. Grades for user will be displayed.

Using Grade History:

  1. Use the Download Table Data as dropdown menu to obtain a copy of the Grade History set by your parameters.

Return to Top