Teaching good Excel design and skills: A three spreadsheet assignment project

Cynthia Frownfelter- Lohrke

Journal of Accounting Education, 2017, vol. 39, issue C, 68-83

Abstract: Over sixty percent of AIS courses cover Excel because it is an important tool for accounting students to learn and master. Although spreadsheet programs like Excel provide powerful analytical tools for business, in practice, they are often created and used by people with minimal programming experience. Consequently, users can often develop spreadsheets containing critical errors, which, in turn, can cause significant losses for their businesses. Errors can be reduced, however, by learning and employing good spreadsheet design techniques. Good spreadsheet design also makes it easier to update and continue to use a spreadsheet over time. This paper describes a method for teaching spreadsheet design where students complete three spreadsheet assignments in an iterative and repetitive process. By the time students have completed these assignments, they will have acquired good spreadsheet design skills and improved their basic Excel skills.

Keywords: Excel; Spreadsheets; Spreadsheet design; Active learning; Project-based learning (search for similar items in EconPapers)
Date: 2017
References: View complete reference list from CitEc
Citations: View citations in EconPapers (2)

Downloads: (external link)
http://www.sciencedirect.com/science/article/pii/S0748575115300403
Full text for ScienceDirect subscribers only

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:eee:joaced:v:39:y:2017:i:c:p:68-83

DOI: 10.1016/j.jaccedu.2016.12.001

Access Statistics for this article

Journal of Accounting Education is currently edited by Natalie Tatiana Churyk

More articles in Journal of Accounting Education from Elsevier
Bibliographic data for series maintained by Catherine Liu ().