Skip to content
keyboard_arrow_left See all units

Guide to an Area

Use structured data to create an interactive guide to an area in a spreadsheet.
Time to complete

timer 4 - 6 hours

Suitable for

Middle and High School

Skills covered
  • Data representation
  • Sorting and filtering
  • Spreadsheet organization
Lesson plans keyboard_arrow_right
Rubric keyboard_arrow_right
Activity 1: Create an Area Guide
  1. assessment Organize Data to Create an Area Guide
  2. play_circle_filled Why Structured Data?
  3. play_circle_filled Choose an Area
  4. play_circle_filled Add Column Headings
  5. play_circle_filled Add One Place to Visit
  6. play_circle_filled Include More Places to Explore
  7. play_circle_filled Reusing Data in Multiple Ways
  8. assessment Activity Reflection for Why Structured Data
Activity 2: Add Filters and Custom Rating Scales
  1. play_circle_filled Introduction to Sortable Data
  2. play_circle_filled Make a Rating Scale
  3. play_circle_filled Rate Locations with Data Validation
  4. play_circle_filled Sort and Filter Your Data
  5. play_circle_filled The Power of Sortable Data
  6. assessment Activity Reflection for Sortable Data
Activity 4: Make a Custom Map
  1. play_circle_filled Reuse Your Spreadsheet to Make a Map
  2. play_circle_filled Create Your Map
  3. play_circle_filled Customization Options in My Maps
  4. play_circle_filled Link Your Custom Map
  5. assessment Activity Reflection on Reuse Your Work
Activity 5: Unit Wrap Up
  1. play_circle_filled Area Guide Wrap Up
  2. assessment Guide to an Area Reflection
  3. extension Guide to an Area Extensions