IDEAS home Printed from https://ideas.repec.org/a/eee/joaced/v32y2014i1p76-87.html
   My bibliography  Save this article

Power to business professors: Automatic grading of problem-solving tasks in a spreadsheet

Author

Listed:
  • Bertheussen, Bernt Arne

Abstract

This paper presents an innovative approach, based on Excel files and a detailed implementation guide, that allows a professor with proficient spreadsheet skills to develop individualized problem-solving tasks for assignments and examinations that test students on cognitive thinking processes beyond memorizing and drilling. The professor accomplishes this goal by requiring the students to model a business problem-solving task in a worksheet environment. Each student’s work is marked automatically by a generic “plug and play” Visual Basic for Application (VBA) algorithm. The scores and feedback provided are tailored to each individual student and address not only the problem-solving outcome but also the problem-solving process. The learning objective discussed in this work is implemented at a Norwegian university business school.

Suggested Citation

  • Bertheussen, Bernt Arne, 2014. "Power to business professors: Automatic grading of problem-solving tasks in a spreadsheet," Journal of Accounting Education, Elsevier, vol. 32(1), pages 76-87.
    • Handle: RePEc:eee:joaced:v:32:y:2014:i:1:p:76-87
    DOI: 10.1016/j.jaccedu.2014.01.002
    as

    Download full text from publisher

    File URL: http://www.sciencedirect.com/science/article/pii/S0748575114000037
    Download Restriction: Full text for ScienceDirect subscribers only
    File URL: https://libkey.io/10.1016/j.jaccedu.2014.01.002?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. Sally Aisbitt & Alan Sangster, 2005. "Using internet-based on-line assessment: A case study," Accounting Education, Taylor & Francis Journals, vol. 14(4), pages 383-394.
    2. Johnson, Benny G. & Phillips, Fred & Chase, Linda G., 2009. "An intelligent tutoring system for the accounting cycle: Enhancing textbook homework with artificial intelligence," Journal of Accounting Education, Elsevier, vol. 27(1), pages 30-39.
    3. Blayney, Paul & Freeman, Mark, 2008. "Individualised interactive formative assessments to promote independent learning," Journal of Accounting Education, Elsevier, vol. 26(3), pages 155-165.
    4. Marriott, Pru & Lau, Alice, 2008. "The use of on-line summative assessment in an undergraduate financial accounting course," Journal of Accounting Education, Elsevier, vol. 26(2), pages 73-90.
    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. Apostolou, Barbara & Dorminey, Jack W. & Hassell, John M. & Rebele, James E., 2015. "Accounting education literature review (2013–2014)," Journal of Accounting Education, Elsevier, vol. 33(2), pages 69-127.

    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. Javier Márquez & Laura Lazcano & Carmen Bada & José Luis Arroyo-Barrigüete, 2023. "Class participation and feedback as enablers of student academic performance," SAGE Open, , vol. 13(2), pages 21582440231, May.
    2. 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.
    3. Afrogha, Olufolakemi & Oladele, Femi & Wright, Olatunde, 2020. "Influencing Factors On Academic Performance In Bowen University: The Perceptions Of Accounting Undergraduate Students," International Journal of Contemporary Accounting Issues-IJCAI (formerly International Journal of Accounting & Finance IJAF), The Institute of Chartered Accountants of Nigeria (ICAN), vol. 9(2), pages 120-140, September.
    4. Curtis, Susan M., 2011. "Formative assessment in accounting education and some initial evidence on its use for instructional sequencing," Journal of Accounting Education, Elsevier, vol. 29(4), pages 191-211.
    5. Litherland, Kate & Carmichael, Patrick & Martínez-García, Agustina, 2013. "Ontology-based e-assessment for accounting: Outcomes of a pilot study and future prospects," Journal of Accounting Education, Elsevier, vol. 31(2), pages 162-176.
    6. Keith Lownie & Fiona A. E. McQuarrie, 2014. "Applying the Principles of Soccer Training to the Design and Delivery of Classes in Introductory Accounting Courses," Accounting Perspectives, John Wiley & Sons, vol. 13(1), pages 83-98, March.
    7. Watty, Kim & McKay, Jade & Ngo, Leanne, 2016. "Innovators or inhibitors? Accounting faculty resistance to new educational technologies in higher education," Journal of Accounting Education, Elsevier, vol. 36(C), pages 1-15.
    8. Fatima Eid Al Adwan & Abdelsalam Fahad Al Awamrah, 2018. "The Extent to Which Students Have Sufficient Awareness of E-Learning and its Relation to Self-Studying and Academic Achievement," Modern Applied Science, Canadian Center of Science and Education, vol. 12(1), pages 137-137, January.
    9. Johnson, Benny G. & Phillips, Fred & Chase, Linda G., 2009. "An intelligent tutoring system for the accounting cycle: Enhancing textbook homework with artificial intelligence," Journal of Accounting Education, Elsevier, vol. 27(1), pages 30-39.
    10. Marriott, Pru & Lau, Alice, 2008. "The use of on-line summative assessment in an undergraduate financial accounting course," Journal of Accounting Education, Elsevier, vol. 26(2), pages 73-90.
    11. Parunchana Pacharn & Darlene Bay & Sandra Felton, 2013. "The Impact of a Flexible Assessment System on Students' Motivation, Performance and Attitude," Accounting Education, Taylor & Francis Journals, vol. 22(2), pages 147-167, April.
    12. 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.
    13. Margaret Healy & Maeve McCutcheon & John Doran, 2014. "Student Views on Assessment Activities: Perspectives from their Experience on an Undergraduate Programme," Accounting Education, Taylor & Francis Journals, vol. 23(5), pages 467-482, October.
    14. Brisejda Zenuni Ramaj & Elenica Pjero, 2023. "The Implementation of Accounting Information Systems for its Role in Marketing and Management Processes," European Journal of Marketing and Economics Articles, Revistia Research and Publishing, vol. 6, January -.

    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:eee:joaced:v:32:y:2014:i:1:p:76-87. 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: Catherine Liu (email available below). General contact details of provider: https://www.journals.elsevier.com/journal-of-accounting-education .

    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.