Examining Errors in Simple Spreadsheet Modeling from Different Research Perspectives

Abstract

By using a sample of 1st-year undergraduate business students, this study dealt with the development of simple (deterministic and non-optimization) spreadsheet models of income statements within an introductory course on business informatics. The study examined students' errors in doing this for business situations of their choice and found three kinds of errors: errors in selecting variables, errors in initializing variables, and errors in relating variables. This article describes these errors, discusses possible reasons for them from different research perspectives, and gives suggestions for further practice and research. These perspectives dealt with modeling with spreadsheets, spreadsheets as mindtools, and errors in operational spreadsheets. The article is primarily directed to teachers of modeling with spreadsheets, interested in taking a broader view of the subject. To my son Aleksandar

Data modeling with dashboards: opportunities and challenges

“…If we alleviate technology-based challenges (e.g., by using short videos), challenges regarding the modeling process (viewed as a design task) may primarily be caused by lack of knowledge concerning the social phenomena under scrutiny (generalized from Ben-Zvi, 2002), as well as a lack of skills in problem structuring and integrating its parts with respect to questions and hypotheses examined (cf. Kadijevich, 2012). It is context that matters throughout the whole modeling process, and statistical and contextual domains may (and frequently do) interact in a complex way (Makar, Bakker & Ben-Zvi, 2011) that may be characterized as tapestry (Stillman, 1998).…”

Enseñanza de la teoría de grafos en la escuela secundaria basada en la modelación geométrica y la resolución de problemas

“…A través de la aplicación de métodos empíricos e instrumentos como encuestas a docentes, entrevistas a expertos y la revisión de la literatura, se constatan dificultades la resolución de problemas en los estudiantes: limitado reconocimiento de variables y las relaciones entre ellas (Sol et al,2011), escasas estrategias de abordaje para el análisis y la justificación, falta de habilidades para la comprensión y contextualización de un problema (Socas et al, 2014), y la limitada comprensión para explicar las relaciones entre objetos reales y las matemáticas. Además de las restringidas destrezas para explorar un problema social y abordarlo matemáticamente (Edo et al, 2013;Kadijevich, 2009).…”