Teaching decomposition forecasting models using an Excel-based spreadsheet application with Solver and randomisation

Kurt Hozak

International Journal of Innovation and Learning, 2019, vol. 26, issue 4, 407-425

Abstract: This article describes an Excel-based application to help teach forecasting with additive and multiplicative decomposition models using the standard Solver add-in to identify intercept, linear trend, and seasonality parameters. By using the application, students can see how easy it is to apply Solver's GRG nonlinear solving method in a relatively familiar forecasting context. To give additional opportunities to practice and encourage academic integrity, the software randomly generates data and layouts and disables copying and pasting between windows. Homework results suggest it provides a challenge despite offering extensive feedback and help. Students reported that it helped them learn forecasting and Excel. Those who correctly completed the assignment have had mixed results on a variety of forecasting exam questions. Even when using innovative technologies such as this application, additional resources, motivation, and opportunities may be necessary to facilitate breadth and depth of learning beyond the essentials required to complete assignments.

Keywords: spreadsheets; Microsoft Excel; cheating prevention; forecasting; e-learning; educational software; learning technology; management science; statistics; learning styles; linear programming; modelling; information technology; nonlinear programming; Solver. (search for similar items in EconPapers)
Date: 2019
References: Add references at CitEc
Citations:

Downloads: (external link)
http://www.inderscience.com/link.php?id=102905 (text/html)
Access to full text is restricted to subscribers.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:ids:ijilea:v:26:y:2019:i:4:p:407-425

Access Statistics for this article

More articles in International Journal of Innovation and Learning from Inderscience Enterprises Ltd
Bibliographic data for series maintained by Sarah Parker ().