i-nth logo

Authors

Djordje Kadijevich

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.

Sample

Example model
Example model

The students developed a simple model and made recommendations from a what-if analysis. Even with such a simple model, errors were very common.

Publication

2012, Educational Computing Research, Volume 47, Number 2, January, pages 137-153

Full article

Examining errors in simple spreadsheet modeling from different research perspectives