Power to business professors: Automatic grading of problem-solving tasks in a spreadsheet
Author(s)Bertheussen, Bernt Arne
KeywordsVDP::Social science: 200::Economics: 210::Business: 213
VDP::Samfunnsvitenskap: 200::Økonomi: 210::Bedriftsøkonomi: 213
Full recordShow full item record
AbstractThis 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.
Journal of Accounting Education (2014), Online version