Applied Digital Skills lessons have moved to a new platform! This site will no longer be available after 30 June 2025 and all accounts and data will be deleted. Learn more

This lesson will no longer be available after 30 Jun 2025.

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