Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

BINGO!

Bingo by ALice KEeler

BINGO!

Bingo by Alice Keeler

Create a Bingo Board with Google Sheets

Use Google Sheets to create multiple, different, Bingo boards from your own list.

Bingo Sheet example in Google Sheets

Template

alicekeeler.com/bingo

As with all Apps Script coding projects you need to wait a minute for the code to load. Look for the “Bingo” menu to load up next to the Help menu.

Choose setUp and authorize the Add on.

25 Checkboxes

The initial setup is 25 checkboxes. You want a minimum of 25 choices for your Blackout Bingo boards.

Checkboxes in the spreadsheet

Add More

Have as many options as you want! This Bingo board generator chooses a random 25 items for each board. Continue to add to your list of items beyond the 25. Adding extra checkboxes is one of the fun things about Google Sheets! It is SO EASY! Highlight the blank cells in column A and use the Insert menu to add checkboxes. PRO TIP: The spacebar will check the checkboxes. Highlight all your unchecked checkboxes and press space.

Instead of inserting the checkboxes manually you can use the Bingo menu to Insert checked checkboxes for the additional rows you have.

Title and Other

In cell C1 replace the word TITLE with the title of your Bingo sheet. In D1, delete the word Other, or replace it with a value that will appear below their name.

Make Bingo Sheets

You will be prompted for how many Bingo sheets you want. A unique board will be automatically generated for each. Note, only items that are checked will be included in the Bingo board. If you do not have 25 checked items the result will be blank boxes.

Print in Portrait

By default, spreadsheets print in landscape. Control P to print and change to “Portrait.” Be sure set the print range beyond just the “Current sheet” to print all of the Bingo boards.

Check the print settings for portrait when printing.

5 Easy Steps for Teaching with Digital Tools

Introducing digital tools into your teaching can seem challenging at first. There are many tools out there, and it might feel like there’s a lot to learn. But with easy steps for teaching with digital tools, you can start simply and gradually. There’s no need to dive in all at once – just take it one step at a time. Taking easy steps for teaching with digital tools starts with trying something!

Read More »
Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

2 thoughts on “BINGO!

  1. This is great thank you! I would love to be able to use images instead of just words. Is there a way to do this? I uploaded images into the cells but it did not work.

Leave a Reply

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

%d