Tip #18: Downloading/uploading your Gradebook

Tip: You can download your Gradebook into Microsoft Excel and upload your Gradebook into Blackboard from Excel.

Here’s how to do it:
To download your Blackboard Gradebook to Excel, navigate to your course Gradebook. Click the Download Grades button. Select the Tab filter type and click Submit. Right-click the Download button and select Save Target As…

Name the file and select the location on your computer to which you want to save the file. Click the Save button. Locate the file you saved, double-click the file, and it will open in Microsoft Excel.

NOTE: We recommend that instructors periodically download their Gradebooks to an external drive for record-keeping purposes.

Upload your Gradebook from Excel into Blackboard:
Navigate to your Gradebook and click the Upload Grades button. Click the Browse button to locate the Excel file on your computer hard drive. Click Submit. Select the Excel column you want to import. Select the column to which you will import the Excel information or select the option to create a new Gradebook column. NOTE: You can import only one column at a time. Click Submit.

On the next page, select which students’ grades you want to upload or click the Select All button to upload all students’ grades. Click Submit.

Want more information?
Step-by-step tutorials are available at: http://www.twu.edu/blackboard/Bb72Tutorials.asp
Visit our website: http://www.twu.edu/blackboard,
or call: (940) 898-3706