Content Authoring Phase 3 Pilot - Fall 2017 - Exporting data from Learning Locker and working with the data in Excel
Learning Locker is an open source learning record store designed to store learning activity statements generated by xAPI compliant learning modules. To login to Learning Locker go here: https://learninglocker.med.wisc.edu/ If you would like an account to login to Learning Locker to generate your own reports please e-mail firstname.lastname@example.org to request an account.
This document covers basic information on Learning Locker for the Fall 2017 Content Authoring Phase 3 Pilot.
Learning Locker documentation can be found here: http://docs.learninglocker.net/reporting/
Creating Exports in Learning Locker
For the pilot the primary way to get data out of Learning Locker is to use the export function. Future work may focus around reports.
- Login to Learning Locker
- Click on UW Madison LRS Pilot.
- Click Exporting on the left side menu.
- Click Edit next to either Storyline Simplified Export, Pressbooks Simplified Export or Captivate Simplified Export [Note that the Captivate report was not available when this document was written]
- Click the Download dropdown and select .CSV Name the CSV something that will make it easily findable in the future.
Working with Your CSV File in Excel
- Open the .CSV in Excel.
- Turn on the filters by clicking Data tab and then on the Filter.
- Filter the object ID column with the Activity ID which can be found by Editing the xAPI Content post in the pilot WordPress instance.
This is where the Activity ID can be found in the xAPI content post in the pilot WordPress instance (click for a larger image):
- Set up your Filter to Text Filter > Contains “Activity ID”:
- Insert a column between result duration and result response and title it Answer Translation.
- Open the .xml file in Excel and select Open XML “As an XML table”. Click OK.
- Click OK through the warning.
- Back in the Learning Locker export, add the following formula to any field in the Answer Translation column next to where there is a response other than null in the Result Response column.
- Enter a VLookup formula w/ the following criteria
* Lookup_value = result response cell you are trying to translate
* Table_array = the columns from the .xml spreadsheet which contains the ID value you are trying to translate in the first column of your selection through the column where the answer translation resides
* Col_index_num = The column number in your selection from above where the answer translation resides
* Range_lookup = false
- Click OK.
- Copy the function into any other cell that needs it. The formula should update automatically.
- Copy the entire answer translation column and paste it as “value” only. This will prevent the spreadsheet from needing to reference the .xml spreadsheet for the translation.
- Save as an .XLS workbook.
- Case Scenario Critical Reader - Alternative Tools (UW-Madison)
- Content Authoring Phase 3 Pilot - Fall 2017
- Content Authoring Phase 3 Pilot - Fall 2017 - Pressbooks
- Content Authoring Phase 3 Pilot - Fall 2017 - Storyline
- Content Authoring Phase 3 Pilot - Fall 2017 - Setting up a Captivate project to use xAPI
- Content Authoring Phase 3 Pilot - Fall 2017 - Uploading a Storyline or Captivate module to WordPress/GrassBlade
- Content Authoring Phase 3 Pilot - Fall 2017 - Sending a grade from a Storyline or Captivate module in WordPress to Canvas