Next Generation Accountability System
State of Connecticut
@usgov.state_of_connecticut_next_generation_accountability_system
State of Connecticut
@usgov.state_of_connecticut_next_generation_accountability_system
Connecticut’s Next Generation Accountability System is a broad set of 12 indicators that help tell the story of how well a school is preparing its students for success in college, careers and life. The system moves beyond test scores and graduation rates to provide a more holistic, multi-factor perspective of district and school performance.
The 12 Indicators are:
CREATE TABLE table_1 (
"fallofyear" BIGINT,
"rptngdistrictname" VARCHAR,
"reportingdistrictcode" BIGINT,
"schoolname" VARCHAR,
"schoolcode" BIGINT,
"schoolorgtype" VARCHAR,
"schoollowgrade" VARCHAR,
"schoolhighgrade" VARCHAR,
"schooltitleitype" VARCHAR,
"category" VARCHAR,
"totalpoints" DOUBLE,
"totalpossiblepoints" BIGINT,
"accountability_index" DOUBLE,
"finalcategory" DOUBLE,
"achievementgapflag" DOUBLE,
"ind1ela_all_rate" DOUBLE,
"ind1ela_all_points" DOUBLE,
"ind1ela_all_possiblepoints" DOUBLE,
"ind1ela_hn_rate" DOUBLE,
"ind1ela_nhn_rate" DOUBLE,
"ind1ela_hn_points" DOUBLE,
"ind1ela_hn_possiblepoints" DOUBLE,
"ind1math_all_rate" DOUBLE,
"ind1math_all_points" DOUBLE,
"ind1math_all_possiblepoints" DOUBLE,
"ind1math_nhn_rate" DOUBLE,
"ind1math_hn_rate" DOUBLE,
"ind1math_hn_points" DOUBLE,
"ind1math_hn_possiblepoints" DOUBLE,
"ind1sci_all_rate" DOUBLE,
"ind1sci_all_points" DOUBLE,
"ind1sci_all_possiblepoints" DOUBLE,
"ind1sci_hn_rate" DOUBLE,
"ind1sci_nhn_rate" DOUBLE,
"ind1sci_hn_points" DOUBLE,
"ind1sci_hn_possiblepoints" DOUBLE,
"ind1elagap" DOUBLE,
"ind1mathgap" DOUBLE,
"ind1scigap" DOUBLE,
"ind2ela_all_rate" DOUBLE,
"ind2ela_all_points" DOUBLE,
"ind2ela_all_possiblepoints" DOUBLE,
"ind2math_all_rate" DOUBLE,
"ind2math_all_points" DOUBLE,
"ind2math_all_possiblepoints" DOUBLE,
"ind2ela_hn_rate" DOUBLE,
"ind2ela_nhn_rate" DOUBLE,
"ind2ela_hn_points" DOUBLE,
"ind2ela_hn_possiblepoints" DOUBLE,
"ind2math_hn_rate" DOUBLE,
"ind2math_nhn_rate" DOUBLE,
"ind2math_hn_points" DOUBLE,
"ind2math_hn_possiblepoints" DOUBLE,
"ind3partrateflag" DOUBLE,
"ind3ela_all_rate" DOUBLE,
"ind3ela_hn_rate" DOUBLE,
"ind3ela_nhn_rate" DOUBLE,
"ind3math_all_rate" DOUBLE,
"ind3math_hn_rate" DOUBLE,
"ind3math_nhn_rate" DOUBLE,
"ind3sci_all_rate" DOUBLE,
"ind3sci_hn_rate" DOUBLE,
"ind3sci_nhn_rate" DOUBLE,
"ind4rate" DOUBLE,
"ind4points" DOUBLE,
"ind4possiblepoints" DOUBLE,
"ind4hnrate" DOUBLE,
"ind4hnpoints" DOUBLE,
"ind4hnpossiblepoints" DOUBLE,
"ind5rate" DOUBLE,
"ind5points" DOUBLE,
"ind5possiblepoints" DOUBLE,
"ind6rate" DOUBLE,
"ind6points" DOUBLE,
"ind6possiblepoints" DOUBLE,
"ind7rate" DOUBLE,
"ind7points" DOUBLE,
"ind7pointspossible" DOUBLE,
"ind8rate" DOUBLE,
"ind8points" DOUBLE,
"ind8pointspossible" DOUBLE,
"ind9rate" DOUBLE,
"ind9points" DOUBLE,
"ind9pointspossible" DOUBLE,
"gradgapflag" DOUBLE,
"ind10rate" DOUBLE,
"ind10points" DOUBLE,
"ind10possiblepoints" DOUBLE,
"ind11fitnessrate" DOUBLE,
"ind11participationrate" DOUBLE,
"ind11points" DOUBLE,
"ind11possiblepoints" DOUBLE,
"ind12rate" DOUBLE,
"ind12points" DOUBLE,
"ind12possiblepoints" DOUBLE,
"grad6yrratehn" DOUBLE,
"grad6yrratenhn" DOUBLE,
"grad6yrhnnhndiff" DOUBLE,
"hurdle_mean_ela" DOUBLE,
"hurdle_mean_math" DOUBLE
);Anyone who has the link will be able to view this.