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

  • High School
  • Middle School

Digital tools

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

Skills

  • Coding
  • Organizing data
  • Sorting and filtering
  • Spreadsheet design
  • Spreadsheet organization

Teaching materials

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