Electrical Analysis of Wind Power part of Teaching Methods:Teaching with Data:Examples
For this experiment, students use a DC motor as a generator and various shaped turbine designs to test which design produces the most electrical power. Using a fan to generate the "wind", students attach ...

World Population Activity I: Excel part of Teaching Methods:Mathematical and Statistical Models:Examples
(Activity 1 of 2) This activity is primarily intended as an introductory tutorial on using Excel. Students use Excel to explore population dynamics using the Logistic equation for (S-shaped) population growth.

Sea Floor Spreading I part of Teaching Methods:Mathematical and Statistical Models:Examples
In this introductory Excel tutorial (Activity I) students use Excel to explore the geodynamics model equation for ocean depth around a sea-floor spreading center. For students with no prior Excel experience.

Planck Radiation Laws: Excel; Mac or PC part of Teaching Methods:Mathematical and Statistical Models:Examples
Students use an existing Excel workbook to investigate how spectral irradiance from a blackbody radiator depends on temperature, Excel Mac or PC

Global Phosphorus Cycle part of Activity Collection
Students create and modify a STELLA model of the global phosphorus cycle to test a number of scenarios.

Lithospheric Density part of Teaching Methods:Teaching with SSAC:Examples
Students learn about the weighted mean by building spreadsheets that apply this concept to the average density of the oceanic lithosphere.

Race, Gender, and Intersectionality at Work: An Exploration of Your Future Occupation part of Teaching Methods:Teaching with Data:Examples
In this assignment students examine data from the 2014 American Community Survey and learn more about an occupation of personal interest. In doing so, they gain insight into how social characteristics like race and gender shape the wages paid to people with their chosen occupation.

Back-of-the-Envelope Calculations: Percentage of Copper in Ore part of Activity Collection
Question Suppose that you are building a new house. It will take about 90 kg (198 pounds) of copper to do the electrical wiring. In order to get the copper in the first place, someone needs to mine solid rock that ...

Back-of-the-Envelope Calculations: Weight of Gold part of Activity Collection
Question Let's suppose that you have a shoe box full of water (the box is waterproof, of course). The shoe box weighs about 9 kg (19.8 pounds). Suppose you emptied the box and filled it completely with rock ...

Sun Spot Analysis part of Teaching Methods:Teaching with Data:Examples
Introductory students use Excel to graph monthly mean Greenwich sunspot numbers from 1749 to 2004 and perform a spectral analysis of the data using the free software program "Spectra".