Instructors may upload Gradebook information into the Blackboard Learning System from the Upload Gradebook page.
The Gradebook Upload will fail if the user name for each row of data is not present. Also, the Gradebook will not process the data for any Username that is not enrolled as a user in the Learning System course. Changes to the first name and last name columns will not be processed.
Note: For best results, Instructors should manipulate and upload a Gradebook that has been downloaded from the Blackboard Learning System (Release 6 or higher). It is not advised that Instructors create a new Gradebook from scratch then upload it. Also, it is not possible to upload a Gradebook from an earlier version of the Blackboard Learning System, such as Blackboard 5.
Follow the steps below to open the Upload Gradebook page.
Select Gradebook on the Control Panel.
Click Upload Gradebook.
Click Browse and select the file to upload to the Gradebook. The Choose Column to Import page will appear. On this page the Instructor may specify which item he or she would like to upload to the Gradebook. When a Gradebook is uploaded the existing grades are not automatically written over or lost. In the following Web pages the Instructor chooses which information is uploaded and written over.
Gradebooks may be uploaded as .csv files (using a spreadsheet) or as .txt (flat files). When uploading as a .txt file, check to make sure that the file uses the following format:
"Last Name, First Name (User Name) | Student Id","item1","item2","test 4","survey","Total","Weighted Total"
Keep in mind that the values for total and weighted total will not be processed as part of the upload. Only the scores for the individual Gradebook Items will be uploaded.
If the name of a column in the source does not match the name of a column in the destination, the user will be notified. They may decide whether or not they would like to proceed with the operation.
Note: The Total and Weighted Total columns cannot be included in a Gradebook upload because this data is generated by calculations within the Gradebook. Instructors cannot manipulate the data for these areas.