To review player performance and target instruction accordingly, you can download a report for each game that you’ve or a teammate (subscription required) has hosted. Reports are in xlsx spreadsheet format, or saved directly to Google Drive and opened with Google Sheets. This article covers how to navigate all the data made available in spreadsheet form.
Please note: Reports are intended for formative assessment purposes only. They include data for each player, such as answers submitted, points awarded, and response times. But there is no identifiable information on players. Nicknames cannot be used as a reliable identifier.
A basic spreadsheet report consists of five types of sheets:
Here you’ll find stats about the overall session, like when it was played, who hosted the session, how many players joined, and how many questions were played before the session ended. The Overview sheet also has “Overall Performance” and “Feedback” sections.
Here you can get a general idea of how challenging the game was. You’ll see percentages of correct and incorrect answers, as well as the average score. You can compare these numbers to reports for the same game with different groups to, for example, see if there’s a trend and adjust the complexity of questions or training accordingly.
After hosting a live game, you can click “Get results” in the top right corner of the screen. Players will be given a short feedback form to fill out. Results from their feedback will appear on-screen. Individual player feedback is not stored. But the on-screen feedback data gives you a pulse check on how your audience perceived the game and can be reviewed in reports.
This sheet shows a full leaderboard that includes nicknames, total score, correct answers, and incorrect answers.
This sheet shows a full leaderboard that includes nicknames and total score, followed by each question along with each players’ points awarded answer chosen.
Each question has a sheet with detailed stats. Question sheets also have “Answer Summary” and “Answer Details” sections.
For each answer option, you can see how many answers were received and the average time taken to answer.
For each player, you can see what answer they chose, their score earned, their total score, and their time taken to answer.
This sheet is formatted to be pivot-table friendly so that you can create your own tables and charts. Each row contains all data for a player’s response to a question.
Here are short descriptions of what data is collected in each column:
- A - Question Number: This is the numerical order a question was presented, regardless if the question order is or isn’t randomized. The number is also followed by the type of question asked.
- B - Question: This is the question text players submitted an answer for.
- C, D, E, F - Answer 1, 2, 3, 4: These are the answer options players could choose from.
- G - Correct Answers: These are the correct answer options that award points if chosen.
- H - Time Allotted to Answer (seconds): This is the time players were given to respond.
- I - Players: This is the responding player’s nickname.
- J - Answer: This is the responding player’s submitted answer.
- K - Correct / Incorrect: This text value identifies if the player’s answer is “Correct” or “Incorrect”
- L - Correct: This numerical value identifies if the player’s answer is correct (1) or not (0)
- M - Incorrect: This numerical value identifies if the player’s answer is incorrect (1) or not (0)
- N - Score (points): This is the points earned for the answer submitted, including excluding Answer Streak Bonus.
- O - Score without Answer Streak Bonus (points): This is the points earned for the answer submitted, excluding Answer Streak Bonus.
- P - Current Total Score (points): This is the total points a player had earned after answering the question.
- Q - Answer Time (%): This is the percentage of allotted time passed before the answer was submitted.
- R - Answer Time (seconds): This is the seconds that passed before the answer was submitted.