There are three methods that can be used within Ultra to calculate midterm grades:
- Method 1: Using the overall grade column as your midterm grade. This should only be used when you’ve already created all course assessments.
- Method 2: Creating a manual calculation column within Ultra to calculate midterm grades.
- Method 3: Downloading a copy of the Gradebook into Excel and calculating the grades from there.
Method 1: Using the overall grade function as the midterm column
- Set up the Overall Grade as a weighted total.
- Please ensure the following two items in the settings are checked off, and select Percentage as a display to students (unless you want to show other type of display).
- Ensure that you only grade items that contribute to the midterm grade.
- The grade displayed is the midterm grade. You can enter that grade into Banner. As you continue to grade items throughout the semester, the Overall Grade will update to reflect the current grade.
Method 2: Creating a manual calculation column for midterm grades
- A manual calculation can be created within Ultra for the midterm grade.
- To create a manual column in the Gradebook, choose either “Add Calculation” or “Add Total Calculation“. The Total Calculation column mirrors the Overall Grade column, enabling the easy calculation of the lowest/highest X scores.
- Name the calculation “Midterm Grades” and assign the appropriate grading schema.
- To use Calculation column, follow the instructions below. Only add items that you want included in the midterm grade calculation.
- Select “Variable” from the menu on the left. Then, hover the cursor over the box that appears to choose a gradable item that needs to be included in the midterm calculation.
- Select “Multiply” from the menu on the left and an asterisk should appear.
- Select “Value” from the menu on the left. Enter the weight of the assessment into the empty box that appears. For example, if an assessment is worth 15%, enter 0.15.
- Select “Add” from the menu on the left if another gradable item needs to be added into the calculation.
- Repeat steps 1-3 as needed. The formula should look similar to this:
- Select “Variable” from the menu on the left. Then, hover the cursor over the box that appears to choose a gradable item that needs to be included in the midterm calculation.
- Save the formula to validate it. To access this calculation and view student midterm grades, find and select the column in your Gradebook.
Method 3: Downloading the Gradebook into Excel to calculate midterm grades
- Please see this resource which demonstrates how to download your gradebook into Excel.
Need support? Contact the Innovative Learning Support Centre. We are here to help!