ESUM-RG Open-source VBA Excel Macros and Manual
ESUM-RG (Equating SUMmary for the Random Groups design) is an open source VBA enabled Excel workbook that reads in output produced by Equating Recipes (Brennan, Wang, Kim, & Seol, 2009), and then organizes the output into worksheets that facilitate selecting an equating method for operational use.
The main purpose of ESUM-RG is to facilitate selection of an appropriate equating method. ESUM-RG allows a user to view equating results from five different perspectives: conversion tables, moments and moment differences (relative to scores on Form Y), color (e.g., many-to-one conversions and gaps in rounded equated scale scores), relative frequency distributions of rounded equated scale scores; and a wide selection of graphs.
Any single ESUM-RG workbook is for scores on a single form of a test. For example, if there are three scores (say, Reading, Writing, and Math) for any form, and two forms are equated to a base or anchor form, then there should be six ESUM-RG workbooks. Note that, for ESUM-RG, the data collection design must be the random groups design, as discussed by Kolen and Brennan (2014).
References
Brennan, R. L., Wang, T., Kim, S., & Seol, J. (2009, September). Equating Recipes (Version 1) [Computer software and manual] (CASMA Monograph No. 1). Iowa City, IA: Center for Advanced Studies in Measurement and Assessment, The University of Iowa. (Available on http://www.education.uiowa.edu/casma)
Kolen, M. J., & Brennan, R. L. (2004). Test equating, scaling, and linking: Methods and practices (2nd ed.). New York: Springer-Verlag.