EDFacts Assessment, 2011-12
Department of Education
@usgov.ed_gov_edfacts_assessment_2011_12_e9477
Department of Education
@usgov.ed_gov_edfacts_assessment_2011_12_e9477
EDFacts Assessment, 2011-12 (EDFacts ASSMT:2011-12) is one of 17 'topics' identified in the EDFacts documentation (in this database, each 'topic' is entered as a separate study). EDFacts ASSMT:2011-12 (ed.gov/about/inits/ed/edfacts) annually collects cross-sectional data from states about students participation in and performance on academic assessments in Reading/Language Arts, Science, and Mathematics in elementary and secondary education at the school, LEA, and SEA levels. EDFacts ASSMT:2011-12 data were collected using the EDFacts Submission System (ESS), a centralized portal, and their submission by states is mandatory and required for benefits. Not submitting the required reports by a state constitutes a failure to comply with law and may have consequences for federal funding to the state. Key statistics produced from EDFacts ASSMT:2011-12 are from eight (8) data groups with information on Academic Achievement, Academic Achievement-Flexibility, Assessment Participation, and Assessment Participation-Flexibility in Mathematics and Reading/Language Arts. For the purposes of this system, data groups are referred to as 'variables', as a result of the structure and format of EDFacts data.
Organization: Department of Education
Last updated: 2023-08-12T23:26:34.393613
Tags: achievement, assessment, assessment-participation, b5c3333b-259a-49c3-9576-51203d216820, economically-disadvantaged-students, edfacts, elementary-and-secondary-education, elementary-school, english-learner, esea, esea-flexibility, high-school, homeless-students, language-arts, lea, limited-english-proficienct, mathematics, middle-school, migratory-students, reading, reading-language-arts, readinglanguage-arts, schools, science, sea, students, students-with-disabilities
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 userssharedsdfleaachvrsltsassessrlasy201112 (
"stnam" VARCHAR,
"fipst" BIGINT,
"leaid" BIGINT,
"leanm11" 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,
"mhi_rla08numvalid_1112" DOUBLE,
"mhi_rla08pctprof_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.