Individual Rank Sheets - Google Sheets to the Rescue

Over the last couple of years, as my game has grown, so has my need to add elements that improve the sharing of ranks, perks, and standings with my students. Up until now, I have published our leaderboard two ways:

• a "combined" leaderboard that displays the Top 15 students among all 170 of them.
• each grade level gets their own, which ranks all 34 students for that particular class.

I also publish a Badge Sheet for each class, where students can go and see which of the badges they have earned. All of this already populates automatically from the "master leaderboard" I shared a while back (Leaderboard and Badging with Google Sheets).

This works well to inform the students of their standings. However, it requires that students navigate between several web pages and do some scrolling, often complaining about not "finding themselves" within the data. I also often worry about the students who are at the bottom of the leaderboard since these placements within the ranks are public to all my students. As I pondered these problems, I also thought about a way to give students some control about what information is shared with all and what is "just for each one".

In searching for an answer, I came across two blog posts that should be mentioned as the inspiration for the sheets I came up with, @MrMatera's "Standards Based Grading Gamified and Googled" and @MrPowley's "XP Grading: Video Blog". As always, these two masters of the gamified classroom had already come up with solutions that better informed the students of their progress - The Individual XP Sheet. With a name in hand, and knowing that it was possible to share individually with students, I set about creating one that made sense for my classroom, using a combination of IMPORTRANGE and conditional formatting so that everything would auto-populate without me having to open up a whole bunch of individual sheets. Remember I have 170 individual sheets to maintain.

Just like in the VLookup post I published a few days ago, I would love to simply give you a template to use tomorrow. Unfortunately, even if you use what I share in the set-up procedure that follows, the references for the cells will need to change as soon as you create a copy.

Before I go into explaining the set-up and scare you (it is time-consuming, but you only have to do it once!), let me show you the magic. In the following mini-video you see my leaderboard, my "Teacher Master Sheet" spreadsheet, and a Student Individual XP Sheet

Now that you've seen it in action, let me explain what to do to set this up. It all starts with the Leaderboard, where I need to be very consistent in the placement of the information, especially student names and Emails so that things do not become complicated down the line. In order to accomplish this, the first three columns on the Leaderboard sheet are the only ones where I actually type names and e-mails. The first three columns (A:C) in every other sheet on the leaderboard, where I will type in or import scores, get:

=arrayformula(index(Leaderboard!A3:C36))

With that in place, it is time to create the Teacher Master  Sheet template. I created mine using Alice Keeler's TemplateTab so I would not have to duplicate each student tab myself. If you open the Teacher Master  Sheet template, you will notice that it includes 4 tabs instead of Alice's 2. The Heraldry and Standing tabs, which are imported from the Leaderboard using TRANSPOSE(IMPORTRANGE) and IMPORTRANGE respectively, were necessary for my purposes since I wanted to display elements of both but limit the delay it could cause as I was importing the other elements.

The mini-leaderboard is set to always display the owner student in the middle and two students above and below. It combines some manipulation of conditional formatting and If- Match statements in order to not get errors when the student is at the top or bottom of the class leaderboard. This is why I had to add the Standing sheet.

Once my template was done, I used IMPORTRANGE to add the names to the roster and ran Alice's TemplateTab script. Since I ran the script after I had added the Heraldry and Standing sheets I ended up with a couple of sheets that were mislabeled. If this happens to you, simply discard them and/or duplicate and rename what you need. You will only run the script once for each Teacher Master sheet.

Then comes the onerous task of referencing each of the correct cells from the Leaderboard, as C3 will need to become C4 and D3 will become D4, etc. I wish there was some way to automate this, but I have yet to find it. However, it more painstaking than anything else, and just like the script, I only need to do this for the set-up, and never again. I opened the leaderboard, and for each name, I found the row where it was located and changed the numbers accordingly.

Once I had finished all of them and had the Teacher Master (sharing one where all the numbers have been changed for 34 students, though if you use it you would need to change the leaderboard reference), it is time to create the individual sheets. One would think that you can just open up a spreadsheet and copy/paste, but that does not preserve the format that I painstakingly created, plus I want them to all update automatically, so instead there are a couple more steps.

To preserve the formatting, I first created a new spreadsheet (I called it Student Template). Then I chose one of the student sheets in the Teacher Master. I clicked on the arrow next to the name and chose duplicate sheet. It asked where you want it, and of course, I selected Student Template. Once it is duplicated, I went to the Student Template and saw it had added a tab called Copy of "Name". I deleted Sheet 1, and instead of selecting and deleting the cells in Copy of "Name", I selected and cleared the cells. This preserves all formatting, including all conditional formatting.

Of course, since the referenced sheets were no longer there, it looked like there was an error, but I knew what the final step was...

I made a copy of the Student Template, renaming it with the correct name for my first student (Name 1 in the example), and went back to my trusty =IMPORTRANGE formula.

=IMPORTRANGE("URL of TeacherMaster","'Name 1'!A1:M14")

Notice that Name 1 includes single quotes, this is because the sheet name has a space between name and 1. This is not needed if there are no spaces in the Sheet Name.

After doing this final step 34 more times, I had my first complete set of Individual Student Sheets.

I use the same basic sheets for all my 5 classes, but I do have five leaderboards (where the badges differ) and also like to keep the Teacher Masters separate. This means that I had to change the leaderboard URL to create each of the Teacher Masters before running the Alice's TemplateTab script.

The last step is to share each Individual Student Sheet with the student "owner", which I accomplish the regular way (share, type e-mail, can view). 

Those individual links can also be added to a spreadsheet or blog post where names are sorted alphabetically and since only the student "owner" and myself have access, the risk of oversharing is minimized. Now, for those students that perhaps do want to share their badges or rank insignia, there is always the possibility of creating mini-sheets within their individual sheet. Using =arrayformula(index('Name of student sheet'!C2:E6)) you can select specific cells to share. If you publish just that mini-sheet to the web, students can then get the embed code and publish in their blogs or e-portfolios.

Side quests - with semi automated XP

If you are new to the idea of side quests, consider visiting Explore Like a Pirate and GamificationEDU.

The past few weeks I have been mulling over the idea of adding more sidequests to my game. Up until now, sidequests have been few and far between for a couple of reasons. The biggest hurdle is that I have felt that it is up to me to develop the side quest, complete with resources for the students, and this simply takes too much time. Another issue is that I honestly have never put in a system for awarding XP for sidequests, so whenever a student has actually completed one that I planned for we are both dissatisfied with the XP assigned. If this was not enough, I hate the idea of prepping all of this only to have one student actually complete the side quest that may have taken me days to craft. Yes, it is a me problem.

However, my gamification #PLN often mentions sidequests as a great way to engage students, and provide in-class time for struggling or less interested students to catch up, while more advanced students happily toil on the sidequests. This got me thinking about how I could shift more of the responsibility of side quests to students by providing a board of activities with some assigned XP for attempting/submitting, but still have the choice to add either XP or items on top of that if the end product warrants it. With that in mind, I turned to Westphal's "Differentiating Instruction with Menus", and the internet, and came up with a menu of 15 ideas that could be used as a sidequest. The menu includes a general side quest rubric and explains that the base XP value of a side quest type decreases the more times it is attempted. My motivation for placing this limitation is simply that I would rather a student attempt different avenues to explore the content and not fall into a routine of recreating the same thing for different concepts. The menu also includes a space for complete student choice for my more adventurous students.

With that hurdle taken care of, the issue of how to collect the work, keep track of who did what, avoid repeats and assign XP needed to be taken care of. I toyed with the idea of writing a Google Sheets script, but that is, at the moment, beyond me. What I came up with is a Google Form whose response sheet would:

1. Provide a place to submit the work (if the work is a physical product, the students will have to take a picture and submit that. I wanted to avoid the "I created a mobile and left it in your room, but there is no XP!"
2. Ensure that duplicates of a file are not counted for assigning base XP. (I have middle schoolers who are prone to clicking submit over and over in hopes of rigging the system)
3. Automatically count the number of times a specific side quest type has been submitted and assign base XP accordingly.
4. Automatically add up the XP a student receives.

This is the sheet/form I came up with, and you are welcome to make a copy of both. The folder and its contents are shared with anyone can view. To make a copy, click on file/make a copy for each of them, placing them in the same folder. Depending on your district's permissions you may be able to make a copy of the response sheet and have the option to create the form, or you may need to copy both and link them yourself.  For those of you that may need to recreate the form from scratch, I have included comments on each sheet explaining what it does and the formulas that are attached. Brief recap of how this works:

• FormResponses1: Is where the data from the form is collected, and the query to check for unique URLs is created.
• Unique: Counts the number of unique URLs and type of product by student e-mail.
• PivotCount: Creates a pivot table that adds the values for each product type.
• BasePoints: Uses the data from the pivot table to assign base XP values.
• BaseXP: Creates a pivot table that adds the base XP earned by each student e-mail

I am sure that there is a more elegant way of doing all of this, and I welcome any feedback or suggestions.  If you would like to know how to automatically add these scores to your leaderboard or grade book, I invite you to take a look at "Assign XP automatically using Vlookup - Google Sheets".

Grades in the Gamified Classroom

https://twitter.com/mr_isaacs/status/885658805002018816

In a recent #games4ed conversation we were talking about gamified grading, and the two tweets above came up. This resonated with me for several reasons:

1. As I am sure it is true in most cases, at the end of the day (term, school year), I have to submit regular letter grades. 

2. I have been guilty of falling for the above-mentioned pointification, or simple substitution of traditional grading for an XP-like system and leaderboard. While the change did infuse some excitement in my classroom, the students quickly discovered that it was simply "a rose by another name" and rebelled accordingly - Gamification - Don't Fake It

Simply changing the grades to points does not change the student's mindset. At its core, gamified grading can be a visual representation of competency-based grading, which as Matt Townsley reminds us is different than standards-based grading.

"Competency Based Education is a system in which students move from one level of learning to the next based on their understanding of pre-determined competencies without regard to seat time, days, or hours.

In a competency-based system…

• Students advance to higher-level work and can earn credit at their own pace. (In a building, district, or classroom using a standards-based grading philosophy, this is not necessarily the case. Students are likely required to complete x number of hours of seat time in order to earn credit for the course.)
• Learning expands beyond the classroom. This may or may not take place in a standards-based grading philosophy. For example, in a competency-based system, a student who learns a lot about woodworking over the summer may earn credit when he or she returns to school the next year. Similarly, students are encouraged to learn outside the classroom so that they can demonstrate competencies at their own, rapid rate.
• Teachers assess skills or concepts in multiple contexts and multiple ways. (This may or may not be the case in a standards-based grading classroom; however, it is non-negotiable in competency-based education.)"

How does this translate to a gamified environment?

1. Explicit criteria and targets are made available to students ahead of time. The students in a gamified classroom know exactly what it takes to "defeat the boss" (AKA demonstrate mastery). Basically, everything is assessed using rubrics. The rubrics are created using objective measures, provide actionable feedback and are presented in kid-friendly language. 

2. There are multiple opportunities to gain XP (practice the standards). Every piece of work submitted results in XP, even incomplete or half-correct work! Let's think about this from the gamer standpoint. A player going through the third level of Mario falls and must restart the level. The XP he gained does not go away, and he/she will try the level again using what he/she learned from the previous attempt in order to pass the checkpoint and proceed to the next level. This cycle continues throughout the game. This is also true in the gamified classroom. That half-correct work is re-done based on the feedback, resubmitted for a new assessment and opportunity to gain more XP.

3. Some may demonstrate mastery on their first attempt earning a set amount of XP and perhaps a badge that shows the students (and community) that mastery of the standard has been achieved. This does not mean that the "learning is done". The student can then go on a side quest to earn even more XP and continue to level up within that standard. While this is happening other students are re-working/adding to their work and even going through the same side quest that the "masters" are completing, practicing the standard until they have collected enough evidence of mastery and the total amount of XP available for the standard is achieved.

All of this made public to my students on the leaderboard. But what happens at the end of the week, when I am contractually obligated to publish at least one new grade in the grade book? For that, I choose the most recent evidence of learning. This means that what goes in is not the same piece for all, but rather the individual piece of work that illustrates the learning from that particular student for that week. So, for example, the student that demonstrated mastery on week one and decided to sit back and relax on week two may, in fact, receive a failing grade for the week (no evidence of learning), while the student that has not shown mastery could be receiving an A. 

I know that this system is not perfect, and there is a possibility of inflated grades. Have you found a different solution? I would love to hear your thoughts.

Leaderboard and Badging with Google Sheets

Many of us in the gamified education game have toyed with different leaderboards and badging systems over the years. I've often dreamed of having a system that does the tracking of XP, badges, and items automatically as I input scores, without having to navigate between spreadsheets copy/pasting data from one to the other. This dream also includes the ability to change ranking and badging systems relatively quickly so that if my students become bored with something I do not have to start from scratch each time. As I've kept toying with this idea, I've been discovering some new tricks on spreadsheets that have allowed me to come up with a template of sorts.

I invite you to make your own copy of the template before I explain what is happening in each sheet. Doing so will allow you to follow along and make changes so that by the end of this post you have your own working copy.

Leaderboard and Badging Template

Leaderboard Sheet

Displays all names, ranks, total XP and badges earned by the students. The names and last names are carried over to all other sheets, so any changes you make there will be present in all other sheets. Inversely, it populates the data and images from the other sheets, so changes made in other sheets will display on the Leaderboard sheet without you needing to make any adjustments to it. This is the only sheet I share with the students.

Ranking Sheet

This is a pivot table created from the data on the Leaderboard sheet. If you are using the template, you do not need to do anything to it, but I am sharing a video that explains how to create one in case you are interested.

Heraldry Sheet

In this sheet, I include the images and points needed for each of the 11 ranks I have in my game this year. If you want to change the image to something else, you will need to have the URL for the image you want to display. Simply substitute that URL within the =image("URL goes here, inside the quotations") formulas found in cells A2-A12. Changing those URLs will automatically change the images on the leaderboard page. Same goes for changes in the name and the min and max XP for each rank, allowing you to quickly change the theme of your ranks as well as make adjustments to your ranking when you find that the range of points for a rank is too wide or too narrow.

Badges Sheet

Much like the heraldry sheet, this sheet contains the images and descriptors for each of the badges I have for this class. Any changes in name or image for the badge are reflected on the Leaderboard sheet. Just like in the Heraldry sheet, to substitute the badge image change the URL of the image to one of your liking within the quotations of the =image("URL") function. All of my badges were created using Google Draw as explained by Alice Keeler in this blog post.

XP Sheets - (Blogs, PBL quests, Mastery Quests, Repeat Assignment)

These are the sheets where I input the XP. Although I could have done this on just one sheet, I prefer to have the different sheets in order to organize the data. The names in all of them are populated from the leaderboard, and the total values calculated in each sheet, populated back into the hidden columns (F-J) on the Leaderboard and added into column E. Changing the names of the sheets will not affect the Leaderboard calculations nor the ranking sheet. The "magic happens" on the cells with a grey background so those are the ones that should not be touched directly.

Badge Tally Sheet

This is the sheet where the badges are "awarded".  You can award the badges "manually" by entering the scores directly, or you can pull those scores from the sheets and manipulating them using the different formulas you see on the sheet. The names for the badges come from the Badges sheet, making it easy to keep everything organized.

Right now, I am toying with adding an Items sheet that will work much like the Badges sheet, and I will share that with you as soon as I am done. If there is anything that does not work, or you find confusing drop me a note in the comment section. I'll gladly help you figure it out.

We don't need badges, or do we?

When I started my gamification journey, one of the sore spots, if you will, was the awarding of badges. On the one hand, I agree with the ideas in Daniel Pink's Drive and the overjustification effect, and which translates into "Badges ruining intrinsic motivation to learn". On the other hand, I have a gamer son, who keeps going back to specific games in his collection simply because he wants to get that elusive gold badge just so he can show it off in his profile. So which is it?

As I continued to ponder the answer to this question, I participated in a couple of workshops and PD that offered badges that could be "added to my profile". I was surprised by my own drive to complete the activities, not really for the sake of learning, but because I wanted to show off the badges I had. Badges were giving me a sense of accomplishment and encouraged me to persevere, even when I got bored! If badges were doing this for me, why was I being so reluctant to add them to my classroom?

I began exploring different ways that other educators have used badges and came up with two reasons that if addressed would make me re-think the whole badging issue.

First, if I were to include badges, I had to make sure that the badges represented real achievement. One of my concerns with badging is that it can simply become a sticker chart. The idea that everyone gets a badge simply for showing up or participating in an activity takes away the value of the badges. Let's face it if the students know that they will get a badge simply for filling in boxes in an assignment, will they put any effort into making sure that their answers are correct? Probably not. However, if they know that they will only get the badge if they get a high enough score, then they may feel that the badge has some value attached to it. Even better, let's say that they did not get a high score in the badge assignment(s) the first time around. Will knowing that they can re-work the assignment giving them more than one opportunity to earn the badge, motivate them to keep at it, even if they think it is boring or not worth their time? I think it will.

Now, if this is the case, then I knew that I needed to be able to make my own badges. There are several online tools that allow us to do that. Classbadges, Credly and OpenBadges come to mind. However, I prefer to fully create my own simply using GoogleDraw and clearly explained here by Alice Keeler.

Second, the whole idea of badges for me is that they must be public. Students will want to know, not only if they have the badge, but also who else in the classroom has it. That gamer sense of competition and being able to showcase achievement adds value to the badge. The tools mentioned before for creating the badges, also allow students to log in and view their badges. Now this would require students to create an account and/or log in with accounts that the teacher creates. That, for me, was a no go, and although I toyed with the idea of creating my own system using GoogleSheets, I decided against it (simply due to time constraints), when I came across Flippity.net's Badge Tracker. With a few tweaks, this tool allowed me to import the data of my existing leaderboard, use my own badges and embed it in my webpage for public viewing. All around win!

For now, I have decided on three types of badges:

Leveled Badges: These symbolize achievement in on-going assignments. Students will earn these badges by scoring well on their weekly writings and reading assignments.

Project Badges: These badges represent the skills and knowledge gained in a specific unit of study within the scope of science and engineering curriculum. 

Commitment Badges: These are badges awarded for achievement outside the leveled and project badges. What I envision here is, for example, a "Digital Citizenship" badge or a "Creative Commons" badge. 

So, what do you think about adding badges to your gamified classroom? I would love to hear your ideas.

Beyond the Leaderboard: Self-ranking charts

A couple of days ago, I talked about creating a multiple-class, self-ranking leaderboard. My students love the idea of being able to see where they rank, and compare themselves to one another, creating this competitive gaming environment that often leads them to perform and to keep working, simply to "outrank" one another. As I was updating my class website to include this new board, I started thinking about how to use the leaderboard as more than just a ranking system for the XP. Could I use it to inform students about how they are doing in different categories? Could I show the data in some way that would maintain the integrity of the leaderboard, but focus students' attention on opportunities for improvement as well? And almost as important, is there an easy way to do it; one that would not require much more than inputting values as the students grow? The answer turned out to be YES on all accounts.

Before I show you how, let me share the end products:

"I Need To Do More" chart

This first interactive chart, displays the totals for each XP category. As the year progresses, students can see how much each of the categories has impacted their XP totals. On their own, or with some help, they can decide to go back to assignments they may have missed or where they scored low XP and re-do/re-submit in order to up their total XP for that category. In my case, it could show an Aha moment akin to, "I have not done many of my blogs, if I do them now I can gain all those XP I missed".

"I Need To Do Better" chart

In this other format, the same data is displayed by average XP obtained in each category. When students see the data organized this way, they can quickly see areas where they can focus their efforts, to increase their standings.

The beauty of both of these charts is that they use the same Pivot Table I created for the self-ranking leaderboard, so not only do they update as soon as I input new values, they are also tied to the original ranking. The student order within the chart updates as well as they move up or down on the leaderboard, making it a "one-stop" responsive system that does not create more work for me to maintain or update.

The following video explains how to create the charts, and I am also sharing a template that you can use to draft your own.

Let the games begin!

Appsmash to Gamify - From Leaderboards to Quests

Although many of us agree that gamifying your classroom can provide benefits in terms of engagement and relevance for the students. Many of the teachers I have talked to have this idea that gamification is too hard, or that you can only do it by purchasing an app or some other tool, which may or may not limit what you can do. However, this is simply not true. With the myriad of free tools at our disposal and a little creativity, you can create your own gamified world for little to no money. Gamification is about creating a game-like experience, not about creating an actual game.

Before we go any further, take a peek at my "Island of AdVENTURE", where our ultimate goal is to take over the world. That is the simple storyline for my classroom. The benefit of such a broad and vague topic is that it will never be "done", and gaming elements can easily be added as they are needed. I talked about the decision to adopt a single storyline for all my classes in a previous post. If interested, you can visit Gamification Year 2 - The quest continues.

So, what was needed to create the Islands of AdVENTURE experience?

Game Website:  

If you have been here before, you know that my go to place for this is WIX, because it allows for ultimate flexibility in item placing, allowing you to embed practically anything you may wish to add. WIX is free to use, and gives you one place to create as many web sites and subpages within a site  as you need. On the game website itself, I like to add links to my blog, class calendar, and all of our classroom policies, procedures and even the green sheet. This gives the students a central place to go for everything related to the gamified classroom, and completely eliminates any "but I didn't know..." moments. These different documents are added as tabs, or in the case of the classroom management stuff, an interactive Thinglink image that gives access to all documents with a simple click.

Maps: 

This is the only item in my gamification arsenal that I paid for: Profantasy Campaign Cartographer. I could have used art from other sources and/or even used maps from Google Mapmaker, but creating my own allowed me utmost flexibility to include what I wanted, down to shaping the islands to represent grade levels, and creating distinct homes for each class.

This was also where I began to Appsmash. The islands on the game website are linked to the grade level houses and leaderboard using "invisible" shapes that act as buttons. The quests inside the houses are linked using interactive Thinglink images. The reasoning for this is simple. I wanted the students to be able to quickly and easily identify the quests they have, without cluttering the images with a lot of text or buttons. By hovering over each icon, students can quickly access the quests they are undertaking without any instructions from me regarding the icon that was used to represent a specific assignment.

XP and Leaderboards:

In my class, students gain experience points (XP) by blogging consistently and by completing the different projects they work on. Whatever you choose for XP, I recommend that you do not tie it to behavior, but rather mastery of skills or concepts. Just like in games and real life, XP does not "go down". Once you gain experience, you never get experience taken away. 

To create the leaderboard(s), I use Google sheets. I previously shared how to create one for a single class. This year, I am adding a leaderboard that functions much the same way, but since I am working with a single storyline, I needed to create one that could rank all my students from different classes and give us a way to compare classes. The following video will show you how.

Quests:

In my project based learning (PBL) environment we have two types of quests. The PBL Quests that culminate in a Boss Battle (i.e. the project product itself) and Mastery Quests. The PBL Quests are created using WIX for the bigger projects or Tackk for smaller assignments. Both allow embedding and manipulation of the color schemes, backgrounds, etc. giving you the opportunity to create a different aesthetic feel for each quest. The PBL Quests are embedded into the class game site and linked through Thinglink.

The Mastery Quests are the worksheets (level 1), quizzes (level 2) and tests (level 3) I use with students.  This simple renaming and leveling of the different types of work, tells the students how they need to prepare, and gets them excited about completing them. Don't you agree that it is much cooler to complete a Mastery Quest Level 3 than to take a test?

To create the first two types of Mastery Quests, I use the capabilities of Wizer.me. Mastery Quests Level 1 usually have links, videos and/or simulations embedded (example) and Level 2 may still have some supports (example). For Level 3, you can still use Wizer.me if you wish to give access to articles or graphs that the students must analyze. For a more "traditional" level 3 Mastery Quest, however, I use Google forms.

I usually do not embed the Mastery Quests in the game website itself, but rather give access to them by posting the individual URLs for the different assignments on our Edmodo stream. Of course, they can be shared in Google classroom or whatever other way you currently have to distribute online work.

Class Currency:

The behavior rewards, if you would like to have them, can be handled in several ways. In the interest of Appsmashing, you could use Class Dojo, and have it embedded into your WIX page. However, that has never really worked for me. I find it cumbersome to walk around with a device and scrolling when I want to assign behavior points. For this I go old-school, and use my school's paper based currency (Patriot Bucks), giving them out as needed. Since they are physical objects, I do not have to create a way to manage them. The "store" is created again using a Thinglink  embedded into the WIX class game page so that students can simply hover over the different items, and check "prices". 

What do you think? Have you tried gamification in your class? Please share your experiences.

Gamification Year 2; The Quest Continues

As I am preparing to say goodby to another year of gamifying, I feel the need to write down some of the things that are buzzing in my head, lest I forget them in the summer days ahead. This year completed my year 2 in the gamification arena, and as always some things went well, while others will need a complete rethinking.

Story Lines

This year I worked with four distinct story lines, one at each of the grade levels I teach. They were fun to create, and although the students liked that they each had different avenues, I have to admit that keeping them all working at the same time became rather difficult. I would get ranks and achievements mixed up, and sometimes even directed students to a different story.

As I begin to rethink  and prepare for next year I will be going back to one story line as my main effort, allowing me to also combine some of the other aspects of the gamification experience for my students.

Leaderboards 

The self-ranking leaderboards are in place and served to keep the kids motivated in continuing with the game throughout the year. At times they are still chore to keep updated, but the kids kept me accountable for doing this, as they did check them often, particularly towards the end of the school year as they were looking forward to achieve the highest rank and obtain lofy perk of "Blog Immunity".

This is also where I think having a single storyline will come into play. During this school year, each grade level had their own leaderboard, ranking system, etc. However, I also published for the students the cumulative class ranking. Students were particularly interested in seeing how each class stacked up against each other, and often asked which students were in the lead. In looking forward, I am considering having the individual leaderboards for each class, but also publishing a "top ten", which will be easier to achieve if all classes are working under the same story.

XP

The structure of the game using the blogs as the primary way to get XP worked well, particularly for my upper graders. For the most part, kids blogged consistently about their learning, and we saw a couple of students reach 100 content-related blog post this year. Including the S&EP (as mentioned in my Gamifying the NGSS post) pushed the students to "think like scientists", and provided me with a tangible way to assess them in their progress towards mastery of the practices.

Although the blog points as XP has worked really well, I am re-considering not using their unit tests, performance tasks and projects within the XP structure. The XP has always been about progress towards mastery, and including them in the XP would allow me to encourage the students to perfect their work. It is an easy fix, but it will require a little work on the back end to make sure the playing field is even in regards to points, particularly since these are tied not only to rank but to privileges as well.

Gold Coins

The structure I had in place for obtaining gold coins this year did not work at all. Only three of my 240 students even attempted a cross-cutting "boss battle"(Gamifying the NGSS). When I asked why, the students reported that it was too hard to obtain gold coins, and although I modified the structure several times, by the time the changes came about the students had lost all interest in them. 

As I think about next year, I am considering reverting the gold coins back to simple participation points and displays of good citizenship or behavior, instead of tying them to the content. However, I need to figure out a way to keep the management simple. Walking around with an open app (like Class Dojo) or a spreadsheet has never worked for me. I guess I could create some tokens...

Other gamification things to explore

Escape Rooms: 

Recently I attended the Deeper Learning conference, and participated in an Escape Room experience. I think this has great potential for the gamified classroom, and I invite you to visit some of the things I've found regarding their use in education:

Ms. Casa-Todd's Escape Room

Ms. Pollock's EduEscape

Ms. Magiera's EscaperoomEdu

Choose your own adventure videos:

A year ago, my daughter showed me the Interlude tool and I remember thinking how well it could be integrated into a gamified classroom. This video creation tool allows you to design, create and publish an interactive video with relative ease, providing you with a way to enhance your gamified classroom with "choose your own adventure" videos. Unfortunately I forgot all about it until a couple of days ago, and I am sharing it here in case one of you gamifiers wishes take it on as a summer project.

Leaderboards with Google Apps, an update

A while back I talked about using Google Spreadsheets to create a leader board. The main drawback I saw in my original version is that students (and me) were unable to see clearly who was in the lead unless I sorted it, which at times created errors in some of the cells. I continued to tinker with it and discovered the pivot table function. This was the answer!

 Here is a video tutorial that shows just how to create the self-ranking leader board.

The formulas that I used to create this are -

Importing ranges of cells:

=arrayformula(index(Leaderboard!A1:A38))

Conditional formula for images:

=IF(C2>=15401, image("https://goo.gl/3Pqxfr"),IF (AND(C2<=15400,C2>=13601), image("https://goo.gl/thtuwd"), IF (AND(C2<=13600,C2>=11901), image("https://goo.gl/2yWS3J"),IF(AND(C2<=11900,C2>=10301),image("https://goo.gl/I76A2i"),IF(AND(C2<=10300,C2>=8801),image("https://goo.gl/ahUpyM"),IF(AND(C2<=8800,C2>=7501),image("https://goo.gl/XyVodq"),IF(AND(C2<=7500, C2>=6301),image("https://goo.gl/ORNbNs"),IF(AND(C2<=6300, C2>=5201),image("https://goo.gl/2VYg9Q"),IF(AND(C2<=5200, C2>=2501),image("https://goo.gl/87vY96"), IF(C2<=2500,image("https://goo.gl/aVgK1f")))))))))))

Modified embed code - I highlighted the part you add:

<iframe src="https://docs.google.com/spreadsheets/d/1YeCoYjAp_n6d7q9UkmV3-WJ24OtMsHfLR43ryLmy6vA/pubhtml?gid=990555132&amp;single=true&amp;widget=true&amp;headers=false&amp;gid=0&amp;range=A1:D39" width="450" height="2350" ></iframe>

Of course, you can always make a copy of the document I used in the tutorial and modify it to suit your needs.

I invite you to play around with it. For example, you can add avatars or other images using

 =image("https://goo.gl/Bv19zc")

You will again need to host the images in a published document, shorten the URLs, and remember to modify the range, width and height if you are going to embed it anywhere. In this document, I show the avatars in the pivot table, and just like before they are ranked by XP.

I have not found a way to also include items or badges in the pivot page. When I try it, the totals are pushed to the very end, creating a rather messy look. However, you could always publish them in the leader board page, which keeps them in alpha order and could actually be an even better idea.


If you've found different ways of doing this or need some help, leave a comment. Don't be shy. We are in this journey together.