Faculty Assessment View Video Tutorial iconopen in new window
Gradebook

The Gradebook tool lets you perform many different functions related to grading. Within the Gradebook, you can add items, manage items, specify your Gradebook settings, set specific grade weights, download grades, and upload grades. You can also designate percent grades to their corresponding letter grades and vice versa. Blackboard automatically grades tests, so you do not have to go through and grade each exam.

For Tips and Tricks on how to use the Gradebook, please visit the tutorial.

Adding an Item
Setting Letter Grade Values
Changing the Item Order
Modify Spreadsheet Settings
Viewing Survey/Test Detailed Statistics
View a Student's Test Results / Assign a Grade to an Essay Question
Clearing Survey/Test Attempts
Adding New Categories
Adding New Grade Display Options
Running Total / Total
Running Weighted Total / Weighted Total
Weighting Grades
Downloading Grades
Uploading Grades


Adding an Item

From the Control Panel:

  1. Click on the Gradebook link in the Assessment section.
  2. Click on the Add Item icon.
  3. Type in the item’s name in the Item Name field.
  4. Choose a category from the Category drop-down menu.
  5. Type a description of the item in the Description field.
  6. Choose a date for the Gradebook item.
  7. Type in the amount of points possible for this item in the Points Possible field.
  8. Choose a display option in the Display As drop-down menu.

    Display Options:

    • Complete / Incomplete – This option signifies that a Student has completed an item. It is the default option for Surveys.
    • Letter - is a grade that equals a specific range of Percentages. For example, 94% to 97% equals an “A” Letter grade. The following Letter grades are built into the Blackboard Learning System. Instructors may modify these on the Modify Grade Display Options page.
      - 97% to 100% (or higher) = A+
      - 94% to 97% = A
      - 90% to 94% = A-
      - 87% to 90% = B+
      - 84% to 87% = B
      - 80% to 84% = B-
      - 77% to 80% = C+
      - 74% to 77% = C
      - 70% to 74% = C-
      - 67% to 70% = D+
      - 64% to 67% = D
      - 60% to 64% = D-
      - 59% or below = F
    • Percentage – Percentage is calculated by using the following calculation: (Raw Score/Points Possible) *100.
    • Score – Score is the raw score earned by the Student. There is a limit of 6 digits. For example, 100.00 or 123456.
    • Text – Text allows the Instructor to enter any string as the score for a Gradebook item. It does not have any calculable value. Scores that are entered as Text cannot be set to a numerical range. It is not possible to copy this display option, or modify the possible values.
  9. Scroll down to the bottom of the screen and click on the Submit button.

Options:

Settings - Letter Grade Values

From the Control Panel:

  1. Click on the Gradebook link in the Assessment section.
  2. Click on the Gradebook Settings button.
  3. Click on the Manage Display Options link.
  4. Click on the Modify button on the right of the Letter Option.
  5. Modify the percent values.
    Percent Value Screen Value
  6. Scroll down to the bottom of the screen and click on the Submit button.

Changing the Order of Gradebook Items

From the Control Panel:

  1. Click on the Gradebook link in the Assessment section.
  2. Click on the Manage Items icon.
  3. Choose the desired order numbers from the Order drop-down menu.
  4. Scroll down to the bottom of the screen and click on the OK button.

Viewing Survey/Test Detailed Statistics

From the Control Panel:

  1. Click on the Gradebook link in the Assessment section.
  2. Click on the Survey / Test name.
  3. Click on the Assessment Attempt Details link.
  4. Scroll down to the bottom of the screen and click on the OK button.
  5. Scroll down to the bottom of the screen and click on the OK button to return to the Gradebook.

Viewing a Student's Test Results / Assign a Grade to Essay Questions

From the Control Panel:

  1. Click on the Gradebook link in the Assessment section.
  2. Click on the Grade or ! character on the right os the student's name.
  3. Click on the View button on the right.
  4. Scroll down to the bottom of the screen and click on the Cancel button.
    Note: if you changed or entered a grade, then click on the Submit button.
  5. Scroll down to the bottom of the screen and click on the Cancel button to return to the Gradebook.

Clearing Survey/Test Attempts

From the Control Panel:

  1. Click on the Gradebook link in the Assessment section.
  2. Click on the Grade, or ! character on the right of the student's name.
  3. Click on the View button on the right.
  4. Click on the Clear Attempt button on the upper right.
  5. Click on the OK button on the Dialog Box.
    Note: This removal of the grade is permanent and can't be recovered.

Modifying Your Spreadsheet Settings

From the Control Panel:

  1. Click on the Gradebook link in the Assessment section.
  2. Click on the Gradebook Settings icon.
  3. Click on the Spreadsheet Settings link.
  4. Click on the check boxes next to the information you want displayed.
  5. Scroll down to the bottom of the screen and click on the Submit button.

Options:

Adding a New Gradebook Category

From the Control Panel:

  1. Click on the Gradebook link in the Assessment section.
  2. Click on the Gradebook Settings icon.
  3. Click on the Manage Gradebook Categories link.
  4. Click on the Add Category icon.
  5. Type information in the appropriate fields.
  6. Scroll down to the bottom of the screen and click on the Submit button.
Adding a New Grade Display Option

From the Control Panel:

  1. Click on the Gradebook link in the Assessment section.
  2. Click on the Gradebook Settings icon.
  3. Click on the Manage Display Options link.
  4. Type the name of the new display option in the Name field.
  5. Type in the desired numbers and letters in the appropriate Add Symbols and Values fields.
  6. Scroll down to the bottom of the screen and click on the Submit button.

Total / Running Total

Total displays the students total points even if all the items are not completed. Although the Running Total will allow you to see the students current grade (not all items completed), the student will only see the total in the My Grade view.

Depending on the options chosen displays the Running Total or Total grade.

Note: It is best not to leave a Null Value Null Value screen image for any Gradebook item.

From the Control Panel:

  1. Click on the Gradebook link in the Assessment section.
  2. Click on the Total link (item).
  3. Click on the Item Information link.
  4. Choose to Exempt items that have not been graded or not.
    Note: Recommended to choose NO. Choosing Yes (with Null Values) will cause an incorrect final letter grade tabulation for students. Choosing No, will not allow student to see (without manual calculations) their current grade during the quarter.
  5. Choose the Display As type.
  6. Scroll down to the bottom of the screen and click on the Submit button.

Display Options:

  • Complete / Incomplete – This option signifies that a Student has completed an item. It is the default option for Surveys.
  • Letter - is a grade that equals a specific range of Percentages. For example, 94% to 97% equals an “A” Letter grade. The following Letter grades are built into the Blackboard Learning System. Instructors may modify these on the Modify Grade Display Options page.
    - 97% to 100% (or higher) = A+
    - 94% to 97% = A
    - 90% to 94% = A-
    - 87% to 90% = B+
    - 84% to 87% = B
    - 80% to 84% = B-
    - 77% to 80% = C+
    - 74% to 77% = C
    - 70% to 74% = C-
    - 67% to 70% = D+
    - 64% to 67% = D
    - 60% to 64% = D-
    - 59% or below = F
  • Percentage – Percentage is calculated by using the following calculation: (Raw Score/Points Possible) *100.
  • Score – Score is the raw score earned by the Student. There is a limit of 6 digits. For example, 100.00 or 123456.
  • Text – Text allows the Instructor to enter any string as the score for a Gradebook item. It does not have any calculable value. Scores that are entered as Text cannot be set to a numerical range. It is not possible to copy this display option, or modify the possible values.

Weighted Total / Running Weighted Total

The Weighted Total can display the students final grade percentage or letter grade. Although the Running Weighted Total will allow you to see the students current grade (not all items completed), the student will only see the total in the My Grade view.

Note: If you are using extra credit (not counted against their final grade), then you cannot weight your grades. Weighting the extra credit item with 0...will not provide additional points for those who have completed it.

Note: It is best not to leave a Null Value Null Value screen image for any Gradebook item.

Depending on the options chosen, the Running Weighted Total or Weighted Total grade percentage will be displayed.

From the Control Panel:

  1. Click on the Weighted Total link (item).
  2. Click on the Item Information link.
  3. Choose to Exempt items that have not been graded or not.
    Note: Recommended to choose NO. Choosing Yes (with Null Values) will cause an incorrect final letter grade tabulation for students. Choosing No, will allow you to see the students current grade during the quarter, but not the student.
  4. Choose the Display As type.
    Note: You may want to leave this at the default setting Percent.
  5. Scroll down to the bottom of the screen and click on the Submit button.

Display Options:

  • Complete / Incomplete – This option signifies that a Student has completed an item. It is the default option for Surveys.
  • Letter - is a grade that equals a specific range of Percentages. For example, 94% to 97% equals an “A” Letter grade. The following Letter grades are built into the Blackboard Learning System. Instructors may modify these on the Modify Grade Display Options page.
    - 97% to 100% (or higher) = A+
    - 94% to 97% = A
    - 90% to 94% = A-
    - 87% to 90% = B+
    - 84% to 87% = B
    - 80% to 84% = B-
    - 77% to 80% = C+
    - 74% to 77% = C
    - 70% to 74% = C-
    - 67% to 70% = D+
    - 64% to 67% = D
    - 60% to 64% = D-
    - 59% or below = F
  • Percentage – Percentage is calculated by using the following calculation: (Raw Score/Points Possible) *100.
  • Score – Score is the raw score earned by the Student. There is a limit of 6 digits. For example, 100.00 or 123456.
  • Text – Text allows the Instructor to enter any string as the score for a Gradebook item. It does not have any calculable value. Scores that are entered as Text cannot be set to a numerical range. It is not possible to copy this display option, or modify the possible values.

Weighting Grades

Note: If you are using extra credit (not counted against their final grade), then you cannot weight your grades. Weighting the extra credit item with 0...will not provide additional points for those who have completed it.

From the Control Panel:

  1. Click on the Gradebook link in the Assessment section.
  2. Click on the Gradebook Settings icon.
  3. Click on the Weight Grades icon.
  4. Click on the Weight by Category or Weight by Item radio button.
  5. Type in the desired weight of each item in the appropriate text fields under the option you selected.
    Total of all weights must equal 100%.
  6. Scroll down to the bottom of the screen and click on the Submit button.

Download Grades

The Blackboard Gradebook file can be downloaded to your computer as a backup file or for adding grades in Excel. If you wish to use Excel to modify the Blackboard Gradebook, you MUST download the Bb Gradebook file first, do not change anything in the Excel file except the grades for one item, then Upload the file back into the Bb Gradebook with the instructions below.

Note: The exported .csv file cannot not be changed (new columns, complex equations) or it will not upload back into Blackboard. Also only one column at a time can be uploaded.

Note: The Total and Weighted Total columns are included in a Gradebook download. However, these columns will not be included in a Gradebook Upload, because they are generated by calculations within the Gradebook. The Instructor cannot manipulate the data for these areas.

From the Control Panel:

  1. Click on the Gradebook link in the Assessment section.
  2. Click on the Gradebook Settings icon.
  3. Click on the Download Grades icon.
  4. Select the delimiter type for the downloaded file.
    Note: If the downloaded .csv file will not open in Excel, try the .txt file.
       Comma: provides a .csv file.
       Tab: provides a .txt file.
  5. Scroll down to the bottom of the screen and click on the Submit button
  6. Read the instructions on the Download Gradebook screen.
  7. Click on the Download button to save the file on your computer.

    If you are unable to download a file (link) by clicking on it...Depending on the browser (Netscape, IE, Safari, or Firefox) computer (Mac or PC), and mouse you can download it by:
    • Right-Click on the link: Download to Disk.
    • Right-Click on the link: Save Link Target As.
    • Right-Click on the link: Save Link As.
    • Option/ Alt, Left-Click : Save Link As.
    • Control, Left-Click: Download Link to Disk.
    • Control, Left-Click: Save Link As.
  8. Scroll down to the bottom of the screen and click on the OK button.
Upload Grades

If you used Excel to modify the Blackboard Gradebook, you MUST download the Bb Gradebook file first, do not change anything in the Excel file except the grades for one item, then Upload the file back into the Bb Gradebook with the instructions below. Blackboard will most likely not except an Excel file uploaded into it's Gradebook.

Note: The exported .csv file cannot not be changed (new columns, complex equations) or it will not upload back into Blackboard. Also only one column at a time can be uploaded.

Note: The Total and Weighted Total columns are included in a Gradebook download. However, these columns will not be included in a Gradebook Upload, because they are generated by calculations within the Gradebook. The Instructor cannot manipulate the data for these areas.

From the Control Panel:

  1. Click on the Gradebook link in the Assessment section.
  2. Click on the Gradebook Settings icon.
  3. Click on the Upload Grades icon.
  4. Click on the Browse button to find the Gradebook to upload.
  5. Choose the column you want to upload.
  6. Choose the destination column for the uploaded data.
    Screen image of Gradebook, upload .csv

  7. Click on the checkbox next to the Student's grades to upload.

    Don't forget to do this part or the grades will not be uploaded!

    Screen image Uploard Gradebook students items

  8. Scroll down to the bottom of the screen and click on the Submit button.
More Information

Q: Can I sort my Gradebook items?
A: Yes, use the Sort Items by drop-down menu to sort your Gradebook by category, date added, positions, or titles.

Q: Why would I want to use the Filter Items by Category drop-down menu?
A: Filtering narrows down the items in your Gradebook. This makes it easier for you to find which assignment you want to view or grade.

Q: How can I quickly add all my Midterm One grades for my 50 students?
A: There are two ways to quickly add grades. 1) you can click on the item name and then the Item Grade List link you can tab through and enter the grades. 2) you can download the gradebook, modify in Excel and upload it back into Blackboard.

Q: What happens if I click on any of the underlined names or assignments?
A: Clicking on the underlined names gives you access to the students’ user information, grades, and details. Clicking on an assignment gives you access to the item’s grade list, information, and details.

Q: How do I upload an Excel file of my grades to the Gradebook?
A: Blackboard needs a special format for the Gradebook to function. The easiest way to import your Gradebook into Blackboard is to create a Gradebook in Blackboard with all of your items. This Gradebook should not contain any student specific grades, just the items. Use the Download Grades tool to save the empty Gradebook as a .csv file on your computer that both Excel and Blackboard recognizes. You can then open the file in Excel and enter your grades for each student. Finally, use the Upload Grades tool to import the grades back to Blackboard.
Note: The exported .csv file cannot not be changed (new columns, complex equations) or it will not re-upload back into Blackboard. Also only one column at a time can be added re-uploaded.