How to Download Test Results in Blackboard
Downloading scores per question
If you wish, you can download a complete breakdown of marks per question, for each user.
Go to Control Panel > Grade Centre > Full Grade Centre (or Tests), locate the Test for which you wish to download results and click on the editing arrow at the top of the column. Select Download Results.
On the Download Results screen, choose the desired file format and then the way the results should be formatted.
The on-screen help text states:
“The format listed By User will include all of the questions for a user in one row.
The format listed By Question and User will list each question for each user in a separate row”.
Examples are shown below:
By User
· Each user is shown on a new row.
· There are separate columns for each question, showing the question text, answer submitted by this student, points possible, points awarded.
By Question and User
· There is a separate row for each student’s response (or lack of response) to each question
i.e. if your Test contains five questions, the spreadsheet will contain five rows per student.
· Separate columns show the question text, submitted answer, points possible, points awarded.
· Initially the worksheet is arranged by username, but you could also sort it by question.
· Files downloaded from the Download Results screen are named ‘download’, and lack a file extension. Before you can open the file, you will need to edit its filename – simply add .xls to the end of the filename.
· In some cases the question and/or answer text will be obscured by several lines of html code. This is almost certainly because the text was copied and pasted from MS Word.
You can use Find and Replace to strip away this code in the downloaded Excel sheet.
To avoid the problem recurring in future, it would be worth editing the Test questions in Blackboard to remove the unnecessary formatting – there is a ‘Remove Formatting’ tool on the editing toolbar.