Any time you can make learning and reviewing vocabulary fun, do it! Magic Picture Reveal worksheets are a great way to engage students and reward them for learning their vocabulary. And now that we’re all on some rollercoaster of face-to-face, hybrid, and remote learning, any time you can make it digital, do it! Here’s a breakdown of how to create your own magic picture reveal worksheets digitally.
Using conditional formatting, I created vocab worksheets on Google Sheets. As students correctly answer each question, a few pixels of a magic picture is revealed. Get all the answers correct and the whole picture is revealed. Get some answers wrong and miss out on the the picture. It’s easy for students to self-check their work and they’re engaged while doing so.
To create your own magic picture puzzle, follow these steps:
- Write 10-20 questions in a column in Google Sheets. Leave a space for the answers. If the answers are words or terms, include a word box to eliminate spelling or case mistakes. [Let’s make a small magic picture together. Write 4 questions on a Google Sheet.]
2. On a separate Google Sheet, draw a pixelated image. Try the school logo, holiday related, or curricular like a picture of a heart for your unit on the cardiovascular system. A 15×15 grid is a good place to start, but you can make your image as big or small as you want.
3 Create a grid the same size as the pixelated image on your worksheet. I outlined it in black.
4. Control/Click on a few random pixels of the same color. Then, select Format > Conditional Formatting.
5. In the popup window, select “custom formula is” in the “Format cells if” box.
6. Locate the cell that contains the answer you want to link to those pixels. In the custom formula window, type =$E$16=”petunia” but exchange the E and 16 for the column and row of the answer and exchange the actual correct answer for petunia. In other words, if the correct answer you want linked to the pixels you selected is in cell D18 and the correct answer is orange, you would type =$D$18=”orange”. One exception – if the correct answer is a number, eliminate the quotation marks around the answer.
7. Under Formatting style, select the fill color you want those pixels to be filled in with.
8. Repeat until all of your pixels are filled with the correct color.
9. When you share the magic picture worksheet with someone, you must use a forced copy to share the URL so that each person will make their own copy of the worksheet rather than writing on yours. To do that, look at the URL. At the end, there is a / followed by the word ‘edit’ and possibly some other code. eliminate everything after that / and replace it all with the word ‘copy.’
Here’s another magic picture reveal worksheet I created for Punnett Squares.
And here’s a magic picture reveal worksheet for weather vocabulary:
Preview the Simple Machines Digital Reveal Worksheet here.