Schedule > Hand-Drawn Charts
Open this coffee data spreadsheet in Google sheets. Then make a copy of it (so you can edit it). Pretend this spreadsheet represents all coffee sales for Texas, California, and Florida in 2024.
Spreadsheet Basics
- Sorting
- Filtering
- Aggregating (pivot tables)
Pivot Table Tips
To make a pivot table, Insert > Pivot Table (select "New Sheet") Three different options: values, rows, and columns:
- Values: What you want to measure or add up (e.g., Total Cups Sold, Average Sales)
- Rows: What you want to list or group by (e.g., States, Months, Coffee Types)
- Columns: How you want to break those groups apart (e.g., Months across the top, Coffee Types across the top)
Sarah will do a short demo
Data Questions
As a group, try to answer the following questions using your spreadsheet:
- How many cups of Espresso were sold in California in January?
- Which state sold the most lattes in January?
- What is the total number of cups sold in Florida in January?
- Compare total coffee sales across the three states for the entire year. Which state sold the most coffee overall?
- Compare Espresso vs Latte vs Drip sales in Texas in January. Which was the most popular?
Pick ONE of the following charts and draw it
- Make a chart that shows Espresso, Latte, and Drip sales in Texas in January side by side.
- Make a chart that shows how total coffee sales in California changed from January to December.
- Make a chart that shows sales of Espresso, Latte, and Drip in Texas from January to March.
- Make a chart that compares annual coffee sales for each state.
- Make a chart that shows how coffee consumption varies across the 3 states throughout the year (intentionally vague...open to interpretation).