Gradebook Overview

1. Gradebook Overview

2. Navigation

3. Creating Graded Items

4. Grouping Items in the Gradebook

5. Manage Grading

6. Entering Percentage Values in the 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:

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.

7. Disabling Course 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.

8. 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.

9. Dropping the Lowest Grades

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.
3. Click the Show More link under the Grade Category section.
4. Under the Drop the lowest section, choose the desired number of activities you wish to drop.
5. Click Save Changes.

10. 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.

11. Exporting the 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.

12. 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.

13. 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.