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
