Skip to main content
Brad Lawryk
Braniac
March 22, 2019
Question

Storing Test Results

  • March 22, 2019
  • 5 replies
  • 1937 views

Is there a way to store quiz results to a MySQL database or do we need to use some third party LMS?

    This topic has been closed for replies.

    5 replies

    Participating Frequently
    June 2, 2019

    Hi Brad,

    Its already a couple months so hopefully you found your answers. However, if you did not, or if there is someone else with same question, I hope this might help.

    There are several ways to do it, but it depends a lot on how you are hosting the content and how much you can get into code.

    If you are using SCORM you need an LMS, and you can use Moodle or something similar. Still, if I remember correctly, it doesn't store the answers from users if you need that too.

    If you are hosting without an LMS, you can either try some javascript methods like mentioned by Le Dirlo.., or you can publish for Tin Can API (also known as xAPI). Experience API is the next generation of SCORM that doesn't require an LMS. You will need:

    1. An LRS that supports MySQL as you need data in MySQL. So far I know of Free ADL LRS, and paid GrassBlade LRS, that stores data in MySQL.

    2. Build a Tin Can URL, and load the content in an iframe or create a hyperlink to launch the content. In the link, you basically pass the user's name, user email id (or any other identifier), and the LRS details when you want to send the data to. Exact information is available everywhere on internet and you will be able to use it. If you face problem with that I can help. When user name/email is not available from their login, I either create a simple form in HTML to ask for that information, or I use the IP to keep the data fairly separate.

    Now when anyone uses the content, you get the data in the LRS's MySQL tables.

    Participating Frequently
    May 27, 2019

    Moderator: spam removed, nothing to do with question.

    Dirlo
    Inspiring
    March 28, 2019

    ...

    Hello !...

    I'm also interested by this subject... And the limited number of learners prevents me from using a LMS...

    I found this while ago and maybe it will help you :

    Using JavaScript, PHP and MySQL to Log Captivate Variable Data - eLearning

    (Didn't try it... )

    ...

    chrismay_at_delta6226261
    Inspiring
    March 29, 2019

    There is some info here on how to connect to a server:

    Report quiz results to an internal server

    Emily_Serenity
    Participating Frequently
    March 28, 2019

    Hi Brad,

    I just completed a needs assessment for an LMS and found https://findanlms.com/ to be helpful with narrowing down what I wanted (discussions I needed to have with stakeholders) to give me a starting point on where to go. From there, I went to https://www.capterra.com/learning-management-system-software/ in order to read reviews and find out what functionality was available.

    For my own work, I use Wordpress, so I went with LearnDash, which meets my needs. For other organizations, I've used a number of options. The one the company I did the work with has an SQL developer so they needed the data stored there to integrate it with their systems. I don't know any MySQL ones specifically, but I'm sure there are some out there.

    Lilybiri
    Braniac
    March 22, 2019

    The easiest way is using a LMS indeed.

    Lilybiri
    Braniac
    March 22, 2019

    Score slide, which is automatically inserted when having Question slides, will show the content of several quizzing system variables to the learner. Those results are transferred to the LMS.