Embedded Files
#FormulateFun with Color by Number GSheets
#FormulateFun with Color by Number GSheets
If you're looking for a content rich, engaging activity that also provides immediate feedback for your students, look no further!
If you're looking for a content rich, engaging activity that also provides immediate feedback for your students, look no further!
K-12 students all over Chesterfield County already know, and now yours can too! Learn how to create your own Color by Number activity that gives your students immediate feedback for every question they answer or problem they solve. With a little conditional formatting and simple formula magic, your students will be engaged from beginning to end and will be motivated to complete this fun assignment.
Follow us on Twitter: @altheadespina & @kavester
Continue the conversation on Twitter with the following hashtags:
#ccpsdld #EdTechCCPS #FormulateFun #oneCCPS
Color by Number with GSheets- December.mp4What is conditional formatting?
What is conditional formatting?
Conditional formatting is a spreadsheet tool that allows you to format a cell or range of cells. Formatting changes will depend upon the value of the cell (what is in the cell) or the value of a formula (the answer to the formula inside the cell).
How does conditional formatting work?
How does conditional formatting work?
Conditional formatting is simply applying a rule to a cell or range of cells that changes the cell background and text colors based on the value of the cell or the value of the formula in that cell.
Why is conditional formatting important to teachers?
Why is conditional formatting important to teachers?
Teachers can see at a glance who is understanding the concepts being reviewed and who is not. Because conditional formatting colors in cells based on student responses, teachers are able to analyze data within seconds of looking at it. Imagine how much time you can save and how much data will be at your fingertips with this simple GSheets trick!
Image Source: All images on this site are registered as Public Domain.
Report abuse