Gradebook - QuickGuide (Part 2)
QuickGuide
Gradebook Part #2
Summary
This guide will help you with the following tasks in LearningHub:
Setting up custom grading scales
Adding extra credit to the gradebook
Creating a multi-credit gradebook
Importing and exporting gradebooks
Navigating the gradebook
Dropping the lowest score from a category
Creating a Scale
Scales are useful for pass/fail grading or for point values using decimals (e.g., 0.5, 1.0, 1.5, etc.).
Steps to create a scale:
Open Excel.
In cells A1 and B1, input the first two numbers (e.g., 0.5 and 1).
Highlight both cells.
Use the small black square in the bottom right corner of the selection to drag the series to the desired maximum value.
Save the file as a CSV format.
Open the CSV file in Notepad and copy the values.
-
In your course on LearningHub:
Go to Gradebook Setup.
Click Scales under "Grade Administration".
Scroll down and select Add a new scale.
Name your scale (e.g., “0.5–7 scale”).
Paste the copied values into the Scale field.
Click Save changes.
Adding Extra Credit
You can add extra credit either to a specific category or to the entire gradebook.
To add a grade item as extra credit:
Go to Gradebook Setup.
Click Add grade item.
Name it (include "EC" or similar to indicate it's extra credit).
Set the point value.
Click Save changes.
Edit the settings of the grade item and check the Extra Credit box if not using a parent category.
To create an extra credit category:
Create a new category (e.g., "Extra Credit") and check the Extra Credit box.
Move all related grade items into that category.
Do not check the extra credit box on the individual items within the category.
Setting Up a Multi-Credit Gradebook
Multi-credit gradebooks are for courses that may be taken for a variable number of credits.
To set this up, email your grading plan to dlit@andrews.edu, and someone from the helpdesk will assist you.
Exporting the Gradebook
Steps:
Click Grades from the Administration Block.
Select the Export tab.
Choose Excel Spreadsheet.
Select the items to export.
Click Submit, then Download.
An Excel file will be saved to your device.
Importing Grades from Excel
If you maintain a gradebook in Excel or a publisher site, you can upload it to Moodle.
Steps:
Go to Gradebook Setup.
Click the Import tab.
Upload your file (CSV format recommended).
-
Use the following settings:
Encoding: UTF-8
Separator: Comma
Verbose Scales: Yes
Preview rows: 10
Click Upload Grades.
Mapping:
Moving Grade Items
In Gradebook Setup, click the arrow next to the item you want to move.
Select the dashed-line box in the desired location or category.
The item will move there automatically.
Dropping the Lowest Grade
This works only if all items in the category have the same point value.
Steps:
Click Grades.
Go to Categories and Items.
Click Edit on the category.
Select Edit Settings, then Show more under Aggregation.
Enter the number of lowest items to drop.
Click Save Changes.
Additional Resources: