Quick Correct: A Method to Automatically Evaluate Student Work in MS Excel Spreadsheets
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 place...
| Main Authors: | , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
McMaster University
2007-11-01
|
| Series: | Spreadsheets in Education |
| Subjects: | |
| Online Access: | http://epublications.bond.edu.au/ejsie/vol2/iss3/1 |
| Summary: | 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. |
|---|---|
| ISSN: | 1448-6156 |