Skip to main content
Participant
April 7, 2008
Question

Storing Quiz Answers in a database

  • April 7, 2008
  • 1 reply
  • 558 views
Good Morning Everyone,

I am working on the quiz feature of captivate. I need to store the scores of my quiz to a database. I accomplished it using JavaScript, .Net & SQL Server 2005 database. I used the tutorial by Tim Mushen as a reference to do that.
http://www.adobe.com/devnet/captivate/articles/store_cpresults.html

I am getting my quiz scores in my SQL Server database. I need to know, whether I can transfer the answers of the individual questions in the quiz to the database along with the scores. I can see the answers, if I click the review quiz button. But, I need to know, if adobe captivate is exposing the answers, so that I can pass it along with the scores or is it keeping it private.

Thanks in advance...
Reny Mathew.
    This topic has been closed for replies.

    1 reply

    Captiv8r
    Legend
    April 7, 2008
    Hi Reny and welcome to our community

    When you click Quiz > Quiz Preferences... > Reporting node, do you see the area in the lower right corner? The one labeled "Reporting Level"? There you should see two options. One is simply "Report score". The other is "Interactions and score".

    What is your setting there?

    Perhaps that is all you need to do. Change that setting.

    Cheers... Rick
    Reny1983Author
    Participant
    April 7, 2008
    Thanks for your help Rick.

    I have tried that. Now am getting a new row in the results string like Interaction, Interaction Data,Interaction ID,Objective ID, Correct Response, Student Response, Result, Weight, Latency. But am not getting any corresponding values for these fields like the ones I get for MAx Score, Min Score etc.

    Please help!!!

    Reny.
    Reny1983Author
    Participant
    April 8, 2008
    Hellow Everyone,

    I am almost done with an acceptable solution. The only thing, I lack is that I am not getting the answers selected by the user in my query string. Any Captivate Experts, please help!!!

    Thanks,
    Reny