---
title: "Creating Advanced Calculations in Ultra Course View"
canonical: "https://kb.uconn.edu/space/TL/26258800872/Creating%20Advanced%20Calculations%20in%20Ultra%20Course%20View"
format: markdown
---
This article is intended for instructors looking to create an Advanced Gradebook Calculation in Ultra Course View.

Instructors can use Functions to build calculations and combine functions using operators. 

- Functions
  - **Average**- Returns the average for the selected Gradebook items.
  - **Total**- Returns the total points earned relative to the points possible for the selected Gradebook items.
  - **Minimum**- Returns the minimum score for the selected Gradebook items.
  - **Maximum**- Returns the maximum score for the selected Gradebook items.
  - **Variable**- Select an individual Gradebook item to include in the formula.
- Operators
  - **Add**
  - **Subtract**
  - **Multiple**
  - **Divide**
  - **Parentheses**
  - **Value**- Enter a numeric value for use in the formula. At most, the value can contain seven digit before the decimal and four digits after the decimal, however, only two decimal places will be shown to students.

---

# **Video Instructions**

> Macro (iframe)

---

# **Instructions:**

1. Navigate to your course in Husky CT
2. On the top navigation menu, click **Gradebook.**
3. The next steps will vary depending on your **Gradebook** view, follow the steps corresponding to your view.
  1. **List View:**
    1. Hover over the gray line at the location where you want to add the column.
    2. The line will turn purple and a plus sign will appear in the middle. Click the plus sign to see the drop-down menu.
    3. Click **Add Calculation. **
  2. **Grid View: **
    1. Hover over the gray line at the location where you want to add the column.
    2. The line will turn purple and a plus sign will appear.
    3. Click the plus sign and a drop-down menu will appear.
    4. Click **Add Calculation.**
4. A new window will appear where you can create the column.
  1. Give the Column a Name.
  2. Set the Visibility of the Column.
  3. Under Select a Grade Schema, set the desired Grade method.
  4. Optionally, provide a description.
  5. Create the formula used for the calculation. Instructors can select functions and operations from the left hand menu, and set any required options in the main equation panel.
5. Click **Validate **to verify the formula is syntactically correct.
6. Once the formula is Validated, click **Save. **
  

> ℹ️ For more information or assistance with HuskyCT, please contact the** Educational Technology Office** at [edtech@uconn.edu](mailto:edtech@uconn.edu) or **(860) 486-5052 **