On the lookout for a method to award college students badges to visualise engaging in objectives or demonstrating expertise? Google Sheets provides an easy resolution to create and handle digital badges. By combining the spreadsheet’s knowledge administration capabilities with its conditional formatting choices, you may simply design and show badges that symbolize particular person achievements. Here’s a tutorial on methods to create badges in Google Sheets
Utilizing Badges within the Classroom
If in case you have ever performed a digital recreation that awarded badges there are 3 causes to earn a badge.
Exhibit Mastery
Pupil demonstrates they’ve mastered a sure ability or normal. What’s nice about utilizing badges for that is that badges can be utilized for recognizing gentle expertise that aren’t essentially named requirements, but have worth for college kids.
For Enjoyable
Including enjoyable to the classroom is motivating. Supply some enjoyable challenges which have little to no connection to the requirements, but assist construct tradition and engagement.
Extending Challenges
Overcoming a problem is partaking. Badges assist you to supply college students non-compulsory challenges that may encourage them to go above and past.
Create Badges in Google Sheets
Begin by making an inventory of challenges in a Google Sheets spreadsheet. Keep in mind to supply selection, incorporate completely different choices for pupil pursuits.
Whilst you 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: Maintain down the shift key to make sure you draw an ideal circle.
- Make sure the circle fills nearly the complete 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 Net.”
- Copy the printed hyperlink.
Including the Google Drawing
Whilst you can add pictures to Google Sheets utilizing the Insert menu, I might advocate a formulation as a substitute. You need the badge picture to solely present up if the coed has completed the necessities for the badge.
You will have a method 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.
Within the cell you want the badge to look add the formulation
=IF(A2=FALSE,””,IMAGE(“URL”))
A2 assumes the checkbox is in row 2 and column A. Regulate the formulation accordingly.
The place the formulation says “URL” as a substitute paste the hyperlink to the printed drawing. Make sure the URL is enclosed inside “single quotes.”
