1 of 19

Mary Howard

Sixth Grade Teacher

Grand Island Central Schools

National Board Certified

2018/2020 Teacher of the Year Finalist

2018 ISTE Virtual Pioneer of the Year

New York State Master Teacher

Google Sheet

Secrets and Surprises

Twitter: @mrshoward118

Instagram: @Using_Your_Smarticles

Blog: http://www.yoursmarticles.com

TPT https://www.teacherspayteachers.com/Store/Using-Your-Smarticles

EMail: yoursmarticles@gmail.com

Youtube: https://www.youtube.com/channel/UC6W33lH6gBPfTyCc7-4ALUg

TikTok: Maryhoward118

Find me:

bit.ly/3OiP7qX

2 of 19

Presentation Goals

Section #1: Say What?

Section #2: Gotta get that!!

Section #3: Wait what, they’re editable?

Section #4: Oh you did NOT…make your own!!

bit.ly/3OiP7qX

3 of 19

Pixelation should be YOUR New year’s resolution

bit.ly/3OiP7qX

4 of 19

Say What?

What exactly IS Pixel Art Reveal???

bit.ly/3OiP7qX

5 of 19

Example

A spreadsheet with embedded conditional formatting that ‘listens’ for a particular answer. When the correct answer is typed, it reveals a portion of a secret pixelated image. After ALL answers are entered, an ENTIRE pixelated image will be revealed.

WHAT IS IT?

bit.ly/3OiP7qX

6 of 19

2. Gotta Get That

Get (and find) your own!!

bit.ly/3OiP7qX

7 of 19

Here are some examples!

I NEED THAT!

Elements (Among Us)

Mean (I am Groot)

Conservation of Matter (Grogu)

Marvel Characters

Newton’s Laws (Starry Night)

BB8 Electric Circuits

8 of 19

Here’s where you can find more!

WHERE TO FIND MORE!

Facebook Group

Blog

9 of 19

3. Wait…..What?

You can customize them?

bit.ly/3OiP7qX

10 of 19

HOW TO EDIT PIXEL REVEAL

Find step-by-step directions here:

https://youtu.be/FqULbJWSwZA

Step #1: Locate the area that has the Conditional Formatting (it’s

usually the answer cell).

Step #2: Edit the ‘answer’ inside the quotation marks in the Format

Rules section.

Step #3: Change the questions by editing the cell with the question..

Let’s GO Buffalo!!!

11 of 19

4. Oh you did NOT!

Oh yes, I did…here’s how YOU can make them!!

bit.ly/3OiP7qX

12 of 19

Want big impact?

Use big image.

13 of 19

LET’S MAKE OUR OWN!!

Step #1: Find an image, add to the center of a slide (rather small) and save as an image (File, Download, .jpg)

Step #2: Open new Google Sheet. Use Pixel Art Extension to Generate pixelated Image.

Step #3: Delete extra rows and columns. Widen the first 2 columns for questions and answers.

Option #1: Draw your own Pixel Image and Format

Step #1: Open a new Google Sheet

Step #2: Alter ENTIRE sheet so that cells are square (Except the first 2 columns).

Step #3: Use the BUCKET tool to start drawing your pixel art.

Option #2: Convert an image to Pixels and Format (fancier BUT more difficult)

PART A: THE ART PART

Eric Curts Pixel Art Drawing Spreadsheet

Pattern Ideas: https://kandipatterns.com/

14 of 19

LET’S MAKE OUR OWN!!

PART B: THE FORMATTING PART

Step #1: Click IN the answer cell. Select Conditional Formatting.

Step #2: In the Conditional Formatting Rules:

Step #2: Add Questions/Modify Answers

Select Custom formula
Enter a formula like this where b is your column and 2 is the row you’re formatting and “nyscate” is the answer you are listening for.
Click the bucket tool and select the color you’re working with

15 of 19

LET’S MAKE OUR OWN!!

STEP #2: THE FORMATTING PART

Step #3: Select Apply to range

Step #4: Hold command (Mac) or Ctrl (Windows) and start clicking all the cells that are red in your image. When finished, click Done

Step #5: When finished, select your bucket tool from the top toolbar and click reset.

Step #6: Move to the NEXT answer cell (B3) and repeat the steps.

Step #7: Customize column A with your questions and replace the word “NYSCATE” in the Conditional format rules with appropriate answer that you’re looking for.

Find step-by-step directions here:

https://youtu.be/vjcaNAbhUb0