Using Excel to upload student marks

Please note that this blog post was created in January 2016, in the pilot phase of the ORE project. For current materials on return of marks to Exams Office via Blackboard, please see the Blackboard support pages and the Exams Office FAQ.

We are aware that a significant number of people prefer to work in Excel to calculate and keep track of grades. It is possible to continue this practice by exporting a spreadsheet from Blackboard Grade Centre. The spreadsheet can then be uploaded back into Blackboard.

I’ve created a video demonstrating how to export the file, and how to upload results from the file afterwards. Or you can take a look at the text instructions below.

Export a spreadsheet suitable for working in Excel

To create a file suitable for working in Excel, you can download your Grade Centre by choosing Work Offline -> Download.

Some recommendations:

  • Download the full grade centre, so that you will include course instance codes. These can then be used in Excel to group students together.
  • Accept other defaults and create a tab-delimited file.
  • Save this file somewhere secure, where you can find it again easily, and using a suitable filename.
  • DO NOT ATTEMPT to directly open the file in Excel (see next section)

Import the file into Excel

Excel has a problem with some of the student numbers that we use – and treats them as numbers rather than text. So a student ID started with “07” for example, will have the first zero stripped in Excel. This means that Blackboard won’t recognise the number when you try to upload the file again.

Instead you need to first open Excel, and then choose the Data tab to import your Grade Centre file from Text. As you import the file you can tell Excel to treat the Student ID and Username columns as “text”.

Once the file has been imported, you can work on it as normal in Excel. To save the file in a format suitable for Blackboard, choose Save As, and then change the type to either csv or txt.

Upload the file to Blackboard

To upload your file, within the Full Grade Centre, choose Work Offline -> Upload. Browse to find your txt or csv file, and Blackboard will suck all the information back into the Grade Centre.

For full details on exporting the file and importing it to Excel, see the attached handout. Exporting the Grade Centre for Excel in Bb9_handout

Advertisements
This entry was posted in Grade Centre, Grade Entry and tagged , . Bookmark the permalink.

2 Responses to Using Excel to upload student marks

  1. Forde, Margaret says:

    Good video Sharon ?

    Sent from my iPhone

  2. Pingback: The Online Results Entry project – FAQ | Blackboard: NUI Galway

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s