You are here

Data Overview

We have collected student subgroup- and school-level data that State Education Agencies use to determine whether schools met Adequate Yearly Progress in the 2002-03 and 2003-04 school years. The data include variables for whether the school made Adequate Yearly Progress overall as well as the percentage of students within each subgroup that took the math and reading tests, the percentage that scored proficient and above, and whether these percentages met that states’ Annual Measurable Objectives. The data also include the number of tested students per subgroup. Proficiency and participation rates are typically not reported if a subgroup’s size falls below the state’s minimum requirement.

On the Files and Documentation page we post national data files for each school year (2002-2003 and 2003-2004) in STATA format. In addition, we post separate data files for each state and year in both Excel and Stata formats. A Word document accompanies the national files and each of the state and year files that contains descriptions of each variable and its data source. The tables below describe the naming conventions for the variables contained in the state data files. Read the printable version (pdf) of the naming conventions.

Naming Conventions For 50-State Standardized AYP Variables

Table 1 (below) reports our abbreviations for various reporting levels, and table 2 (below) reports our naming conventions for each variable in our 50-state database. Please note that the level of data disaggregation varies by state. For instance, one state may disaggregate its data by subject, group, and level; another state may only disaggregate by subject and group. In addition, states have some flexibility in choosing groups to report. Please visit either the national or state-specific codebook for state-by-state data details.

Variable reporting levels for Subject (s) Group (g) and Level (l)
Click image to enlarge. See text version.

Variable name, variable label, and variable value naming conventions
Click image to enlarge. See text version.

Contact Us

Randall Reback, Barnard College
Jonah Rockoff, Columbia Business School
Heather Schwarz, RAND Corporation
Elizabeth Davidson, Teachers College

Funding

This work was funded by grants from the Spencer Foundation (200900082) and the Institute for Education Sciences (R305A090032).

The Curl Ideas to wrap your mind around

How Learning Creates Growth

Joseph E. Stiglitz and Bruce C. Greenwald explain how the key to economic innovation and prosperity lies within each of us — and within entire societies. The two were awarded the Eccles Prize for Excellence in Economic Writing

Read More >

The Flaws in the Trans-Pacific Partnership

It's not a partnership of equals, and it's not a free-trade agreement.

Read More >

The United States and China: An Unsustainable Codependency

A preeminent economist says both of the world's largest economies need to rebalance. Or else...

Read More >

Dean’s Office Announces 2015 MBA Teaching Awards

Last week, the Dean’s Office recognized three Columbia Business School faculty members with 2015 Dean’s Prizes for Teaching Excellence in MBA elective courses.

Read More >

Cara Mandarino, Medini Singh Win 2015 Service Awards

On May 5, the Office of Student Affairs, Dean’s Office, and Student Government together announced the winners of the 2015 Service Awards for Faculty and Administration.

Read More >

Morgan Stanley Donates $5.25 Million to Manhattanville Campus

The transformative gift, made by Morgan Stanley and alumni and friends at the firm, will create a Morgan Stanley Suite in each of Columbia Business School’s two new Manhattanville buildings.

Read More >

Study by Columbia Business School and U.S. Trust Uncovers Financial and Emotional Challenges of Business Succession Planning

Paper Documents Eight Real-life Stories of Entrepreneurs Who Transitioned Their Businesses

Read More >

Annual Dinner Builds Excitement for the School’s Future

More than 850 people gathered together for Columbia Business School’s 39th Annual Dinner on May 4.

Read More >

Get Ahead with “Idea Networking”

When opportunity takes too long to arrive, go out and find it

Read More >