Teaching good Excel design and skills: A three spreadsheet assignment project
Autor: | Cynthia Frownfelter Lohrke |
---|---|
Rok vydání: | 2017 |
Předmět: |
0106 biological sciences
Cover (telecommunications) business.industry Process (engineering) Computer science 02 engineering and technology Project-based learning 01 natural sciences Design skills Education 020204 information systems Accounting Active learning 0202 electrical engineering electronic engineering information engineering Software engineering business 010606 plant biology & botany |
Zdroj: | Journal of Accounting Education. 39:68-83 |
ISSN: | 0748-5751 |
DOI: | 10.1016/j.jaccedu.2016.12.001 |
Popis: | 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. |
Databáze: | OpenAIRE |
Externí odkaz: |