What's the best way to get data from MySQL?

What's the best way to get data from MySQL?

av Ron Raney -
Antal svar: 2

I use Moodle 2.5.1+ and I am using up to date Lesson, Quiz and Questionnaire modules for a set of courses. I am using a shared host with MySQL database.

My question is what is: What is the BEST way to export data for a weekly quiz or lesson, to be analyzed by SAS statistical software? We basically need to export WHO answered WHICH questions and WHAT was their answer. I understand that there is complexity in the way the database is set up. Some of the data is going to be located in the Moodle Questions tables, and some information will be extracted from the various modules.

Any and all information will help me a great deal. I am pioneering and on my own, so I need help from all of you wonderful Moodle forum folks.

Thank you in advance.

Medeltalet av utvärderingarna: -
Som svar till Ron Raney

Re: What's the best way to get data from MySQL?

av Michael Anuzis -

+1 to this question. Any guidance would be very useful.

The closest query I've been able to find is on this page: http://docs.moodle.org/dev/Overview_of_the_Moodle_question_engine#Detailed_data_about_an_attempt

Ideal output would be rows of users, columns of questions, values being whether answer was correct.

Medeltalet av utvärderingarna: -
Som svar till Ron Raney

Re: What's the best way to get data from MySQL?

av Richard Bakos -

I don't really know how SAS works but moodle can export all that info out into spreadsheets from the admin backend already. Could you possibly provide the spreadsheet to the SAS software?

If you need to use MySQL it's probably going to be a pretty complex query involving a lot of JOIN/INNER JOIN statements: http://www.mysqltutorial.org/mysql-inner-join.aspx

Medeltalet av utvärderingarna: -