Can I Upload an Excel Spreadsheet to Blackboard

• Created by , final modified by Andrew J McClurg on Feb nineteen, 2018

Topic Overview

If you lot adopt to maintain pupil grades in an Excel spreadsheet on your computer, you can still upload them to your course site.

NOTE

You can upload multiple grade columns to the Grade Center at one time.

IMPORTANT!

Columns that are added to the Course Center from an external file are text columns with zero points possible. Text columns cannot be included in Calculated Columns such every bit Weighted Grade, Full Points, Average Form, and Minimum/Maximum class. To include the added column in calculations, alter the column later uploading: alter Primary Display from text to score and type points possible.

Steps

Download Course Heart Spreadsheet

1. Click Piece of work Offline in the upper right corner of the primary Grade Center page.
2. Select Download from the drop-down menu.
3. Select the Full Grade Center radio push.
4. Leave Tab equally a delimiter type. Tab delimited files have the file extension .xls.
5. Cull Yes side by side to Include Hidden Information if you want hidden columns and students to be included in the spreadsheet.
6. Press the Submit button.
7. Press the Download button and relieve the file on your computer.

Calculation formulas cannot be downloaded or uploaded in such columns as Total and Weighted Full. Blackboard only copies values that resulted from the calculations.

Open a Tab-Delimited File in Excel

Double-click the downloaded tab-delimited file.

OR

1. Open the Excel plan.
2. Select File > Open . Select the saved tab-delimited file. Select Open up.
3. If Text-Import Wizard opens, get out the default "Delimited" option unchanged and press Next.
4. Leave Tab selected as a delimiter and printing Next.
5. Printing Finish.

Edit a Spreadsheet

You lot can use the downloaded spreadsheet to manage the grades in an Excel spreadsheet on your figurer. For instance, you can:

• Enter grades in columns downloaded from the Class Center
• Create new columns
• Enter grades in the new columns
• Perform form calculations using the Excel functions.

Don't modify any educatee information (proper noun, username, and student ID) and existing cavalcade headers if you plan to upload the spreadsheet back into Blackboard. When you add a new column, remember to blazon the name of the cavalcade in the header. Blackboard will add a column ID automatically when you upload the column.

Save a Spreadsheet as a Regular Excel File

1. Select File > Save as .
2. Type the descriptive name of the file including the course lawmaking and date (eastward.g., ed255_050508) in the File Name box.
3. Select "Excel Workbook" in Save As Type (on a PC) and Format (on a Mac) drop-downward menu.

Save a Spreadsheet every bit a Tab-Delimited Text File for Uploading

1. Select File > Save as .
2. Type the descriptive name of the file including the appointment (e.grand., ed255_050508) in the File Name box.
3. Select "Text (tab-delimited)" in "Save As Blazon" (for a PC) and Format (for Mac) drop-downwardly carte. Y'all can likewise select CSV (comma delimited option).
4. Click Save.
5. Click Yes to the question, "Do you want to proceed the workbook format?"

A Text (tab-delimited) option will salvage a file with .txt extension, for example, course.txt. A CSV (comma-delimited) option will relieve a file with .csv extension, for example, course.csv. Blackboard recommends using tab-delimited files for uploading.

In order to upload grades to the Grade Eye in Blackboard, you can first download the Grade Center, brand your modifications, and save the file. For instructions on how to download the Grade Center and correctly relieve the modified file, click this link: Downloading the Grade Center

Upload a Delimited File

Preparing the csv file

Your file should contain a header row on elevation to include the word username. You should likewise take a championship for the newly created column and should not be left bare.

1. In Blackboard, click Work Offline in the upper right corner of the main Grade Heart page.
2. Select Upload from the drop-down bill of fare.
3. Printing the Scan button.
4. Select the file on your computer. Make certain you selected a delimited file with .txt extension or a file with .csv extension.
5. Click Open up.
6. Select the Delimiter Type: Auto . Motorcar will attempt to automatically detect the delimiter used in the selected file.
7. Click Submit to upload the selected file.
8. Review the list of data from the file to exist uploaded. Use the bank check boxes to deselect any data to be excluded from the upload. Using this method, information technology is possible to upload only the desired columns of information from the spreadsheet.
9. Review the Information Preview cavalcade to ensure the correct data is beingness uploaded. Data that appears wrong tin denote an improperly formatted file. The Data Preview will simply show a sample of the data in each cavalcade in the file.
10. Click Submit to ostend and upload the file.

You can upload multiple grade columns to the Form Centre at once. The columns that do not have whatsoever deviation with the Form Center columns will be faded and not available for upload. To avoid long processing times, interruption upwardly large files into separate uploads

Sources and Relevant Links

Video- Working Offline with the Grade Centre

murrelldires1972.blogspot.com

Source: https://answers.syr.edu/display/blackboard01/Uploading+and+Downloading+Grades

Share this post