Click the Advanced Filters button.
In the filter area, select the desired the filter options from the drop-down menus.
Click the 
button to obtain the Grades view of your choice.
The Grades tab allows you to manage grades for assignments completed by the students. The Course Content navigator displays the Course Content/My Course folders and activities for the course. You can view the available student grades for the assignments and activities. The Grades tab has three main areas: the Course Content Navigator, the Grades Area with the list of graded activities, and the Download Grades tools.
When using the Gradebook, please note, the following rules apply:
You cannot use commas in column names or column data as this will cause problems in downloading or exporting grades.
You cannot create more than 256 columns in the Gradebook.
The Course Content navigator displays the folders and study plans available in your course, mirroring the folder structure and organization in the My Course window. To view the contents of a folder, click the folder name to open it. To view the contents of a study plan, click the Study Plan name to view all of the items contained within that study plan (for example, a Pre-Test, Training, or Post-Test).
If you want to close the Course Content Navigator to make more room for the Grades Area, click the Hide text icon below the Date and Grades list, at the left side of the window. To redisplay the Course Content Navigator, click the Show text icon at the bottom left of the window.
Note: To set the course content navigator default view in Gradebook, go to the Grading section of the Preferences tool. To hide the navigator when the gradebook is opened, select Hide Gradebook Course Content Navigator by Default.
Advanced Filters allow you to choose which gradebook items/columns that display, so you can obtain a filtered view of the Grades. To use Advanced Filters to filter the Grades view, complete the following steps:
Click the Advanced Filters button.
In the filter area, select the desired the filter options from the drop-down menus.
Click the button to obtain the Grades view of your choice.
The filter options are:
Search Students: By default, the Grades view lists all students. To filter the Grades view to results for one or more students:
Click the Search Students button in advanced filter options. The Find Users page opens.
Enter the search criteria for a student based on User Name, First Name, or Last Name.
Select the search criteria. Options are:
Equals: The exact text entered.
Contains: The name contains a specific character(s).
Begins with: The name begins with a specific character(s).
Ends with: The name ends with a specific character(s).
Enter the search criterion in the text box.
Click Search to display the search results. The Grades view automatically refreshes to show the Grades view filtered for the student(s). The total number of students found is displayed next to the Search Students button. To again view all students, click Show All.
Show Status of all items: Displays the status of all items in Gradebook. When selected, all other filters are disabled. The status icons include:
Not Submitted: Indicates activity has not been submitted.
Submitted. Indicates that the content item is completed and submitted. This icon displays for unassigned items.
Passed: Indicates the student has passed the activity.
Not Passed: Indicates the student has failed.
Not Started: Indicates the student has not yet opened the activity.
Submitted: Indicates that student has completed the activity and submitted it for grading. This icon appears for submitted activities that have at least one instructor graded question and the question has not yet been graded.
Select Activity types: Allows you to select from the available activity types and sort the display for particular activity types. By default, all activity types display in the Grades view. Click Select Activity types to display the activity types available in your course and then click the checkbox for those activities you wish to include in the filter Grades view.
Item Status: Displays the following filter options:
All Items: (default) When selected, it displays all the items/columns in gradebook.
Completed only: Displays only items/columns that have at least one submission.
Assigned only: Displays all the items/columns that have an item assigned.
Assigned and Completed: Displays all the items/columns that have completed, assigned activities.
Column Sort: Allows you to sort the display of gradebook columns by:
Course Order: Displays the items/ columns in the order as seen in Course Content.
Alphabetical: Displays the items/columns in an Alphabetical order (A to Z).
By Due Date: Displays all the items/columns with due dates.
The Grades Area includes a number of navigation and filtering options. The Grades Area displays a series of columns -- one for student information, a Course Average column, and one column per activity assigned to students in your course. For each activity, a column includes a column header and various icons to indicate the status of the activity. Additional columns can be added using the Create Column tool (see below).
The Gradebook column headers include:
Student Name/Student ID: Displays the names of students enrolled in the course. If you want to view the gradebook by Student ID, click Show ID link. To view by Student Name, click the Show Name link next to Student ID column. [Note: you can use the Student ID view in conjunction with the Current Display download to generate a .csv file that can be imported into another grading or learning management system.] An option menu is available for each student, with option to Edit Grades, Send a Message, or Deny Access. For more details, click here.
The Student Name/Student ID column can be sorted ascending or descending by clicking the 
up or 
down arrow.
Course Average and/or Folder Average: If enabled for the course, these columns include folder-level calculations, as defined by the instructor. The Course Average appears in the top level the gradebook; the Folder Average appears when you click into a folder.
Note: For the columns to appear, Enable Folder level calculations for Gradebook and Today's View must be selected on the Grading section of the Preferences tool. From the Grading page, to specify the calculation criteria, select which content items are included, or to rename the default column headings, click Edit calculation settings .
The Course Average and Folder Average columns are updated every 24 hours to reflect student scores for all assigned items. The row also displays the last time the grade was updated (for example, last updated at 12:00 AM GST).
Note: If you want to confirm the last time the score was updated, click the last updated at 12:00 AM GST link. The Grade to Date Column window opens, listing the last date and time on which the Course Average or Folder Average was updated. Click Close to close the window.
The Grade to Date row has the following limitations:
Items that have not been submitted but are not yet due will not be counted
Items that have not been submitted but are past due will be counted as a zero
Items that were submitted past the due date will be counted as a zero unless the instructor accepts the grade
Items that are assigned without a due date will be considered as due on the last day of the course, and all the above apply.
Activities: The Gradebook includes one column per activity assigned to students in your course. For each activity, a column includes a column header and various icons to indicate the status of the activity.
Each gradebook column has an options menu, with various options available. For more information on options, click here.
Drag the icon to the left or right to change the order of columns in a gradebook.
Displays if an activity or study plan is assigned.
Displays if due date is specified for an activity or study plan. Point to the icon to display a tool tip showing the due date and time.
If you have indicated that unassigned items should display a checkmark in the Grading Preferences, a checkmark displays for unassigned items. If you select this option, the score and grades will be displayed for the students on the view submission page, but the score will not be available for the instructor. The instructor can only view the icon in the Gradebook for this item and cannot view the submission.
Created Columns: If you have created custom columns (see below), these columns also display in the gradebook.
Class Average Row: If you have used Class Average columns, these columns also display in the gradebook.
When scheduling an Objective-Based Question Only Exam or Dropbox activity, you have an option to provide a Class Average, either having students identified or anonymous. If you have selected this option, a Class Average row appears in the Grades view to show the average score of a class for those activities. Average score is calculated for all student submissions and is only calculated for numeric scoring. Average totals are updated continuously as each student completes or starts the activities. Note: Class average cannot be used in conjunction with Skill-Based or Project-Based Exams or Trainings or Study Plans.
The averages are displayed according to the Grade options specified in the activity preferences. These might include:
For Class Average, Students Anonymous: Displays class average only for each activity. Score results are displayed as:
Not Attempted: Indicates none of the students have started the activity.
In Progress: Indicates some of the students have started but have not yet completed the activity, or some of the students have completed the activity, but others have not.
Complete: Indicates all of the students have completed the activity.
For Class Average, Students Not Anonymous: Displays class average score and all student records for the class. Score results are displayed as Not Attempted, In Progress or Complete, as noted above. Additionally, score results for students are displayed on individual student rows. The score results for each student are displayed as:
Not Attempted: Indicates student has not yet started the activity.
In Progress: Indicates student has begun but not completed the activity.
Complete: Indicates student has completed the activity.
For each activity in the Gradebook, scores are represented with the following icons:
: Displays if the grades are edited after the submission.
: Displays if a student has a late submission (submissions after due date) and the scores are grayed. The scores will not be counted for any averages and will not be displayed in Reports. This icon will disappear only if you accept the submission. On accepting, the scores will be displayed normally.
: Displays if the student has failed to obtain passing grades.
: Displays to indicate a new grade. This icon displays when view the page for the first time after the grade is posted.
Not Attempted: Displays if a student has not yet started the activity.
In Progress: Displays if a student has started but not completed the activity.
Complete: Displays if a student has completed the activity. Click the Complete link to open View Submissions screen.
At the top of the Grades area, a toolbar includes a number of options for managing grades and student access..
Create Column
Send Message
Grant Access
Deny Access
This option helps you to create customized grade columns based on certain criteria. To create a new column in the Gradebook, complete the steps as outlined below.
NumericUsing Course Content Navigator, navigate to the folder where you want to create the column.
Click Create Column in the Gradebook toolbar and then click Numeric.
The Create Numeric Column window opens.
Type the column name in the Column name text box, up to 25 alphanumeric characters.
Select the location where the column is to be inserted from the Insert as drop-down list. Last will display the column as the last column this folder; 1 will display it as the first, 2 as the second, and so on.
Click Save to save the changes.
CalculatedA Calculated column allows you to aggregate grades for selected activities, and to also assign a weight to the final calculated grade, if desired. You can choose the operation that you want to use for the calculated grade, and then define the weighted grade for the calculated grade of specified content.
Using Course Content Navigator, navigate to the folder where you want to create the column.
Click Create Column in the Gradebook toolbar and then click Calculated.
The Create Calculated Column window opens.
Type the column name in the Column name text box, up to 25 alphanumeric characters.
Select the operation to be performed on the columns from the Select the Operation list: Sum to add the grades, Avg to average the grades, Min to display the lowest grade, and Max to display the highest grade.
Enter a Grade Weight(%), up to 99%.
From the Insert as list, select the location where the column is to be inserted from the Insert as drop-down list. Last will display the column as the last column this folder; 1 will display it as the first, 2 as the second, and so on.
In the Select the columns for operation area, all assigned activities display. Click the check box next to the appropriate items to include them in the calculation. To delete an activity, select the activity and click Remove from the Selected Activities taskbar.
Click Save to save the changes.
Selection ListA Selection List column includes a series of text options from which you can select. For example, if you wanted to add a Selection List column to store class participation column, you could create a Selection List column with options of Excellent, Very Good, Fair, Poor. To create a Selection List column:
Using Course Content Navigator, navigate to the folder where you want to create the column.
Click Create Column in the Gradebook toolbar and then click Selection List.
The Create Selection List Column window opens.
Type the column name in the Column name text box, up to 25 alphanumeric characters.
In the Enter list item text box, enter the first text option to appear in the list and click Add. The corresponding list item is added in the Existing List Item grid. Repeat this process until all list items are added. [To delete an added item or items, select the check box next to the item(s) to delete and then click the 
Delete selected items link.]
Select the location where the column is to be inserted from the Insert as drop-down list. Last will display the column as the last column this folder; 1 will display it as the first, 2 as the second, and so on.
Click Save to save the changes.
Free TextA Free Text column allows you to add a note to you or your student, directly in the gradebook. A maximum of 1000 alphanumeric characters can be entered in a Free Text column. To create a Free Text column:
Using Course Content Navigator, navigate to the folder where you want to create the column.
Click Create Column in the Gradebook toolbar and then click Free Text.
The Create Free Text Column window opens.
Type the column name in the Column name text box, up to 25 alphanumeric characters.
Select the location where the column is to be inserted from the Insert as drop-down list. Last will display the column as the last column this folder; 1 will display it as the first, 2 as the second, and so on.
Click Save to save the changes.
Import GradesThe Import Grades option allows you to import grades from a .csv file into your gradebook. When you import grades, they are added into a new column. To import grades:
First, generate a correctly formatted grade import .csv (comma separated value) file. At the bottom of the Gradebook page, in the Download area, select Student Roster from the drop-down list and set csv as the format. Click the 
Download link and then click the Save button to save the file to a location on your computer (for example, the Desktop).
Open the .csv file. Note that it includes five columns (no header) with student data in columns in the following order:
UserID: A system generated User ID for the student.
LastName: The last name of the student.
First Name: The first name of the student.
Userscore: The score the student obtained on the assignment. This column is blank; enter the student grade in this column.
Maxscore: Contains the maximum possible score for the assignment. This column is blank; enter the maximum possible grade in this column.
Save the .csv file in a location that you will remember.
Now, you can add the column to the Gradebook. Using Course Content Navigator, navigate to the folder where you want to create the column.
Click Create Column in the Gradebook toolbar and then click Import Grades.
The Create Imported Grades Column window opens.
Type the column name in the Column name text box, up to 25 alphanumeric characters.
Select the location where the column is to be inserted from the Insert as drop-down list. Last will display the column as the last column this folder; 1 will display it as the first, 2 as the second, and so on.
Click Browse to select the .csv (comma separated value) file with the grades.
Click OK to import the grades.
Total ColumnA Total Column allows you to create a column that calculates the total grade received by a student, based on one or more assessments, which can be weighted appropriately. To create a Total Column:
Using Course Content Navigator, navigate to the folder where you want to create the column.
Click Create Column in the Gradebook toolbar and then click Total Column.
The Create Total Grades Column window opens.
Type the column name in the Column name text box, up to 25 alphanumeric characters.
Select the location where the column is to be inserted from the Insert as drop-down list. Last will display the column as the last column this folder; 1 will display it as the first, 2 as the second, and so on.
On the left side of the window, navigate through the My Course view to locate the activities you want to include in the calculation. Select the check box next to the appropriate activities and then click the Add button. The selected item will be added to the Selected Columns section.
Continue adding activities until all items are added. [Note: to add activities from a Study Plan, you must click the Study Plan name and then select from the activities included in the Study Plan.] To remove an activity from the list, select the checkbox for the appropriate activity and then click Remove in the Selected Columns taskbar.
Assign a weight for each column or activity in the Weight text box.
The total weight for the selected columns is added up and displayed in the Total Weight text box. The total weight of the columns should ideally be 100.
Click Save to save the Total Column.
This Send Message tool allows you to send messages to students.
Select the check box next to the appropriate student name(s) in the Name column.
Click the Send Message link on the toolbar.
The New message window opens, so you can compose the mail. For more details, click here.
The Grant Access link allows you to define what students have the rights to access a course.
To grant access to a student, select the check box next to the appropriate student name(s) in the Name column.
Click the Grant Access link on the Gradebook toolbar.
The strikethrough no longer appears over the student name, indicating that the student has been granted access to the course.
The Deny Access link allows you to define what students have the rights to access a course.
To deny access to a student, select the check box next to the appropriate student name(s) in the Name column.
Click the Deny Access link on the Gradebook toolbar.
A strikethrough appears over the student name, indicating that the student has been denied access to this course.
At the bottom of the Gradebook, a Download Grades area displays. From here, you can download views of the gradebook and student roster in various formats. The Download drop-down list has three options: All Grades, Current Display, and Student Roster. The file format options include csv (comma-separated value), tab delimited, or pdf files.
All Grades: Downloads all the grades in all of the folders.
Select All Grades from the Download drop-down list.
Choose a file format from the drop-down list.
Click the 
button. A File Download dialog box displays, with options to Open or Save the file to a desired location.
Current Display: Downloads the grades shown in the current display.
Select Current Display from the Download drop-down list.
Choose a file format from the drop-down list.
Click the button. A File Download dialog box displays, with options to Open or Save the file to a desired location.
Student Roster: Downloads student information such as user ID, last name, first name. Use the .csv format to create a file that then can be used to import grades (see above).
Select Student Roster from the Download drop-down list.
Choose a file format from the drop-down list.
Click the button. A File Download dialog box displays, with options to Open or Save the file to a desired location.
Note: The download displays the Student Name or Student ID, depending on the view you have set at the time of download. If you download the grades when viewing by Student name, the download displays Student name. If you download the grades when viewing by Student ID, the download displays Student ID. [Note: you can use the Student ID view in conjunction with the Current Display download to generate a .csv file that can be imported into another grading or learning management system.]
The Gradebook has many options menus throughout, to allow you quick access to relevant functions. For more information on Gradebook Options, click here.