IDEAS home Printed from https://ideas.repec.org/a/taf/accted/v26y2017i2p127-143.html
   My bibliography  Save this article

Beyond the mechanics of spreadsheets: using design instruction to address spreadsheet errors

Author

Listed:
  • Kent N. Schneider
  • Lana L. Becker
  • Gary G. Berg

Abstract

Given that the usage and complexity of spreadsheets in the accounting profession are expected to increase, it is more important than ever to ensure that accounting graduates are aware of the dangers of spreadsheet errors and are equipped with design skills to minimize those errors. Although spreadsheet mechanics are prevalent in accounting curricula, less attention has been given to design considerations that can reduce the incidence of spreadsheet errors. The extant literature provides evidence of the most common types of spreadsheet errors and explanations as to why they occur. Using the work of Panko and others, this paper outlines a three-step approach for introducing spreadsheet design practices to novice spreadsheet developers. To facilitate design instruction, this paper provides a summary of foundational readings related to spreadsheet errors as well as specific teaching strategies for addressing the most common spreadsheet errors identified in the literature.

Suggested Citation

  • Kent N. Schneider & Lana L. Becker & Gary G. Berg, 2017. "Beyond the mechanics of spreadsheets: using design instruction to address spreadsheet errors," Accounting Education, Taylor & Francis Journals, vol. 26(2), pages 127-143, March.
    • Handle: RePEc:taf:accted:v:26:y:2017:i:2:p:127-143
    DOI: 10.1080/09639284.2016.1274912
    as

    Download full text from publisher

    File URL: http://hdl.handle.net/10.1080/09639284.2016.1274912
    Download Restriction: Access to full text is restricted to subscribers.
    File URL: https://libkey.io/10.1080/09639284.2016.1274912?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Ian Beaman & Erwin Waldmann & Peter Krueger, 2005. "The impact of training in financial modelling principles on the incidence of spreadsheet errors," Accounting Education, Taylor & Francis Journals, vol. 14(2), pages 199-212.
    2. Usha Ramachandran Rackliffe & Linda Ragland, 2016. "Excel in the accounting curriculum: perceptions from accounting professors," Accounting Education, Taylor & Francis Journals, vol. 25(2), pages 139-166, April.
    3. Gregory Stoner, 2009. "Accounting Students' IT Application Skills over a 10-year Period," Accounting Education, Taylor & Francis Journals, vol. 18(1), pages 7-31.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Susanne Leitner-Hanetseder & Christoph Eisl & Carina Knoll & Othmar M. Lehner, 2021. "Need For Advanced It Skills For Accountants €“ What Does Accounting Education Literature Tell Us?," Business Education and Accreditation, The Institute for Business and Finance Research, vol. 13(1), pages 57-69.
    2. Apostolou, Barbara & Dorminey, Jack W. & Hassell, John M. & Rebele, James E., 2018. "Accounting education literature review (2017)," Journal of Accounting Education, Elsevier, vol. 43(C), pages 1-23.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Hamood Mohammed Al-Hattami, 2021. "University Accounting Curriculum, IT, and Job Market Demands: Evidence From Yemen," SAGE Open, , vol. 11(2), pages 21582440211, April.
    2. Khaldoon Al-Htaybat & Larissa von Alberti-Alhtaybat & Zaidoon Alhatabat, 2018. "Educating digital natives for the future: accounting educators’ evaluation of the accounting curriculum," Accounting Education, Taylor & Francis Journals, vol. 27(4), pages 333-357, July.
    3. Apostolou, Barbara & Dorminey, Jack W. & Hassell, John M. & Rebele, James E., 2017. "Accounting education literature review (2016)," Journal of Accounting Education, Elsevier, vol. 39(C), pages 1-31.
    4. Husam Aldamen & Rajab Al-Esmail & Janice Hollindale, 2015. "Does Lecture Capturing Impact Student Performance and Attendance in an Introductory Accounting Course?," Accounting Education, Taylor & Francis Journals, vol. 24(4), pages 291-317, August.
    5. Susanne Leitner-Hanetseder & Christoph Eisl & Carina Knoll & Othmar M. Lehner, 2021. "Need For Advanced It Skills For Accountants €“ What Does Accounting Education Literature Tell Us?," Business Education and Accreditation, The Institute for Business and Finance Research, vol. 13(1), pages 57-69.
    6. Singh, Anil & Mangalaraj, George & Taneja, Aakash, 2011. "An approach to detecting plagiarism in spreadsheet assignments: A digital answer to digital cheating," Journal of Accounting Education, Elsevier, vol. 29(2), pages 142-152.
    7. Debbie Delaney & Lisa McManus & Chew Ng, 2015. "First Year Accounting Students’ Perceptions Of Blended Learning," Business Education and Accreditation, The Institute for Business and Finance Research, vol. 7(2), pages 9-23.
    8. Singh, Anil & Mangalaraj, George & Taneja, Aakash, 2014. "Addressing business needs: A creative module for teaching data macros in an accounting information systems course," Journal of Accounting Education, Elsevier, vol. 32(1), pages 61-75.
    9. Khabyuk, Olexiy, "undated". "Marketingausbildung im Zeichen der Arbeitsmarktfähigkeit und Digitalisierung: Diskussion der Anforderungen an Marketing-Curricula in den angelsächsischen wissenschaftlichen Veröffentlichungen der letz," Duesseldorf Working Papers in Applied Management and Economics 50, Duesseldorf University of Applied Sciences.
    10. Reinstein, Alan & Churyk, Natalie Tatiana & Tate, Stefanie L., 2018. "Analyzing pedagogical approaches used in second auditing courses," Advances in accounting, Elsevier, vol. 42(C), pages 110-124.
    11. Lee, Lorraine & Shifflett, Eileen & Downen, Tom, 2019. "Teaching excel shortcuts: A visualization and game-based approach," Journal of Accounting Education, Elsevier, vol. 48(C), pages 22-32.
    12. Domino, Madeline A. & Schrag, Daniel & Webinger, Mariah & Troy, Carmelita, 2021. "Linking data analytics to real-world business issues: The power of the pivot table," Journal of Accounting Education, Elsevier, vol. 57(C).
    13. Lin Mei Tan & Fawzi Laswad, 2018. "Professional skills required of accountants: what do job advertisements tell us?," Accounting Education, Taylor & Francis Journals, vol. 27(4), pages 403-432, July.
    14. Ragland, Linda & Ramachandran, Usha, 2014. "Towards an understanding of excel functional skills needed for a career in public accounting: Perceptions from public accountants and accounting students," Journal of Accounting Education, Elsevier, vol. 32(2), pages 113-129.
    15. Apostolou, Barbara & Hassell, John M. & Rebele, James E. & Watson, Stephanie F., 2010. "Accounting education literature review (2006–2009)," Journal of Accounting Education, Elsevier, vol. 28(3), pages 145-197.
    16. Parra, Fernando & Jacobs, Aimee & Trevino, Laura L., 2021. "Shippy Express: Augmenting accounting education with Google Sheets," Journal of Accounting Education, Elsevier, vol. 56(C).

    More about this item

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:taf:accted:v:26:y:2017:i:2:p:127-143. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Chris Longhurst (email available below). General contact details of provider: http://www.tandfonline.com/RAED20 .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.