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

  • Authors:
  • Kostas Lavidas;Vasilis Komis;Vasilis Gialamas

  • Affiliations:
  • Department of Educational Sciences and Early Childhood Education, University of Patras, Patras, Greece 26500;Department of Educational Sciences and Early Childhood Education, University of Patras, Patras, Greece 26500;Department of Early Childhood Education, National and Kapodistrian University of Athens, Athens, Greece 10680

  • Venue:
  • Education and Information Technologies
  • Year:
  • 2013

Quantified Score

Hi-index 0.00

Visualization

Abstract

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.