Consolidated State Performance Report, 2011-12
Department of Education
@usgov.ed_gov_consolidated_state_performance_report_2011_12_4629f
Department of Education
@usgov.ed_gov_consolidated_state_performance_report_2011_12_4629f
The Consolidated State Performance Report, 2011-12 (CSPR 2011-12), is part of the Consolidated State Performance Report (CSPR) program: a required annual reporting tool for each state, the Bureau of Indian Education, the District of Columbia, and Puerto Rico; program data is available since 2005-06 at . CSPR 2011-12 (https://www2.ed.gov/admins/lead/account/consolidated/index.html) is a cross-sectional report that measures each state's progress towards implementation of the No Child Left Behind Act (NCLB) and the reporting instrument for state formula grant programs authorized by the Elementary and Secondary Education Act (ESEA) as amended by NCLB. The reporting was conducted using state education agencies' (SEAs) reports in the EDFacts online submission system. CSPR 2011-12 is a universe survey. The study's response rate was 100%. Key statistics include information on adequate yearly progress, state performance assessments, highly qualified teachers, public school choice and supplemental education services options.
Organization: Department of Education
Last updated: 2023-08-12T23:58:25.162151
Tags: b5c3333b-259a-49c3-9576-51203d216820, consolidated-state-performance-report, elementary-and-secondary-education, esea-programs, grant-monitoring, high-school-graduation, highly-qualified-teachers, learning-environment, math-proficiency, program-monitoring, reading-language-proficiency, readinglanguage-proficiency, schools, state-activities
CREATE TABLE userssharedsdfachvmntrsltsstateassmtsmathssy201112 (
"stnam" VARCHAR,
"fipst" BIGINT,
"leaid" BIGINT,
"leanm" VARCHAR,
"ncessch" BIGINT,
"schnam11" VARCHAR,
"all_mth00numvalid_1112" BIGINT,
"all_mth00pctprof_1112" VARCHAR,
"mam_mth00numvalid_1112" DOUBLE,
"mam_mth00pctprof_1112" VARCHAR,
"mas_mth00numvalid_1112" DOUBLE,
"mas_mth00pctprof_1112" VARCHAR,
"mbl_mth00numvalid_1112" DOUBLE,
"mbl_mth00pctprof_1112" VARCHAR,
"mhi_mth00numvalid_1112" DOUBLE,
"mhi_mth00pctprof_1112" VARCHAR,
"mtr_mth00numvalid_1112" DOUBLE,
"mtr_mth00pctprof_1112" VARCHAR,
"mwh_mth00numvalid_1112" DOUBLE,
"mwh_mth00pctprof_1112" VARCHAR,
"f_mth00numvalid_1112" DOUBLE,
"f_mth00pctprof_1112" VARCHAR,
"m_mth00numvalid_1112" DOUBLE,
"m_mth00pctprof_1112" VARCHAR,
"cwd_mth00numvalid_1112" DOUBLE,
"cwd_mth00pctprof_1112" VARCHAR,
"ecd_mth00numvalid_1112" DOUBLE,
"ecd_mth00pctprof_1112" VARCHAR,
"lep_mth00numvalid_1112" DOUBLE,
"lep_mth00pctprof_1112" VARCHAR,
"hom_mth00numvalid_1112" DOUBLE,
"hom_mth00pctprof_1112" VARCHAR,
"mig_mth00numvalid_1112" DOUBLE,
"mig_mth00pctprof_1112" VARCHAR,
"all_mth03numvalid_1112" DOUBLE,
"all_mth03pctprof_1112" VARCHAR,
"all_mth04numvalid_1112" DOUBLE,
"all_mth04pctprof_1112" VARCHAR,
"all_mth05numvalid_1112" DOUBLE,
"all_mth05pctprof_1112" VARCHAR,
"all_mth06numvalid_1112" DOUBLE,
"all_mth06pctprof_1112" VARCHAR,
"all_mth07numvalid_1112" DOUBLE,
"all_mth07pctprof_1112" VARCHAR,
"all_mth08numvalid_1112" DOUBLE,
"all_mth08pctprof_1112" VARCHAR,
"all_mthhsnumvalid_1112" DOUBLE,
"all_mthhspctprof_1112" VARCHAR,
"mam_mth03numvalid_1112" DOUBLE,
"mam_mth03pctprof_1112" VARCHAR,
"mam_mth04numvalid_1112" DOUBLE,
"mam_mth04pctprof_1112" VARCHAR,
"mam_mth05numvalid_1112" DOUBLE,
"mam_mth05pctprof_1112" VARCHAR,
"mam_mth06numvalid_1112" DOUBLE,
"mam_mth06pctprof_1112" VARCHAR,
"mam_mth07numvalid_1112" DOUBLE,
"mam_mth07pctprof_1112" VARCHAR,
"mam_mth08numvalid_1112" DOUBLE,
"mam_mth08pctprof_1112" VARCHAR,
"mam_mthhsnumvalid_1112" DOUBLE,
"mam_mthhspctprof_1112" VARCHAR,
"mas_mth03numvalid_1112" DOUBLE,
"mas_mth03pctprof_1112" VARCHAR,
"mas_mth04numvalid_1112" DOUBLE,
"mas_mth04pctprof_1112" VARCHAR,
"mas_mth05numvalid_1112" DOUBLE,
"mas_mth05pctprof_1112" VARCHAR,
"mas_mth06numvalid_1112" DOUBLE,
"mas_mth06pctprof_1112" VARCHAR,
"mas_mth07numvalid_1112" DOUBLE,
"mas_mth07pctprof_1112" VARCHAR,
"mas_mth08numvalid_1112" DOUBLE,
"mas_mth08pctprof_1112" VARCHAR,
"mas_mthhsnumvalid_1112" DOUBLE,
"mas_mthhspctprof_1112" VARCHAR,
"mbl_mth03numvalid_1112" DOUBLE,
"mbl_mth03pctprof_1112" VARCHAR,
"mbl_mth04numvalid_1112" DOUBLE,
"mbl_mth04pctprof_1112" VARCHAR,
"mbl_mth05numvalid_1112" DOUBLE,
"mbl_mth05pctprof_1112" VARCHAR,
"mbl_mth06numvalid_1112" DOUBLE,
"mbl_mth06pctprof_1112" VARCHAR,
"mbl_mth07numvalid_1112" DOUBLE,
"mbl_mth07pctprof_1112" VARCHAR,
"mbl_mth08numvalid_1112" DOUBLE,
"mbl_mth08pctprof_1112" VARCHAR,
"mbl_mthhsnumvalid_1112" DOUBLE,
"mbl_mthhspctprof_1112" VARCHAR,
"mhi_mth03numvalid_1112" DOUBLE,
"mhi_mth03pctprof_1112" VARCHAR,
"mhi_mth04numvalid_1112" DOUBLE,
"mhi_mth04pctprof_1112" VARCHAR,
"mhi_mth05numvalid_1112" DOUBLE,
"mhi_mth05pctprof_1112" VARCHAR,
"mhi_mth06numvalid_1112" DOUBLE,
"mhi_mth06pctprof_1112" VARCHAR,
"mhi_mth07numvalid_1112" DOUBLE,
"mhi_mth07pctprof_1112" VARCHAR
);CREATE TABLE userssharedsdfachvmntrsltsstateassmtsrlasy201112 (
"stnam" VARCHAR,
"fipst" BIGINT,
"leaid" BIGINT,
"leanm" VARCHAR,
"ncessch" BIGINT,
"schnam11" VARCHAR,
"all_rla00numvalid_1112" BIGINT,
"all_rla00pctprof_1112" VARCHAR,
"mam_rla00numvalid_1112" DOUBLE,
"mam_rla00pctprof_1112" VARCHAR,
"mas_rla00numvalid_1112" DOUBLE,
"mas_rla00pctprof_1112" VARCHAR,
"mbl_rla00numvalid_1112" DOUBLE,
"mbl_rla00pctprof_1112" VARCHAR,
"mhi_rla00numvalid_1112" DOUBLE,
"mhi_rla00pctprof_1112" VARCHAR,
"mtr_rla00numvalid_1112" DOUBLE,
"mtr_rla00pctprof_1112" VARCHAR,
"mwh_rla00numvalid_1112" DOUBLE,
"mwh_rla00pctprof_1112" VARCHAR,
"f_rla00numvalid_1112" DOUBLE,
"f_rla00pctprof_1112" VARCHAR,
"m_rla00numvalid_1112" DOUBLE,
"m_rla00pctprof_1112" VARCHAR,
"cwd_rla00numvalid_1112" DOUBLE,
"cwd_rla00pctprof_1112" VARCHAR,
"ecd_rla00numvalid_1112" DOUBLE,
"ecd_rla00pctprof_1112" VARCHAR,
"lep_rla00numvalid_1112" DOUBLE,
"lep_rla00pctprof_1112" VARCHAR,
"hom_rla00numvalid_1112" DOUBLE,
"hom_rla00pctprof_1112" VARCHAR,
"mig_rla00numvalid_1112" DOUBLE,
"mig_rla00pctprof_1112" VARCHAR,
"all_rla03numvalid_1112" DOUBLE,
"all_rla03pctprof_1112" VARCHAR,
"all_rla04numvalid_1112" DOUBLE,
"all_rla04pctprof_1112" VARCHAR,
"all_rla05numvalid_1112" DOUBLE,
"all_rla05pctprof_1112" VARCHAR,
"all_rla06numvalid_1112" DOUBLE,
"all_rla06pctprof_1112" VARCHAR,
"all_rla07numvalid_1112" DOUBLE,
"all_rla07pctprof_1112" VARCHAR,
"all_rla08numvalid_1112" DOUBLE,
"all_rla08pctprof_1112" VARCHAR,
"all_rlahsnumvalid_1112" DOUBLE,
"all_rlahspctprof_1112" VARCHAR,
"mam_rla03numvalid_1112" DOUBLE,
"mam_rla03pctprof_1112" VARCHAR,
"mam_rla04numvalid_1112" DOUBLE,
"mam_rla04pctprof_1112" VARCHAR,
"mam_rla05numvalid_1112" DOUBLE,
"mam_rla05pctprof_1112" VARCHAR,
"mam_rla06numvalid_1112" DOUBLE,
"mam_rla06pctprof_1112" VARCHAR,
"mam_rla07numvalid_1112" DOUBLE,
"mam_rla07pctprof_1112" VARCHAR,
"mam_rla08numvalid_1112" DOUBLE,
"mam_rla08pctprof_1112" VARCHAR,
"mam_rlahsnumvalid_1112" DOUBLE,
"mam_rlahspctprof_1112" VARCHAR,
"mas_rla03numvalid_1112" DOUBLE,
"mas_rla03pctprof_1112" VARCHAR,
"mas_rla04numvalid_1112" DOUBLE,
"mas_rla04pctprof_1112" VARCHAR,
"mas_rla05numvalid_1112" DOUBLE,
"mas_rla05pctprof_1112" VARCHAR,
"mas_rla06numvalid_1112" DOUBLE,
"mas_rla06pctprof_1112" VARCHAR,
"mas_rla07numvalid_1112" DOUBLE,
"mas_rla07pctprof_1112" VARCHAR,
"mas_rla08numvalid_1112" DOUBLE,
"mas_rla08pctprof_1112" VARCHAR,
"mas_rlahsnumvalid_1112" DOUBLE,
"mas_rlahspctprof_1112" VARCHAR,
"mbl_rla03numvalid_1112" DOUBLE,
"mbl_rla03pctprof_1112" VARCHAR,
"mbl_rla04numvalid_1112" DOUBLE,
"mbl_rla04pctprof_1112" VARCHAR,
"mbl_rla05numvalid_1112" DOUBLE,
"mbl_rla05pctprof_1112" VARCHAR,
"mbl_rla06numvalid_1112" DOUBLE,
"mbl_rla06pctprof_1112" VARCHAR,
"mbl_rla07numvalid_1112" DOUBLE,
"mbl_rla07pctprof_1112" VARCHAR,
"mbl_rla08numvalid_1112" DOUBLE,
"mbl_rla08pctprof_1112" VARCHAR,
"mbl_rlahsnumvalid_1112" DOUBLE,
"mbl_rlahspctprof_1112" VARCHAR,
"mhi_rla03numvalid_1112" DOUBLE,
"mhi_rla03pctprof_1112" VARCHAR,
"mhi_rla04numvalid_1112" DOUBLE,
"mhi_rla04pctprof_1112" VARCHAR,
"mhi_rla05numvalid_1112" DOUBLE,
"mhi_rla05pctprof_1112" VARCHAR,
"mhi_rla06numvalid_1112" DOUBLE,
"mhi_rla06pctprof_1112" VARCHAR,
"mhi_rla07numvalid_1112" DOUBLE,
"mhi_rla07pctprof_1112" VARCHAR
);CREATE TABLE userssharedsdflealvlachvmntrsltsforstateassmntsinmathssy201112 (
"stnam" VARCHAR,
"fipst" BIGINT,
"leaid" BIGINT,
"leanm11" VARCHAR,
"all_mth00numvalid_1112" BIGINT,
"all_mth00pctprof_1112" VARCHAR,
"mam_mth00numvalid_1112" DOUBLE,
"mam_mth00pctprof_1112" VARCHAR,
"mas_mth00numvalid_1112" DOUBLE,
"mas_mth00pctprof_1112" VARCHAR,
"mbl_mth00numvalid_1112" DOUBLE,
"mbl_mth00pctprof_1112" VARCHAR,
"mhi_mth00numvalid_1112" DOUBLE,
"mhi_mth00pctprof_1112" VARCHAR,
"mtr_mth00numvalid_1112" DOUBLE,
"mtr_mth00pctprof_1112" VARCHAR,
"mwh_mth00numvalid_1112" DOUBLE,
"mwh_mth00pctprof_1112" VARCHAR,
"f_mth00numvalid_1112" DOUBLE,
"f_mth00pctprof_1112" VARCHAR,
"m_mth00numvalid_1112" DOUBLE,
"m_mth00pctprof_1112" VARCHAR,
"cwd_mth00numvalid_1112" DOUBLE,
"cwd_mth00pctprof_1112" VARCHAR,
"ecd_mth00numvalid_1112" DOUBLE,
"ecd_mth00pctprof_1112" VARCHAR,
"lep_mth00numvalid_1112" DOUBLE,
"lep_mth00pctprof_1112" VARCHAR,
"hom_mth00numvalid_1112" DOUBLE,
"hom_mth00pctprof_1112" VARCHAR,
"mig_mth00numvalid_1112" DOUBLE,
"mig_mth00pctprof_1112" VARCHAR,
"all_mth03numvalid_1112" DOUBLE,
"all_mth03pctprof_1112" VARCHAR,
"all_mth04numvalid_1112" DOUBLE,
"all_mth04pctprof_1112" VARCHAR,
"all_mth05numvalid_1112" DOUBLE,
"all_mth05pctprof_1112" VARCHAR,
"all_mth06numvalid_1112" DOUBLE,
"all_mth06pctprof_1112" VARCHAR,
"all_mth07numvalid_1112" DOUBLE,
"all_mth07pctprof_1112" VARCHAR,
"all_mth08numvalid_1112" DOUBLE,
"all_mth08pctprof_1112" VARCHAR,
"all_mthhsnumvalid_1112" DOUBLE,
"all_mthhspctprof_1112" VARCHAR,
"mam_mth03numvalid_1112" DOUBLE,
"mam_mth03pctprof_1112" VARCHAR,
"mam_mth04numvalid_1112" DOUBLE,
"mam_mth04pctprof_1112" VARCHAR,
"mam_mth05numvalid_1112" DOUBLE,
"mam_mth05pctprof_1112" VARCHAR,
"mam_mth06numvalid_1112" DOUBLE,
"mam_mth06pctprof_1112" VARCHAR,
"mam_mth07numvalid_1112" DOUBLE,
"mam_mth07pctprof_1112" VARCHAR,
"mam_mth08numvalid_1112" DOUBLE,
"mam_mth08pctprof_1112" VARCHAR,
"mam_mthhsnumvalid_1112" DOUBLE,
"mam_mthhspctprof_1112" VARCHAR,
"mas_mth03numvalid_1112" DOUBLE,
"mas_mth03pctprof_1112" VARCHAR,
"mas_mth04numvalid_1112" DOUBLE,
"mas_mth04pctprof_1112" VARCHAR,
"mas_mth05numvalid_1112" DOUBLE,
"mas_mth05pctprof_1112" VARCHAR,
"mas_mth06numvalid_1112" DOUBLE,
"mas_mth06pctprof_1112" VARCHAR,
"mas_mth07numvalid_1112" DOUBLE,
"mas_mth07pctprof_1112" VARCHAR,
"mas_mth08numvalid_1112" DOUBLE,
"mas_mth08pctprof_1112" VARCHAR,
"mas_mthhsnumvalid_1112" DOUBLE,
"mas_mthhspctprof_1112" VARCHAR,
"mbl_mth03numvalid_1112" DOUBLE,
"mbl_mth03pctprof_1112" VARCHAR,
"mbl_mth04numvalid_1112" DOUBLE,
"mbl_mth04pctprof_1112" VARCHAR,
"mbl_mth05numvalid_1112" DOUBLE,
"mbl_mth05pctprof_1112" VARCHAR,
"mbl_mth06numvalid_1112" DOUBLE,
"mbl_mth06pctprof_1112" VARCHAR,
"mbl_mth07numvalid_1112" DOUBLE,
"mbl_mth07pctprof_1112" VARCHAR,
"mbl_mth08numvalid_1112" DOUBLE,
"mbl_mth08pctprof_1112" VARCHAR,
"mbl_mthhsnumvalid_1112" DOUBLE,
"mbl_mthhspctprof_1112" VARCHAR,
"mhi_mth03numvalid_1112" DOUBLE,
"mhi_mth03pctprof_1112" VARCHAR,
"mhi_mth04numvalid_1112" DOUBLE,
"mhi_mth04pctprof_1112" VARCHAR,
"mhi_mth05numvalid_1112" DOUBLE,
"mhi_mth05pctprof_1112" VARCHAR,
"mhi_mth06numvalid_1112" DOUBLE,
"mhi_mth06pctprof_1112" VARCHAR,
"mhi_mth07numvalid_1112" DOUBLE,
"mhi_mth07pctprof_1112" VARCHAR,
"mhi_mth08numvalid_1112" DOUBLE,
"mhi_mth08pctprof_1112" VARCHAR
);Anyone who has the link will be able to view this.