Make Art with Google Sheets

Create a pixel art project using conditional formatting in a spreadsheet.

Example outcome

Lesson details

Learning objectives

By the end of this lesson, students should be able to:
  • Create a spreadsheet pixel art project that uses conditional formatting rules to assign cell and text colors to specific values
  • Explain how to set conditional formatting rules to call attention to specific information in a spreadsheet
  • Understand there are different ways to organize, display, and analyze data with formatting
  • Recognize conditional formatting as a tool for visually organizing spreadsheet data for easier reference and improved usability
  • Complete creative projects as a fun, effective way to learn advanced app features and digital skills

Time to complete

45—90 minutes

Audience

  • Key Stage 3
  • Key Stage 4
  • Post-16

Digital tools

  • Icon representing the Sheets toolSheets

Skills

  • Advanced formulas
  • Conditional formulas
  • Data visualisation
namespaces/google.engedu.apski/contents/Unit-309729917916065811457410922813111666722en-uk