Leicester School of Biological Sciences

12 February 2009

Getting module questionnaire data from Blackboard

Filed under: Blackboard, how_to — Tags: — jobadge @ 11:18 am

How to use the data gathered on a Blackboard survey for a module questionnaire and represent answers as scores not percentages.

The School of Biological Sciences standard end of module questionnaire is available as a blackboard survey which can be customised for your course. Contact Jo Badge to get a copy for your course.

To see which students have completed the survey

Once the module has ended and the survey has been completed by as many students as possible, you can access the data via the gradebook.


You will see a column for the module questionnaire (subtitled ‘survey’). A green tick will appear for every student that has completed the questionnaire and submitted it. A padlock icon indicates that the student has looked at, but not completed the questionnaire. You will not be able to retrieve partial data from these attempts, so contact the students and ask them to finish the survey.

To view the summary of results:

Click on heading for the column for the module questionnaire (subtitled ‘survey’), then choose ‘ASSESSMENT ATTEMPT DETAILS’. This will show you how many students answered the survey and give percentage scores for each answer.

assessment attempt details

assessment attempt details

For simplicity and a record of the survey this page can be printed off.

Alternatively, if you wish to download the raw data for the survey, you can manipulate the results in Excel to produce an overall score out of 5 for each question.

To download the raw data

From the GRADEBOOK, click on heading for the column for the module questionnaire (subtitled ‘survey’), then choose ‘DOWNLOAD RESULTS’. Save the file to your computer.

download survey

download survey

To convert to scores

Open the downloaded results in Excel. Copy and paste the formulas from the example spreadsheet into your dataset for each question.

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: