Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Create Badges in Google Sheets

Wanting to gamify your class with badges? One option is to create badges in Google Sheets. Create a list of achievements and add a badge for each one.
Create Badges in Google Sheets

Want to bring a bit of game-like fun into your classroom? Badges are a great way to do just that! They’re perfect for showcasing students’ learning achievements in a visual and exciting way. You can whip these up right within Google Sheets! I’m here to walk you through a quick start guide on creating and displaying badges. It’s simpler than you might think and a fantastic way to celebrate achievements, making your classroom an even more engaging space. Create badges in Google Sheets to easily design and display badges. Here is a tutorial on how to create badges in Google Sheets.

I heard from many of you that you wanted to know what to do next after you made the badges! Check out this workshop I did for OTIS to help you take those next steps.

Create Badges in Google Sheets

In this video I show you how to create a badge in Google Drawings and insert it into a display grid in Google Sheets.

Using Badges in the Classroom

Badges are a visual way to acknowledge achievement. Certificates are an example of badges that are frequently used in schools. However, they do not have to take the form of a rectangle the size of a piece of paper. Using digital badges that are displayed on a grid allows for a more granular acknowledgement of accomplishments. 

Why Assign Badges?

If you have ever played a digital game that awarded badges there are 3 reasons to earn a badge.

Demonstrate Mastery

Student demonstrates they have mastered a certain skill or standard. What is great about using badges for this is that badges can be used for recognizing soft skills that are not necessarily named standards, yet have value for students.

For Fun

Adding fun to the classroom is motivating. Offer some fun challenges that have little to no connection to the standards, yet help build culture and engagement.

Extending Challenges

Overcoming a challenge is engaging. Badges allow you to offer students optional challenges that can encourage them to go above and beyond.

Badge Game Template

I am passionate about gamification. Google Sheets has been a great tool for me to display badges for students. Here is a template I have previously shared on this blog for creating a gamified experience:

Learn More about Google Sheets from Teacher Tech

Start with Creating Challenges in Google Sheets

Start by making a list of challenges in a Google Sheets spreadsheet. Remember to offer choice, incorporate different options for student interests.

Create Badges with Google Drawing

You can create your badge image in any graphics program. I choose to use Google Drawing because I do not need to download it. I can use the publish settings to get the image link. The link is used in Google Sheets to display the badge. 
screenshot of google drawing with a perfect circle drawn. The line thickness option in the toolbar is selected at 16
  • Use the File menu to select “Page setup.”
  • Resize the canvas to 5 inches by 5 inches.
  • Use the circle/ellipse tool to draw a circle.
    Tip: Hold down the shift key to ensure you draw a perfect circle.
  • Ensure the circle fills almost the entire canvas.
  • Use the line weight tool to make a thick border on the circle.
  • Add design elements.
  • Use the File menu to select “Share” and “Publish to the Web.”
  • Copy the published link.

Books by Alice Keeler

Available on Amazon or in bulk order.

Add Badges in Google Sheets

While you can add images to Google Sheets using the Insert menu, I would recommend a formula instead. You want the badge image to only show up if the student has accomplished the requirements for the badge.

Level Up with a Checkbox

You can pre-load a spreadsheet with all of the badges but not have them display until you check off that the student has accomplished the achievement. Create a column with inserted checkboxes next to each badge.

=IF(A2=FALSE,””,IMAGE(“URL”))

A2 assumes the checkbox is in row 2 and column A. Adjust the formula accordingly.

Replace the formula says “URL” with the link to the published drawing. Ensure the URL is enclosed within “single quotes.”

Basic Getting Started

Hopefully this gets you started with an easy way to practice creating badges and sharing them. You can get much more complex by using systems in spreadsheets, but this is a place to start! Happy practicing creating badges in Google Sheets

2 thoughts on “Create Badges in Google Sheets

  1. Pingback: Sharing Diigo Links and Resources (weekly) | Another EducatorAl Blog

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

© 2024 All Rights Reserved.