Capstone Project

Page title			html
chart#	chart title	data file	variables: descriptions
NYC Public High School Student Demographics			index.html
1	Percent students by Ethnicity	ProfileEthnicity.csv	Cohort_Year: The year of each cohort Asian: The percentage of Asian students in the cohort Black: The percentage of Black students in the cohort Hispanic: The percentage of Hispanic students in the cohort Multi-Racial: The percentage of multi-race students in the cohort Native American: The percentage of Native American students in the cohort White: The percentage of White students in the cohort
2	Percent students by Borough	ProfileLocation.csv	Cohort_Year: The year of each cohort Bronx: The percentage of students attending schools in the Bronx Brooklyn: The percentage of students attending schools in Brooklyn Manhattan: The percentage of students attending schools in Manhattan Queens: The percentage of students attending schools in Queens Staten Island: The percentage of students attending schools in Staten Island
3	Students by Economic Needs	All.csv	Category: The student demographic categories, such as Poverty, Disability, and ELL Cohort_Year: The year of each cohort Subcategory: sub-categories of student demographics, such as economically disadvantaged, not economically disadvantaged, disabled, not disabled, current ELL, former ELL, not ELL Total_Cohort: Number of students in each sub-category
4	Students by English Learning
5	Students by Special Education
8 Years of NYC Public High School Graduation Rates			gradAll.html
6	Graduation Rates from Cohort Year 2012 to 2019	All.csv	Category: The student demographic categories, such as Ethnicity Cohort_Year: The year of each cohort Percent_Grads: The graduation rates of students in each ethnicity subcategory: student ethnicities
7	Graduation Rates by Ethnicity per Cohort Year
Demographics of Cohort 2019 (Class of 2023)			boro.html
8	% ELL students	StudBoro.csv	Borough: The five NYC boroughs Category: The student demographic categories, such as Economically Disadvantaged, ELL, Ethnicity, Disability, Dropout Percent_Stud: The percentage of students in each category
9	% Economically Disadvantaged Students
10	% Students with Disability
11	% Students by Ethnicity
12	Percent Dropout in Borough
13	Percent Dropout by Ethnicity	All.csv	Percent_Drop: The dropout percentage for each ethnicity
Graduation Rates of Cohort 2019 by Ethnicity and Borough			ethn.html
14	Graduation Rates by Ethnicity per Borough	GradBoroEth.csv	Borough: the five NYC boroughs Percent_Grad: The graduation rates of students in each ethnicity subcategory: Student ethnicities
15	Graduation Rates by Borough	All.csv	ategory: Student demographic categories subCategory: the five NYC boroughs Percent_Grads: The graduation rates of students in each borough
Graduation Rates of Cohort 2019 by Demographic Characteristics			grad2.html
16	Graduation Rate by English Learning Status	GradBoroEng.csv	Borough: The five NYC boroughs ELL: The percentage of students classified as ELL as of the graduation year Former ELL: The percentage of students classified as ELL in the prior two school years and are no longer ELL Not ELL: The percentage of students who have never been classified as ELL or declassified more than two years prior the graduation year
17	Graduation Rate by Economic Status	GradBoroPov.csv	Econ Disadv: The percentage of students from economically disadvantaged families Not Econ Disadv: The percentage of students whose families are not economically disadvantaged
18	Graduation Rate by Disability Status	GradBoroDisab.csv	SWD: The percentage of students with disabilities Not SWD: The percentage of students without disabilities
19	Percent Dropout by Demographic Category	DropoutBoroDemo.csv	Category: Ethnicity and Dropout Percent_Drop: The percentage of dropouts in each sub-category subCategory: student ethnicity and demographic category
District-level Demographics and Graduation Rates of Cohort 2019			grad.html
20	% Ethnicity in Each School District	GradDistrict.csv	Category: Student demographic categories District: NYC School district numbers, 1 through 32 Percent_Cohort: The percentage of students in each sub-category Percent_Grads: The graduation rates of students in each sub-category subCategory: student ethnicity and demographic category
21	Graduation Rates by Ethnicity in each District
22	% Students by Demographic Category in Each District
23	Graduation Rates by District
Proportion of Schools with Graduation Rates Above/Below the Citywide Average			schools.html
24 -29	Citywide; Bronx; Brooklyn; Manhattan; Queens; Staten Island	SchoolsAB.csv	Borough: The five NYC boroughs Status: The school-level graduation rate is whether above or below the citywide average of 83.7% Total: Total number of schools for each status
NYC Public High Schools: Average School Funding per Pupil			fund.html
30	Average of Total School Funding per Pupil	FundingPerSchool.csv	AY: Academic Year Category: The three funding categories for the analysis. Funding_per_Pupil, Funding for Instructional_Media, and Funding for Pupil_Support_Services Manhattan: The average funding for schools in Manhattan for each category Bronx: The average funding for schools in the Bronx for each category Brooklyn: The average funding for schools in Brooklyn for each category Queens: The average funding for schools in Queens for each category Staten Island: The average funding for schools in Staten Island for each category
31	Average School Funding per Student for Instructional Media
32	Average School Funding per Student for Student Support Services
Graduation Rates and School Survey Results			survey.html
33	Rigorous Instruction: % Positive	SchoolSurvey.csv	school_name: High school's name Borough: The five NYC boroughs Grad_Rate: The school-level graduation rates Rigorous_Instr: The percentage of positive responses on Rigorous Instruction Collaborative: The percentage of positive responses on Collaborative Teachers Supportive: The percentage of positive responses on Supportive Environment Leadership: The percentage of positive responses on Effective School Leadership FamilyComm: The percentage of positive responses on Strong Family-Community Ties sTrust: The percentage of positive responses on Trust (whether the relationships between administrators, educators, students, and families are based on trust and respect)
34	Collaborative Teachers: % Positive
35	Supportive Environment: % Positive
36	Effective Leadership: % Positive
37	Family-Community Ties: % Positive
38	Trust and Respect: % Positive