To eliminate potential double entry of Grade Center data, you can perform offline grading and import grades into the Grade Center. You can also upload grades from external sources such as a spreadsheet or a comma-separated values (CSV) file. You must format data specifically to upload correctly and to synchronize with existing Grade Center data.
You can also use Grades Journey to save and share grade information for individual courses and assignments if your institution uses this feature.
The following narrated video provides a visual and auditory representation of some of the information included on this page. For a detailed description of what is portrayed in the video, open the video on YouTube, navigate to More actions, and select Open transcript.
Video: Work Offline with Grade Center Data shows how to set download options, download the Grade Center file, upload the new file, and select which grades to change.
Doesn't seem familiar? Jump to the "Ultra" help about downloading grades.
You can download full or partial data from the Grade Center.
Items with anonymous grading enabled won't be included in the downloaded file.
- Access the Work Offline menu and select Download.
- Select the data to download as described in this table.
Data to download Option Description Full Grade Center Contains all columns and associated data. Comments won't be included, and you can't add them offline. Selected Grading Period From the menu, select a grading period. You must create grading periods before you can choose any. Selected Column From the menu, select one column and its data. Select the check box to Include comments for this Column. Comments will download from the Quick Comment feature or Manual Override tab. You can edit included comment text offline. User information Columns containing student data such as username are included.
- Select the file delimiter, Comma or Tab.
- Select whether or not to Include Hidden Information in the downloaded data. Hidden information includes columns and students you hid from the view in the downloaded file.
- Select the location for the download. Browse to select a folder in the Content Collection if you have access to it.
- Select Submit.
- On the next Download Grades page, select Download to save the file.
- Access the Reports menu and select View Grade History.
- On the Grade History page, select Download and select the Delimiter Type for the file.
- Select Yes to Include Comments or No to exclude them from the download.
- Select Submit.
- Select Download to save the file to your computer.
After you download the file and open it in the appropriate editing software, you can make changes. If you download the full Grade Center, you can change and add grades, and save the file for uploading. If you downloaded a single column, you can add or change grades and comments, and save the file for uploading.
Comments are downloaded only when you select a single Grade Center item and the option to include its associated comments. The comments downloaded and uploaded are for the grade—accessed in the Quick Comment feature or Manually Override tab. The comments aren't for the attempt—accessed on the View Attempt or grading pages.
Four comment-related columns are included in the downloaded file. If you added comments online, those will be included in the download. Otherwise, you may add comments offline and upload them to the full Grade Center to appear in the Quick Comments feature or the Manually Override tab.
Add or edit comments in the Grading Notes and Feedback to User columns.
Links within comments to rich media, such as images or sound files, should be inserted and edited online.
When your edits to grades and comments are complete, save the file, return to the full Grade Center, and upload.
|Grading Notes||Grade Center column-specific comments visible only to an instructor or TA|
|Notes Format||Smart text, plain text, or HTML|
|Feedback to User||Grade Center column-specific comments visible to students|
|Feedback Format||Smart text, plain text, or HTML|
|Smart text||Automatically recognizes a link, the Enter key as a paragraph tag, and accepts HTML tags.|
|Plain text||Displays text as it's written in the text area. Plain text doesn't render HTML code. HTML code will appear as text.|
|HTML||Displays text as coded by the user with HTML tags.|
To synchronize external data to Grade Center data, unique identifiers are necessary for each student and for each column in the Grade Center. The unique identifier used for each student is the student's username. The unique identifier for each column is a column ID number. Column ID numbers are generated by the system and shouldn't be changed or deleted. Columns that don't have column ID numbers in an uploaded file will create new columns in the Grade Center.
Columns you add to the Grade Center from an external file are added as text columns with points possible equaling zero (0). Text columns can't be included in calculated columns, such as weighted, total, average, and minimum/maximum. After the upload, convert text columns to other columns types and add points possible.
Each data file you upload to the Grade Center requires a header row with one record per line subsequently.
The format of the data file uploaded to the Grade Center is determined by the type of delimiter you use to parse the data into separate columns. Data files are tab-delimited with a file extension of XLS or comma-delimited with a file extension of CSV.
Data in each column of comma-delimited files must be contained within a quote character—the most common is quotation marks ( " " ). Data in each column of tab-delimited files doesn't require a quote character.
When you upload data to the Grade Center, we recommend that you use tab-delimited files. When you use tab-delimited files, you don't have to use quote characters and you can open the files directly in Microsoft® Excel®.
To obtain a file that's formatted correctly for uploading, download the full Grade Center first and open it in a text editor or spreadsheet application. Existing columns have column ID numbers that must be included in future uploads.
Batch files are TXT files that hold large quantities of information to upload to the system. Each batch utility contains specific instructions on creating the batch file. These batch file standards are universal:
- Each file must be one of the supported file types: TXT or CSV.
Microsoft Excel versions 2003 and later automatically insert double quotes in every field if the worksheet is saved as a CSV file.
- Each file must be in DOS format. Files in MAC or UNIX format must be converted to DOS.
- Each field must be enclosed in double quotation marks, for example: "ENG_201"
- If quotation marks appear in a field, use an escape character to indicate that the next character doesn't mark the end of the field. The escape character is a backslash (\), for example: "\"ENG_201\""
- Each field must be separated with one of these delimiters: comma, colon, or tab. When you choose Auto, only one type of delimiter may be used in each batch file, for example: "ENG_201"or "English Literature" or " "ENG_201":"English Literature"
- Each record must be on a separate line.
- Don't include blank lines between records. The blank line will be processed and return an error.
- We recommend that each batch file not exceed 500 records because of timeout restrictions associated with most browsers.
Doesn't seem familiar? Jump to the "Ultra" help about uploading a file with grades.
Any file you upload that contains an "Incomplete" for a grade entry will be set to null, with no grade or text displayed. Any file you upload that contains "Complete" for a grade entry will be set to an override grade of the maximum points possible (100% for a grade item) in a column that has the primary display of Complete/incomplete. Any file you upload that contains a numeric entry will be a numeric entry.
- Access the Work Offline menu and select Upload.
- Browse for the file on your computer or from the Content Collection if you have access to it.
- Select the delimiter type: Comma, Tab, or Auto. If you choose Auto, the system attempts to automatically detect the delimiter used in the selected file.
- Select Submit to upload the file.
- On the Upload Grades Confirmation page, review the list of data from the file you want to upload. Clear the check boxes for any data to be excluded from the upload. With this method, you can upload only the columns of data you want from the file.
Review the Data Preview column to check that the correct data is being uploaded. Data that appears incorrectly can denote an improperly formatted file. The data preview only shows a sample of the data in each column in the file.
- Large files take significant time to process and a warning message appears for files that need extra time to process. To avoid long processing times, break up large files into separate uploads.
- Select Submit to confirm and upload the file.
Starting with the Q4 2015 release of Blackboard Learn 9.1, institutions can use Grades Journey to easily transfer student grade data from Blackboard Learn to their Student Information Systems (SIS). You can use Grades Journey to save and share grade information for individual courses and assignments if your institution uses this feature.
Ready to export grades? It’s easy to start the transfer process within the Grade Center. Before you begin, be aware that you may only transfer grades if your administrator has configured Grades Journey to allow your role to do so. If you have trouble, contact your administrator to make sure you have the appropriate permissions to use this feature.
To start extracting grade information, go to your course’s Grade Center and select Grade Approval and Transfer in the Manage menu. What you see next depends on the settings your administrator has chosen.
Administrators can enable a setting in Grades Journey that locks the Grade Center when you begin transferring grade information. The setting ensures that the grade data in BlackboardLearn stays consistent with the information contained in the grade extract file.
If this setting is enabled for your institution, a warning appears that says your Grade Center will be locked if you continue with the transfer. You'll still be able to see the grades for that course, but it's a read-only view and you won’t be able to edit.
See something that looks off after you extracted the grade information? If you notice any incorrect information or otherwise need to update it, contact your administrator to ask them to unlock the Grade Center for that course.
If your administrator hasn't enabled the Lock on Approval setting, you're brought to a Grade Extract History page after you select Grade Approval and Transfer. This page displays grade extract activity for this course.
The Action column describes what happened to the grade data, whether it was Extracted, Scheduled, or Unlocked. In each of the rows, you can also see who performed the action, when it was performed, and whether or not it was successful.
To continue the grade extract process, select Schedule Extract at the bottom of the page. A message appears to confirm that you want to release the grades for transfer. Select OK to continue or Cancel to go back. The extract occurs at the next scheduled interval, which is also a setting chosen by your administrator.
Doesn't seem familiar? Jump to the "Original" help about downloading grades.
You can download the full gradebook or select columns from your Ultra courses. However, items with anonymous grading enabled can't be selected and won't be included in the downloaded file.
You can export the file in a comma-delimited (CSV) or tab-delimited (XLS) format. You choose whether to save the file to your device or the Content Collection.
You can import your downloaded file into an application such as Microsoft® Excel® to do statistical analysis or other ad hoc computational work.
These columns are included in a downloaded file:
- Last name, first name, and username
- Student ID, last access, and availability
- Grade columns
- Manually added items
In the gradebook, select the icon with the down arrow to open the Download Gradebook panel.
Make your selections:
- Download the full gradebook or select columns.
- Select the file type for the downloaded file. Data files are comma-delimited (CSV) or tab-delimited (XLS).
- Select the location for the download. You can save the file to your device or Browse to select a folder in the Content Collection.
When you choose Select columns, a list of columns appears. Select the check boxes for the columns you want to download. Select the Show more link to display all the gradebook columns.
You can only include feedback in the downloaded file when you select a single column. Select the check box for Include feedback for the selected column. If the single item you select is an assignment or test, feedback only appears if you posted the grade. For a manually added item and graded discussions, feedback appears for all grading statuses: posted, ready to post, and needs grading.
If you assigned a grade and added feedback and later overrode the grade, your feedback won't appear in your single-column downloaded file.
When you download the full gradebook, the file includes the grades you posted or are ready to post. No feedback is included. Overall grades are included if you set that up in your gradebook.
Grades you assigned appear as points, letters, or percentages based on how you chose to display each graded item in the gradebook. The column header includes the grade display.
Some additional information is provided:
- In Progress: Student opened the item but didn’t submit it.
- Needs Grading: You have an attempt to grade.
- Needs Grading (grade): You assigned and posted a grade, and one or more attempts are ready to grade.
- Ready to Post (grade): You assigned a grade, but didn't post it.
If you haven't created any graded items, you may still download the gradebook. If you complete a course, you may no longer download the gradebook.
Doesn't seem familiar? Jump to the "Original" help about uploading a file with grades.
You can upload a grade file you worked on offline and update your gradebook. To upload a correctly formatted file, download the gradebook. Then, edit the file with the data you want to upload.
In the downloaded file, be sure to clear any cells you want to add a new grade to. For example, if "Ready to Post" appears with a grade, remove the text and the grade.
In the gradebook, select the icon with the up arrow to open the Upload Gradebook panel.
You can drag a file from your computer and drop it in the "hot spot" of the upload panel. You can also browse your files or use one you stored in the Content Collection.
In the panel, you can review the list of columns you changed in the file you want to upload. Clear the check boxes for any data you want to exclude from the upload.
In the grid view, columns with grade changes appear highlighted for a few seconds to show where the changes occurred.
Any grade additions or changes you made to non-posted grades in the file appear as overrides in your gradebook. In the student list view, you can open a student's submission and select Undo Override if needed. If you change a posted grade in the file, you'll need to post the grade again.
If you complete a course, you may no longer upload a file to the gradebook.
You can only upload a file in a comma-delimited (CSV) or tab-delimited (XLS) format. Reminder: To upload a correctly formatted file, download the gradebook. Then, edit the file with the data you want to upload.
To synchronize external data to gradebook data, unique identifiers are necessary for each student and for each column in the gradebook. The unique identifier used for each student is the student's username. The unique identifier for each column is a column ID number. Column ID numbers are generated by the system and shouldn't be changed or deleted.
You can add a column without a column ID number in the file you upload to create a new column in the gradebook. However, you must add at least one student's grade so the column is recognized and uploaded. The system adds a column ID number. You can edit the column after it appears in the gradebook to add the points total.
After you upload a file, a list of errors appears if you've made changes that adversely affect the gradebook. You're also notified about invalid usernames. Select the View Error Details link to learn more.
For some errors where you've cleared grades, you must select a result.
You're about to clear some grades with attempts. Select a result:
- Preserve grade
- All attempts appear as submitted but not graded
You're about to clear some override grades with attempts. Select a result:
- Use the attempt grades
- All attempts appear as submitted but not graded
For some errors, you can continue to upload with a warning that some data with errors may result in unwanted effects.