Title: Teaching spreadsheet proficiency: beyond hitting the keys

Authors: Chang Boon Patrick Lee

Addresses: Faculty of Business Administration, University of Macau, Macao, China

Abstract: Many tertiary institutions teach spreadsheets as part of the introductory course on computing. The time allocated for spreadsheet teaching is usually limited and instructors are often faced with the dilemma of how to ensure effective coverage of the subject. Some instructors end up ||dumping|| manual-like materials onto the students, thinking that they will read the materials religiously. It is possible that the frequent occurrence of spreadsheet errors that has been established in prior research is a result of inadequate teaching. It is important, therefore, for instructors to know how to teach effectively. This paper identified six teaching methods and discussed their advantages and disadvantages. This paper also proposed a three-stage spreadsheet teaching model that emphasises teaching the procedural and conceptual aspects of the software. The model provides a useful guide for instructors and it should help to address the concern regarding frequent occurrence of spreadsheet errors.

Keywords: spreadsheets; teaching methods; spreadsheet errors; higher education; tertiary education.

DOI: 10.1504/IJHRDM.2005.006327

International Journal of Human Resources Development and Management, 2005 Vol.5 No.2, pp.218 - 226

Published online: 20 Feb 2005 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article