You can upload grades from Blackboard Vista into Banner. However, the Final column must be either a Alphanumeric column or a Text column. By default, the Final column is Calculated. The upload process can only be attempted once. Only the instructor of record can upload grades from Blackboard to Banner.

If you have a calculation in the Final column, you must create a letter column based on the Final calculated grade:

1. Open the Blackboard Vista Grade Book.
2. Click Create Column.
3. Select Letter grade. The Letter Grade column screen is displayed.
4. In the “Column Label” text box, type a name for the column. For example, Final Letter.
5. In the “Based on numeric/calculated column” drop-down list, select Final.
6. Click Save. The Grade Book is displayed.

Download the Grade Book into an Excel spreadsheet:

1. Click Export to Spreadsheet. The Export to Spreadsheet screen is displayed.
2. Keep the defaults and click Export. The File Download dialog box is displayed.
3. Click Save. The Save As dialog box is displayed.
4. In the “Look in” drop-down list, navigate to the folder where you want to save the file.
5. In the “File name” text box, type a descriptive name.
6. Click Save.
7. If the File Download dialog box is displayed, click Close.
8. Click Cancel. The Grade Book is displayed.

Change the Final column from Calculated to a Text column:

1. Click Grade Book Options.
2. Select Column Settings. The Column Settings screen is displayed.
3. For the Final column, click the Calc link. The Convert Column Type window is displayed.
4. In the “New Value” drop-down list, select Text.
5. Click Save. The Confirm New Values screen is displayed.
6. Scroll to the bottom of the screen and click Apply. The Grade Book is displayed.

Edit the Excel file:

1. Minimize Blackboard Vista.
2. Open the Excel file; it will have a .csv extension.
3. Delete the Final column.
4. Rename the column that holds the letter grades to Final.
   NOTE: This is case sensitive, it must be named with a capital "F" and lower case "inal".
5. Save and close the Excel file.

Upload the Excel file into Blackboard Vista:

1. In Blackboard Visa, click Import from Spreadsheet. The Import from Spreadsheet screen is displayed.
2. Click Browse. The Choose File dialog box is displayed.
3. In the “Look in” drop-down list, navigate to the folder where the Excel file is stored.
4. In the file area, select the Excel file.
5. Click Open. The Import from Spreadsheet screen is displayed.
6. Click Upload. The Import File screen is displayed.
7. Scroll to find the Final column. Make sure the letter grades are there.
8. Scroll to the bottom of the screen and click Import. The Import Errors screen is displayed. It will let you know that it did not import the Last Name, First Name or Role columns. This is fine.
9. Click OK. The Grade Book is displayed and the Final column contains the letter grades.

Finally, you can upload the grades into Banner:

1. In the “Export to SIS” drop-down list, select Final.
2. Click Go (the green arrow). The Export Final Grade screen is displayed.
3. To the left of the Last Name column is a check box, click in the check box to select it. All the students will be selected.
4. Scroll to the bottom of the screen and click Export Final Grade. The screen updates and for each student you should see the message “Awaiting response from SIS".
5. The grades should take about 30 minutes to upload. You should check Banner to make sure the grades have uploaded properly.