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.
- Michielvan-d058Community Member
I have just added the first PHP version to the downloads section. http://code.google.com/p/quizbaker/downloads/list
- Michielvan-d058Community Member
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.
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.
- BJacobsCommunity Member
We ended up using Jquery and Ajax to export and capture a variable that was then stored in a SQL database on the back end. This project was a collaboration with our IT department. Here is the storyline file I created for IT based on information I found on the Internet (don't ask me where). That was a contract project which ended, so I no longer have access to anything else. I hope you can find something to use or to help you find what you need. Best wishes.
- JustinWilcoxCommunity Member
Hi Michiel.
Thanks for sharing this!
- SubhashDobhalCommunity Member
Hi Michiel,
I Need some help as I want to understand how to open the tool that you have created. I am Asst.Manager working with IT company and want to create a online exam so that employee can open IE and complete the assisment . Answers updated by the users to be saved on Database so that I can see and provide the pass /fail report. I have downloaded your tool however not sure how to use it.
Request you to please provide me the steps for the same. my email ID is dobhal.subhash@gmail.com
Thanks you so much for this help in advance!
Regards,
Subhash Dobhal
- MunishSethiCommunity Member
Michiel van der Blonk said:
I have just added the first PHP version to the downloads section. http://code.google.com/p/quizbaker/downloads/list
I have downloaded the php version, but i didnt looked at it yet.I am trying to develop a solution independent of any LMS, so i may save the results of the quiz in my personal database MySql.
I will update my progress here.
- MunishSethiCommunity Member
Hi Michiel.
Thanks for the great work.
I looked at both the zip files provided. I can see that you have folders
Report - showing scores etc from db.
Student - images and an index asp file.
DB - DB connection, persistence support etc.
But i wanted to see how a quiz on completion throws out the result data. Can you pls upload or put here a zip with quiz files and the js files about how data will come out of the quiz.
- ShaneRobinsonCommunity Member
Hi,
Thanks for posting this.
Does anyone know a workaround for the following client request. Maybe it is already addressed by the email to database code that is proposed in this forum. However, I am relatively new to these aspects of deploying live eLearning from the hosting-side, so wanted to ask for clarification or possibly a solution if anyone has one:
· The emails [quiz results] will need to be able to be sent using an SMTP relay through the company's email system. We can’t be guaranteed that every user's machine accessing the [training course and quiz] application will have the Outlook client installed or that the user will have a valid MHS email address.
If I understand this question correctly, is there a way to have quizmaker send an email or quiz results in any form, to the client's SQL database, if the end-user's don't have an installed email client like Outlook on their machines? What is an SMTP relay?
Also, this is a time-sensitive question. I am being asked to provide an answer to this question in a couple hours!? HEY YOU GUYS! HELP FROM HEROES NEEDED ASAP.
Thanks,
Shane
- Rohan-KCommunity Member
Hi,
Can anyone shed some light on what are the following fields in the Quiz_Detail Table of quizbaker:
- summary_id
- interaction_id
- objective_id
- interaction_type
- weight
- latency
- question
Thanks
Rohan