Pulling a Report of Scores per Play

Pulling a Report of Scores per Play is a great way to show how repetitive play of mLevel's highly engaging activities affects your learners' retention. Here are the steps to show this data using an Engagement report:

Scores per Play

This process will not work for Mac users, since Apple’s version of Excel does not provide the ability to export to a Data Model.

1. Pull an Engagement Report for the duration you are looking to examine.
2. Open the file once it is downloaded to your computer.
3. Save the file as an Excel workbook.
4. Click on the “Insert” Ribbon and then click “Pivot Table”.
5. On the Pivot Table menu, add your Pivot Table to a new sheet. Also, make sure to check the box to “Add this data to the Data Model”.

1. On the new sheet, drag “GamePlayNumber” into the “Rows” section of your pivot table. Then, drag “CustUserName” and “ActivityMasteryPercentage” into the Values sections.

1. Click on “Count of CustUserName” and then click “Value Field Settings”. Change the entry to “Distinct Count”, which is at the bottom of the list. Rename the field as “Plays”.
2. Click “Sum of ActivityMasteryPercentage” and then rename it “Average Score”.
3. Change the Average Score column to format as a percentage.
4. When you’re done, the table should look like this:

Creating a Graph

1. Highlight your pivot table, click “Insert” in your tool ribbon, and then click “Recommended Charts”.
2. Click the Combo option at the very bottom of the list.
3. Check the box on the Average Score row for “Secondary Axis” and click Ok.

You now have a pivot table and graph showing the typical scores per play, and the number of users for each sample!