Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Using Pixel Art with TemplateTab

Looking for a fun activity to do with your students? Look no further than Pixel Art! Harness the power of TemplateTab by Alice Keeler to
how to using pixel art with templatetab

Using Pixel Art with TemplateTab

One of my most popular activities is Pixel Art. This allows students to essentially paint by number in a spreadsheet. Typing numbers into the spreadsheet. I love to have all students working together in the same Google Sheets spreadsheet. TemplateTab allows you to duplicate a graphic organizer within the same spreadsheet. Creating graphic organizers with Pixel Art is fun! Here is how to use Pixel Art with TemplateTab

Adding Single Digit Numbers

When using pixel art with TemplateTab the students will type the digits 1 to 9. This allows them to be creative to start with a picture for the lesson activity. There are so many uses!

screenshot gif of a google sheets spreadsheet with single digit numbers being entered. When 1 is entered the cell turns red. 2, the cell turns orange. Etc..

Pixel Art with TemplateTab

Install TemplateTab

TemplateTab allows you to have all students in the same Google Sheets spreadsheet. Using pixel art with TemplateTab will give each student the pixel art template on an individual tab within the same spreadsheet.

TemplateTab collects NO user data. No PII. 

Start with Pixel Art Template

Make a copy of the pixel art template at alicekeeler.com/pixelart. This will prompt you to make a copy. Rename the spreadsheet to match your activity.

Customize the Template

The pixel art template is simply a grid that has conditional formatting applied. To design a learning activity you may want to merge some cells and add lesson elements. 

From the book “50 Ways to Engage Students with Google Apps” try this pixel art sample where the pixel art template was modified for the activity. 

TemplateTab Add-on

After making a copy of the pixel art template, use the Extensions menu to select TemplateTab. “Setup Sheet” will add a sheet to the front of the spreadsheet. Paste your class list, roster, into column A. 

Pixel Art with TemplateTab is facilitated by using Extensions menu and selecting TemplateTab by Alice Keeler and selecting Setup Sheet.

Run TemplateTab

What is important is that the first sheet in your spreadsheet is a list of your student names and that the second sheet is the pixel art template. 

After you have pasted your class list, go back to the Extensions menu and “Run TemplateTab.” This will duplicate the Pixel Art template for each student on the list. A tab will be created with their name.

A Tab Per Student

After running TemplateTab each student will have a tab with their name on it. The tab will be a copy of the pixel art template. 

Share the Spreadsheet

TemplateTab is intended to create a collaborative experience. Share the one spreadsheet with students, giving them edit access. 

Students locate the tab with their name on it to complete the activity. 

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 »

Leave a Reply

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