# List of Chapter Activities - Spreadsheets - see book for activities

## 20.1 Calculations and Computer Modeling

• Activity 20.1.1 – Using formulas
• Activity 20.1.2 – Performing calculations
• Activity 20.1.3 – Making a conversion tool
• Activity 20.1.4 – Computer modeling of greenhouse gas emissions

## 20.2 Relating Graphs to Real-World Experiences

• Activity 20.2.1 – Walking through motion graphs

## 20.3 Graphing Stories

• Activity 20.3.1 – Matching stories with graphs
• Activity 20.3.2 – Creating stories from graphs
• Activity 20.3.3 – Creating graphs from stories

## 20.4 Scatter and Line Graphs

• Activity 20.4.1 – Displaying data as a scatter (x-y) plot
• Activity 20.4.2 Displaying Data with Line Graphs

## 20.5 Column and Bar Graphs

• Activity 20.5.1 – Column chart: Comparing between different items
• Activity 20.5.2 – Stacked column charts: Comparing within and between groups
• Activity 20.5.3 – Pareto charts: Ranking data graphically
• Activity 20.5.4 – Bar charts: Graphing qualitative independent variables
• Activity 20.5.5 – Clustered bar charts: comparing composition of various items

## 20.6 Pie and Area Graphs

• Activity 20.6.1 Pie Charts: Comparing relative magnitude within a data series
• Activity 20.6.2 Area graphs: Illustrating the magnitude of change over time

## 20.7 High-Low, Combination, and Log Plots

• Activity 20.7.1 – High-Low graphs (Stock): Plotting means and ranges of data
• Activity 20.7.2 – Combination graphs: Graphing two types of data on one chart
• Activity 20.7.3 – Semi-logarithmic plots: Plotting wide range data

## 20.8 Statistics

• Activity 20.8.1 – Descriptive statistics: Making sense of the data
• Activity 20.8.2 – Trendlines: Discovering relationships in the data