Spreadsheet Examples AuTe Logo The test development resource.
Workshop Dates & Locations Search Site Sign Up Contact

Home
Spreadsheets
White Papers
Testing Industry Calendar
Development Calendar
Validation Study
Links
FAQs
Wallace
Input Form
Glossary
Testing Forum

These are just a sample of the thirteen spreadsheets which will be made available to workshop participants.
Calculating a PIP Helps you decide which test to develop first.
From Engineering Human Performance by Tom Gilbert. <
JTA Gantt Chart Template for all tasks required to administer and
analyze a Job Task Analysis. Provides both a Gantt
Chart and a List of Tasks by Date. <
2 x 2 Analysis Conceptual experimentation spreadsheet. Lets you compare
validity measures using Chi Squared, Tetrachoric R, Kappa,
and the Agreement Coefficient. <
Item Analysis Worksheet Given exam score data, calculates the point-biserial
point-biserial correlation and P-Values for all items. <
Item Filter Evaluates whether items meet psychometric constraints
for point-biserial correlation and P-Value bounds.
Adaptive Scale Correlations Enables small-sample adaptive testing with independent scales.
Computes scale intercorrelations for adaptive administration.
Also prioritizes sequence of scale administrations.
Cutpoint Computation Computes the appropriate cutscore for your exam
using Angoff, Bookmark, or Contrasting Groups methods.
Scale Consistency Classification Computes Kappa, a measure of agreement, for ratings
of up to 5 raters on 6 scales for up to 100 items.
ScaleMark Computes an appropriate cutscore for multiple
scales in an exam using ScaleMark procedure.
Time & Accuracy Scoring Uses both time and accuracy to compute a
performance efficiency integrated matrix.
Trial Item Pool Size Computes the optimal trial item pool size
to include in the next release of a test.
Inter-Rater Reliability Measures inter-rater reliability for three
raters, using a Kappa computation.
Scale Stability Index Measures reliability for scales in a test
using a stability measure, as opposed to
an internal consistency measure.
Bias Calcs Computes bias calculations to see if a test
conforms to EEOC guidelines.
Scaled Score Converter Converts a raw score into a scaled score by either
of two methods: Linear rescaling or bilinear rescaling.
Includes a graphic of the linear rescaling model.


©2007..2009 Authentic Testing Corporation
Revised Wednesday, 18-Feb-2009 12:21:01 PST