Upload Marks using a Spreadsheet (Original)
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
- From the Control Panel select Grade Centre > Full Grade Centre.
- Refer to the Create a column guide.
Download the spreadsheet
- Click on the Work Offline button.
- Click on the Download from the drop down.
Data
- From Select Data to Download.
- Select the Full Grade centre radio button.
Options
- Select the Comma radio button for Delimiter Type.
- Select the No radio button for Include Hidden Information.
Download Grades
- Click the Download button.
- Click on the downloaded spreadsheet to open it in Excel.
Enter / calculate marks
- 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).
- Highlight the marks in the column and then select copy.
- With the marks still highlighted, select Paste > Paste Values.
- The spreadsheet must be saved as a txt or csv file to be uploaded to Blackboard.
- If a message is displayed when you save the file, click the Yes button.
Upload the Spreadsheet
- Click on the Work Offline button.
- Click on the Upload from the drop down.
- Click on the Browse My Computer button.
- Open the required file.
- Click the Submit button.
- Check the upload grades confirmation page to make sure the changes you have made is there.
- 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.