The Manning Equation part of Spreadsheets Across the Curriculum:General Collection:Examples
In this Spreadsheets across the Curriculum activity, students investigate the relationship between discharge and culvert diameter, given various culvert materials and slope angles. To begin, students are given the culvert diameter, material and gradient, and use the Manning equation to determine velocity and then discharge. Next, students determine culvert size to convey a specified discharge. These activities allow students to graph the relationship between culvert diameter and discharge.
Global Climate: Estimating How Much Sea Level Changes When Continental Ice Sheets Form part of Spreadsheets Across the Curriculum:General Collection:Examples
In this Spreadsheets across the Curriculum activity, students estimate the drop in sea-level during glacial maxima. They begin by estimating the surface area of the world's oceans, and then use ice volume data to approximate how much sea-level dropped. Students then see how to address one of the key assumptions of the model (area of continental shelf). With this backround, students re-evaluate the key assumption and determine the sea-level rise that would occur if the remaining ice melted.