Carbon Sequestration in Campus Trees part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets Across the Curriculum module. Students use allometric relationships to calculate tree mass from trunk diameter in a stand of trees in the Pacific Northwest.
Quantitative Concepts: Measurement; Data presentation and analysis; Probability:Descriptive statistics; trend lines :Line- and curve-fitting, Measurement; Data presentation and analysis; Probability:Visual display of data :Logarithmic scale, Measurement; Data presentation and analysis; Probability:Statistical models; statistical inference; sampling, Algebra; Modeling; Functions:Nonlinear functions of a single variable:Power function, Algebra; Modeling; Functions:Straight lines and linear functions:Slope, intercept; linear trends, Algebra; Modeling; Functions:Manipulating equations, Basic arithmetic; Number sense:Logarithms; orders of magnitude; scientific notation, Measurement; Data presentation and analysis; Probability:Visual display of data :XY scatter plots, Basic arithmetic; Number sense:Significant figures, Creating and manipulating tabular data, Algebra; Modeling; Functions:Nonlinear functions of a single variable:Logarithmic function, Exponential function, Basic arithmetic; Number sense:Comparisons; percent difference, change, increase
Subject: Natural science:Earth science, Biology
Excel Skills: Basic Arithmetic:Nested Formulas, Other Elementary Math Functions:EXP, Graphs and Charts:Pie Chart, Other Elementary Math Functions:LN
Shaking Ground - Linking Earthquake Magnitude and Intensity part of Spreadsheets Across the Curriculum:General Collection:Examples
An in-class activity for connecting earthquake magnitude, shaking, and intensity.
Quantitative Concepts: Measurement; Data presentation and analysis; Probability:Visual display of data :Reading graphs, Logarithmic scale, Basic arithmetic; Number sense:Rates, Algebra; Modeling; Functions:Multivariable functions, Nonlinear functions of a single variable:Power function, Exponential function, Measurement; Data presentation and analysis; Probability:Visual display of data :XY scatter plots, Algebra; Modeling; Functions:Modeling:Forward modeling, Creating and manipulating tabular data, Geometry; Trigonometry :Circles (including radians and pi), Basic arithmetic; Number sense:Units and Dimensions:Unit Conversions
Subject: Natural science:Earth science
Excel Skills: Graphs and Charts:XY Scatterplot:Multiple Plots, Basic Arithmetic:Nested Formulas, Simple Formulas
From Isotopes to Temperature: Working With A Temperature Equation part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets Across the Curriculum module. Students build a spreadsheet to examine from a dataset the relation between oxygen isotopes in corals and the temperature of surrounding seawater.
Quantitative Concepts: Measurement; Data presentation and analysis; Probability:Descriptive statistics; trend lines :Goodness of fit (R2), Standard deviation; variance; range, Line- and curve-fitting, Basic arithmetic; Number sense:Average; weighted average, Algebra; Modeling; Functions:Straight lines and linear functions:Slope, intercept; linear trends, Algebra; Modeling; Functions:Manipulating equations, Measurement; Data presentation and analysis; Probability:Visual display of data :Line graphs, Basic arithmetic; Number sense:Ratio and proportion; percentage; interpolation, Measurement; Data presentation and analysis; Probability:Visual display of data :XY scatter plots, Bar graphs; column graphs; stacked bar graphs, Creating and manipulating tabular data, Basic arithmetic; Number sense:Comparisons; percent difference, change, increase
Subject: Natural science:Chemistry, Biology, Earth science
Excel Skills: Basic Arithmetic:Nested Formulas, Graphs and Charts:XY Scatterplot:Trendlines, Graphs and Charts:Bar Graph, Line Graph, Logic Functions:COUNTIF, Statistical Functions:One array:MAX, MIN, etc, Basic Arithmetic:Simple Formulas, Statistical Functions:One array:AVERAGE, STDEV, STDEVP, etc
Global Climate: Estimating How Much Sea Level Changes When Continental Ice Sheets Form part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets Across the Curriculum module. Students build spreadsheets to estimate how far sea level drops during a continental glaciation.
Quantitative Concepts: Algebra; Modeling; Functions:Manipulating equations, Basic arithmetic; Number sense:Estimation, Significant figures, Ratio and proportion; percentage; interpolation, Logarithms; orders of magnitude; scientific notation, Units and Dimensions:Unit Conversions, Geometry; Trigonometry :Spheres, Circles (including radians and pi)
Subject: Natural science:Earth science
Excel Skills: Basic Arithmetic:Simple Formulas, Nested Formulas, Angles and Trig Functions:PI
Bacteria in a Flask -- Spreadsheeting Population Density vs. Time part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets Across the Curriculum module. Students tabulate and graph data on bacteria density vs. time for a culture. Data start with innoculation and progress through the peak and decline.
Quantitative Concepts: Measurement; Data presentation and analysis; Probability:Descriptive statistics; trend lines :Line- and curve-fitting, Measurement; Data presentation and analysis; Probability:Visual display of data :Reading graphs, Creating and manipulating tabular data:Organizing and classifying data, Algebra; Modeling; Functions:Straight lines and linear functions:Slope, intercept; linear trends, Basic arithmetic; Number sense:Units and Dimensions:Unit Conversions, Basic arithmetic; Number sense:Logarithms; orders of magnitude; scientific notation, Measurement; Data presentation and analysis; Probability:Visual display of data :Logarithmic scale, Algebra; Modeling; Functions:Nonlinear functions of a single variable:Exponential (geometric) growth, Measurement; Data presentation and analysis; Probability:Visual display of data :XY scatter plots, Algebra; Modeling; Functions:Modeling:Finite differences, Basic arithmetic; Number sense:Rates:Rates of Change
Subject: Natural science:Biology
Excel Skills: Basic Arithmetic:Simple Formulas, Graphs and Charts:XY Scatterplot:Log Scale, One Plot, Other Elementary Math Functions:LOG, LOG10
Simple vs. Compound Interest -- Spreadsheeting the Difference part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets Across Curriculum module. Students build spreadsheets to tabulate, graph and compare the future value of investments with compound vs. simple interest. Spreadsheet level: beginner.
Quantitative Concepts: Measurement; Data presentation and analysis; Probability:Descriptive statistics; trend lines :Line- and curve-fitting, Algebra; Modeling; Functions:Modeling:Forward modeling, Algebra; Modeling; Functions:Nonlinear functions of a single variable:Exponential function, Algebra; Modeling; Functions:Straight lines and linear functions, Basic arithmetic; Number sense:Comparisons; percent difference, change, increase, Measurement; Data presentation and analysis; Probability:Visual display of data :XY scatter plots, Basic arithmetic; Number sense:Ratio and proportion; percentage; interpolation, Creating and manipulating tabular data, Algebra; Modeling; Functions:Nonlinear functions of a single variable:Exponential (geometric) growth, Basic arithmetic; Number sense:Rates:Rates of Change
Subject: Business, economics and finance :Finance, Mathematics, statistics and computers:Mathematics
Excel Skills: Basic Arithmetic:Nested Formulas, Simple Formulas, Graphs and Charts:XY Scatterplot:Multiple Plots, Trendlines
Predator-Prey Interactions -- Modeling the Number of Fishers and Porcupines in New Hampshire part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets Across the Curriculum activity/Introductory Ecology course. Students build and manipulate spreadsheets to model and graph populations using the Lotka-Volterra predator-prey equations.
Quantitative Concepts: Calculus; Numerical methods:Differential equations including difference equations, Basic arithmetic; Number sense:Rates:Rates of Change, Algebra; Modeling; Functions:Modeling:Forward modeling, Creating and manipulating tabular data, Measurement; Data presentation and analysis; Probability:Visual display of data :XY scatter plots
Subject: Natural science:Biology
Excel Skills: Graphs and Charts:XY Scatterplot:Multiple Plots, Basic Arithmetic:Simple Formulas, Nested Formulas, Graphs and Charts:XY Scatterplot:One Plot
Earthquake Magnitude: How Can We Compare the Sizes of Earthquakes? part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets Across the Curriculum module. Students build spreadsheets to tabulate and graph seismic wave amplitude and energy release to explore the logarithmic scale of earthquake magnitude.
Quantitative Concepts: Measurement; Data presentation and analysis; Probability:Descriptive statistics; trend lines :Line- and curve-fitting, Algebra; Modeling; Functions:Nonlinear functions of a single variable:Exponential function, Basic arithmetic; Number sense:Logarithms; orders of magnitude; scientific notation, Number operations:Number operations: addition, subtraction, multiplication, division, Algebra; Modeling; Functions:Manipulating equations, Measurement; Data presentation and analysis; Probability:Visual display of data :Logarithmic scale, XY scatter plots, Creating and manipulating tabular data, Basic arithmetic; Number sense:Ratio and proportion; percentage; interpolation
Subject: Natural science:Earth science
Excel Skills: Basic Arithmetic:Nested Formulas, Simple Formulas, Graphs and Charts:XY Scatterplot:Multiple Plots, One Plot, Log Scale
Powers of 2: Many Grains of Wheat part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets Across the Curriculum module. Students use a spreadsheet to connect powers of 2 to powers of 10 to help understand exponential growth.
Quantitative Concepts: Creating and manipulating tabular data, Measurement; Data presentation and analysis; Probability:Creating equations; text-to-math translation, Geometry; Trigonometry :Cubes and rectangular solids, Basic arithmetic; Number sense:Logarithms; orders of magnitude; scientific notation, Estimation, Comparisons; percent difference, change, increase, Algebra; Modeling; Functions:Modeling:Forward modeling, Basic arithmetic; Number sense:Units and Dimensions:Unit Conversions, Algebra; Modeling; Functions:Nonlinear functions of a single variable:Power function, Exponential (geometric) growth, Basic arithmetic; Number sense:Significant figures
Subject: Mathematics, statistics and computers:Mathematics
Excel Skills: Basic Arithmetic
Maximize the Volume of a Box: Exploring Polynomial Functions part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets Across the Curriculum module. Students build spreadsheets to find the maximum volume of an open-top box by cut-and-folding a sheet of cardboard.
Quantitative Concepts: Calculus; Numerical methods:Finding maximum/minimum, Creating and manipulating tabular data, Measurement; Data presentation and analysis; Probability:Visual display of data :XY scatter plots, Calculus; Numerical methods:Derivatives and integrals (analytical), Algebra; Modeling; Functions:Modeling:Forward modeling, Algebra; Modeling; Functions:Functions: general:Zeroes of function, Algebra; Modeling; Functions:Manipulating equations, Basic arithmetic; Number sense:Units and Dimensions:Dimensions, Geometry; Trigonometry :Cubes and rectangular solids, Algebra; Modeling; Functions:Nonlinear functions of a single variable:Quadratic function, Geometry; Trigonometry :Squares and rectangles, Algebra; Modeling; Functions:Modeling:Inverse problem, Algebra; Modeling; Functions:Nonlinear functions of a single variable:Polynomial function
Subject: Mathematics, statistics and computers:Mathematics
Excel Skills: Basic Arithmetic:Simple Formulas, Basic Arithmetic, Graphs and Charts:XY Scatterplot, Graphs and Charts
Quantitative Concepts