You can download the learning records from the LRS (Learning Record Store) to a CSV file by following these steps:
-
Go to Site Administration > Reports > Learning Records
-
Unselect the "Start time" and "End time" check boxes
-
Click on the "Filter" button
-
Once the data is loaded, using the dropdown below at the bottom of the page select "Comma separated values text file"
-
Click on the "Download" button
This will output the LRS records in a .CSV file which is formatted in this manner:
actor,verb,object,timestamp,finalgrade
jdoe,completed,WHMIS,2016-06-28,90
jsmith,completed,WHMIS,2015-04-21,100
jsmith,completed,Accessibility, 2015-04-21,85
The header columns in the CSV correlate to these values:
|
LRS Column |
LMS Field |
|---|---|
|
Actor |
Username |
|
Verb |
Type of completion |
|
Object |
Shortname of the course or program |
|
Timestamp |
When the course or program was completed |
|
Finalgrade |
The final course grade when the record was created, out of a possible total score of 100. |
Important Notes
-
If any extra fields are selected for the report, they will show up in the LRS export as well.