In this tutorial you’ll learn how to create from scratch a Sight Word Bingo Card generator so you can generate your own Bingo Cards. you’ll be able to use our 180 words prepopulated in the file or use your own.
What are Sight Words
Most used in English, sight words are high frequency words that young children, in kindergarten or Grade 1 are exposed to. The goal is to improve reading by identifying these words quickly
What is a Sight Word bingo game
Sight word bingo is a game combining the game of bingo with learning of sight words. An educator or a parent reads random sight words from a list and children mark the words on Sight Word bingo cards. Very similar with the game of Bingo but instead of numbers, the game uses words
Learning sight words is a very important activity for pre-kindergarten, kindergarten and grades 1 and 2 kids. It is the foundation of learning to read.
The winner of the game is the first person to mark off five numbers in a row or column.
How to find Sight Word Cards
Making materials for this game can be a challenge. Often educators have to Sight Words printable cards with pre-defined words that only get used a few times. These cards can become predictable.
Another way is to make these Bingo cards by hand, printing blank templates and writing the words.
Can I generate Sight Word Card with random words?
In this tutorial you’ll learn how to make a generator in Excel for Sight Words Bingo cards. This generator can use your own list of words and will randomize cards with the press of a button allowing you to print each card once reviewed on the screen.
Can I just download the Sight Word Card Generator
Yes, if you have trouble following the tutorial to create these yourself, don’t have the time or the simply don’t feel like it, see the link at the end of the post to learn how to download a fully customizable Sight Word Card Generator in Excel ready to use.
How to make a Sight Word Card Generator in Excel
To make this you need Excel 2016 or above and basic Excel skills.
Step 1 – Create a card template
The first step in creating the sight words bingo generator is to create the layout of the card. In a blank Excel Sheet, increase the row and column sizes to create a grid like below. Make a 5×5 grid for the words and merge the first 5 cells to leave room for a title. Leave a blank row and column on top and on the left in order to see the card properly and create borders. Add borders to all the cells as per image below.
Step 2 – Create a list of words
On another sheet, create a list of words. In this example, I’ll use 180 words and I’ll place them in the column I with an index from 1 to 182 in column H.
The great part about this is that you can customize this with the words you want, with familiar words, names of kids in the class, names of streets in your town, names of teachers in the school, etc.
Step 3 – Create the Index
This is where the magic happens. Well, the first part of it at least.
In the next step, create an index of unique random numbers from 1 to 180. This is done with an array function.
First, in cell B1 put the number 180. This is the total number of words and will be used in the formula below.
In the cell B3, copy the following formula. Once copied, hold down CTRL+SHIFT and press ENTER. That is the way to enter an array formula.
The formula will look for all the existing values in the column B and generate an integer number random between 1 and 180 that is different from the numbers already generated.
Copy the formula down to cell B182 (first 2 cells are already use with the max number and a space left in B2 for clarity)
Step 4 – Copy the words in the Bingo Card
In this last step, in the first sheet containing the bingo card, use the following formula to copy the words. The formula will copy look at the first 15 cells and find 15 random numbers out of 180. It will then bring the words corresponding to those numbers from the words list.
In this example the word “jump” is delivered by the formula =INDEX(‘Formula Sheet’!$H$3:$I$181,’Formula Sheet’!$B10,2)
This formula looks into the second sheet for the number in B10 and finds the randomly generated number 2. In the next step, the word found in the 2nd position in the word list is retireved.
To fill up the Bingo card, use the formula above in each of the cells replacing the $B10 with values from $B3 to $B26. Use your favorite symbol in the middle of the card for a fun design.
This is how it looks when completed. You just have to press F9 and the formulas will generate you a new card that you can print.
Download the “ready to use” Bingo Card Generator
If you want to skip all the work and just download the file, it is available for sale on
Etsy or TeachersPayTeachers
The product you download from there has the formulas all hidden into a sheet and contains a teacher sheet where you can type all your words in.
You’ll also find other related products in our
Etsy Store or TpT Store.
Bingo Card Generator Excel Windows numbers from 1 to 75
Download the Generator
File name: 180505-BingoCardGenerator-1to75-Win-2016.xls
Versions: Microsoft Excel Windows 2016, 2010, 2007
Size: 925 KB
You can obtain Microsoft Office for Windows here: United States, Canada
If the Excel program doesn’t open, disable the option “Protective View”.
File > Options > Trust Center > Trust Center Settings > Protected View
This Microsoft Excel program generates random bingo cards containing numbers from 1 to 75 with a free center. Change the contents of the yellow boxes on the Master Card. The cards will automatically update depending on the content entered.
Select one of the sheet “Card” at the bottom of the program to select the card format you wish to print. Check that the information is properly displayed. To modify the font size and color of your cards, select the corresponding rows and make the changes. You can go back at anytime to the “Instructions” sheet if changes to the Master Card are needed. To mix the cards, make any changes to the program or copy / paste (cmd + c, cmd + v) on an empty square itself. When your done creating your cards, make sure that the Page Layout is set properly before printing. You can also create a PDf File of the bingo cards you just generated. Also print the “Call Sheet” to help you organize your bingo and mark down the numbers. Don’t forget to save your work before closing the program. Good bingo!
Microsoft Excel Games
Bingo Card Generator
That's right just input all your words or numbers into the cells and hit print. Then click the shuffle button and hit print again. Each time you hit the shuffle button MS Excel creates a two unique bingo cards that you can print out and use. Be sure to read the instructions. These improved bingo card generators have tabs for one card or two cards per page. Note: These games will only function correctly on Microsoft Excel Version 2003 or higher for Windows.
Download Bingo Card Generator 4x4
| Instructions | Office 2007 Instructions | Video Tutorial | Purchase More Now! |
Want more Bingo Card Generators Including ones for Pictures?
Now you can create picture bingo games with ease. That's right just input all your pictures into the cells and hit print. Then click the shuffle button and hit print again. Each time you hit the shuffle button excel creates a unique bingo board that you can print out and use. These and even more games are available on our Premium Web Site with eBook purchase. Learn More....
Self Checking Excel Spreadsheets
You can create self checking excel spreadsheets for any curriculum. In these spreadsheets you use the "If" function to check for right answers, then provide positive feedback to students. Provided below are examples and instructions on creating your own.
Download Instructions for Office 2007
| States | Addition | Pictures |
Want Even More Games and Game Templates?
Want more Excel Bingo Card Generators?
Learn how to purchase the Premium Game Templatesweb site and the eBook Everybody Wins: A teacher's guide to customizing games for any curriculum. For less than $20 dollars (US currency) you can have access to all these games and more right now.
Access Premium Web Site with eBook purchase. Learn More....
Sign Up for Our Email Alerts
Sign up for our email alerts and receive notification when new games and resources are added to this site. Your email will never be shared with any other party .
Sign up for our Email Alerts
It’s Friday, and things are slow at the office. To liven things up, you could create bingo cards in Excel, and organize a game during the lunch hour.
In this example, there are three cards, each with a set of random numbers. You’ll need one of those numbered ball popper machines though, or create a number selector in Excel.
Make Lists of Random Numbers
To generate the random numbers, there are three sets of lists on the Numbers sheet. In each set, there are typed numbers 1-75, with the formula =RAND() in the adjacent column.
When you press the F9 key, the sheet recalculates, and those random numbers change.
Add Random Numbers On Cards
On the three bingo cards, an INDEX/MATCH formula pulls the numbers from the random number tables.You can read more about the INDEX and MATCH functions on my website.
For example, this formula is used in cell E2:
The same number might appear on all three cards, but each card uses a separate lookup table of random numbers. With all that randomness (is that a word?), the 3 cards should never be exactly the same.
Print the Bingo Cards in Excel
The cards are formatted to print three per sheet, on letter sized paper.
After you print each set of three cards, press the F9 key to generate a new set of numbered cards.
Download the Sample File
- You can download the zipped Bingo Card Excel file, from my web site. Enjoy your lunch hour, and if you create a random number selector, let me know.
- There is a new Bingo Cards With Pictures sample file for you to download. Go to the Excel Sample files page on my website. On that page, go to the Functions section, and look for FN0045 – Excel Bingo Card With Pictures
- [Update] This is a new Bingo Card Creator file that uses numbers 1 to 100. Go to the Excel Sample files page on my website, and in the Functions section, look for FN0068 – Bingo Card 1 to 100
Excel bingo template
I owe a big ass to my father's genetics, and all I got from my mother was her tactility and sensuality, so I was blessed. With a very voluptuous body. But due to being overweight in my youth, I always wore baggy clothes, embarrassed about my body, and spent most of. My time reading books.Create Bingo card by Excel Formula No VBA
Most likely, she would even give instructions on how to achieve success on the love front. But he didn't need it, because Danya did not. Consider his passion a problem.
You will also like:
- Perc 5
- Gtav map
- Sikh pronounce
- Marlin github
- Community helpers paper bag puppets
- Baby terrier mix
- Boto3 s3
- Ap exhaust
- Topamax depression
- Retro rockers
- Lattepanda projects
Sure it would be difficult to notice me. Mom went to Magomed's site and knocked on the fence. She awkwardly shifted from foot to foot, held one hand against each other.