Gradebook

From the Control Panel:

1. Click on the Gradebook link in the Assessment section.

Add Item

1. Click on the Add Item button.
2. Fill in Item Name field.
3. Select from the Category pull down list.
4. Type in a Description of the item.
5. Set the Date.
6. Fill in the Points Possible.
7. Specify an option from the Display As pull down list.
8. Select Options by clicking desired radio box(s).
9. Scroll down to the bottom of the page and click the Submit button.

Manage Item

1. Click on the Manage Items button.
2. Click on the Modify button next to the item to change.
3. Change the desired information.
4. Scroll down to the bottom of the page and click the Submit button
5. If desired, change the order of items by clicking on the dropdown number menus in front of each item.
6. Click the OK button.

Gradebook Settings

1. Click on the Gradebook Settings button.
2. Select desired option (see below).
3. Click the OK button.

Spreadsheet Settings

1. Click desired options.
2. Scroll down to the bottom of the page and click the Submit button.

Manage Gradebook Categories

1. Click the Add Category button.
2. Fill in the Name field.
3. Fill in the Description field.
4. Scroll down to the bottom of the page and click the Submit button.

Manage Display Options

1. Click the Modify button next to the Letter option.
2. Adjust the numbers and letters in offered fields as desired.
3. Scroll down to the bottom of the page and click the Submit button.

Weight Grades

1. Click the Weight Grades button.
2. Click desired Weight radio button.
3. Scroll down to the bottom of the page and click the Submit button.

Download Grades

1. Click the Download Grades button
2. After Delimiter Type click the circle before Comma.
3. Click the Submit button.
4. Click the Download button.
5. Click the Save button from the File Download window.
6. Select the location to save to. You may also want to change the name to reflect the class, section, semester, and year like the Blackboard Course ID.
7. Click the Save button.
8. Click the Open button from the Download Complete window.
9. The file should have each gradebook item in an Excel column and you should not see any squares or other strange characters. If the Excel file does not look correct, try again and after the Delimeter Type click the circle before Tab.
10. Close the Excel Spreadsheet
11. Click the OK button.

Note: The Gradebook .csv downloaded file is Excel compatible file, and can be opened from within Excel (File>open).

Upload Grades

1. Click the Upload Gradebook button.
2. Click the Browse button.
3. Find the desired file on your computer.
4. Click the Open button.
5. Click the Submit button.
6. Choose desired options.
7. Click the Submit button.
8. Select all students affected by the upload.
9. Click the Submit button.
10. Click the OK button.

More Information

Question: Can I enter all the grades for an item at one time?
Answer  : Yes, click on the name of the item at the top of the column and you will see a list of all the students and a grade field. Use your tab key to move between fields. Remember to Submit the grades before leaving this screen.

Question: How can I sort my items by Titles?
Answer  : The Sort Items by pull down list allows you to sort Items by Category, Date Added, Positions, and Titles.

Question: Why would I want to use the Filter Items by Category pull down list?
Answer  : The Filter Items by Category pull down list allows you to filter items by specific Items or view all Items at the same time.

Question: What happens if I click on any of the underlined names?
Answer  : By clicking the underlined names you will be able to access a list of options for each category. The student’s name provides such information as User Information, User Grade List, and User Details. Clicking the assignments you will be offered options such as Item Grade List, Item Information, Item Detail, Item Download, and Item File Clean Up.