Today we’re going to talk about one of Blackboard’s best kept secrets, one that can can save you time and effort.
After you have completed marking assignments, rather than typing results up into a spreadsheet, instead you can download the results directly from the grade centre into a spreadsheet or CSV file.
To do this, first go to the grade centre, which can be found under the Course Management settings near the bottom of the left hand menu. Click to expand the sub-menu.
Select Assignments to see Blackboard and Turnitin assignments, Tests to see the results of tests or quizzes, or Full Grade Centre to see both types of results.
Navigating the Grade Centre
You will see a list of students all of the students who are enrolled on the module, with a column for each assignment or test that has been set. Only assignments that have been graded will show a grade.
You may have to use the scroll bar within the grade centre (as opposed to the window’s scroll bar) to navigate further down the list.
Exporting the Grades
On the right hand side of the screen you will see the Work Offline command. Click this and select Download
You will be given the option to export the full grade centre or specific assignments, which you can do by clicking on the Selected Column dropdown and selecting the assignment you require.
To export as a CSV, choose the Delimiter type Comma, for Excel, choose Tab.
Your chosen fileds will be downloaded as a spreadsheet or CSV, depending on the delimiter type chosen.
If you have any further queries, please contact the Technology Enhanced Learning Unit at TEL@worc.ac.uk