Hello BB Users
Did you know you can download you grade center and open it with Excel, make the necessary changes and upload it back to Blackboard?
Here is how you do it:
How to download the Grade Center to Excel
1. Go to the control panel
1. Go to the Grade Center
2. Click on “Manage”
3. Click on “Download”
4. Select what you want to download
5. Click on “submit”
6. Click on “Download”
7. Save File on your computer as a txt file (default).
8. You can now open it with Excel and start working with it.
How to upload the Grade Center from Excel
In order to download the grade center, you have to keep the same format in which you downloaded it. You can add columns and grades but cannot change the original format.
Columns Username, Last Name, First Name have to be exactly as they appear in your grade center.
9. Go to the control panel
10. Go to the Grade Center
11. Click on “Manage”
12. Click on “Upload”
13. Browse for your grade center
14. Click on “submit”
15. Upload Grades confirmation page
16. Calculated columns will not be updated, only grade columns.
17. Click on “submit”
Your Grade Center is now updated with the new data.
**Your file needs to be a TXT file in order for the upload to work. The best way is to keep the original format in which you downloaded it **
For more detailed instructions go to:
https://www.courses.miami.edu/webapps/portal/frameset.jsp?tab_id=_160_1
Thanks,
Rick Ramos
Blackboard Help Desk Supervisor
305-284-3949
