Spreadsheets as cognitive tools: A study of the impact of spreadsheets on problem solving of math story problems

摘要

In this study, we investigated the impact of computer spreadsheets on the problem solving practices of students for math story problems, and more specifically on the transition from arithmetic to algebraic reasoning, through the construction of algebraic expressions. We investigated the relationships among the students' prior knowledge and skills, the verification processes, and the effectiveness of the problem solving tasks. For identifying the factors involved in the problem solving process and their role, in our analysis we employed the Structural Equation Modeling (SEM) approach. We mainly focused on math story problems and on students of tertiary education with little prior experience on the use of computers and spreadsheets. Analysis of the data indicates that spreadsheets can support the transition from arithmetic to algebraic reasoning and this transition is influenced by prior skills of the students relevant to the interaction with the interface (enter formula skills), and the students' frequency of verification of the solution.