Upload Marks using a Spreadsheet

Marks can be uploaded to the Grade Centre by following the following steps:

1. Add a blank column to the Grade Centre for the marks.

2. Download the spreadsheet.

3. Enter / calculate the required marks in the blank column.

4. Remove formulas and save the file as a csv file.

5. Upload the spreadsheet to Grade Centre.

Create a blank column

1. From the Control Panel select Grade Centre > Full Grade Centre.

2. Refer to the Create a column guide.

Download the spreadsheet

1. Click on the Work Offline button.
2. Click on the Download from the drop down. 

Data

1. From Select Data to Download.
   • Select the Full Grade centre radio button. 

Options

1. Select the Comma radio button for Delimiter Type.
2. Select the No radio button for Include Hidden Information.

Download Grades

1. Click the Download button. 

2. Click on the downloaded spreadsheet to open it in Excel.

Enter / calculate marks

1. Enter the marks / formula in the required column.

Note: Do not sort the spreadsheet or you may create errors when you upload it.

Remove formulas / Save

Note: The spreadsheet cannot contain formulas when it is uploaded to Blackboard. To remove the formulas copy the cells and paste them back again as values.

Note: Save this working file as a record of all of your calculations (with a different name).

1. Highlight the marks in the column and then select copy. 

2. With the marks still highlighted, select Paste > Paste Values.

3. The spreadsheet must be saved as a txt or csv file to be uploaded to Blackboard. 

4. If a message is displayed when you save the file, click the Yes button.

Upload the Spreadsheet

1. Click on the Work Offline button.
2. Click on the Upload from the drop down. 

3. Click on the Browse My Computer button.
4. Open the required file.
5. Click the Submit button. 

6. Check the upload grades confirmation page to make sure the changes you have made is there.  
7. Click on the Submit button. 

Note:  In the above example the column was set to display the score and the secondary display we set to Percentage.