This is a tutorial on how to setup the Basic XP Calculator and Leaderboard. The idea is that a teacher can input student XP into a Google Form and automatically update a leaderboard on a Google Site. This basic version (v2.1) can currently handle up to 75 students and is best suited for elementary classrooms or smaller class sizes. If you have a large number of students, you may want to try the Advanced XP Calculator system instead.
Here is how you set up the basic version, step by step…
Create a Google Form for the Input of Student XP
- Make a form where each question is the name of a student in your class. The question should be a simple text input. The question title should be whatever name you wish to appear on the leaderboard.
- For anonymity, you may wish to enter an avatar or ID number in the question title so that the real name does not show up in the public leaderboard. If you do this, you may want to enter the student’s real name in the description so you can easily reference them. Enable the description text on a question by using the three dots in the lower right hand corner of each question.
This is an example of what your input form might look like.
- Finally, Click on the Responses tab and create a Form Responses Spreadsheet where all of your data will be stored. Then you are ready to set up the calculator.
*Pro Tip- Bookmark your XP input form link on your mobile device so you can quickly access it and input XP on the go!
Set up the XP Calculator and Leaderboard Sheet
- First, Click here for the XP Calculator and Leaderboard Spreadsheet v2.1. Look down at the tabs on the bottom. From the “XP Calculator” tab dropdown menu, select “copy to” and choose the Form Responses sheet created from your Google Form. The XP Calculator sheet will automatically pull the names and data (for up to 75 students) from your “Form Responses 1” tab. When data is entered, It will sum the XP of students, look up their level, rank them by XP, and even report on the status of their guild or team if you set it up to do so.
- To customize this sheet to your game, first edit the YELLOW section. This is where you determine the XP thresholds and given titles for each level. This section can be modified for whatever fits with your game. In the ORANGE section you may assign a guild or team to each student who shows up in the blue section. If a team is added, the calculator will give team scores as well as individual scores. If you do not want to use this feature, just leave it blank. Everything else is automated, so don’t mess with it! Your final sheet will probably look something like this.
Publish the Results on a Website.
- On your Form Responses Sheet, adjust your “sharing” settings so that this sheet is viewable “PUBLICLY ON THE WEB” If you do this correctly you will see a little globe icon in the blue share button“ If you do not share your sheet, your charts will not show on your website.
- Set up a website. I like Google Sites for this because you can insert a chart from any Google Sheet with a few clicks. At the bottom of the insert sidebar, simply select “Chart” and choose your Response Sheet. It will display all available charts. If mine are not enough feel free to make your own charts from the data or just edit mine to suit your needs. When you have inserted all of your charts make sure to “PUBLISH” your site and put a link to it somewhere easy for your students to access. Don’t forget to make sure it is available to everyone on the web so that there are no privacy barriers in place. If you do it right, your site should look like this.
And you are done! Now, every time you submit a form, it your website will update. Students may have to refresh the page to see the newest data, but that’s it! If you need a run through here is a video tutorial.
Be careful! Leaderboards can be a tricky balance of fame and shame so you might want to read my article on 6 Tricks for Shameless Leaderboards. Remember that effective gamification is not about the points and leaderboards, it is about diversified learning. Slapping some XP on a project does not effectively gamify a classroom. However, points and levels can be powerful feedback tool in a properly gamified system. For more on how to gamify a classroom read my Insert Coin Series.