The quick correct method allows instructors to easily assess Excel spreadsheet assignments and notifies students immediately if their answers are acceptable. The instructor creates a spread-sheet template for students to complete. To evaluate student answers within the template, the instructor places logic functions (e.g., IF, AND, OR) into a column adjacent to student responses. These “quick correct” formulae are then password protected and hidden from view. If a student enters an incorrect answer while completing the spreadsheet template, the logic function returns an appropriate warning that encourages corrections.
Wetzel, Laura R. and Whicker, Peter J.
Quick Correct: A Method to Automatically Evaluate Student Work in MS Excel Spreadsheets,
Spreadsheets in Education (eJSiE):
3, Article 1.
Available at: http://epublications.bond.edu.au/ejsie/vol2/iss3/1