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 2a Part I Video
2. Watch Goal 4 Module 2a Part II Video
3. Read Goal 4 Module 2a Additional Resources (recommended)

GOAL 4 MODULE 2A PART I

Watch the following video on cleaning your dataset using Excel for the Equity Explorer (Part I).

 

 

GOAL 4 MODULE 2A PART II

Watch the following video on cleaning your dataset using Excel for the Equity Explorer (Part II).

 

 

Goal 4 Module 2a Additional Resources

 

NEXT STEPS

After completing this module, you'll proceed to Module 2b: 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.