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. |
If any extra fields are selected for the report, they will show up in the LRS export as well.