ORGANIZING YOUR DATASET FOR THE EQUITY EXPLORER

Objectives

1. Rename demographic and testing variables.
2. Transform testing variables into standardized Z-scores.
3. Organize variables with more than one test administration (e.g., MAP).
4. Locate a norm table online (e.g., MAP).

Learning Tasks

1. Watch Goal 4 Module 2 Part I Video
2. Watch Goal 4 Module 2 Part II Video
3. Read Goal 4 Module 2 Additional Resources (recommended)

GOAL 4 MODULE 2 PART I

Watch the following video on cleaning your dataset using Excel for the Equity Explorer (Part I). This gives general advise on how to structure your dataset and quickly clean up your data to be able to use within the Shiny app.

GOAL 4 MODULE 2 PART II

Watch the following video on cleaning your dataset using Excel for the Equity Explorer (Part II). This section goes over how to locate norms tables and how to clean up multiple test administrations.

Goal 4 Module 2 Additional Resources

Example Datasets for the Shiny Application
Finding & Removing Duplicates
Microsoft: Top 10 Ways to Clean Your Data
Cleaning Data in Excel
How to Calculate Z-Scores in Excel
NWEA Normative Data for Achievement Scores
NWEA MAP Growth Technical Report
STAR Reading
STAR Math

NEXT STEPS

After completing this module, you'll proceed to Module 3: Using the Equity Explorer.

This work was supported by a grant from the U.S. Department of Education (award number S206A200007 – 21) as part of the Jacob K. Javits Gifted and Talented Students Education Program. The contributors to this site include Kiana Johnson, Lindsay Lee, Matt Makel, Matthew McBee, Betsy McCoach, Scott Peters, & Tamra Stambaugh.