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.

Google Workspace: Sheets - Part 2

Evaluate and interpret data with different spreadsheet functions, filters, and charts using Google Sheets.

Example outcome

Lesson details

Learning objectives

By the end of this lesson, students should be able to:
  • Use filters, functions, and charts in a spreadsheet to analyze data for a community fundraiser

Time to complete

45—90 minutes

Audience

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

Digital tools

  • Icon representing the Sheets toolSheets

Skills

  • Conditional formulas
  • Data analysis
  • Data representation
  • Data visualisation
  • Organising data
  • Sorting and filtering
  • Spreadsheet design
  • Spreadsheet organisation

Teaching materials

namespaces/google.engedu.apski/contents/Unit-231871540619884446755195926108737564153en-uk