Laura R. Wetzel, Eckerd College
Peter J. Whicker, Eckerd College

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.

Tell a Colleague

Get Acrobat Reader

Printing Tip: Select the option
to 'print as image' in the Acrobat print
dialog to ensure the article prints as
it appears on screen.
Learn more...