Organizing Data to Explore It
An important component of working with data is determining how to organize it in ways that can help us explore it and create data visualizations from the data.
ORGANIZING DATA RESOURCES
- Terms for organized data: Data Table, Dashboard, Dataframe / Database, vs. Spreadsheet
- Ways to organize data: Wide vs Long/Tidy Organization
- Cheat Sheet: Organizing Data in Google Sheets: Cleaning & trimming data, Creating cross references, Filtering, Sorting, Splitting data, Using equations
- Data files to play with: nst-est2018-alldata.csv OR Adelie Penguin Census.csv
- Online data portals to explore with: County Population by Characteristics: 2010-2018 OR Adelie Census
GOOGLE SHEETS RESOURCES TO EXPLORE
Introductory Google Sheets
- Google Sheets 101: The Beginner's Guide to Online Spreadsheets
- The Essential Google Spreadsheet Tutorial
- 8 Basic Google Sheets Tips Every Teacher Should Know About
Advanced Google Sheets
- 21 Awesome things Google Sheets can do - tips & tricks
- 27 incredibly useful things you didn’t know Google Sheets could do
- Where to Find Google Sheets Activities for Middle School
- 8 Important Google Sheets Add-ons for Teachers and Educators
Often the best thing to do is Google your question of how to do things in Google Sheets, but here are some resources on specific topics to give you a starting point.
- Calculating summary statistics: Google Sheets - Basic Descriptive Statistics (Mean, Variance, Standard Deviation, etc.) (*Note, his screen is set up as a spreadsheet and a dashboard within one worksheet)
- Conditional formatting: Google Sheets - Conditional Formatting
- Copying cell value to others, drag/double click corner: How to autofill in Google sheets | How to drag formula in Google sheets | How to fill down series
- Leveraging Google Forms integration: Google Forms-Sheets Integration
- Protecting/locking cells so they cannot be changed: How to Protect a Cell Range in Google Sheets
- Creating quick look visualizations: Creating Charts in Google Sheets
