Adding and deleting assignments [See Video]
Adding a new exam or assignment to your existing template is a 3-step process.
STEP 1: Adding a new blank column
- Select the entire column that is located just to the right of where you would like to add your new column by clicking the top (lettered) cell of the column.
- Next, go to the menu bar at the top of the screen and select "Insert" and then select "Columns."
- A new column will appear; double-click in the top cell to name the new assignment (e. g., "Exam 3").
STEP 2: Applying embedded formulas to the new assignment [See Video]
- To add formulas to your new columns, you will first need to ""unhide"" two hidden rows embedded at the top of the gradebook that contain computational formulas.
- On the menu bar, go to "Format," then "Columns," and then "Unhide;" rows 1 and 2 containing formulas will appear.
- Alternatively, place your cursor at the upper border of the top left cell (probably "row # 3"); when the cursor changes to double arrows you can drag down hidden row #2, and repeat the process to show hidden row #1.
- Next, copy the formulas from adjacent cells into the new columns. (Review "copying formulas")
STEP 3: Applying weights to the new assignment [See Video]
- Finally, re-hide the top 2 rows by selecting them, going to your menu bar to "Format," then "Columns," and then "Hide."
- Next, enter details of the new assignment or exam. If it is a weighted gradebook you must fill in the % you wish to allocate --making sure that the total % for all assignments and exams still adds up to 100%
- Enter the maximum points possible for the new assignment or exam.
- Finally, you will need to apply the formula that calculates average grade into the new cells.
STEP 4: Deleting columns
- You may decide to eliminate an assignment or exam. To do so you must delete the entire column.
- Highlight the column you want to delete by clicking on the top cell; right-click and select "Delete" from the menu that appears; the column will be deleted.
[back]