Forum Discussion
Storing QuizMaker results in a database
I am an ICT teacher at a school, and have created a solution to save all results to a database automatically after the quiz. I am using a MS SQL Server database, but it could easily be adapted to a...
- summary_id = id of quiz done by a student (link to summary.id)
- interaction_id = a unique identifier combining the question with the student and quiz (I think). Articulate knows more, I don't use it
- objective_id = an id for the question, so that even if the questions are randomized they will be identifiable. This id is used in vwDetails as LEFT(SUBSTRING(dbo.Quiz_Detail.objective_id, 9, 5), LEN(dbo.Quiz_Detail.objective_id) - 10)
- interaction_type = type of question, e.g. multiple choice, yes/no
- weight = always 1, I have no idea why Articulate uses this. Perhaps it's something that is reserved for later use, or maybe it's used in some other tools
- latency = network delay, not very useful, unless there is a consistent delay
- question = the actual question text
I hope this helps a bit. I should put this in the Wiki. It gave me a lot of headaches to find out. But rest assured you can get all necessary data by using the views (or implement them as queries if you like). See the database file at http://code.google.com/p/quizbaker/source/browse/DB/createDB.sql
