Michael McConnell

This activity guides students to construct a spreadsheet from a blank Excel workbook that will simulate titration of acids or bases. *Teacher background on Excel is not required* After constructing the spreadsheet and graphs the students will experiment with the spreadsheet to answer analysis questions that will help students learn the mathematical nature of titration (solutions are provided including descriptions of all spreadsheet manipulations necessary to solve each problem). The va

This math activity allows students to investigate the behavior of functions (Quadratic, Cubic, Hyperbolic and Exponential) by adjusting the domain over which the functions are viewed. Students are guided with step by step instructions on how to program a blank spreadsheet to graph functions of their choosing over intervals that they specify. Graphs are manipulated and students are guided to look at growth rates of functions and how they behave as they approach larger and smaller values. Real

Students will be guided to produce a spreadsheet from a blank Excel workbook that uses the quadratic formula to find the roots of a quadratic equation. They will then be guided to graph the functions and see the intersection points of the graph with the X axis. Then other nonlinear functions will be solved using Goal Seek. Goal Seek is a trial and error that allows students to solve equations that cannot be solved algebraically. Students will bring all terms of the equation to one side and

EXPAND THE USE OF SPREADSHEETS IN YOUR PHYSICS CURRICULUM... This Physics activity good for all levels of Physics is a free preview of "The Spreadsheet Lab Manual." It guides students to construct a mathematical simulation starting from a blank spreadsheet that quantitatively models freefall with air resistance as an object reaches terminal velocity. Students will be guided through an inquiry based simulation as they answer assessment questions and gain skills on spreadsheets while manipulati