Skip to content | Change text size
 

Managing the Grade Book

Role: Instructors

 The Grade Book allows you to view, add, edit, release and export grades as well as to view student information.

Grade Book tabs
Add or edit a single grade
Add or edit multiple grades
Release grades
Add a column
Export data to a spreadsheet
Edit Grades in spreadsheet
Import Spreadsheet into Blackboard
SendMail

 

Grade Book tabs

The Grade Book is divided into five tabs that present various columns of grade and member-related data.

1. Click on the Teach tab.

2. Click on Grade Book in the Instructor Tools menu.

Tools menu

  • Grades: displays columns that are tagged as grade-related. Use this tab to view, enter or override grade-related information.
  • Members: displays columns containing student information such as username and location
  • View All: displays all columns
  • Custom View: allows you to create your own custom view of member information
  • SCORM Grades: displays columns that are automatically added for gradable SCORM modules

Grade book columns

top

Add or edit a single grade

1.Click on the Teach tab.

2. Click on Grade Book in the Instructor Tools menu.

3. Click on the Grades tab.

4. Click on the grade or space that corresponds with the appropriate assignment/assessment column and student. The Edit Value for: window will appear.

Change Grade

5. Type the new grade into the Change to field.

Change Grade

6. If you have edited a grade, type in a Comment explaining why the change was made.

7. Click Save.

Change Grade

Note: Grades added or edited via the Grade Book will appear with a caret symbol ^ next to them.

top

Add or edit multiple grades

1. Click on the Teach tab.

2. Click on Grade Book in the Instructor Tools menu.

3. Click on the Grades tab.

4. Click on the title at the top of the column in which you wish to edit or add grades.

Multiple Grades

5. Click Edit Values  .

Edit Values

6. For each student, type the grade into the Change to field.

Multiple Grades

7. If you have edited a grade, type in a Comment explaining why the change was made.

8. Click Save.

Note: Grades added or edited via the Grade Book will appear with a caret symbol ^ next to them.

top

Release grades

1. Click on the Teach tab.

2. Click on Grade Book in the Instructor Tools menu.

3. Click on the Grade Book Options button at the top-right of the window.

4. Click on Column Settings.

Grade Book options

5. Click on the box at the top of the appropriate column.

6. Click on the Release button at the bottom-left of the window. (You may need to use the scroll bar.) Once you have done this, Yes should replace No in the row titled Released to Student for this assessment item.

Grade Release

7. The released grades will now be visible to students (via My Grades, accessible from the My Tools menu in the Student View tab).

top

Add a column

1. Click on the Teach tab.

2. Click on Grade Book in the Instructor Tools menu.

3. Click on the Grades tab.

Create Column

4. Click on the Create Column button near the top-left of the window, and select the type of column you wish to add from the drop-down list.

Create Column

5. Type a title in the Column label field.

6. If the item is gradable, click on box next to Grade-related column.

7. If you wish for the student to view the column (via My Grades, accessible from the My Tools menu in the Student View tab), click on the box next to Released to Student.

Create Column

8. Click Save.

top

Hide/Show Column

Hiding Columns that are not required until the end of Semester reduces the width of the Grade book, allowing you to scroll across more easily. Hidden columns can be revealed at any time.

1. In the Grade Book, click the Custom View Tab

Custom View tab

2. Click on Reorder Columns

Reorder columns

3. Click on the the button to the right of the column titles to toggle between hiding and showing columns information in the Grade book

Show Hide Column

You can also rearrange your columns in the Grade book from this screen by clicking on the Move icon on the left.

  • Click on the check box next to the column you want to move
  • Click on the Move icon next to column, above which you want to move your column
  • The column will move to its new place

Freeze/Unfreeze column

The Last Name First Name columns in the Grade Book can be locked in place by selecting Freeze column. By doing this the Last Name and First Name columns continue to be displayed as you scroll across columns in the Grade Book.  Selecting Unfreeze Columns will unlock it.

Freeze column

Delete Columns

In Grade Book, you can delete columns you do not require.

1. In Grade Book, click Grade Book options

2. Select Column Settings

Delete Columns

3. On the Column Settings screen, select the checkbox above the columns you wish to delete

4. On the bottom left of the screen, click Delete

5. A pop up window asks you to confirm the removal of the column(s)

6. Click OK.

Export data to a spreadsheet

Note: Only grade-related columns can be exported.

1. Click on the Teach tab.

2. Click on Grade Book in the Instructor Tools menu.

Tools menu

3. Click on the Export to Spreadsheet button at the bottom of the window.

Grade Book Export

4. In the Export to Spreadsheet window, ensure the following are selected:

  • Members to Export: All Members
  • Columns to Export: Visible columns
  • Export Format: Comma-delimited
  • Character Set: Unicode (UTF-8)

5. Click on the Export button.

Grade Book Export

6. In the File Download box, Click Save

File Download box

7. In the Save As box, save File as exportedcourse.csv

Save As box

8. Select the folder into which you wish to save the file.

9. Click on Save.

10. Click Cancel in the Export to Spreadsheet window to return to Grade Book

top

Edit Grades in spreadsheet

1. Open exportedcourse.csv file in Excel

2. Sort Columns by Role

Exported spreadsheet

3. Add or edit Grades for Assignment

4. Save exportedcourse.csv file.

top

Import spreadsheet in Blackboard

1. Click on Import from Spreadsheet in Grade Book

Import from Spreadsheet

2. Click on Browse and locate exportedcourse.csv

Browse for File

3. Click on Upload

4. In the Import File box, match up the columns to be imported from the exportedcourse.csv spreadsheet with the Grade Book columns. Click on down arrows to choose from the options.

Matching columns

5. Click Import

The spreadsheet is now imported into Blackboard.

Send Mail

You can send mail to the members listed in the Gradebook by using the Send Mail link within the Gradebook.

send mail

1. Select the members from the Gradebook by ticking on the checkbox next to their name

2. You can select all members at once by ticking the checkbox on top (next to the Last Name)

3. Click on Send Mail

4. Compose Message as usual

Create Message

5. Click on Send.

Note: You can only send bulk mail to upto 200 members at a time in the Gradebook. Only select upto 200 recipients at a time from a page.

top