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:
- the learner name and email, 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
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, this can help you identify which release has been accessed. The unique code of each release can be found on the Release page of your Project:
release_description
When creating a new release, you have the option to add a note:
These 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.
You can see the current release version on the Release page of your Project:
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.
Tip: 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 will display differently depending on the question types. Here are a few examples of these.
Drag and Drop
Multiple Response
Multiple Response questions will display a separate column for each question. The column header will display as the example above, with an additional field showing question-1, question-2 etc. to identify the relevant question in the project:
59ce1fe607657-p157047a04ca-question-3[:]Multiple Response - p157047a04ca- question-3
Each column will then display the answer in two parts, the answer column, and the answer title:
Sortable
Likert
Image Grid
Learner Text Input
A Learner Text Input survey will display the text you enter as the unique name as the column header:
The text entered by the learner will then display in the column.
Tip: If you plan to use the Your Data feature, you will want to think about how questions will be displayed when naming your pages so that they are easily identifiable later. |
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.