About this paper

Appears in:
Pages: 3786-3796
Publication year: 2016
ISBN: 978-84-608-5617-7
ISSN: 2340-1079
doi: 10.21125/inted.2016.1906

Conference name: 10th International Technology, Education and Development Conference
Dates: 7-9 March, 2016
Location: Valencia, Spain

TEACHING STRUCTURED SPREADSHEETS MODELLING AND IMPLEMENTATION

P. Mireault

HEC Montreal (CANADA)
Consequences of spreadsheet errors are abundant in the trade press, and academic research demonstrated that about 90% percent of spreadsheets contain at least one error. This is understandable since spreadsheets are being developed by users who have little expertise or ability to do so. Developing a spreadsheet is rarely one’s full occupation: it’s an occasional activity amidst all the other job-related tasks.

Teaching spreadsheets has mostly been centered on teaching the use of a particular program, with its menus, buttons, functions and options. This approach has the unavowed objective of trying to make a spreadsheet expert out of the student. Research has shown that most spreadsheets use only but a few functions or features

We present an overview of the Structured Spreadsheet Modelling and Implementation methodology and explain how it was developed to reduce the possibility of making errors. We also illustrate how it can be included in a course curriculum and discuss different teaching strategies that have already been used, such as traditional lectures and flipped classrooms.
@InProceedings{MIREAULT2016TEA,
author = {Mireault, P.},
title = {TEACHING STRUCTURED SPREADSHEETS MODELLING AND IMPLEMENTATION},
series = {10th International Technology, Education and Development Conference},
booktitle = {INTED2016 Proceedings},
isbn = {978-84-608-5617-7},
issn = {2340-1079},
doi = {10.21125/inted.2016.1906},
url = {http://dx.doi.org/10.21125/inted.2016.1906},
publisher = {IATED},
location = {Valencia, Spain},
month = {7-9 March, 2016},
year = {2016},
pages = {3786-3796}}
TY - CONF
AU - P. Mireault
TI - TEACHING STRUCTURED SPREADSHEETS MODELLING AND IMPLEMENTATION
SN - 978-84-608-5617-7/2340-1079
DO - 10.21125/inted.2016.1906
PY - 2016
Y1 - 7-9 March, 2016
CI - Valencia, Spain
JO - 10th International Technology, Education and Development Conference
JA - INTED2016 Proceedings
SP - 3786
EP - 3796
ER -
P. Mireault (2016) TEACHING STRUCTURED SPREADSHEETS MODELLING AND IMPLEMENTATION, INTED2016 Proceedings, pp. 3786-3796.
User:
Pass: