Looking for a strategy to award college students badges to visualise undertaking targets or demonstrating expertise? Google Sheets provides an easy answer to create and handle digital badges. By combining the spreadsheet’s information administration capabilities with its conditional formatting choices, you possibly can simply design and show badges that characterize particular person achievements. Here is a tutorial on methods to create badges in Google Sheets

Using Badges within the Classroom

If you’ve gotten ever performed a digital recreation that awarded badges there are 3 causes to earn a badge.

Demonstrate Mastery

Student demonstrates they’ve mastered a sure talent or customary. What is nice about utilizing badges for that is that badges can be utilized for recognizing smooth expertise that aren’t essentially named requirements, but have worth for college students.

For Fun

Adding enjoyable to the classroom is motivating. Offer some enjoyable challenges which have little to no connection to the requirements, but assist construct tradition and engagement.

Extending Challenges

Overcoming a problem is participating. Badges permit you to supply college students non-compulsory challenges that may encourage them to go above and past.

Create Badges in Google Sheets

Start by making a listing of challenges in a Google Sheets spreadsheet. Remember to supply alternative, incorporate totally different choices for scholar pursuits.

While you possibly can insert drawings utilizing the Insert menu, I like to recommend you create your badge in Google Drawings.

• Use the File menu to resize the canvas to five inches by 5 inches.
• Use the circle/ellipse device to attract a circle. Tip: Hold down the shift key to make sure you draw an ideal circle.
• Ensure the circle fills virtually your entire canvas.
• Use the road weight device to make a thick border on the circle.
• Add design parts.
• Use the File menu to pick “Share” and “Publish to the Web.”
• Copy the printed hyperlink.

Adding the Google Drawing

While you possibly can add pictures to Google Sheets utilizing the Insert menu, I’d advocate a components as a substitute. You need the badge picture to solely present up if the coed has achieved the necessities for the badge.

You will want a strategy to point out the coed has met the necessities. I like to make use of checkboxes. Add a checkbox from the Insert menu. Assume that is in column A.

In the cell you want the badge to seem add the components

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

A2 assumes the checkbox is in row 2 and column A. Adjust the components accordingly.
Where the components says “URL” as a substitute paste the hyperlink to the printed drawing. Ensure the URL is enclosed inside “single quotes.”