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

10 Ways to Create a Culture of Open Communication

Creating a culture of open communication can be one of the best ways to inspire excellent performance, improve employee morale, and foster a warmer corporate culture, says Alexander Tuff ’03.

Read More >

It's Time to Reform International Taxation

Taxing subsidiaries of international corporations as separate entities isn’t working

Read More >

Europe's Attack on Greek Democracy

It’s not about the money, says Columbia Business School’s resident Nobel laureate. It’s about forcing Greece to buckle under.

Read More >

Modi's Whirlwind First Year

Arun Jaitley, Narenda Modi’s first lieutenant, describes how far India has come — and what still needs to be done.

Read More >

Columbia Business School Welcomes Six New Board Members

In May, Columbia Business School welcomed six new members to its esteemed Board of Overseers.

Read More >

Columbia Startup Lab Revs Its Engines for Year Two

It’s been exactly one year since the Columbia Startup Lab opened its doors at 175 Varick Street as a shared workspace for budding Columbia entrepreneurs. With a proven track record and a full roster for the coming year, you might say the lab is a startup success story itself.

Read More >

Wearing a Suit Makes You More Powerful (but Not in the Way You Think)

Research by Professor Michael Slepian says wearing formal clothing makes a person feel in control and influences the way they view the world.

Read More >

Women in Business: Brooke Richman, Founder of Coop & Spree

Brook Richman ’13, founder and CEO of coop & spree, a women’s apparel and accessories boutique, is profiled.

Read More >

15 Ways to Powerfully Communicate Climate Change Solutions

Professor Elke Weber says the best way to promote positive climate change action is to communicate effective and credible solutions that cumulate and scale up.

Read More >