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

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
namespaces/google.engedu.apski/contents/Unit-9072930106312363110067416977986064439en