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
