Has Moodle come up with a more efficient, less labor-intensive method of exporting data from questionnaires? For example, is there any way of transferring the results of a questionnaire directly into an Excel worksheet without having to copy and past the results from a text document? Thank you for your input.
That text document is a CSV file. It will open just fine in a spreadsheet program. Try saving the document, and browse for it using Excel. Specify text files as you browse.
Sorry to contradict you, Martha, but the CSV (comma-separated-values) file that Questionnaire exports is the most efficient method of exporting data which can be retrieved into any spreadsheet or statistical package. Much better than being tied to a proprietary software such as MS Excel.
Have you read the extensive documentation I have taken the trouble to write?
Joseph
Hi Joseph,
Yes, I have read all of your well executed thoughts on this matter. What I was wondering was if there was any way to set up a questionnaire so that the date goes directly into a spreadsheet, preferably Excel as we already have it, without having to cut and paste the data from a text document. I know that there are forms in Google Docs that can do this, but we have already developed the questionnaire and it seems a shame to have to go back to the drawing board. It appears, however, that the current set up is as efficient as it gets.
You do not need to cut and paste. As I stated in my first post, you can save the file and open in Excel. Your computer likely opens in a text editor because it does not know any better.
Not that it makes a whole lot of difference but tab-delimited text is recognized by Excel and may be saved with xls extension (and probably also with ods but I haven't checked it yet). In the dataform export I let the user choose the extension and I trust that the user will use the appropriate delimiter (or otherwise accept the consequences).
Hi everybody,
I am exporting questionnaire data from Moodle in the Excel sheet, through the CSV format. I am just wondering if you have a better way of analyzing them. I mean, once I have my excel sheet filled in, I usually filter data and then have to count results manually but it takes so long.
Do you have any tips?
many thanks.
(Edited by Joseph Rézeau - original submission Thursday, 10 November 2011, 02:38 PM)
I have removed the attached Excel file, which contains personal data and as such should not be posted on a public forum.
Joseph
Hi Alessia,
It's difficult to answer your question because we do not know what kind of analysis you want to perform on your exported questionnaire data. It's up to you to decide what you want to do.
I do not understand what you mean by " I usually filter data and then have to count results manually but it takes so long.
Joseph
I am analyzing participants' satisfaction rates (we assess whether e.g. learning objectives have been met "completely", "mostly", "more or less", "partially", "not"). Each option corresponds to a number on a scale of 1 to 5. At the moment when I export to Excel, I insert a filter to know how many people chose "completely">1; ""mostly">2; "more or less">3 ....
Then, I count the total for each response option (how many people answered "1", "2", "3"...)
What I would like to know is if there is a more straight forward efficient way to have this result for our evaluation report.
Many thanks.
In reply to alessia messuti
Re: Efficient exportation of data from questionnaire
by Marty Soupcoff -
You could use the countif function to get the number of users who answered "1" or "2", etc.
For example, if the column of answers is in Column D and you want to count the number of users who answered "1", a formula of: =countif(D;D,1) would get you what you want.
Happy 
oodling!
In reply to Marty Soupcoff
Re: Efficient exportation of data from questionnaire
by alessia messuti -
Many thanks Marty.
I was not aware of this excel function.
Alessia
Hi Alessia,
Once you have opened the .csv file in Excel and cleaned up any anomalies you can then analyse it in SPSS.
SPSS has a great range of analysis tools.
Regards,
Ian
Yes, and for example IBM's SPSS packages are quite cheap.
Joseph