# New Feature! Gradebook Bulk Grade Change and Calculated Column Interface

## Bulk Updates to Assignment Grades

Instructors can now update all grades within a class for a single assignment at once. Instructors can**Add**as many points as they like, with or without a point cutoff. Instructors can**Subtract**as points up to a zero result. Instructors can change grades to be**Set to**a specified amount. All selected grades can automatically be set to**Max**or**Zero**points as well.

In addition, all grades that have had changes applied to them can be**Reset**to unlock the grades or reset all grades to a**dash**. These two options will not automatically apply to all selected students but only students who meet the criteria of having a grade changed and locked or having an automatic process reset the grades from dash to zero. Resetting the dash back to a zero is especially useful if an instructor needs to change the due date of an assignment that has already passed its original due date.

To apply bulk updates, select the**Gradebook**from the left navigation and select the desired class. From the loaded gradebook select the desired column and click the**View Details**button on the right pane.

![](https://3071401631-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M4H0WSwYCmWPAUTpA5M%2Fuploads%2Fgit-blob-974de6b6d8d25728418dac847b8c304f35efeaf5%2F2018-01-Bulkchange0.png?alt=media)

Once the button is selected each of the students in the class will be listed vertically.

![](https://3071401631-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M4H0WSwYCmWPAUTpA5M%2Fuploads%2Fgit-blob-0061f9a04da99daffff951a8ec6e4b33c8b040e5%2F2018-01-Bulkchange1.png?alt=media)

Select the desired students individually, or all students in the class by clicking the**Name**checkbox. Once names are selected, the*Adjust Selected Grades*button will become available to select.

![](https://3071401631-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M4H0WSwYCmWPAUTpA5M%2Fuploads%2Fgit-blob-a29f27f4920330a20dbdaaeafb822a5a1d6834b7%2F2018-01-Bulkchange2.png?alt=media)

Click the**Adjust Selected Grades**button to bring up the*Adjustment*window.

![](https://3071401631-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M4H0WSwYCmWPAUTpA5M%2Fuploads%2Fgit-blob-fc440ca801e3976f1999cce86e6bd723c52d34b4%2F2018-01-Bulkchange3.png?alt=media)

Select the desired change and click**Apply**.

![](https://3071401631-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M4H0WSwYCmWPAUTpA5M%2Fuploads%2Fgit-blob-c7d7fd9746f72016b573265f50105b58ea53a99f%2F2018-01-Bulkchange4.png?alt=media)

Once you select**Apply**a message will ask you to confirm adjustment and then inform you as to how many of the selected grades will be changed. All grades will be changed except for the last two selections which are context dependent.

## Calculated Columns

Selecting the columns involved in a column calculation has been improved. You can now select columns from a list and more easily see which ones have been added.

To view which columns are involved in a calculation, from the gradebook, click the**Gradebook Actions & Settings**button to view the*Columns*in the gradebook. Select a calculated column or click the**Create**button and select**Calculated**.

To view the new options click the**View/Edit**button in the lower right corner of the*Edit Columns*section.

![](https://3071401631-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M4H0WSwYCmWPAUTpA5M%2Fuploads%2Fgit-blob-cf80259293925a36e878b4663aa7bc9dbd88cf5b%2F2018-01-Calccolumn1.png?alt=media)

Select the columns on the left menu and click**Add**to add them to the calculation, on the right. Select the columns on the right and click**Remove**to remove them from the calculation. Once you have added the desired columns, click**Save**to complete the changes. You will be taken back to the*Edit Columns*section to complete the calculated column preferences.![](https://3071401631-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M4H0WSwYCmWPAUTpA5M%2Fuploads%2Fgit-blob-00cf56abb742589e9cda3c545c75db2415a501a9%2F2018-01-Calccolumn2.png?alt=media)