text query
menu query
active menu query
state-by-state data availability
the SMMBTGYY naming convention
K-12 Databases
by Joe Meyer for the Academic Development Institute
Questions or comments?
Google Discussion Group

NLSLSASD database updated with December 14, 2006 files
52 states
AK

   Years: 01-05
   Grades: 3-8
   Breakdown: OK
   Notes: C1 used in 01-2, C2 in 03-5
   Status: Ready as a three year state
  

AL

   Years: 02-05
   Grades: 4,6,8
   Breakdown: OK
   Notes it looks like a different test was used in 2003 with only C1 (C2 is defined as the passing cut point). Joe downloaded and merged the 2006 results from the state web site.
   Status: ready as a 3 year (04,05,06) state.
  

AR

   Years: 1999- 2005
   Grades: 3-8
   Breakdown: OK
   Notes: No counts in 04
   Status: need counts in 2004
  

AZ

   Years: 2000-5
   Grades: 3,5,8,10
   Breakdown: OK
   Notes: test switched from 1 to 0 in 2004
   Status: Ready
  

CA

   Years: 02-05
   Grades:
   Breakdown:
   Notes: tests changed in 03, uses language for reading
   Status: Need to parse language for reading
  

CO

   Years: 2001-5
   Grades: 3-10
   Breakdown: OK, only T in 2003
   Notes: no breakdowns in 2003
   Status: ~Ready except missing breakdowns in 03
  

CT

   Years: 2001-5
   Grades: 4,6 and 8
   Breakdown: OK
   Notes: no HS
   Status: Ready
  

DC

   Years: 03-5
   Grades:3,5,8 and 10
   Breakdown: OK
   Notes: AIR doc. calls for cut point 2 but has 2005 results for C1 only: use C1
   Status: Ready
  

DE

   Years: 02-5
   Grades: 3,5,8,10
   Breakdown: OK
   Notes:
   Status: Ready
  

FL

   Years: 99-05
   Grades:3-10
   Breakdown: OK
   Notes:
   Status: Ready
  

GA

   Years: 01-5
   Grades: 2-8 and unmapped 'F'
   Breakdown: only ethnic
   Notes: no HS unless it is 'F' , no poverty, LEP test data
   Status: Ready but has only ethnic breakdowns
  

HI

   Years: 97-05
   Grades: 3-8, 10
   Breakdown: OK
   Notes: Only one district
   Status: Ready
  

IA

   Years: 03-5
   Grades: 4,8,11
   Breakdown: OK
   Notes:
   Status: Ready
  

ID
Years: 03,05
   Grades: 3-8,10
   Breakdown: OK
   Notes: Data in 03 and 05 only
   Status: need to find 04 data
  

IL

   Years: 99-05
   Grades: 2-5,7,8,11
   Breakdown: OK
   Notes: No counts in 04-5 (there was an unusual C0 field)
   Status: Need to find counts in 04-5: check the 'C0' fields
  

IN

   Years: 01-5
   Grades: 3-9
   Breakdown: OK
   Notes:
   Status: Ready
  

KS

   Years: 2000-5
   Grades:4-8,10,11
   Breakdown: OK
   Notes:
   Status: Ready
  

KY

   Years: 99-05
   Grades: 4,5,7,8,10,11,12
   Breakdown: OK
   Notes:
   Status: Ready
  

LA

   Years: 02-5
   Grades: 4,8,10,11,12
   Breakdown: OK
   Notes: No reading results: use Language as a proxy
   Status: Ready
  

MA

   Years: 98-5
   Grades: 3-8, 10
   Breakdown: OK
   Notes: Uses both Language and Reading
   Status: Ready
  

MD

   Years: 2000-5
   Grades: 3-8
   Breakdown: only ethnic
   Notes: no HS, thin breakdown
   Status: Ready
  

ME

   Years: 99-05
   Grades: 4,8,11
   Breakdown: no break down until 04 then OK
   Notes: no subgroups before 04
   Status: ~Ready
  

MI

   Years: 99-05
   Grades: 4,5,7,8
   Breakdown: OK
   Notes: no HS.
   Status: Ready
  

MN

   Years: 98-05
   Grades: 3,5,7,10, 11
   Breakdown: OK
   Notes:
   Status: Ready
  

MO

   Years: 97-05
   Grades: 3,4,7,8,10,11
   Breakdown: OK
   Notes: No reading results: use Language as proxy.
   Status: Ready
  

MS

   Years: 2000-05
   Grades: 2-8
   Breakdown: OK
   Notes: No counts since 2001
   Status: Need to find number of test takers for 02-05 data
  

MT

   Years: 01-05
   Grades: 4,8,11
   Breakdown: OK
   Notes:
   Status: Ready
  

NC

   Years: 99-05
   Grades: 3-8
   Breakdown: OK
   Notes: No HS
   Status: Ready
  

ND

   Years: 03-05
   Grades: 3-8,11
   Breakdown:
   Notes: No NT in 03: PT is given instead
   Status: Need to find NT in 03 or make even distribution assumptions and proceed using CCD data
  

NE

   Years: 2000 - 5
   Grades: 4,8,11
   Breakdown: OK
   Notes: missing counts in 03
   Status: Need counts in 03
  

NH

   Years:
   Grades:
   Breakdown:
   Notes No data file for 05
   Status: Need data 2005.
  

NJ

   Years: 1999-05
   Grades: 2,4,8
   Breakdown: OK
   Notes: no HS data
   Status: Ready
  

NM

   Years: 2003-5
   Grades: 3-9,11
   Breakdown: OK
   Notes: Three years of data
   Status: Ready
  

NV

   Years: 1998-05
   Grades: 2,3,5,7,8,10
   Breakdown: OK
   Notes:
   Status: Ready
  

NY

   Years: 1999-05
   Grades: 4,8
   Breakdown: OK
   Notes: No HS
   Status: Ready
  

OH

   Years: 1998-05
   Grades: 3-8
   Breakdown: OK
   Notes: No HS, no NT data
   Status: Need counts
  

OK

   Years: 1999,2000,2001,2003,2005
   Grades: 3,4,5,8
   Breakdown: OK
   Notes: No NT data in 05, no data in 04
   Status: missing data
  

OR

   Years: 1998-05
   Grades: 3,5,8,10
   Breakdown: OK
   Notes: many missing counts in 03 and before
   Status: Need to find counts
  

PA

   Years: 1999-05
   Grades: 3,5,8,11
   Breakdown: OK
   Notes:
   Status: Ready
  

PR

   Years: 2000-05
   Grades: 3-8, 11
   Breakdown: OK (Hispanic is the only ethnic group given)
   Notes: Doesn't have Reading (does have Language), no counts in 04, 05
   Status: Need NTs in 04,5
  

RI

   Years:
   Grades:
   Breakdown:
   Notes No data file for 05
   Status: Need data 2005
  

SC

   Years: 1996-05
   Grades: 3-8
   Breakdown: OK (only total in 03)
   Notes: missing breakdowns in 2003
   Status: ~Ready
  

SD

   Years: 04, 05
   Grades: 3,4
   Breakdown: Total, Disadvantaged, non-Disadvantaged
   Notes No data file for 05
   Status: Need data.
  

TN

   Years: 2004,05
   Grades: 3-11
   Breakdown: OK
   Notes: No counts
   Status: Need counts and another year of data
  

TX

   Years: 3-5
   Grades: 3-11
   Breakdown: OK
   Notes:
   Status: Ready
  

UT

   Years:
   Grades:
   Breakdown:
   Notes No data files for 04, 05
   Status: Need data 2004,5
  

VA

   Years: 1999-2005
   Grades: 3,5,8,11
   Breakdown: OK
   Notes: no NT in 04 and 05
   Status: Need counts in 04 and 05
  

VT

   Years:
   Grades:
   Breakdown
   Notes No 2005 data files
   Status: Need data files
  

WA

   Years: 1997-05
   Grades: 3-10
   Breakdown: OK
   Notes:
   Status: Ready
  

WI

   Years: 98-05
   Grades: 4,8,10
   Breakdown: OK
   Notes: no NTs for any years, does has NN*PT=NT
   Status: need to combine NN (number enrolled) and PT (precent tested) columns to build NT (number tested)
  

WV

   Years: 04,05
   Grades: 3-8,10
   Breakdown: OK
   Notes: Only two years of CP data, in 2002,2003 data PR (percentile rank) and Qi (percent at or above quartile i)
   Status: Need to decide on metric for 02,03
  

WY

   Years: 1999-05
   Grades: 4,8,11
   Breakdown: OK
   Notes: No counts in 04,05. Does have PT but no NN and only perecnt tested doesn't help with the missing NT
   Status: Need counts in 04,05