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

Why M&A Is Different in Japan

A byproduct of Japan's sluggish economy has been an uptick in merger and acquisition activity.

Read More >

Students Pitch Their Startups at the Fall Venture Fair 2014

Forty startups from Columbia Business School pitched their companies and products to a diverse crowd of students, professional advisors, alumni, and early-stage investors.

Read More >

Columbia Business School Professor Predicts How Changes in Banking Laws Could Fuel Emerging Economies of Tomorrow

New research tracks emerging countries’ economics activity after law changes and finds a boost in access to credit; increase in employment rate; increase in productivity and sales for firms

Read More >

Power Isn't Enough: Study Reveals the Missing Link for Effective Leadership

New research from Columbia Business School shows that powerful leaders fail to listen properly and take others’ accounts into perspective, jeopardizing the impact they could have

Read More >

Europe's Lapse of Reason

The European Union's malaise is self-inflicted, says Columbia Business School's resident Nobel Laureate.

Read More >

What Makes China Buy

Tom Doctoroff, head of JWT South Asia, reveals how to snag a coveted market: Chinese online shoppers

Read More >

Zelon Crawford Named Assistant Dean of Student Affairs

Effective January 5, Zelon Crawford ’96TC will serve as Columbia Business School’s new Assistant Dean and Dean of Students, Full-Time MBA Program.

Read More >

The Expat's Dilemma

A foreign posting is a real resume booster — right? Not always, especially if you're coming from outside the United States to work within its borders. Assistant Professor Dan Wang explains.

Read More >

How to Convey Power with Your Voice

Professor Adam Galinsky says that simply thinking about a time when you experienced power can help you speak with a more dynamic voice.

Read More >