Quick Correct: A Method to Automatically Evaluate Student Work in MS Excel Spreadsheets

Autor: Laura R Wetzel, Peter J Whicker
Jazyk: angličtina
Rok vydání: 2007
Předmět:
Zdroj: Spreadsheets in Education, Vol 2, Iss 3 (2007)
Druh dokumentu: article
ISSN: 1448-6156
Popis: 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.
Databáze: Directory of Open Access Journals