Using spreadsheets in the teaching and learning of mathematics: a research bibliography

Description/Abstract

This review suggests that one way that seems to help pupils move from a non-algebraic to an algebraic approach is through work with spreadsheets. This is because, in using such a tool, compared to using paper and pencil, pupils appear to be able to learn more readily to express general mathematical relationships using the symbolic language in the spreadsheet environment. This is a key to making progress in algebra. Another area of research, though less developed than that relating to algebra, is examining how a spreadsheet might provide a useful educational environment in which to teach statistics, primarily because statistical concepts and procedures using a spreadsheet may be more transparent to pupils, allowing them to look inside the “black box” of statistical techniques. Other teaching advantages of spreadsheets are that pupils are likely to relatively familiar with them as these are used in other lessons in school. Pupils are also likely to have access to spreadsheet software outside of school, including at home.