Cool Stuff from OETC
Color By Numbers Sheets Activity
Created by Scott Aten, February 21, 2019
Google Sheets is always the app that students (and really teachers too) have the least amount of
experience using.This activity can be used in one of two ways:
1) Teacher creates the activity for students to do as a review of material
2) Students create the activity for their classmates to do as a way to review material.
This Google Sheets activity uses the "Conditional Formatting" feature of Google Sheets to build a pixel image within the Google Sheet. Once you have the general idea of how to make a basic formula in Sheets the activity comes together fairly quickly.
[Try my demo] - when prompted "make a copy" Answers: 5 - amount - carnivore - 13 - nitrogen - 3 (I tried to demo questions in many content areas)
What your students will learn if they make their own?
If you would like to schedule a time for me to come and help you setup one of these or assist your class in making one as a review for a unit, please use my scheduler to pick a time.
[Schedule me to come and help]
1) Teacher creates the activity for students to do as a review of material
2) Students create the activity for their classmates to do as a way to review material.
This Google Sheets activity uses the "Conditional Formatting" feature of Google Sheets to build a pixel image within the Google Sheet. Once you have the general idea of how to make a basic formula in Sheets the activity comes together fairly quickly.
[Try my demo] - when prompted "make a copy" Answers: 5 - amount - carnivore - 13 - nitrogen - 3 (I tried to demo questions in many content areas)
What your students will learn if they make their own?
- Your content - simple review questions of your unit of study
- How conditional formatting works in Google Sheets
- How to setup a formula in Google Sheets
- Creative thinking in designing a pixel image
- Not to be afraid of Google Sheets
If you would like to schedule a time for me to come and help you setup one of these or assist your class in making one as a review for a unit, please use my scheduler to pick a time.
[Schedule me to come and help]
For more helpful information and the archive of previous posts, look for items in the menu to the left.
Green Local Schools
Tech Integration Team
