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 MS Access or other database.
We have already taken hundreds of tests, and all results are stored, up to individual answers. The web interface enables you to download results per quiz, per student or per class in CSV format.
All source code is open sourced, and downloadable on http://code.google.com/p/quizbaker/
I am hoping for collaboration from many of you to improve the software. Email me if you like to cooperate on the project.
I have looked at joep's original solution in .NET and have created my own in classic ASP. See http://www.articulate.com/forums/articulate-quizmaker/4317-quiz-database-instructions-code.html
I plan on supporting MS Access, MySQL and port the version to PHP. One of the hardest problems was capturing the user name of the student, which is now done by forcing the student to use Internet Explorer, the only browser that sends the domain user automatically.
41 Replies
Hi Trent and welcome to Heroes!
There isn't a built in way to pull information from a database into Storyline or Studio, although that being said I wouldn't be shocked if there was a community member who had done something similar that they could offer you here.
Thanks Ashley! I just need to know that the code for a published course can be altered to pull content dynamically from a database. Essentially, our quizzes/tests and all their associated answers are located in a database. I'd like to be able to generate a quiz that could pull that data from a database.
What I've seen so far from Articulate Studio is that a lot of this is flash generated content, particularly the player. I just need to know that it's an option to be able to use it that way. From what you're saying, I think that I can infer that I'm able to add the code I need to get it done.
Hi Trent.
There isn't a way to dynamically add content from a database in Quizmaker. The questions, however, can be imported via a text file or spreadsheet.
Thanks Trent for the clarification - and yes as Justin mentioned you can import questions into Quizmaker 13 from a excel or text file. You'll find additional information about how to set that up here.
Actually I also created a solution to create QuizMaker files straight from Excel. This only works with the Quizmaker 2.0 format, but these can be opened by Quizmaker 9.0
It's in Dutch, so I hope the interface is self explanatory. 'Maak CP' means 'export to Word', and 'Opslaan als QuizMaker' means 'Save in Quizmaker format'.
Make sure to enable macros.
Michiel,
Sorry to ask again, but it seems I cannot locate the reply link to my question last month regarding passing variables to SQL using AJAX.
Can you please resend the email or link?
See the code under CC_PrintResults in /db/db.js in quizbaker. The url goes to /db/db.asp which then extracts the answers and stores them in a database.
Hi Suzan,
This thread is a bit older so I'm not certain that folks are still subscribed. You may want to use the "contact me" button on their profile to reach out directly since we don't support reporting data to a database or text file.
Hi Suzan and others,
I have uploaded the latest ASP code to GitHub. See https://github.com/blonkm/quizbaker/tree/proprietary
This is the code as it is used at our school, so it contains some school specific code. You can download it using the download zip button on the bottom right. I would recommend using the master branch though (choose branch, then master, then download zip).
I have also been working on the PHP version, which is now its own separate project. I know people like this because PHP on linux with mysql is completely free, and can easily be hosted online.
https://github.com/blonkm/Quizbaker-PHP
We are running dozens of quizzes with hundreds of students each year and it's still running great.
Thanks for sharing!
Thanks!
Sent from Windows Mail
