The first version of my XP Calculator and Leaderboard gave teachers a way to update a classroom leaderboard on a Google Site simply by submitting a Google Form. That solution is best suited for single classrooms and only supported leaderboard functionality for individual students. However it became clear that a new solution was necessary in order to align with best prctices stated in my post 6 Tricks for Shameless Leaderboards. Many teachers have requested guild or team support, so I rolled up my sleeves, learned some SQL, and created a second version that integrates guild leaderboards while only adding one step to the set up process. Many of these steps will mirror the original process so I will not go into too much detail.
Step 2: Copy the XP Calculator 2.0- Click this link to access the Calculator sheet. Then, on the sheet dropdown tab, select “copy to” and select the Spreadsheet from your drive that contains Form Responses.
Step 3: Set up your Calculator Sheet-
- First adjust the Level Threshold and Rank Title settings (Yellow).
- The assign Guild Associations (Orange)- Just assign each studet to their respective guild. *** The guild names must be spelled exactly the same in order to be combined later.
- Then delete any extra #REF cells in the Blue section to fix any sorting in the Green section.
- Adjust the Charts to fit your needs.
Step 4: Publish your Charts- From a Google Site, select Insert/Chart and then choose your Response spreadsheet. *Make sure that the spreadsheet is viewable by anyone with the link otherwise your charts will not show up on the website.
I have included 3 charts fo you to play with: an Individual Top ten Leaderboard, a Total class XP Scale, and now a Guild Leaderboard. I have also included an Average Points per Player by Guild(Red) field to use when your guilds include different numbers of players.
If you are interested in a way for students to fill in their points but not allow it to be submitted without you signing off using a password Click here to see how to Password Protect a Google Form.
I am still convinced that it is one of the simplest leaderboard solutions that teachers will find without knowing anything about spreadsheets. The convenience of the Google Form input is crucial for classroom efficiency. Thanks for all of your comments and feedback. Let me know what you want so I can keep improving on this sytem!
*Update 2/23- Video Tutorial
*Update- Thanks to Serge Komadina for finding a bug in this updated version. I have corrected it so it pulls ALL of the names from the form, not just the first 25. OOPS!