Note: You are currently viewing documentation for Moodle 3.3. Up-to-date documentation for the latest stable version of Moodle is probably available here: Viewing Questionnaire responses.

Viewing Questionnaire responses: Difference between revisions

From MoodleDocs
(see also link added)
(major rewrite)
Line 1: Line 1:
{{Questionnaire}}
{{Questionnaire}}


If you click on a questionnaire on a course to which you have editing access, you receive the option to '''View 'n' responses''' in the top-right corner, where 'n' refers to the number of completed surveys. Clicking this will take you to the ''Survey Reports'' page which gives you a graphical (bar chart) and numerical breakdown of responses using both total and percentage results.
== All responses ==
On the Questionnaire Report page, users with the necessary permissions can view a statistical Summary of all the responses given to a Questionnaire instance so far.


There is no mechanism to automatically make the results available to [[Student|students]] who have taken the questionnaire. You could however save the displayed results as an HTML file and upload that as a [[Resources|resource]].
==== View By Response ====
===== Summary =====
Users with the necessary permissions (usually only teachers) can view each response individually.  


At the bottom of this page you have the option to switch your view between individual responses and all responses and/or download a [[CSV]] version of the responses. In the CSV file fields are identified by the name you entered when creating them.
You move from one Response to the next (in chronological response order) with the links-bar at the top. If the questionnaire '''Respondent Type''' was set as “fullname”, then each respondent's name will be displayed, followed by the submission time-stamp. Otherwise ''Respondent: Anonymous'' will be displayed and no submission time-stamp will be displayed (for privacy reasons).


==See also==
===== Print this Response =====
Opens printer-friendly window with current Response.


*Using Moodle [http://moodle.org/mod/forum/discuss.php?d=69911 Removing old and test respondents] forum discussion
===== Delete this Response =====
Deletes current response.
 
==== Order Responses ====
When displaying All Responses you can order the choices by number of responses (the Average column) for the following 4 types of questions.
 
* single choices radio button
* single choices drop-down list
* multiple choices (check boxes)
* rate questions (including Likert scales).
 
When you arrive on the All Responses page, by default all responses are ordered in the order that the questionnaire creator entered the question choices. You can choose to order them by ascending or descending order.
 
==== Delete All Responses ====
Deletes all responses in current questionnaire instance. Can be used to “reset” a questionnaire if you no longer need the current data.
 
==== Download in text format  ====
This feature enables you to save all the responses of a questionnaire to a text file (CSV). This file can then be imported into a spreadsheet (e.g. MS Excel or Open Office Calc) or a statistical package for further processing the data.
 
=====Options for text download=====
On the '''Download in text format''' page you have a set of 2 options which only concern the output of the radio buttons/single answer question type. Here is how these options work.
 
Question text: What is your favorite color? Choice: blue, green, red.
 
 
{| style="border-spacing:0;"
| style="border-top:0.092cm double #808080;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.049cm;"| selected color
| style="border-top:0.092cm double #808080;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.049cm;"| blue
| style="border-top:0.092cm double #808080;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.049cm;"| green
| style="border:0.092cm double #808080;padding:0.049cm;"| red
 
|-
| style="border-top:none;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.049cm;"| Include choice codes
| style="border-top:none;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.049cm;"| 1
| style="border-top:none;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.049cm;"| 2
| style="border-top:none;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:0.092cm double #808080;padding:0.049cm;"| 3
 
|-
| style="border-top:none;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.049cm;"| Include choice text
| style="border-top:none;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.049cm;"| blue
| style="border-top:none;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.049cm;"| green
| style="border-top:none;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:0.092cm double #808080;padding:0.049cm;"| red
 
|-
| style="border-top:none;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.049cm;"| Include choice codes + Include choice text
| style="border-top:none;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.049cm;"| 1 : blue
| style="border-top:none;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.049cm;"| 2 : green
| style="border-top:none;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:0.092cm double #808080;padding:0.049cm;"| 3 : red
 
|-
| style="border-top:none;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.049cm;"| No Include box ticked = same as include choice text box ticked
| style="border-top:none;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.049cm;"| blue
| style="border-top:none;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.049cm;"| green
| style="border-top:none;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:0.092cm double #808080;padding:0.049cm;"| red
 
|}
Note that these output options are over-ridden in case you used the "hidden" option when you created your radio button questions, i.e. the named values will be exported as data. See [todo]
 
 
{| style="border-spacing:0;"
| style="border-top:0.092cm double #808080;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.132cm;"| ''Possible answers: ''
 
Red=the color of blood
 
Blue=the color of the sky
 
Black=opposite of white
| style="border-top:0.092cm double #808080;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.132cm;"| '''What is your favorite color?'''
 
the color of blood
 
the color of the sky
 
opposite of white
| style="border:0.092cm double #808080;padding:0.132cm;"| ''Irrespective of the Include choice codes/text options selected on the Download in text format page, this will output the values '''Red''', '''Blue''' or '''Black''' to the CSV file.''
 
|}
=====The CSV file (how to use it)=====
The text format available here is of the so-called CSV (comma separated values) type. However, for more universal use, the '''tab''' (tabulation) separator is used, rather than the comma or semi-colon.
 
When you click on the '''Download in text format''' button, a window opens, asking you whether you'd like to save the data file or open it. Select ''save''. The data file is named after the name of the current quiz, however you can save it under a different name. The proposed data file extension is *.txt, but you ''can'' rename it. Note that you ''must'' rename it with a *.csv extension for import into ''Open Office Calc''.
 
Then go to your external software, and open the file into it. The following operations depend on the software you are using and on a number of other parameters. If you are using a non-ascii language interface in Moodle or you are using the English language but some of your questionnaire questions (or responses) have non-ascii characters in them, then ''Excel'' (or ''Open Office Calc'') might be able to ''automatically detect'' that your file is UTF-8 encoded, and decode it accordingly. Please note that if most of your data file is using standard ascii characters and only a very small number of non-ascii characters are present, the automatic detection will not work, and you will have to ''manually'' select the UTF-8 encoding in the list provided by your software.
 
At the top of the "table" imported into e.g. ''Excel'', the first line contains the names of all the question fields. This is followed by one line per response. The first 7 fields are as follows (in the English version):
 
 
{| style="border-spacing:0;"
| style="border-top:0.092cm double #808080;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.079cm;"| Response
| style="border-top:0.092cm double #808080;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.079cm;"| Submitted on:
| style="border-top:0.092cm double #808080;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.079cm;"| Institution
| style="border-top:0.092cm double #808080;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.079cm;"| Department
| style="border-top:0.092cm double #808080;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.079cm;"| Course
| style="border-top:0.092cm double #808080;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.079cm;"| Group
| style="border-top:0.092cm double #808080;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.079cm;"| ID
| style="border-top:0.092cm double #808080;border-bottom:0.092cm double #808080;border-left:0.092cm double #808080;border-right:none;padding:0.079cm;"| Full name
| style="border:0.092cm double #808080;padding:0.079cm;"| Username
 
|}
The submitted_date field contains the date (and time, i.e. hour minutes seconds) when the response was submitted by respondent. For example: 15/09/2007 15:57. Normally you should be able to use Excel cell formatting to display such dates at will, in your own language formatting conventions, including the seconds, and if you wish full day or months names, while retaining the sorting facility.
 
If the questionnaire was set as "anonymous responses", the ID and Username will be empty and the Full name field will display "Anonymous".
 
== Your responses ==
On the Questionnaire Report page, users with the necessary permissions can view their own responses on the page entitled “Your results”. Usually students will be allowed to view their own responses.
 
If the questionnaire's settings allow more than one response and more than one response have been entered by the current user, then all of the features of the “View All responses” explained above apply.
 
However, it is not possible to delete individual responses in this “Your responses” view. And the Download as text format is not available to users with the student role.
 
==== All your responses ====
This provides a view of all of a respondent's responses, on successive dates. This feature may be useful if a questionnaire is used as a kind of portfolio.


[[Category:Teacher]]
[[Category:Teacher]]

Revision as of 09:47, 18 December 2010

All responses

On the Questionnaire Report page, users with the necessary permissions can view a statistical Summary of all the responses given to a Questionnaire instance so far.

View By Response

Summary

Users with the necessary permissions (usually only teachers) can view each response individually.

You move from one Response to the next (in chronological response order) with the links-bar at the top. If the questionnaire Respondent Type was set as “fullname”, then each respondent's name will be displayed, followed by the submission time-stamp. Otherwise Respondent: Anonymous will be displayed and no submission time-stamp will be displayed (for privacy reasons).

Print this Response

Opens printer-friendly window with current Response.

Delete this Response

Deletes current response.

Order Responses

When displaying All Responses you can order the choices by number of responses (the Average column) for the following 4 types of questions.

  • single choices radio button
  • single choices drop-down list
  • multiple choices (check boxes)
  • rate questions (including Likert scales).

When you arrive on the All Responses page, by default all responses are ordered in the order that the questionnaire creator entered the question choices. You can choose to order them by ascending or descending order.

Delete All Responses

Deletes all responses in current questionnaire instance. Can be used to “reset” a questionnaire if you no longer need the current data.

Download in text format

This feature enables you to save all the responses of a questionnaire to a text file (CSV). This file can then be imported into a spreadsheet (e.g. MS Excel or Open Office Calc) or a statistical package for further processing the data.

Options for text download

On the Download in text format page you have a set of 2 options which only concern the output of the radio buttons/single answer question type. Here is how these options work.

Question text: What is your favorite color? Choice: blue, green, red.


selected color blue green red
Include choice codes 1 2 3
Include choice text blue green red
Include choice codes + Include choice text 1 : blue 2 : green 3 : red
No Include box ticked = same as include choice text box ticked blue green red

Note that these output options are over-ridden in case you used the "hidden" option when you created your radio button questions, i.e. the named values will be exported as data. See [todo]


Possible answers:

Red=the color of blood

Blue=the color of the sky

Black=opposite of white

What is your favorite color?

the color of blood

the color of the sky

opposite of white

Irrespective of the Include choice codes/text options selected on the Download in text format page, this will output the values Red, Blue or Black to the CSV file.
The CSV file (how to use it)

The text format available here is of the so-called CSV (comma separated values) type. However, for more universal use, the tab (tabulation) separator is used, rather than the comma or semi-colon.

When you click on the Download in text format button, a window opens, asking you whether you'd like to save the data file or open it. Select save. The data file is named after the name of the current quiz, however you can save it under a different name. The proposed data file extension is *.txt, but you can rename it. Note that you must rename it with a *.csv extension for import into Open Office Calc.

Then go to your external software, and open the file into it. The following operations depend on the software you are using and on a number of other parameters. If you are using a non-ascii language interface in Moodle or you are using the English language but some of your questionnaire questions (or responses) have non-ascii characters in them, then Excel (or Open Office Calc) might be able to automatically detect that your file is UTF-8 encoded, and decode it accordingly. Please note that if most of your data file is using standard ascii characters and only a very small number of non-ascii characters are present, the automatic detection will not work, and you will have to manually select the UTF-8 encoding in the list provided by your software.

At the top of the "table" imported into e.g. Excel, the first line contains the names of all the question fields. This is followed by one line per response. The first 7 fields are as follows (in the English version):


Response Submitted on: Institution Department Course Group ID Full name Username

The submitted_date field contains the date (and time, i.e. hour minutes seconds) when the response was submitted by respondent. For example: 15/09/2007 15:57. Normally you should be able to use Excel cell formatting to display such dates at will, in your own language formatting conventions, including the seconds, and if you wish full day or months names, while retaining the sorting facility.

If the questionnaire was set as "anonymous responses", the ID and Username will be empty and the Full name field will display "Anonymous".

Your responses

On the Questionnaire Report page, users with the necessary permissions can view their own responses on the page entitled “Your results”. Usually students will be allowed to view their own responses.

If the questionnaire's settings allow more than one response and more than one response have been entered by the current user, then all of the features of the “View All responses” explained above apply.

However, it is not possible to delete individual responses in this “Your responses” view. And the Download as text format is not available to users with the student role.

All your responses

This provides a view of all of a respondent's responses, on successive dates. This feature may be useful if a questionnaire is used as a kind of portfolio.