keyboard_arrow_left
See all units
Guide to an Area
Use structured data to create an interactive guide to an area in a spreadsheet.
Start
Time to complete
timer 4 - 6 hours
Suitable for
Middle and High School
Skills covered
- Data representation
- Sorting and filtering
- Spreadsheet organization
Rubric keyboard_arrow_right
Activities
Activity 1: Create an Area Guide
- assessment Organize Data to Create an Area Guide
- play_circle_filled Why Structured Data?
- play_circle_filled Choose an Area
- play_circle_filled Add Column Headings
- play_circle_filled Add One Place to Visit
- play_circle_filled Include More Places to Explore
- play_circle_filled Reusing Data in Multiple Ways
- assessment Activity Reflection for Why Structured Data
Activity 2: Add Filters and Custom Rating Scales
- play_circle_filled Introduction to Sortable Data
- play_circle_filled Make a Rating Scale
- play_circle_filled Rate Locations with Data Validation
- play_circle_filled Sort and Filter Your Data
- play_circle_filled The Power of Sortable Data
- assessment Activity Reflection for Sortable Data
Activity 3: Add Interactive Images
- play_circle_filled Add Interactive Images
- play_circle_filled Start Coding an Interactive Sidebar
- play_circle_filled Add an Image to Your Area Guide
- play_circle_filled Embed an Image Link in a Spreadsheet Cell
- play_circle_filled Customize Titles and Instructions
- play_circle_filled Add More Embedded Media
- play_circle_filled Sidebar Wrap Up
- assessment Activity Reflection for Add Interactive Images
Activity 4: Make a Custom Map
- play_circle_filled Reuse Your Spreadsheet to Make a Map
- play_circle_filled Create Your Map
- play_circle_filled Customization Options in My Maps
- play_circle_filled Link Your Custom Map
- assessment Activity Reflection on Reuse Your Work
Activity 5: Unit Wrap Up
- play_circle_filled Area Guide Wrap Up
- assessment Guide to an Area Reflection
- extension Guide to an Area Extensions