How to Create Automatically Graded Spreadsheets for Statistics Courses

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...

Celý popis

Uloženo v:
Podrobná bibliografie
Vydáno v:Teaching of psychology Ročník 43; číslo 2; s. 147 - 152
Hlavní autor: LoSchiavo, Frank M.
Médium: Journal Article
Jazyk:angličtina
Vydáno: Los Angeles, CA SAGE Publications 01.04.2016
Taylor & Francis Ltd
Témata:
Automation
Computer Mediated Communication
Computer System Design
Courseware
Educational Practices
Error correction & detection
Feedback
Feedback (Response)
Grading
Programming
Spreadsheets
Statistics
Technology Uses in Education
spreadsheets
teaching technology
teaching machine
Excel
statistics
ISSN:0098-6283, 1532-2802, 1532-8023
On-line přístup:Získat plný text
Tagy: Přidat tag
Žádné tagy, Buďte první, kdo vytvoří štítek k tomuto záznamu!
Popis
Shrnutí: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.
Bibliografie:ObjectType-Article-1
SourceType-Scholarly Journals-1
ObjectType-Feature-2
content type line 14
ISSN:0098-6283
1532-2802
1532-8023
DOI:10.1177/0098628316636293