Uploading Grades

If you use Excel to keep track of your grades you can now upload them into Blackboard with a few cautionary words. The preferred method for uploading your grades is to first download the grade book from Blackboard. The file will be saved as a .cvs format. Don't change the file extension. It should always remain .cvs not .xls or xlsx. It is important to download the gradebook into Excel first so that the names in the spreadsheet are identical to the names in Blackboard. Not following this procedure can cause errors in your gradebook.

Caution: If you use formulas in your Excel gradebook, the formulas will not transfer to the Blackboard platform the grade will be displayed as a number only.

When uploading data, the user will be able to upload one column at a time. To upload a column:

  1. In Excel, save the file as a CSV file.
    • From the menu bar, select File > Save As.
    • Click the down arrow after File Type and select CSV.
  2. In Blackboard, click the Upload Grades link.
  3. Click on the Browse button to choose your file.
  4. Click on the Submit button .
  5. Click the radio box in front of the column for upload
  6. Select the column currently in the Blackboard gradebook where the uploaded data will go.
    • If a column does not exist, select the last item, Create New Gradebook Item. Faculty member will be prompted to name a new column and assign points. Prompt will now ask user to select students whose grades should be uploaded.
  7. Select one, several or all students.
  8. System will also list scores to be loaded into the designated column in Blackboard.
  9. If an error message is displayed, use the browser's back button to get back to the Gradebook