Gamify your classroom with Google Forms

Gamification and badges in education have been ideas floating around for a few years now. Some educators have jumped on the band wagon only to abandon the concept soon after. Often, one of the obstacles to effective implementation is proper technological support (1). The good news is Google Forms is a relatively simple (and free!) tool to help implement gamification elements into education.

What are “badges” & “gamificationGamification and badges in education using Google Forms“?

Badges in education and the idea of gamification is one way teachers can help motivate students in the classroom and help students keep track of effort and achievement.

Gamification can be defined as:

the concept of applying game mechanics and game design techniques to engage and motivate people to achieve their goals.

Source: https://badgeville.com/wiki/Gamification

The idea is much like the concept behind the Scouts movement – achieve something, earn a badge. Many popular video games also use a badge system, and many of our students enjoy and understand this way of measuring achievement. So it makes sense to use a badges systems in the classroom.

To find out more about using badges in the classroom, have a look at this article:

http://www.edudemic.com/guides/the-teachers-guide-to-badges-in-education/

Automating gamification & badges in education on a (very!) limited budget

Gamification and badges in the learning environment has been of interest to me for sometime. However, within the learning environment I have been working with, the concept would be very labour intensive to implement and track. While playing around with Google Forms, an idea came to me – surely Google Apps script could be used in a self-marking quiz to send a badge to a supplied email address if a certain score was achieved in the quiz?

So I wrote an algorithm and found some potential providers on Fiverr.com. I contacted them to outline what I wanted. Within hours I had settled with the wonderful Riyafaahf who provided me exactly what I wanted in less than a day.

And below you’ll be able to grab the code and instructions for yourself.

Automating badges in Google Forms

How it works

The student completes a self-marking quiz in Google forms and provides an email address. If the student achieves a certain mark, they will receive a badge via email.

Here is a simple, sample quiz for you to try out and see how it works (don’t worry, I won’t ever use your email address for anything else):

https://goo.gl/forms/9CPFp5Kc4VJFQlV92

What you will need

  • Access to Google Forms (either through Google Drive or G Suite for Education)
  • Student email addresses (they do not have to be Gmail)
  • An image for your badge (this will be emailed to the student should they achieve a certain score) saved to your Google Drive
  • The code on this page
  • The file ID for your Google Sheet where quiz responses will be collected and the file ID of the badge file  (don’t worry, getting these is easy – see the video if you’re not sure)
  • Devices for students to respond to the form (works well across most platforms including smart phones and tablets)

Planning

It might be a good idea to start off with a smaller topic area with a few quizzes (and badges). This allows you to test the waters and the technology. Your badges with be based on the required student outcomes.

It might also be a good idea to think about what you would like students to do with the badges they collect. One simple idea is having each student create a simple eportfolio in Google Slides to save their badges in.

Tips for setting up your quiz in Google Form

Watch video tutorial for visual step-by-step instructions.

You need to save your Google Form as a self-marking quiz and make sure the responses are being collected into a Google Sheet.

  • Make sure you are collecting email addresses. This can be done by asking for an email address in the quiz (use data validation to ensure the address provided appears valid) or selecting the option to collect email addresses in a  G Suite for Education school.
  • Mark all questions as “required”.
  • Select “Make this a quiz” in the form settings.
  • Go through each question and add your points and select the correct answer.

Adding the “Send badge” code

Watch video tutorial for visual step-by-step instructions.

This adds the badge ‘magic’ – sending the badge to the student’s email once they submit their responses.

Below is the code, ready for you to insert your information. You will need to copy it, paste it into your Google Form Script Editor and replace the variable information with your information.

If your browser does not select the code automatically, select all the code from line 1 to line 21 and copy it.

Send badge for Google Forms quiz
 
function onSubmit(e) {
  var sheet = SpreadsheetApp.openById(e.source.getDestinationId()).getSheets()[0];
  //var sheet = SpreadsheetApp.openById("REPLACEwithGoogleSheetsFileID").getSheets()[0];
  var lastRow = sheet.getLastRow();
  var score = sheet.getRange(lastRow, 3).getValue();
  var email = sheet.getRange(lastRow, 2).getValue();
  var subject = "REPLACE with Email Subject";
  if(score>7){
    var body = "REPLACE with Your Email Message.";
    var id ="REPLACEwithYourBadgeFileID";
    var fileBlob = DriveApp.getFileById(id).getBlob();
    GmailApp.sendEmail(email, subject, body, {
      attachments: [fileBlob]
    });
  }else{
    var url = "https://goo.gl/forms/REPLACEwithYourFormURL"
    var body = "Good try at the quiz. Have another try to improve your score and earn your solar system expert badge. You can access the quiz at "+ url;
    GmailApp.sendEmail(email, subject, body);
    
  }
}

 

To paste the code into your form:

  • Go to your Google Form
  • Click on the 3 dots at the top right of the screen
  • Select select <> Script Editor…
  • File > New > Project
  • Paste the code
  • Give your project a name
  • Replace variable information as required (see table below)
  • Click on Resources > Current Project’s Triggers
  • Click to add a new trigger. The triggers should look as follows (should be the default):
    Google Apps Script triggers screen shot
  • Review and authorise permissions

You will need to change all or some of the following information for the variables (depending on how your form and spreadsheet are set up). The table below should help you work out what you need to replace.

Line numberVariable to replaceWhat to replace it with
03REPLACEwithGoogleSheetsFileIDThe ID of the Google Sheet collecting your form information
053Column number in the Google Sheet that contains the quiz score
062Column number in the Google Sheet that contains the email address of the student
07REPLACE with Email SubjectReplace with the text for the subject of the email the student will receieve
087Replace with the minimum score a student should achieve to receive the badge
09REPLACE with Your Email Message.Replace with the text for the email message body for students who achieve the badge
10REPLACEwithYourBadgeFileIDReplace with the ID of your badge file in Google Drive
16https://goo.gl/forms/REPLACEwithYourFormURLReplace with the URL of your Google Form
17Good try at the quiz. Have another try to improve your score and earn your solar system expert badge. You can access the quiz atReplace with the message you would like students to receive who DO NOT achieve the badge.

Test your form

Watch video tutorial for visual step-by-step instructions.

Make sure you test your form before you unleash it on your students. Use the preview button to respond to the form. Check to make sure you get the badge when you answer the right number of questions correctly and you DON’T get the badge when don’t get enough questions right.

Sharing your form

Watch video tutorial for visual step-by-step instructions.

Once you’ve tested your quiz and everything is working okay, you are ready to share! You can email a link or provide a written link. I find the Google Forms URL shortener pretty clunky so I usually use bit.ly and create a custom, easy to understand URL.

Video tutorial: Automating gamification in education with Google Forms

Other helpful resources

12 free badge images:

https://www.teacherspayteachers.com/Product/12-Free-Badge-Images-for-Classroom-Gamification-2954231

Over 120 editable badge images (paid resource):

https://www.teacherspayteachers.com/Product/120-badges-and-images-for-gamification-in-the-classroom-2954139

 

Did you find this article useful? Why not share it!

Responsive elearning made easy using Google Forms

Google Forms is an incredibly versatile and powerful tool. Google Forms has made it simple (not to mention free!) for anyone to create a simple, online form. These days, surveys created in Google Forms are almost ubiquitous, used by individuals and big companies alike.

Over time, Google Forms have improved and evolved. Now you can add videos and images. You can even set-up a form to go to particular sections based on responses provided. And that’s where the branched elearning scenarios come in to it.

A branched scenario throws up a challenge to the student and gives the student choices. This leads to consequences based on the choices made. These ‘3cs of scenario building’ are outlined in the below illustration and explained in the video at the end. Google Forms lets you build these scenarios by moving users through the form based on their responses rather than in a straight line.

Branched scenario

Is Google Forms the most elegant and sophisticated of the elearning scenario building tools? Well, no, but it’s easy to use and quick to learn and the price for Google Apps for Education users is perfect (free!)

Tips and tricks

  • Mathematical concepts can be hard to express properly in Google Forms (as per my example in the video). In hindsight, I should have created the 3 different options in a drawing and cross referenced them in the question.
  • Plan out out scenario and organise all your media (images, video, text, etc) before putting it to together in Google Forms. It will make the process quicker and more efficient.
  • Make sure you test your form before you unleash it (even get a friend to test it for you). You want to make sure your branching works or you could create confusion.
  • Responses will be saved to a Google Spreadsheet. In a GAFE domain, students can login and you can check using the responses spreadsheet how they went, how long it took, etc.

Applications for education

Branched scenarios are great for checking students’ skills and knowledge. You can provide instant feedback, as well as instant support if there is a skills or knowledge gap.

To find out more and see step-by-step how to set up a branched scenario in Google Forms, watch the video below.

References

http://blogs.articulate.com/rapid-elearning/build-branched-e-learning-scenarios-in-three-simple-steps/

Did you find this article useful? Why not share it!