Using Excel to Analyze Multiple-Choice Items – Simple Ways to Improve a Test

Date
2013-10-29
Authors
Hill, Yao Zhang
Contributor
Advisor
Department
Instructor
Depositor
Speaker
Researcher
Consultant
Interviewer
Annotator
Journal Title
Journal ISSN
Volume Title
Publisher
Volume
Number/Issue
Starting Page
Ending Page
Alternative Title
Abstract
No test is perfect. Some test items may not be clear or fair to the students. This session provides introductory statistical methods to examine an item’s difficulty level, sensitivity to instructions, and power to differentiate master and non-master students, as well as the quality of the answer choices. The presenter demonstrates the analysis using Excel 2007 and the participants are expected to leave the session knowing the basic item analysis concepts, how to carry out the analysis, and how to interpret the results. The presenter will also showcase an example using item analysis to improve program learning assessment.
Description
Keywords
item analysis, learning assessment
Citation
Hill, Y. Z. (2013, October). Using Excel to analyze multiple-choice items: Simple ways to improve a test. Interactive session presented at the IUPUI Assessment Institute Annual Conference, Indianapolis, IN.
Extent
17
Format
Geographic Location
Time Period
Related To
Table of Contents
Rights
Rights Holder
Local Contexts
Email libraryada-l@lists.hawaii.edu if you need this content in ADA-compliant format.