Interactive spreadsheet models reinforce accounting principles

Abstract

This note presents an interactive spreadsheet model requiring students to create formulas that complete an incomplete, preexisting spreadsheet model and thereby demonstrate their understanding of the accounting principle being applied. The model's verification feature uses keyboard macro commands that compare the student's formulas to correct formulas stored on the spreadsheet. If any formula is incorrect, the error is highlighted and an online help screen is displayed to assist the student in preparing a correct solution. Interactive models provide students with immediate knowledge of results and improve the efficiency of class administration.