In Your Data, you're able to view your learner data in the dashboard or by downloading it as a CSV.
In the dashboard, you can view:
- Your learners' names and emails, if collected
- Their Completed and Passed status
- The date of their Completion
- The answers they submitted to any questions in the course. In the dashboard, a learner's answers can be expanded or collapsed using the magnifying glass icon
However, the CSV export contains a wider set of data which can facilitate a more detailed analysis of your learners' actions and answers within your course.
Reading the data contained within the CSV file
Each column in the CSV export shows a different data point. Below is a guide to help you interpret what each column shows.
Contents
1. learner_user_registration_id
2. project_code
3. project_name
4. release_code
7. release_type
10. learner_name
12. start_date
13. attempts
14. completion_date
15. completed
16. result
17. score
18. questions
19. page_score
learner_user_registration_id
A learner will be issued a unique registration number for each session.
One learner may have multiple registrations if they have accessed the course more than once over multiple sessions.
project_code
This is the unique Project ID found in your Project's URL and Online Link Release URLs. This is useful if you need to identify which Project the data is from.
For example, below is the URL for the Online Link Release of the demo How Well Do You Know Elucidat quiz. The string shown in bold is the Project code.
https://learning.elucidat.com/course/57b1adfeac795-57b1aee16fa2e
You can append this code to the following URL to quickly navigate to the Project:
https://projects.elucidat.com/
project_name
This is the Project's name. This is useful if you need to identify which Project the data is from.
release_code
Using the same example URL as above, the unique release code is shown in bold here:
https://learning.elucidat.com/course/57b1adfeac795-57b1aee16fa2e
The section shown in bold is the release code.
If you have multiple releases on the same Project, this can help you identify which release the data is from.
release_description
When creating a new release, you have the option to add a note:
This will be shown in the release_description column.
release_version
If you have updated a release using Re-release, its version number will increase to reflect this. This will allow you to identify which version was accessed.
release_type
Elucidat offers four different release modes which are indicated with different labels.
SCORM for LMS - scorm
Online Link (with or without Learner Identification switched on) - online-public
API release - online-private
Backup SCORM - offline-backup
learner_user_id
This column will display a unique ID for each learner.
While a learner may have multiple registration numbers, their learner_user_id will remain the same.
learner_email
This data varies depending on the release type and, in the case of SCORM releases, what information has been passed on by the LMS. A blank entry indicates that this has either not been collected or has not been passed on by the LMS.
SCORM for LMS - Learner's email address or SCORM ID provided by LMS
Online Link - this data is not collected by this release type
Online Link (with Learner Identification switched on) - this data is not collected by this release type
Backup SCORM package - Learner's email address or SCORM ID provided by LMS
learner_name
This data varies depending on the release type and, in the case of SCORM releases, what information has been passed on by the LMS. A blank entry indicates that this has either not been collected or has not been passed on by the LMS. This information can also appear obscured (*****) if anonymization has been enabled.
SCORM for LMS - Learner's name/email address/employee number etc provided by LMS
Online Link - this data is not collected by this release type
Online Link with Learner Identification switched on - email address provided by the learner
Backup SCORM package - Learner's name/email address/employee number etc provided by LMS
learner_identifier
This data varies depending on the release type and, in the case of SCORM releases, what information has been passed on by the LMS. A blank entry indicates that this has either not been collected or has not been passed on by the LMS. This information can also appear obscured (*****) if anonymization has been enabled.
SCORM for LMS - Learner's name/email/address/employee number provided by LMS
Online Link - this data is not collected by this release type
Online Link with Learner Identification switched on - name as provided by the Learner
Backup SCORM package - Learner's name/email/address/employee number provided by LMS
start_date
This will indicate when a learner started a session.
attempts
This column will show how many times this learner has attempted the course before their final score was recorded.
Note: This will only be recorded if the course is accessed via a SCORM package. |
completion_date
If the learner has completed the course then their date of completion will show here.
This is also displayed in the Your Data dashboard under the Date Completed column.
completed
In the data CSV, a 0 in this column indicates that the learner has not completed the course. A 1 indicates that they have completed the course.
In the Your Data dashboard, this is indicated with a tick or a cross under the Completed column.
result
In the data CSV, a failed in this column, indicates that the learner has failed the course. A passed in this column indicates that they have passed the course. A blank entry indicates that the learner's final result has not been reported yet.
In the Your Data dashboard, this is indicated with a tick or a cross under the Score column.
score
This will display the learner's total score for the course.
This is also shown in the Your Data dashboard under the Score column.
A blank entry indicates that the learner's score has not been reported yet.
questions
If your course contains Question pages, the data from each question will follow this column.
A question page column header will be structured something like this.
5982fe23b7aff-p1570478197e[:]Example page- p1570478197e
It is made up of three unique parts.
The page ID where the question is located:
5982fe23b7aff-p1570478197e[:]Example page- p1570478197e
The unique ID of the question:
5982fe23b7aff-p1570478197e[:]Example page- p1570478197e
The title of the page where the question is located
5982fe23b7aff-p1570478197e[:]Example page- p1570478197e
The answers may be displayed differently depending on the question types.
If a learner has submitted an answer more than once, for example by re-attempting a question they answered incorrectly, each attempt will appear on a new line in the same cell.
The answer on the bottom line is the one that has been most recently submitted.
page_score
Each question page column will be followed by a page_score column for that page. This will show the learner's score depending on the score weighting set.
For example, with a score weighting of 50, a correct score would show here as 50, a partially correct score would show as 25, and an incorrect score would show as 0.
This can also be seen in the Your Data dashboard by clicking the magnifying glass under the Answer section to reveal the question data.
To find out more about scoring and how score weighting can affect a score, see Feature Focus: Progress and Score.