Topics Map > Content Authoring > Advanced Content Authoring and Reporting > Storyline

Advanced Content Authoring and Reporting - Requesting a report or exporting Storyline data from Learning Locker and working with the data in Excel

This document covers basic information on requesting a report on student use of a Storyline module or creating an export from Learning Locker for the content authoring solution and some processing of the data that can be done in Excel.

It can be difficult to interpret Storyline Learning Locker reports as-is because the reports don't include human-readable answers for what students choose for questions. If you would like assistance with data exports from Learning Locker:

  1. E-mail indicating that you would like assistance with a data report for a specific module. Please include any specific data you need, along with when you would like the report. Report requests are processed within 2 business days.
  2. A team member will either send you questions for additional definition of your data requirements, or a CSV file with the requested data.

If you are a School, College, or Department instructional technology consultant who would like an account to login to Learning Locker to generate reports for instructors in your School, College, or Department please e-mail to request an account. 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:

Learning Locker documentation can be found here:

Creating Exports in Learning Locker

The primary way to get data out of Learning Locker is to use the export function.

  1. Login to Learning Locker.
  2. Click on UW Madison LRS Pilot.
  3. Click Exporting on the left side menu.
  4. 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]
  5. 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

  1. Open the .CSV in Excel.
  2. Turn on the filters by clicking Data tab and then on the Filter.
  3. Filter the object ID column with the Activity ID which can be found by Editing the xAPI Content post in the content authoring WordPress instance.
    This is where the Activity ID can be found in the xAPI content post in the content authoring WordPress instance (click for a larger image):

  4. Set up your Filter to Text Filter > Contains “Activity ID”:

  5. Insert a column between result duration and result response and title it Answer Translation.
  6. Open the .xml file in Excel and select Open XML “As an XML table”. Click OK.
  7. Click OK through the warning.
  8. 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.
  9. 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
  10. Click OK.
  11. Copy the function into any other cell that needs it. The formula should update automatically.
  12. 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.
  13. Save as an .XLS workbook.

See Also:

Keywords:content, authoring, pilot,learning, locker, record, store, xapi, statements, wordpress, grassblade, csv, excel ACAR   Doc ID:76536
Owner:Learn@UW Madison .Group:Learn@UW Madison
Created:2017-09-14 06:17 CSTUpdated:2018-09-25 07:18 CST
Sites:Academic Technology Pilots, DoIT Help Desk, Learn@UW Madison
Feedback:  0   0