home

=Interactive Excel for Developing Math Connections= Penn State University One-to-One Conference April 19-21, 2010

//“My favorite subject is math, because I get to play with numbers.”// Quote from a 6-year old

//I am using Box.net to store the excel files that I am using in this presentation. By clicking on an icon below, you can preview the sheet and download them. A separate page (see left menu) has been created for each spreadsheet.// media type="custom" key="5866981" align="center"

**Why Interactive Excel:**

 * Learn 21st century skills
 * 2-fer: learn math and computer applications (spreadsheets)
 * Build connections between the abstract equation and graphical representation (multiple representations: formula, graph, table)
 * Hands-on explorations, inquiry, discovery (investigate many more examples in a class period than traditional methods)
 * Higher order thinking skills (especially when students create their own)
 * Combine with calculator or paper calculations (not just using Excel formulas)
 * Shift from teacher-directed to student-centered learning
 * Java-like applet, internet not necessary

Excel Spreadsheets that are used in the classroom are interactive spreadsheets or simulations of mathematical models. The user changes a variable and the spreadsheet graph changes. Through the use of numerical experimentation and "what if" scenarios, we have a powerful learning tool for students using readily available software already installed on most computers. Excel is a great data collector and if you set it up to graph as data is entered, students can visualize the graph of the curve as the data in entered.

//(4/20/10 from Penn State One-to-One Conference Keynote Presentation, Dr. Kyle Peck)//

 * ** In mathematics, the art of asking questions is more valuable than solving problems. Georg Cantor **
 * ** The essence of mathematics is not to make simple things complicated but to make complicated things simple. Stanley Gudder **

media type="custom" key="5867021" align="right" width="120" height="100"

stampinpost@yahoo.com
 * //Pages Created by Kathleen L Post//**