Blackboard FAQ: Grade Center, Uploading/Downloading Grades

How do I upload and download information into the Grade Center?

Downloading Grades
Periodically during the semester, it is prudent to download the Blackboard Grade Center as a backup or to work from exclusively. The Grade Center will be a CSV (comma delimited) file that can be opened in Excel or other spreadsheet programs.

1. From the Control Panel, access the Full Grade Center
2. Click Work Offline > Download located in the upper right corner of the Grade Center
3. On the following page, select from the following options:
   
   • Select the data to be downloaded (Full Grade Center, Selected Column(s), or User Information Only)
   • Demlimter Type (Comma or Tab*)
   • Download Location (My Computer or Content Collection)
4. Click Submit
5. Click Download when file is ready to be downloaded

*Note:  Comma-delimited files (.CSV) have data items separated by commas. Tab-delimited files (.TXT) are text files that have data items separated by tabs. Both are common types of data files and can be opened in most editing software. Tab-delimited files can be opened in Microsoft Excel but must be saved as .TXT files. Comma-delimited files need to be imported for use in Excel and must be saved as .CSV files. Saving the file in another format will make the file unreadable by the system when uploading.

Uploading Grades

Faculty who maintain a spreadsheet grade book outside Blackboard can upload their grades into the Blackboard Grade Center. To simplify the task of maintaining a spreadsheet outside Blackboard, first DOWNLOAD the Blackboard spreadsheet into Excel or preferred program. This automatically populates a spreadsheet with students' names.

1. From the Control Panel, access the Full Grade Center
2. Click Work Offline > Upload located in the upper right corner of the Grade Center
3. Browse for the file. Files can be uploaded from a local computer or if available, from the Content Collection.
4. Select the Delimiter Type: Comma, Tab, or Auto (Auto will attempt to automatically detect the delimiter used in the selected file)
5. Click Submit 
6. Review the list of data from the file to be uploaded on the Upload Grades Confirmation page. Use the check boxes to de-select any data to be excluded from the upload. Using this method, it is possible to upload only the desired columns of data from the file.
7. Click Submit to confirm and upload the file.

Note:  Large files take significant time to process and a warning message will be displayed for any files that need extra time to process. To avoid long processing times, break up large files into separate uploads.

< back to Blackboard FAQ index




Last Updated: 08/22/2011