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.
- Pull an Engagement Report for the duration you are looking to examine.
- Open the file once it is downloaded to your computer.
- Save the file as an Excel workbook.
- Click on the “Insert” Ribbon and then click “Pivot Table”.
- 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”.
- On the new sheet, drag “GamePlayNumber” into the “Rows” section of your pivot table. Then, drag “CustUserName” and “ActivityMasteryPercentage” into the Values sections.
- 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”.
- Click “Sum of ActivityMasteryPercentage” and then rename it “Average Score”.
- Change the Average Score column to format as a percentage.
- When you’re done, the table should look like this:
Creating a Graph
- Highlight your pivot table, click “Insert” in your tool ribbon, and then click “Recommended Charts”.
- Click the Combo option at the very bottom of the list.
- 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!