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:
| No Formatcode |
|---|
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.