Data Science: Visualizing and Analyzing Data from a Spreadsheet
Difficulty: intermediate Lesson Type: curriculum unit Subject: computer science |
Grade Level: |
|

- Comfort navigating App Inventor Designer and Blocks screens.
- Up-to-Date App Inventor Companion (version 2.65 or higher) for Android devices (iOS Spreadsheet capability currently in development)
- Only Part 4: Some prior knowledge of statistical terms
This lesson can serve as a resource in a unit on climate change and align with NGSS, LS2.C: Ecosystem Dynamics, Functioning, and Resilience or Practice 2e: "Develop and/or use a model (including mathematical and computational) to generate data to support explanations, predict phenomena, analyze systems, and/or solve problems." Resources on Google Drive
Data in Action: Using Spreadsheets and Charts in MIT App Inventor
- PART 1: Make Sense of Data with Charts
- PART 2: Deepen Your Understanding by Comparing Datasets
- PART 3: Gather Evidence by Comparing Multiple Examples
- PART 4: Add a Mathematical Model to the App
Appendix:
- Link your app to your own spreadsheet (in development)
- Create a Google Sheets credential for free to read and write to private spreadsheets (in development)
Duration
2 x 50-minute lesson
Target Grades
High School | Grades 9-12