Create a Guide to an Area

Create an interactive guide to an area using Google Sheets, Google Maps, and Apps Script.

Example outcome

Lesson details

Learning objectives

By the end of this lesson, students should be able to:
  • Identify and explain common terms and concepts related to spreadsheets
  • Organize and manipulate data in a spreadsheet
  • Break down data, processes, or problems into smaller, manageable parts
  • Write a program to automate a task

Time to complete

4—6 hours

Audience

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

Digital tools

  • Icon representing the Apps Script toolApps Script
  • Icon representing the Maps toolMaps
  • Icon representing the Sheets toolSheets

Skills

  • Coding
  • Organising data
  • Sorting and filtering
  • Spreadsheet design
  • Spreadsheet organisation

Teaching materials

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