Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Coding with Conditional Formatting by @bmossholder

Conditional Formatting and coding

Coding with Conditional Formatting by @bmossholder

Conditional Formatting and coding

Code Conditional Formatting

Guest blog post by Beth Mossholder

A few years ago I was looking for ideas to create some new lessons on spreadsheet, and where do you go to find spreadsheet ideas? Duh. AliceKeeler.com  I ran across this post about creating pixel art and spreadsheets. There was an ah-ha moment when I realized two things: 1. Yet again, the answer is a spreadsheet 2. Conditional formatting is coding!

Conditional formatting uses If/then statements to code the spreadsheet.  To introduce If/Then statements, have students try paint by numbers.

I created this inspired by Alice’s post.

conditional formatting

If/Then Statements

Here’s the If/then statement:

IF any cell in this sheet has a value of 9 THEN turn the cell black.

Tip:  “Add another rule”  reduces steps

Usually, once students understand the concept they get pretty creative.  This is a great jumping off point to create other sheets, and have deeper conversations with learners about coding concepts and their application in the real world.  I started this with 2nd graders and use the concept for teaching students of all ages (including adults) about coding and spreadsheets.


If you would like use this example its linked here.



[author] [author_image timthumb=’on’]https://sites.google.com/a/c2e.org/c2e-tech-1/home/mossholder%20headshot.jpg?attredirects=0[/author_image] [author_info]Beth Mossholder is a geek who loves digital badges. She became a Google Certified Innovator (Teacher) in Sydney, Australia in 2011, a Google for Education Certified Trainer in 2015, and a Raspberry Pi Certified Educator in Manchester, UK in 2016. Beth loves her tiny human Presley, Googly things, Geeky Things, and connecting with other educators over their shared love of technology and teaching. She loves presenting at local, state, and international conferences sharing creative ways to utilize Google tools, tablets, Chromebooks, and other technologies such as 3d printers and Raspberry Pi. She has been working in education for nearly 2 decades and feels passionate about speaking from experience and with a sense of humor. Her goal is to connect with others to collaborate on making the world a better place through the continued improvement of educational experiences for children and adults.[/author_info] [/author]

5 Easy Steps for Teaching with Digital Tools

Introducing digital tools into your teaching can seem challenging at first. There are many tools out there, and it might feel like there’s a lot to learn. But with easy steps for teaching with digital tools, you can start simply and gradually. There’s no need to dive in all at once – just take it one step at a time. Taking easy steps for teaching with digital tools starts with trying something!

Read More »
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.