Why Teach with Spreadsheets?
Spreadsheet programs are enormously flexible, familiar, and relatively easy to use. As such, they can increase both the breadth and depth of the topics covered in a class. For example, spreadsheets can be set up to numerically solve complex systems of equations, find trends in data, or discover the optimum solution to a problem. However, any class that presents data in a table may use spreadsheet exercises to enhance quantitative literacy. While the efficacy of using spreadsheets to enhance learning has not been formally investigated, the long history of using this technology in a variety of disciplines has revealed undeniable advantages, as documented by Baker and Sugden (2003) in "Spreadsheets in Education –The First 25 Years".
Increase the breadth of course contentBecause spreadsheets can be used to quickly solve complicated mathematical models, several authors have suggested that more sophisticated topics become in reach for lower-level courses. (See e.g. Cahill and Kosicki (2000, 2001).), Baker and Sugden (2003).) For example, models described by systems of equations with no standard algebraic solution can be explored though numerical examples when the spreadsheet program is used to solve the system numerically. In individual disciplines, spreadsheets have been used to teach chemistry without symbolic mathematics (Lim 2003), advanced topics in mathematics (Baker and Sugden (2003), Beare (2003)) and introductory physics (Webb 1993).
Example 2: Suppose you want to determine the relationship between two variables like GDP and the unemployment rate, number of terrorists and income, or atmospheric carbon dioxide levels over time. The Trendline feature of Excel can plot the line that bests fits the data and display the equation on the chart. Students (and teachers) would not need any knowledge of regression techniques to get these data.
Example 3: Consider the Cobb-Douglas function commonly used to model production by firms and preferences of consumers: (Output) = (Efficiency parameter)*[(Hours of labor)^(labor parameter)]*[(units of capital)^(capital parameter) (Q=A*(N^p)*(K^(1-p))) The non-linear nature of this function makes it difficult to quickly solve numerical examples, but a spreadsheet program can easily show for example how output will change if different levels of labor, capital or parameter values are chosen.
Increase the depth of course contentSometimes data sets are too large or models are too complicated to allow significant exploration with just a pencil, paper and calculator. Using spreadsheets allows for a variety of scenarios to be explored quickly so students can get a better intuitive sense of how a model works or what a data series shows. For example, Abramovich et al (2010) argue that spreadsheets can help develop skills in teaching science, technology, engineering and mathematics from the basic to advanced level.
Example 2: One of the reasons Crater Lake is intriguing is its complex underwater rock formations. A spreadsheet model can be used to calculate the volume of water in the lake from a topographical map by breaking it into many vertical prisms, as in this example: How much water is in Crater Lake.
Example 3: A spreadsheet can be used to visualize Maddison's very long run (2000 years for some countries) series for population, Real GDP, and Real GDP per person as in this example: Maddison data on the world economy.
Improve critical thinking skills
A number of studies have suggested that using the spreadsheet platform can also enhance critical thinking skills.
- Building spreadsheets requires abstract reasoning by the learner.
- Spreadsheets are rule-using tools that require that users become rule-makers (Vockell and van Deusen 1989).
- Spreadsheets promote more open-ended investigations, problem-oriented activities, and active learning by students (Beare 1992).
Beare (1993) notes that spreadsheets:
...facilitate a variety of learning styles which can be characterized by the terms: open-ended, problem-oriented, constructivist, investigative, discovery oriented, active and student-centered. In addition they offer the following additional benefits: they are interactive; they give immediate feedback to changing data or formulae; they enable data, formulae and graphical output to be available on the screen at once; they give students a large measure of control and ownership over their learning; and they can solve complex problems and handle large amounts of data without any need for programming.
Improve quantitative literacy
Any course that uses tables of data, equations, graphs, or makes arguments based on quantitative information provides an opportunity for students to enhance fluency in quantitative methods. Many careers, everyday events and news stories require quantitative skills. The National Numeracy Network (NNN), hosted by SERC argues for the importance of quantitative literacy and provides a wealth of resources to support for achieving this goal in the classroom.
Dirty students' hands
Constructing and using spreadsheet models forces students to "get their hands dirty." That is, when students directly interact with a model or data, they maybe able to understand it better than they would by taking in a lecture or reading a text. In this way, the benefits are similar to teaching with simulations. Research has suggested that students learn more when they are engaged with research, and that creative use of technology can support this process. For example, see the Boyer Commission Report, "Reinventing Undergraduate Education" (link opens new window). In addition, research has shown that students learn more when they are interactively engaged with course material