In this workshop, you will learn the basic concepts: item difficulty, difference index, B-index, distractor analysis; how to conduct item analysis using formulas in Excel; item analysis in pre- and post-test scenarios and achievement test scenarios; and how to interpret item analysis results.

PowerPoint and Handout
Excel data file 1 and data file2
Workshop Evaluation Report

Many multiple-choice tests can be improved to better measure student learning. A test question can be referred to as an item. Through item analysis, you can see whether each test question (item) matches the level of the learning that you expect of the students. Item analysis helps you examine which learning outcomes are better achieved than others. It also helps you catch misbehaving questions: those with wrong answer keys, those with more than one answer, those not relevant to your teaching objectives, and those that confuse your students.

Level: Beginner (basic Excel skills needed for optimal learning)
Format: Demonstration + hands-on practice
Requirement: Please bring a laptop with Microsoft Excel installed
Date/time/location: Friday, March 1, 2013, 1:30 PM – 2:45 PM, KUY106