NotesFAQContact Us
Search Tips
Peer reviewed Peer reviewed
Direct linkDirect link
ERIC Number: EJ1093889
Record Type: Journal
Publication Date: 2016-Apr
Pages: 6
Abstractor: As Provided
ISSN: ISSN-0098-6283
How to Create Automatically Graded Spreadsheets for Statistics Courses
LoSchiavo, Frank M.
Teaching of Psychology, v43 n2 p147-152 Apr 2016
Instructors often use spreadsheet software (e.g., Microsoft Excel) in their statistics courses so that students can gain experience conducting computerized analyses. Unfortunately, students tend to make several predictable errors when programming spreadsheets. Without immediate feedback, programming errors are likely to go undetected, and as a result, students will likely encounter difficulty mastering this new skill. In this article, I share techniques for creating spreadsheets that grade themselves either by providing immediate feedback or by delaying feedback until instructors have completed necessary evaluations of student performance. Students prefer automatically graded spreadsheets to more traditional methods for checking answers, and in the long run, automatically graded spreadsheets can save instructors' valuable time. Furthermore, the techniques that I discuss can be adapted to create automatically graded assignments for other courses.
SAGE Publications. 2455 Teller Road, Thousand Oaks, CA 91320. Tel: 800-818-7243; Tel: 805-499-9774; Fax: 800-583-2665; e-mail:; Web site:
Publication Type: Journal Articles; Reports - Descriptive
Education Level: N/A
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A
Grant or Contract Numbers: N/A