Saturday, May 15, 2010

Blackboard Tip: Downloading Gradebook to Excel

To download your grade book to excel sheet, from the grade center click Work Offline Button and select download
From the download grade page , select your setting , you can select to download
Full Grade Center Contains all columns and associated data
Selected Column Using the drop-down menu, select one column. Check
the box to include comments for the column if preferred.
User Information Only Columns containing student data such as User Name and UserID .
Note : To download to excel sheet keep the delimiter type as Tab
Click submit
From the download page click download button , a window pops up, enabling to save your workbook any place on your drive , example is in the following screen shot
Blackboard saves the grade book in excel 2000-2003 format , you may have excel 2007 so when opening the file you get the following message
The above error message comes up when opening an XLS file (Excel 2000-2003) with Excel 2007. Select Yes .
Click OK to return to the Grade Center.

No comments:

Post a Comment