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!
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.
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.
