Storing QuizMaker results in a database

I have just added the first PHP version to the downloads section. http://code.google.com/p/quizbaker/downloads/list

Hi Michiel.

Thanks for sharing this!

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

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.

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.

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

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

• 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

Hey thanks a ton Michiel  

Just one question, is there any way to capture the time taken for each question? It is a really important metric that we need to calculate the final score (which will be a function of the time then to answer , the question point value and the no. of attempts)

Thanks

Rohan

Edit: So I've convinced the client to use the overall time rather than individual question time. Don't think will be needing that anymore. Thanks a ton

P.s. I found this link http://www.articulate.com/support/kb_article.php?product=qm9&id=uz26lpzwc4y2

I am assuming the Data reported to quizbaker follows the same format? I ask because I need to capture the no. of attempts per question which I am assuming can be derived from the id field?

Also will I be able to capture the username along with the quiz results from a session variable as I will be authenticating the user before he/she starts taking the quiz?