Reliability and Validity

Excel D & d Blank Worksheet

Excel D & d Example

Psych Central's virtual classroom. All Psych offers a quick read on testing reliability and validity

A great reliability and validity tutorial with simplistic explainations, using examples of teacher made tests. This tutorial was created by a retired professor, Barbara Sommer, from UC Davis.

Information sheet from Stonybrook University on interpreting reliability and validity results

Tutorial on Difficulty Index and Discrimination Index with a sample on which you can test your skills

Stonybrook University

Classroom Assessment

Reliability & Validity

Amazing resources that make Reliability and Validity (almost) fun! Use these to turn your good Items and Tests into superior works with compelling data to back up your efforts.

All Psych

Dr. Barbara Sommers

Excel Worksheet completed with formulas and an example of tables used to calculate the Difficulty Level (D) and Discrimination Index (d) for an individual Multiple Choice test item.

Four tables are used to illustrate calculations on each of four answer choices, A, B, C, and D. Correct Answers are marked with an *

Download this Excel worksheet, based on a 4-item multiple choice test, for use in determining your Difficulty Level (D) and Discrimination Index (d) of each item.

Formulas are already present within the worksheet, just add your Number of Correct Responses for the High Group and Number of Correct Responses for the Low Group, the Number of Students who choose each Distractor in the Low and High Groups. Sums, D, and d, will automatically calculate. Use the table in which your correct Answer is marked with an *