Kick off the new school year with lessons from our Back to School 2022 collection to help students express themselves, build relationships, and stay organized.

1. Create a Guide to an Area Wrap-Up

Playback Speed:

In this unit, you organized data about an area in Google Sheets.

Then, you used that data in different ways to make your area guide unique, interesting, and useful.

You sorted and filtered the data, so people can see what interests them at a glance.

You used data validation to make a rating scale.

You wrote a program in Apps Script, that added fun features to your area guide, like a sidebar, a custom menu, and embedded images.

Finally, you reused the data to create something entirely new when you made a customized, interactive map.

Now that you know how to import, organize, and reuse data, and have some basic coding skills, you can create unique, interesting, and useful spreadsheets for all kinds of projects!

Certificate of Completion

certificate thumbnail

Certificate of Completion

certificate thumbnail
  • "DeepBeat Homepage" by DeepBeat (
  • "Automated Insights Homepage" by Automated Insights (
  • "Automated Insights Use Cases Page" by Automated Insights (