## Download in text format

### The radio buttons/single answer question type

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 this Help file

4.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

If you need to study the data of the questionnaire responses outside of Moodle in a software such as Excel, Open Office Calc or a statistical software package, you can export the data in text format. 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 select the UTF-8 encoding in the list provided by your software by hand.

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".

Updated by JR on 21/11/08