Gradebook 2


Introduction

The Gradebook tool allows you to input and keep track of students' grades in a more efficient manner. You can import and export grades directly between your computer and Sakai.

In order for grades to be sent to Gradebook 2 from the Assignments and Tests & Quizzes tools, you must first enter the Gradebook 2 tool and click Save on the initial setup screen. To change these Gradebook settings in the future, please refer to the Gradebook Settings section below.

Note: When changing some settings, it may be necessary to reset the Gradebook 2 tool in order for the change to take effect.

reset

For a summary of the Gradebook 2 icons, see the Gradebook 2: Navigational and Visual Aids.

Gradebook settings

When you first open Gradebook 2, the Set Up Gradebook page will appear on the right side of your screen.

You can change the name of your gradebook by typing a new name in the text box. You can choose to organize your gradebook into categories (weighted or unweighted) by choosing from the categories dropdown menu.

You can also choose which class grade statistics to display to your students by selecting the check boxes next to the statistic you would like to display.

setup

To edit your gradebook settings later, click Edit underneath the page title, then click Gradebook Settings.

settings

Categories

To organize different types of activities into groups (such as tests, projects, papers, etc.), choose a category type from the dropdown menu in the Set Up Gradebook page. There are two options available: normal categories and weighted categories. The difference between the two is that the latter will allow you to weigh categories in grading (e.g., Tests 50%, Homework 40%, Attendance 10%).

setup categories

Once you select a category type, click Save. To create a new category, click File underneath the page title then select New Category. This will open a New Category page on the right side of the screen.

new category

If you chose to organize the gradebook into non-weighted categories, creating one is simple.

category add

When you finish, click Add. The category will appear in the grade items list on the left as a folder.

categories

When you add grade items, you can assign them to the categories, and the total value for each category will appear.

categories items

To edit any of the category's settings, double-click the category name in the assignments list and it will open an Edit Category page on the right side of the screen, which contains the same settings as your New Category page. Click Save to finalize your changes.

If you've chosen to organize the gradebook in weighted categories, creating a categoryis a little more involved but still fairly simple.

weighted category add

When you finish, click Add. The category will appear in the assignments list on the left as a folder. If you've specified that the lowest grades be dropped, the number you entered will appear in front of the category name with a minus sign (e.g., If you typed 2, the category will display as "-2 Category Name").

Note: Until you add items to the categories, you'll see a message that "This gradebook is not correctly weighted."

weighted categories

When you add grade items, you can assign them to the categories, and the total value for each category will appear.

weighted categories items

To edit any of the category's settings, double-click the category name in the assignments list, and it will open an Edit Category page on the right side of the screen, which contains the same settings as your New Category page. Click Save to finalize your changes.

To delete a category, right-click the category name in the Grade Items list on the left and click Delete this category. Then click Delete on the right side to confirm.

Editing the course letter grade scale

To change the percentage ranges for which course letter grades are assigned, click Edit below the page title then select Grade Scale. This will open a Grade Scale page on the right side of the screen.

grade scale

To change a range for a letter, double-click the From grade and type in the new numerical value for the range. This will automatically change the To grade in the previous range to .01 less than the minimum of the next range.

Note: You can override the calculated course grade for a student by typing a new letter grade in the Grade Override column for that student. See the section on choosing which information to view.

Changing grader permissions

To change which categories and sections Teaching Assistants can grade, click Edit below the page title then select Grade Permissions Settings. On the Permissions page, select the name of a TA from the drop-down menu.

grader permissions

graders

Gradebook items

Individual tasks to which you can assign grades are referred to as Gradebook Items. These include specific activities such as tests, papers, assignments and projects.

Adding a gradebook item

To add a gradebook item, click File below the page title then select New Item. This will open a New Item page on the right side of the screen.

new item

In the New Item page, type a name for the item, number of points, and other specifications.

Click Add to add this item to the gradebook. Click Close to return to the list of students.

item add

Editing the settings for a gradebook item

Double-click the gradebook item that you would like to edit. This will open the Edit Item window on the right side of the screen.

Make any necessary changes to the name, point values, or any of the other attributes of the item.

When you finish, click Save on the lower right.

Recording scores for a gradebook item

Select an item you want to grade by clicking the box to the left of it. This will bring up the item's grade column in the right display screen. Click the box corresponding to the student whose grade it is. You will now be able to type the number of points the student received for that particular item.

grade item

By right-clicking the grade box for a student, you can add a comment to a particular grade:

comment

You may see triangles on the upper left corner of a grade box:

Note: You will not be able to add or change grades directly in the gradebook if the grade item is linked to your Tests & Quizzes or Assignment tool.

Removing a gradebook item

To delete a gradebook item, double-click the item you want to remove.

An Edit Item window will appear on the right side of the screen. Click Delete. A confirmation window will ask you whether you would like to delete. Press Delete on the bottom.

Note: Deleting an item will remove it from the grade book along with the grades. Students will no longer see the grades even if the item was released prior to being deleted.

item delete

Other options

Working with a student's summary

The Student Summary view allows you to view details about a certain student, grade and comment on their assignments, and excuse them from assignments. Clicking the student's name will open the Student Summary panel on the right.

student

In this screen are three tabs: Scores, Comments, and Excuses. The Scores tab shows you every item for the course and allows you to enter or change the grades for each. The Comments tab lets you leave comments for each item that the student will then be able to see. The Excuses tab gives you the ability to exclude certain assignments from a student's grade.

You can click View As Student to see exactly what the student will see. This is helpful if you haven't released all the items.

When you are finished, click Close on the lower right.

Choosing which information to view

To choose which grades and information are displayed on the student list, click the Attributes & Grades tab. Select any of the fields to be shown on the right for each individual student.

attributes

Searching

To search for a student, type his/her name in the search box above the gradebook display screen.

Click Find.

You can also choose to view only a particular section of your course in the gradebook screen. To view particular sections, click the dropdown arrow to choose the section you would like to view.

search

Sorting

You can reorganize the order of the categories and items in the left pane by clicking and dragging them. This allows you to move items to different categories, or reorder items within the same category.

Viewing history

To view the activity that has occurred within the gradebook, such as the addition of items or grades, click View under the page title, then select History.

A screen will appear with information about the Date, Action, and Entity for previous activity. Clicking any cell in a row will show further details about the specific action on the right.

history

Note: If you don't see all the columns, you can use a horizontal scroll bar at the bottom of the list. You can sort by clicking the heading of any column.

Click Close in the lower-right to return to the main gradebook screen.

Displaying statistics

To view a summary of the grades, click View under the page title and then select Statistics. This will bring up a Statistics page with the means, standard deviations, medians, and modes for each item in the gradebook. You can use the pull-down menu to review individual sections.

stats

Click an item in the table to display a graphical representation on the right.

Click Close in the lower-right to return to the main gradebook screen.

Downloading and uploading grades from a local file

Exporting or downloading grades

To save grades in a file on your computer, click Tools below the page title then select Export from the dropdown menu. Choose either to export Only Grades or Grades and Structure. Then choose which format you want to export the grades in (either .csv or .xls). Next, choose whether you want to include the comments you've added in the file.

When you click Export, the grades will be downloaded onto your computer in the format you've chosen.

export

Importing or uploading grades

To import grades, click Tools below the page title then select Import from the dropdown menu.

On the Import page, click Browse to choose the file you would like to upload. Click Next. You will see a summary of the items contained in your file. If there are errors in the file, a notice will appear. At this point you can continue by clicking Next or Cancel the import.

When the upload is complete, click Done.

import file

Formatting grades to be uploaded

You can import grades from a spreadsheet for new or existing gradebook items. The spreadsheet must be in .csv or .xls format.

The first column must have Student ID as the header (the first row of the first column) and contain student UD IDs.

Subsequent columns must contain the name of the gradebook item as the header (the first row). To specify the the maximum number of points for a new item, include the number between two brackets in the header (e.g., Essay 1 [100]). By default, the maximum number is 100.

The file can contain a column with the students' names and a Name as a header to make it easier to identify the UD IDs. The data in the name column will not be uploaded.

import Excel

If there are incorrect UD IDs, a message will appear. The grades for the correct UD IDs will still be imported.

import error


The content of this page is based on information in this page is based on documentation prepared by the students at Rutgers University in the Office of Instructional and Research Technology.