Reviewing Content with Shiny Bosses

By far, the greatest successful addition to my game this year was the Boss Battles. Piloted at the end of last year, and fully implemented this year, I've even had students present this form of testing during Student Exhibition Nights. This boggles my mind since the Boss Battles are in reality nothing more than the normal tests and quizzes I would normally have, but as we all know, beating the Boss, and even better, adding each to our collection of "perfect bosses", is so much better than simply taking a test.

My boss battles have undergone a couple of minor tweaks over the course of the year, with the addition of the first hit and first perfect hit, and Google Sheet's new (to me) shuffle question order, but other than that they have remained the same as when I first created them. 

With CASP dates approaching, I started to think about pulling questions from this already created "bank" of questions to create new battles for review. However, I did not love this idea simply because, I did not think this far along in the school year when I set up the individual student sheets, and thus did not leave myself extra places for more than a couple extra bosses. The other issue I had was that each unit is tied to a race of aliens we encounter through our narrative so it would not make much sense for a "robot" boss (matter) to suddenly ask questions about earth systems, for example. 

I was pondering this one morning while on my daily Pokemon Go walk (yes, I still play) when the idea to make shiny bosses came. If you are unfamiliar with the term, a shiny Pokemon is a variant of a regular Pokemon that has a slightly different coloration. It does not give anything new out nor does it have any special attacks, it is simply different. So I set about trying to figure out how to make that happen without having to recreate (copy) a multitude of forms and sheets and do a bunch of work with changing cell references in my evergrowing leaderboard. Most importantly, I did not want to touch the student ranking sheets. So here goes - Fullscreen link

If you are presenting the shiny boss battles as a stand-alone thing for review, you are done, but if like me, you were already pulling data into your leaderboard, you will need to make some other adjustments. 

 As with most of the gamification set-up tasks, the joy for you may be in creating the first shiny boss, and the rest of the process may become tedious, but remember, once done you do not have to do anything other than enjoy your students as they confront the shiny boss. As you see below, the figuring things out ends up being done by Google Sheets so there is no time wasted in looking up individual students to see if they got the shiny boss or not.

What do you think? Any other ideas to make review a part of your game or narrative? I'd love to hear about them.

Boss Battles with Google Forms/Sheets

For a long time, I've been thinking about how to do more than just award experience points (XP) to my students who complete a mastery quest (quiz/test). I've been toying with the idea of making them a bit more interactive and wanted a way to show students how the Boss would lose hit points (HP) as they answered.

Adam Powley (@MrPowley) wrote a piece on Dreadsheets a few months ago, detailing his system, using a very elegant mix of Google sheets, group roles, and dice, kindly sharing all that is needed to implement his system. Make sure to read his post, as it is truly masterful.

His system works really well when you have all those elements in place, but I sadly am not there yet. However, this did not deter me from continuing my pursuit, so borrowing some of his ideas, but trimming it down to the game elements that I do have, I came up with a simpler version that works for me. Before I get down to the nitty-gritty, let me show you how it works.




These boss battles use the simple quiz version of Google Forms and its corresponding Form Responses spreadsheet. You can obtain the folder where I housed both here, though you may just need to make a copy of the Boss Battle Share (Responses).
Also, although I have deleted the data and created several copies, you may find that if you use a copy directly it still carries over some of the "extras". If this is the case, simply create your own Quiz as you would normally do, and once you have the corresponding Form Responses spreadsheet, add a Boss Battle sheet where you copy/paste everything that is included in cells A1:L16. If you do this, you will also need to create a new tachometer, which is a simple gauge chart; if you do not know how to do this, here are some instructions (Stop at slide 8 since you will not need to embed it anywhere else)

Elements of the Boss Battle Sheet (although embedded below, you may want to open the link if it is not quite as clear as you wish it to be.)

Finally, I set the quiz to automatically collect email adresses, release grade immediately after each submission, respondents can see missed questions, and, depending on what I want, either limit to one response or not. 

With all of this in place, it is just a matter of sharing your quiz with students, and displaying the Boss Battle sheet to the class using your projector and screen. As students complete the quiz and submit their responses, they can see the "damage" they inflicted on the boss, until eventually, they defeat it.

I usually provide individual XP after a boss battle like this one to encourage students to actively participate. The XP for each student can easily be obtained from the Form Responses sheet. Also, once the boss has been beaten, you can use the information from that same sheet to determine which questions were missed most often and/or sort it to find out how many responses each student submitted as well as their specific answers. 

Now, I do realize that one student can answer 50 times (simply memorizing answers), while another student can decide to not even try once. This can be somewhat deterred by limiting the number of responses so that the reluctant student has to answer in order for the whole class to beat the boss. You can also make use of the shuffle answers and the shuffle questions options on the form. This at least "forces" the students to re-read the questions and not just memorize answer placement. You could also make the quiz much longer (this 10 question quiz is just an example, with questions that are not particularly insightful). I do have to say that when I did the latter, making a 25 question quiz, my middle-schoolers complained that it was way too much. They like that relatively immediate "hit" and looking up to see the boss "transformation" 

I would love to hear what you think about all of this. 

_________________________________________________________________________________

I thought you may be interested to know what my students had to say about this format of "testing". I presented them with a 10 question and a 20 question format, and as you can see, their response was positive, although they all agreed that a shorter quiz was more engaging than a long one.

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".

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!