In [1]:

%%javascript
IPython.OutputArea.prototype._should_scroll = function(lines) {
    return false;
}

Introduction¶

Public schools in the US represent a broad cross section of the regional population. They also tend to have robust and consistent collections of data. This data set is from New York City (NYC) public school surveys of the 2011-2012 school year. It consists of 161 columns of information for 363 schools.

Summary¶

Schools with below average assessment of safety and respect have below average results on the SAT.
Initial analysis shows a negative correlation between the percentage of Hispanic students and SAT results. This relationship is not seen in results on the AP exam. Furthermore, when magnet schools and international schools are removed from the data set, the remaining 90% of schools show a fairly uniform distribution and the correlation is lost.
A small group of schools share SAT scores and AP exam values. This could be due to a cohort of students that is shared among the schools. Their influence on the original data set needs to be considered before further analysis is made.

Data Cleaning¶

Read in the data¶

In [2]:

import pandas as pd
import numpy
import re
import pprint
pd.options.display.float_format = '{:20,.4f}'.format
pd.set_option('display.max_rows', None)
pd.set_option('display.max_columns', None)
pd.set_option('display.width', 3000)
pd.set_option('display.colheader_justify', 'center')
pd.set_option('display.precision', 3)

data_files = [
    "ap_2010.csv",
    "class_size.csv",
    "demographics.csv",
    "graduation.csv",
    "hs_directory.csv",
    "sat_results.csv"
]

data = {}

for f in data_files:
    d = pd.read_csv("schools/{0}".format(f))
    data[f.replace(".csv", "")] = d

Read in the surveys¶

In [3]:

all_survey = pd.read_csv("schools/survey_all.txt", delimiter="\t", encoding='windows-1252')
d75_survey = pd.read_csv("schools/survey_d75.txt", delimiter="\t", encoding='windows-1252')
survey = pd.concat([all_survey, d75_survey], axis=0)

survey["DBN"] = survey["dbn"]

survey_fields = [
    "DBN", 
    "rr_s", 
    "rr_t", 
    "rr_p", 
    "N_s", 
    "N_t", 
    "N_p", 
    "saf_p_11", 
    "com_p_11", 
    "eng_p_11", 
    "aca_p_11", 
    "saf_t_11", 
    "com_t_11", 
    "eng_t_11", 
    "aca_t_11", 
    "saf_s_11", 
    "com_s_11", 
    "eng_s_11", 
    "aca_s_11", 
    "saf_tot_11", 
    "com_tot_11", 
    "eng_tot_11", 
    "aca_tot_11",
]
survey = survey.loc[:,survey_fields]
data["survey"] = survey

/var/folders/tf/f9bv6m516pjcr2ytmmh92cw00000gn/T/ipykernel_3180/3674931809.py:5: PerformanceWarning: DataFrame is highly fragmented.  This is usually the result of calling `frame.insert` many times, which has poor performance.  Consider joining all columns at once using pd.concat(axis=1) instead.  To get a de-fragmented frame, use `newframe = frame.copy()`
  survey["DBN"] = survey["dbn"]

Add DBN columns¶

In [4]:

data["hs_directory"]["DBN"] = data["hs_directory"]["dbn"]

def pad_csd(num):
    string_representation = str(num)
    if len(string_representation) > 1:
        return string_representation
    else:
        return "0" + string_representation
    
data["class_size"]["padded_csd"] = data["class_size"]["CSD"].apply(pad_csd)
data["class_size"]["DBN"] = data["class_size"]["padded_csd"] + data["class_size"]["SCHOOL CODE"]

Convert columns to numeric¶

In [5]:

cols = ['SAT Math Avg. Score', 'SAT Critical Reading Avg. Score', 'SAT Writing Avg. Score']
for c in cols:
    data["sat_results"][c] = pd.to_numeric(data["sat_results"][c], errors="coerce")

data['sat_results']['sat_score'] = data['sat_results'][cols[0]] + data['sat_results'][cols[1]] + data['sat_results'][cols[2]]

def find_lat(loc):
    coords = re.findall("\(.+, .+\)", loc)
    lat = coords[0].split(",")[0].replace("(", "")
    return lat

def find_lon(loc):
    coords = re.findall("\(.+, .+\)", loc)
    lon = coords[0].split(",")[1].replace(")", "").strip()
    return lon

data["hs_directory"]["lat"] = data["hs_directory"]["Location 1"].apply(find_lat)
data["hs_directory"]["lon"] = data["hs_directory"]["Location 1"].apply(find_lon)

data["hs_directory"]["lat"] = pd.to_numeric(data["hs_directory"]["lat"], errors="coerce")
data["hs_directory"]["lon"] = pd.to_numeric(data["hs_directory"]["lon"], errors="coerce")

Condense datasets¶

In [6]:

class_size = data["class_size"]
class_size = class_size[class_size["GRADE "] == "09-12"]
class_size = class_size[class_size["PROGRAM TYPE"] == "GEN ED"]

class_size = class_size.groupby("DBN").agg(numpy.mean)
class_size.reset_index(inplace=True)
data["class_size"] = class_size

data["demographics"] = data["demographics"][data["demographics"]["schoolyear"] == 20112012]

data["graduation"] = data["graduation"][data["graduation"]["Cohort"] == "2006"]
data["graduation"] = data["graduation"][data["graduation"]["Demographic"] == "Total Cohort"]

Convert AP scores to numeric¶

In [7]:

cols = ['AP Test Takers ', 'Total Exams Taken', 'Number of Exams with scores 3 4 or 5']

for col in cols:
    data["ap_2010"][col] = pd.to_numeric(data["ap_2010"][col], errors="coerce")

Combine the datasets¶

In [8]:

combined = data["sat_results"]

combined = combined.merge(data["ap_2010"], on="DBN", how="left")
combined = combined.merge(data["graduation"], on="DBN", how="left")

to_merge = ["class_size", "demographics", "survey", "hs_directory"]

for m in to_merge:
    combined = combined.merge(data[m], on="DBN", how="inner")

combined = combined.fillna(combined.mean())
combined = combined.fillna(0)

/var/folders/tf/f9bv6m516pjcr2ytmmh92cw00000gn/T/ipykernel_3180/3398560250.py:11: FutureWarning: Dropping of nuisance columns in DataFrame reductions (with 'numeric_only=None') is deprecated; in a future version this will raise TypeError.  Select only valid columns before calling the reduction.
  combined = combined.fillna(combined.mean())

Add a school district column for mapping¶

In [9]:

def get_first_two_chars(dbn):
    return dbn[0:2]

combined["school_dist"] = combined["DBN"].apply(get_first_two_chars)

Correlations & Analysis¶

Plotting survey correlations¶

In [10]:

# determine correlations
correlations = combined.corr()
correlations = correlations["sat_score"]

# bar plot for correlations between survey_fields and sat_score
import matplotlib.pyplot as plt
correlations.loc["rr_s":"aca_tot_11"].plot.barh()
plt.show()

Observations¶

It looks like the strongest correlations are between the SAT scores and the number of parents or students that respond to the survey. The response rate, on the other hand, is not correlated. This discrepancy might be worth looking at.

Additional correlations are between SAT scores and two other factors, the students academic expectations and the perception of safety and respect by students, teachers, and parents. The next two sections look at each. ## SAT Scores & Safety Scores

In [11]:

# create melted df from combined preserving school borough & DBN, sat_score,  and safety scores
boroughs_long = combined[["boro", "DBN", "sat_score", "saf_s_11", "saf_t_11", "saf_p_11", "saf_tot_11"]]
boroughs_columns = ["borough", "DBN", "sat_score", "safety_student", "safety_teacher", "safety_parent", "safety_total"]
boroughs_long.columns = boroughs_columns
boroughs_long = boroughs_long.melt(id_vars=["borough", "DBN", "sat_score"])

# scatter plot with borough, sat_score, and safety scores (0-10)
# plots are for student, teacher, parent, and total safety scores
import seaborn as sns
sns.relplot(data=boroughs_long, x="value", y="sat_score", hue="borough", col="variable", col_wrap=2)
plt.show()

In [12]:

# mean value for sat_score and safety scores, grouped by borough
boroughs_means = combined.groupby("boro").mean()
boroughs_means = boroughs_means[["sat_score", "saf_s_11", "saf_t_11", "saf_p_11", "saf_tot_11"]]
boroughs_means.reset_index(inplace=True)
boroughs_columns = ["borough", "sat_score", "safety_student", "safety_teacher", "safety_parent", "safety_total"]
boroughs_means.columns = boroughs_columns
display(boroughs_means)

	borough	sat_score	safety_student	safety_teacher	safety_parent	safety_total
0	Bronx	1,157.5982	6.6066	7.0269	8.3462	7.3226
1	Brooklyn	1,181.3645	6.3708	6.9858	8.0368	7.1292
2	Manhattan	1,278.3314	6.8314	7.2878	8.2889	7.4733
3	Queens	1,286.7530	6.7219	7.3656	8.0984	7.3875
4	Staten Island	1,382.5000	6.5300	7.2100	7.8000	7.2000

Observations¶

The scatter plots show two areas influencing the correlation between SAT scores and perceptions of safety and respect. First, the highest SAT scores come from schools with above average perceptions of safety and respect. Second, it looks like most schools have both SAT and safety and respect scores below the median values. It is also interesting that parents have a noticeably higher perception of safety and respect than either teachers or students.

Grouping schools by borough and averaging scores paints a different picture. This seems to indicate that SAT scores and perception of safety do not have a strong positive correlation at all. For instance, Staten Island has the highest average SAT scores and Bronx the lowest. However, the student and parent perception of safety and respect scores are higher in the Bronx than in Staten Island. And while Manhattan has the highest total safety and respect scores, it ranks in the middle for SAT scores. So while using mean for comparison is a start, the scatter plot charts show a much more granular view that is closer to reality. ## SAT Scores & Student Academic Expectations

In [13]:

# scatter plot with borough, sat_score, and academic expectations (0-10)
sns.relplot(data=combined, x="aca_s_11", y="sat_score", hue="boro")
plt.show()

Observations¶

The academic expectation scatter plot shows similar results to those for perception of safety and respect. Again, there are very few schools in the upper half of the academic expectation scores, and among them about half have better than average SAT scores. Also, we see that most schools have both SAT scores and academic expectations that are below the median value.

SAT Scores & Demographics on Race/Ethnicity¶

Taking an objective look at the relationship between race & ethnicity and SAT scores in NYC schools can help in creating an egalitarian public school system that delivers success to all students.

In [14]:

# make bar plot for correlations between race & ethnicity and sat_score
correlations.loc[["asian_per", "black_per", "hispanic_per", "white_per"]].plot.barh()
plt.show()

In [15]:

# scatter plot for sat_scores and percent Hispanic
sns.relplot(data=combined, x="hispanic_per", y="sat_score", hue="boro")
plt.show()

Observations¶

The bar chart for race & ethnicity paints a stark picture, showing a moderately strong negative correlation between SAT scores and the percentage of Hispanic students in the school. That being said, the scatter plot suggests something a little more nuanced.

The highest SAT scores (over 1500) occur in schools with a low percentage of Hispanic students, but this is only about 6% of the schools in the data set. These seem to be magnet schools, which draw the best students from any demographic. There are about 5-10 schools that show close to 100% Hispanic student populations. These schools have low SAT scores, a closer look might show relevant factors. It looks like most of the schools (i.e. school-wide average of less than 1500 on the SAT and student population less than 95% percent Hispanic) have a more even distribution of SAT scores.

As a side note, almost all the schools in the Bronx have more than half the student population identifying as Hispanic. There are just a few with less than 40% Hispanic, and two of these schools score the highest SAT averages.

That creates three groups of schools, with one group being divided again in two. The following sections take a look at each. ## Group 1, High SAT scores

In [16]:

# create high_sat data set
high_sat = combined["Name"][combined["sat_score"] > 1500]
high_sat = high_sat.str.strip()
high_sat_bronx = combined["Name"][(combined["sat_score"] > 1500) & (combined["boro"]=="Bronx")]
display(high_sat)
print(len(high_sat))
print(len(combined))
display(high_sat_bronx)

4           NEW EXPLORATIONS INTO SCIENCE TECH AND MATH
5                        BARD HIGH SCHOOL EARLY COLLEGE
22             PROFESSIONAL PERFORMING ARTS HIGH SCHOOL
23                    BARUCH COLLEGE CAMPUS HIGH SCHOOL
24             NYC LAB SCHOOL FOR COLLABORATIVE STUDIES
26                        ELEANOR ROOSEVELT HIGH SCHOOL
27                               MILLENNIUM HIGH SCHOOL
37                               STUYVESANT HIGH SCHOOL
60                                   BEACON HIGH SCHOOL
61     FIORELLO H. LAGUARDIA HIGH SCHOOL OF MUSIC & ART
79      HIGH SCHOOL FOR MATHEMATICS SCI AND ENGINEERING
151                        BRONX HIGH SCHOOL OF SCIENCE
155    HIGH SCHOOL OF AMERICAN STUDIES AT LEHMAN COLLEG
187                      BROOKLYN TECHNICAL HIGH SCHOOL
198                                      BROOKLYN LATIN
278      LEON M. GOLDSTEIN HIGH SCHOOL FOR THE SCIENCES
287                   BARD HIGH SCHOOL EARLY COLLEGE II
302                         TOWNSEND HARRIS HIGH SCHOOL
304                     BENJAMIN N. CARDOZO HIGH SCHOOL
314                                THE SCHOLARS ACADEMY
325    QUEENS GATEWAY TO HEALTH SCIENCES SECONDARY SCHO
327     QUEENS HIGH SCHOOL FOR SCIENCES AT YORK COLLEGE
346           BACCALAUREATE SCHOOL FOR GLOBAL EDUCATION
356                 STATEN ISLAND TECHNICAL HIGH SCHOOL
Name: Name, dtype: object

24
363

151    BRONX HIGH SCHOOL OF SCIENCE                    
155    HIGH SCHOOL OF AMERICAN STUDIES AT LEHMAN COLLEG
Name: Name, dtype: object

Observations¶

Sure enough, most of these schools sound pretty brainy. The two in the Bronx included.

Group 2, Hispanic Student Population Over 95%¶

In [17]:

# create hispanic_per_95 data set
import numpy as np
columns = combined.iloc[:,[0,1,6,34,8,9,10,60,70]]
hispanic_per_95 = columns[combined["hispanic_per"] > 95]
display(hispanic_per_95)

	DBN	SCHOOL NAME	sat_score	NUMBER OF STUDENTS / SEATS FILLED	AP Test Takers	Total Exams Taken	Number of Exams with scores 3 4 or 5	ell_percent	hispanic_per
44	02M542	MANHATTAN BRIDGES HIGH SCHOOL	1,058.0000	107.1875	67.0000	102.0000	59.0000	72.6000	99.8000
82	06M348	WASHINGTON HEIGHTS EXPEDITIONARY LEARNING SCHOOL	1,174.0000	74.2000	129.0288	197.0385	153.4500	19.6000	96.7000
89	06M552	GREGORIO LUPERON HIGH SCHOOL FOR SCIENCE AND M...	1,014.0000	163.6154	88.0000	138.0000	73.0000	89.6000	99.8000
125	09X365	ACADEMY FOR LANGUAGE AND TECHNOLOGY	951.0000	110.2143	20.0000	20.0000	20.0000	86.6000	99.4000
141	10X342	INTERNATIONAL SCHOOL FOR LIBERAL ARTS	934.0000	141.6923	55.0000	73.0000	45.0000	79.9000	99.8000
176	12X388	PAN AMERICAN INTERNATIONAL HIGH SCHOOL AT MONROE	970.0000	119.1538	129.0288	197.0385	153.4500	92.9000	99.8000
253	19K583	MULTICULTURAL HIGH SCHOOL	887.0000	115.1667	44.0000	44.0000	39.0000	94.6000	99.8000
286	24Q296	PAN AMERICAN INTERNATIONAL HIGH SCHOOL	951.0000	116.0667	129.0288	197.0385	153.4500	91.3000	100.0000

Observations¶

This set of schools has the highest percentage of students identifying as Hispanic. The SAT scores all fall within the bottom quartile, with five of them scoring in the lowest tenth all the schools. The schools are further differentiated by having high percentages of students where English is a second language. The exception to this is the Washington Heights Expeditionary Learning School. All of the schools show a good percentage of passing scores on AP Exams.

Some people would consider AP Exam pass rate as a proxy for academic achievement. This combined with the large number of ELL students suggests that these SAT scores may be non-representational for some groups of NYC public school students.

Group 3, The Majority of the Schools¶

In [18]:

# create majority data set
majority = combined[(combined["sat_score"] < 1500) & (combined["hispanic_per"] < 95)]

# scatter plot for sat_scores and majority of schools
sns.relplot(data=majority, x="hispanic_per", y="sat_score", hue="boro")
plt.show()

In [19]:

# correlations between race & ethnicity and sat_score in the majority of schools
majority_correlations = majority.corr()
majority_correlations = majority_correlations["sat_score"]
majority_correlations.loc[["asian_per", "black_per", "hispanic_per", "white_per"]].plot.barh()
plt.show()

Observations¶

Removing the schools with the highest percentage of Hispanic students (this includes many international and ELL students) and the schools with SAT scores over 1500 shows a more uniform distribution of SAT scores but still accounts for 91% of the schools in the original data set. The correlation between SAT scores and percentage of students identifying as Hispanic drops to less than -0.2.

SAT Scores & Gender¶

Information on student gender percentages is also available.

In [20]:

# bar plot for correlations between gender percentage and sat_score
correlations.loc[["female_per", "male_per"]].plot.barh()
plt.show()

In [21]:

# scatter plots for sat_scores and gender
import matplotlib.pyplot as plt
genders = combined[["boro", "DBN", "SCHOOL NAME", "sat_score", "female_per", "male_per"]]
genders_melt = genders.melt(id_vars=["boro", "DBN", "SCHOOL NAME", "sat_score"])
sns.relplot(data=genders_melt, x="value", y="sat_score", hue="boro", col="variable")
plt.show()

In [22]:

# caluculate percentage female to male
all_the_kids = combined["NUMBER OF STUDENTS / SEATS FILLED"]
per_female = combined["female_per"].mean()
per_male = combined["male_per"].mean()
print("Total students =", all_the_kids.sum())
print("Percent female =", per_female)
print("Percent male =", per_male)

Total students = 62349.76177031602
Percent female = 50.62066115702485
Percent male = 49.37851239669419

In [23]:

# create sat_score over 1700 data set with female and male percentages
smart_kids = genders.iloc[:,2:6][genders["sat_score"] > 1700]
display(smart_kids)

	SCHOOL NAME	sat_score	female_per	male_per
5	BARD HIGH SCHOOL EARLY COLLEGE	1,856.0000	68.7000	31.3000
26	ELEANOR ROOSEVELT HIGH SCHOOL	1,758.0000	67.5000	32.5000
37	STUYVESANT HIGH SCHOOL	2,096.0000	40.7000	59.3000
60	BEACON HIGH SCHOOL	1,744.0000	61.0000	39.0000
61	FIORELLO H. LAGUARDIA HIGH SCHOOL OF MUSIC & A...	1,707.0000	73.6000	26.4000
79	HIGH SCHOOL FOR MATHEMATICS, SCIENCE AND ENGIN...	1,847.0000	34.2000	65.8000
151	BRONX HIGH SCHOOL OF SCIENCE	1,969.0000	42.2000	57.8000
155	HIGH SCHOOL OF AMERICAN STUDIES AT LEHMAN COLLEGE	1,920.0000	46.2000	53.8000
187	BROOKLYN TECHNICAL HIGH SCHOOL	1,833.0000	41.7000	58.3000
198	BROOKLYN LATIN SCHOOL, THE	1,740.0000	45.1000	54.9000
302	TOWNSEND HARRIS HIGH SCHOOL	1,910.0000	71.1000	28.9000
327	QUEENS HIGH SCHOOL FOR THE SCIENCES AT YORK CO...	1,868.0000	43.5000	56.5000
356	STATEN ISLAND TECHNICAL HIGH SCHOOL	1,953.0000	43.0000	57.0000

Observations¶

Three things from the results stand out.

First, the ratio of male to female students seems to have little to no effect on SAT scores.

Second, among the schools with SAT scores over 1700, there are five with over 60% female students and two with over 70%. There is only one with over 60% male students and none with over 70%. The two schools with the highest number of females are Townsend Harris High School (consistently ranked among the 100 best high schools in America) and LaGuardia High School. Both are magnet schools. The two schools with the highest average SAT scores are Stuyvesant High School (59% male) and Bronx High School of Science (58% male). Both of these are also magnet schools.

Third, particularly interesting from a stats point of view, is that the gender break down among all the schools is so close to fifty-fifty. About 50.62% of the students are female and 49.37% male. ## SAT Scores & AP Exams Advanced Placement (AP) courses are college preparatory classes in the US, and are scored on a 1-5 scale. Scores of 3 and above often receive credit in US colleges and universities. AP Exam scores can be seen as a proxy for academic success, similar to SAT scores. This data set provides a good look at how the two are related.

In [24]:

# create a column with percent of total sudents who took ap exams
combined["ap_per"] = combined["AP Test Takers "]/combined["total_enrollment"]
# scatter plot for ap_per and gender
sns.relplot(data=combined, x="ap_per", y="sat_score", hue="boro")
plt.show()

In [25]:

# examine schools with high percentage of students taking ap exam
all_ap = combined[["SCHOOL NAME", "sat_score", "ap_per"]][combined["ap_per"] > 0.5]
display(all_ap)

	SCHOOL NAME	sat_score	ap_per
6	47 THE AMERICAN SIGN LANGUAGE AND ENGLISH SECO...	1,182.0000	0.7415
20	THE HIGH SCHOOL FOR LANGUAGE AND DIPLOMACY	1,223.4388	0.5288
31	MANHATTAN ACADEMY FOR ARTS & LANGUAGE	1,223.4388	0.7373
32	HUDSON HIGH SCHOOL OF LEARNING TECHNOLOGIES	1,223.4388	0.5709
33	INTERNATIONAL HIGH SCHOOL AT UNION SQUARE	1,223.4388	0.7331
39	UNITY CENTER FOR URBAN TECHNOLOGIES	1,070.0000	0.5444
43	REPERTORY COMPANY HIGH SCHOOL FOR THEATRE ARTS	1,253.0000	0.5946
50	HUMANITIES PREPARATORY ACADEMY	1,255.0000	0.6720
59	FRANK MCCOURT HIGH SCHOOL	1,223.4388	0.5892
83	HIGH SCHOOL FOR EXCELLENCE AND INNOVATION	1,223.4388	0.7249
111	BRONX BRIDGES HIGH SCHOOL	1,223.4388	0.8324
155	HIGH SCHOOL OF AMERICAN STUDIES AT LEHMAN COLLEGE	1,920.0000	0.5146
177	THE CINEMA SCHOOL	1,223.4388	0.5786
178	BRONX CAREER AND COLLEGE PREPARATORY HIGH SCHOOL	1,223.4388	0.5288
208	FRANCES PERKINS ACADEMY	1,122.0000	0.7458
209	EL PUENTE ACADEMY FOR PEACE AND JUSTICE	1,035.0000	0.5919
222	THE BROOKLYN ACADEMY OF GLOBAL FINANCE	1,223.4388	0.8115
272	LIFE ACADEMY HIGH SCHOOL FOR FILM AND MUSIC	1,124.0000	0.5141
273	EXPEDITIONARY LEARNING SCHOOL FOR COMMUNITY LE...	1,079.0000	0.5709
302	TOWNSEND HARRIS HIGH SCHOOL	1,910.0000	0.5377
321	HILLSIDE ARTS & LETTERS ACADEMY	1,223.4388	0.6451
327	QUEENS HIGH SCHOOL FOR THE SCIENCES AT YORK CO...	1,868.0000	0.5144
335	CAMBRIA HEIGHTS ACADEMY	1,223.4388	0.8777

In [26]:

# schools with sat_score == 1223.4388
twelvetwentythree = combined[(1223 < combined["sat_score"]) & (combined["sat_score"] < 1224)]
display(twelvetwentythree)

	DBN	SCHOOL NAME	Num of SAT Test Takers	SAT Critical Reading Avg. Score	SAT Math Avg. Score	SAT Writing Avg. Score	sat_score	SchoolName	AP Test Takers	Total Exams Taken	Number of Exams with scores 3 4 or 5	Demographic	School Name	Cohort	Total Cohort	Total Grads - n	Total Grads - % of cohort	Total Regents - n	Total Regents - % of cohort	Total Regents - % of grads	Advanced Regents - n	Advanced Regents - % of cohort	Advanced Regents - % of grads	Regents w/o Advanced - n	Regents w/o Advanced - % of cohort	Regents w/o Advanced - % of grads	Local - n	Local - % of cohort	Local - % of grads	Still Enrolled - n	Still Enrolled - % of cohort	Dropped Out - n	Dropped Out - % of cohort	CSD	NUMBER OF STUDENTS / SEATS FILLED	NUMBER OF SECTIONS	AVERAGE CLASS SIZE	SIZE OF SMALLEST CLASS	SIZE OF LARGEST CLASS	Name	schoolyear	frl_percent	total_enrollment	grade6	grade7	grade8	grade9	grade10	grade11	grade12	ell_num	ell_percent	sped_num	sped_percent	ctt_num	selfcontained_num	asian_num	asian_per	black_num	black_per	hispanic_num	hispanic_per	white_num	white_per	male_num	male_per	female_num	female_per	rr_s	rr_t	rr_p	N_s	N_t	N_p	saf_p_11	com_p_11	eng_p_11	aca_p_11	saf_t_11	com_t_11	eng_t_11	aca_t_11	saf_s_11	com_s_11	eng_s_11	aca_s_11	saf_tot_11	com_tot_11	eng_tot_11	aca_tot_11	dbn	school_name	boro	building_code	phone_number	fax_number	grade_span_min	grade_span_max	expgrade_span_max	bus	subway	primary_address_line_1	city	state_code	zip	website	total_students	campus_name	school_type	overview_paragraph	program_highlights	language_classes	advancedplacement_courses	online_ap_courses	online_language_courses	extracurricular_activities	psal_sports_boys	psal_sports_girls	psal_sports_coed	school_sports	partner_cbo	partner_hospital	partner_highered	partner_cultural	partner_nonprofit	partner_corporate	partner_financial	partner_other	addtl_info1	addtl_info2	start_time	end_time	se_services	ell_programs	school_accessibility_description	number_programs	priority01	priority02	priority03	priority04	priority05	priority06	Location 1	lat	lon	school_dist	ap_per
18	02M392	MANHATTAN BUSINESS ACADEMY	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2.0000	57.7143	2.2857	25.2571	23.4286	27.0000	MANHATTAN BUSINESS ACADEMY	20112012	64.0000	332				148	91	93		33.0000	9.9000	46.0000	13.9000	38	2	22	6.6000	98	29.5000	195	58.7000	16	4.8000	196.0000	59.0000	136.0000	41.0000	83.0000	94	40	172.0000	17.0000	81.0000	8.3000	8.0000	7.6000	8.2000	7.4000	7.5000	7.5000	8.2000	6.9000	6.4000	6.8000	7.5000	7.5000	7.3000	7.3000	8.0000	02M392	MANHATTAN BUSINESS ACADEMY	Manhattan	M440	212-647-1983	212-647-1989	9	12	12.0000	M11, M14A, M14D, M20, M23, M7	1 to 18th St ; 2, 3, F, M to 14th St ; A, C, E...	351 West 18 Street	New York	NY	10011	www.manhattanbusinessacademy.org	426.0000	Bayard Rustin Educational Campus	0	We are a small community committed to creating...	4 years of core courses in Math, Science, Engl...	Spanish	Statistics	0	French, Spanish	Burton Chill Programs: Snowboarding (Winter) a...	Baseball, Basketball & JV Basketball, Soccer, ...	Basketball & JV Basketball, Soccer, Softball, ...	Bowling	Intramural Basketball, Cheerleading	Virtual Enterprises International	Mount Sinai	Baruch College College Now, BMCC College Now, ...	Student Press Initiative	Futures and Option: Career Essentials Program,...	Deloitte, Advent Solutions	0	Institute for Student Achievement	After-school tutoring, PSAT and SAT prep class...	0	8:30 AM	3:15 PM	This school will provide students with disabil...	ESL	Functionally Accessible	1	Priority to Manhattan students or residents wh...	Then to New York City residents who attend an ...	Then to Manhattan students or residents	Then to New York City residents	0	0	351 West 18 Street\nNew York, NY 10011\n(40.74...	40.7429	-74.0021	02	0.3886
19	02M393	BUSINESS OF SPORTS SCHOOL	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2.0000	110.1429	5.0000	22.1286	16.1429	26.4286	THE BUSINESS OF SPORTS SCHOOL	20112012	58.7000	304				150	114	40		23.0000	7.6000	65.0000	21.4000	37	4	5	1.6000	108	35.5000	174	57.2000	13	4.3000	220.0000	72.4000	84.0000	27.6000	92.0000	100	39	194.0000	18.0000	80.0000	8.1000	7.6000	7.5000	7.9000	6.2000	5.8000	6.6000	7.0000	6.2000	6.1000	6.3000	7.0000	6.8000	6.5000	6.8000	7.3000	02M393	BUSINESS OF SPORTS SCHOOL	Manhattan	M625	212-246-2183	212-246-2913	9	12	12.0000	M10, M104, M11, M20, M31, M34A-SBS, M42, M50, ...	1, C, E to 50th St ; A to 42nd St-Port Authori...	439 West 49Th Street	New York	NY	10019	www.nycBOSS.org	420.0000	Graphics Educational Campus	CTE School	We are a small Career & Technical Education (C...	Students may receive CTE endorsement in Entrep...	Spanish	English Language and Composition, Environmenta...	0	French, Spanish	College Guidance, Computer Tech, Dance, Future...	Baseball & JV Baseball, Basketball & JV Basket...	Basketball, Softball	Bowling, Handball, Outdoor Track	BOSS has a Varsity Soccer team in the SSAL.	Federation Employment and Guidance Services, I...	0	St. John's University, Borough of Manhattan Co...	0	New Visions for Public Schools, iMentor	ESPN The Magazine, The Crons Brand, Morgan Sta...	0	Virtual Enterprises, Network for the Teaching ...	Business Dress Code Required: On certain days,...	Community Service Requirement, Extended Day Pr...	8:50 AM	3:30 PM	This school will provide students with disabil...	ESL	Not Functionally Accessible	1	Priority to Manhattan students or residents wh...	Then to New York City residents who attend an ...	Then to Manhattan students or residents	Then to New York City residents	0	0	439 West 49Th Street\nNew York, NY 10019\n(40....	40.7634	-73.9905	02	0.4244
20	02M399	THE HIGH SCHOOL FOR LANGUAGE AND DIPLOMACY	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2.0000	87.3636	5.0000	17.8545	14.0909	24.0000	THE HIGH SCHOOL FOR LANGUAGE AND DIPLOMACY	20112012	80.8000	244				109	57	78		69.0000	28.3000	41.0000	16.8000	14	15	108	44.3000	38	15.6000	80	32.8000	13	5.3000	117.0000	48.0000	127.0000	52.0000	84.0000	50	36	123.0000	7.0000	52.0000	8.1000	7.3000	7.1000	7.3000	6.3000	3.2000	4.1000	5.0000	6.6000	5.7000	6.3000	6.9000	7.0000	5.4000	5.8000	6.4000	02M399	THE HIGH SCHOOL FOR LANGUAGE AND DIPLOMACY	Manhattan	M460	212-253-2480	212-253-2539	9	12	12.0000	M101, M102, M103, M14A, M14D, M15, M2, M23, M3...	1, 2, 3, F, M to 14th St - 6th Ave ; 4, 5, 6, ...	40 Irving Place	New York	NY	10003	www.hsflad.org	358.0000	Washington Irving Educational Campus	0	A member of the Asia Society International Stu...	Intensive Chinese Language Program for all stu...	American Sign Language, Arabic, Chinese (Manda...	Biology, Calculus BC, Chinese Language and Cul...	0	0	IRIS Literary Magazine, Chess, Japanese, Journ...	Baseball, Basketball, Handball, Soccer, Volley...	Basketball & JV Basketball, Softball, Volleyball	Outdoor Track	As we expand, we plan to offer Intramural Spor...	The United Nations Association of the United S...	Beth Israel campus/school-based Health Center ...	New York University	Rueben Museum	YMCA	0	0	Asia Society International Studies Schools Net...	Senior Year Internship	Community Service Requirement, Dress Code Requ...	8:00 AM	3:30 PM	This school will provide students with disabil...	ESL	Functionally Accessible	1	Priority to Manhattan students or residents wh...	Then to New York City residents who attend an ...	Then to Manhattan students or residents	Then to New York City residents	0	0	40 Irving Place\nNew York, NY 10003\n(40.73551...	40.7355	-73.9876	02	0.5288
31	02M427	MANHATTAN ACADEMY FOR ARTS & LANGUAGE	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2.0000	94.0000	4.4000	23.0200	16.6000	27.0000	MANHATTAN ACADEMY FOR ARTS & LANGUAGE	20112012	97.5000	175				94	81			152.0000	86.9000	12.0000	6.9000	7	2	11	6.3000	14	8.0000	148	84.6000	2	1.1000	96.0000	54.9000	79.0000	45.1000	95.0000	100	39	82.0000	8.0000	32.0000	9.0000	8.6000	8.1000	8.3000	9.0000	9.0000	9.7000	9.6000	7.7000	6.0000	7.3000	7.6000	8.6000	7.8000	8.4000	8.5000	02M427	MANHATTAN ACADEMY FOR ARTS & LANGUAGE	Manhattan	M620	212-576-0502	212-576-0518	9	12	12.0000	M101, M102, M15, M15-SBS, M2, M34A-SBS, M34-SB...	4, 5, 7, G, S to Grand Central - 42nd St ; 6 t...	111 East 33Rd Street	New York	NY	10016	www.maalnyc.org	312.0000	Norman Thomas Educational Campus	0	Our mission is to provide a high-quality educa...	Freestanding ESL, Transitional Bilingual Educa...	Spanish	0	0	0	Strings Program, Leadership, Student Governmen...	Baseball, Basketball	Basketball, Softball, Volleyball	0	0	0	0	Hunter College	Urban Arts Partnership, National Dance Institu...	0	0	0	0	Dress Code Required: black polo shirt, beige/t...	0	9:00 AM	3:40 PM	This school will provide students with disabil...	ESL; Transitional Bilingual Program: Spanish	Functionally Accessible	1	Open only to New York City residents who are E...	0	0	0	0	0	111 East 33Rd Street\nNew York, NY 10016\n(40....	40.7461	-73.9810	02	0.7373
32	02M437	HUDSON HIGH SCHOOL OF LEARNING TECHNOLOGIES	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2.0000	84.0000	3.0000	28.0000	27.0000	29.0000	HUDSON HIGH SCHOOL OF LEARNING TECHNOLOGIES	20112012	61.5000	226				122	104			20.0000	8.8000	37.0000	16.4000	14	10	13	5.8000	53	23.5000	141	62.4000	15	6.6000	137.0000	60.6000	89.0000	39.4000	94.0000	100	73	102.0000	10.0000	80.0000	8.7000	7.6000	7.4000	7.7000	8.7000	8.9000	9.4000	9.4000	7.0000	7.0000	6.9000	7.5000	8.1000	7.8000	7.9000	8.2000	02M437	Hudson High School of Learning Technologies	Manhattan	M440	212-488-3330	212-488-3335	9	12	12.0000	M11, M14A, M14D, M20, M23, M7	1 to 18th St ; 2, 3, F, M to 14th St ; A, C, E...	351 West 18 Street	New York	NY	10011	www.hudsonhs.com	462.0000	Bayard Rustin Educational Campus	0	Hudson High School of Learning Technologies (H...	Core classes are scheduled in rotating blocks;...	Spanish	0	Biology, Calculus AB, English Literature and C...	Chinese, English, French, German, Italian, Latin	Art, Music, Dance, Photography, Knitting, Muse...	Baseball & JV Baseball, Basketball & JV Basket...	Basketball & JV Basketball, Tennis, Volleyball...	Bowling	0	Institute for Students Achievement (ISA)	The Mount Sinai Health Clinic (located on the ...	Bank Street College, Teachers College, New Yor...	Museum of the Moving Image, Museum of Mathemat...	The Stupski Foundation, MOUSE - Empowering You...	0	0	0	Before and after-school program offered, Satur...	Community Service Requirement, Student Summer ...	8:45 AM	3:30 PM	This school will provide students with disabil...	ESL	Functionally Accessible	1	Priority to Manhattan students or residents wh...	Then to New York City residents who attend an ...	Then to Manhattan students or residents	Then to New York City residents	0	0	351 West 18 Street\nNew York, NY 10011\n(40.74...	40.7429	-74.0021	02	0.5709
33	02M438	INTERNATIONAL HIGH SCHOOL AT UNION SQUARE	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2.0000	98.0000	4.0000	24.5000	23.0000	26.0000	INTERNATIONAL HIGH SCHOOL AT UNION SQUARE	20112012	82.8000	176				70	106			167.0000	94.9000	1.0000	0.6000	0	0	71	40.3000	22	12.5000	76	43.2000	6	3.4000	108.0000	61.4000	68.0000	38.6000	86.0000	100	30	82.0000	7.0000	28.0000	8.8000	7.6000	7.4000	8.1000	8.1000	7.9000	8.1000	8.3000	7.5000	6.8000	7.3000	7.3000	8.1000	7.4000	7.6000	7.9000	02M438	International High School at Union Square	Manhattan	M460	212-533-2560	212-228-2946	9	12	12.0000	M101, M102, M103, M14A, M14D, M15, M2, M23, M3...	1, 2, 3, F, M to 14th St - 6th Ave ; 4, 5, 6, ...	40 Irving Place	New York	NY	10003	www.ihs-us.org	339.0000	Washington Irving Educational Campus	International School	The mission of International High School at Un...	English and home language skill development th...	0	0	0	0	Before- and After-school Tutoring, Film, Stude...	Baseball, Baseball & JV Baseball, Basketball, ...	Basketball, Softball, Volleyball & JV Volleyball	Handball	New York Road Runners Team, Biking Club	McBurney YMCA, New York Cares, Arkadium, Day O...	Beth Israel School-based Health Clinic	City Universtiy of New York	0	0	0	0	Member school of the Internationals Network fo...	0	Internship Requirement	8:45 AM	3:05 PM	This school will provide students with disabil...	ESL	Functionally Accessible	1	Open only to New York City residents living in...	0	0	0	0	0	40 Irving Place\nNew York, NY 10003\n(40.73551...	40.7355	-73.9876	02	0.7331
56	03M402	THE URBAN ASSEMBLY SCHOOL FOR GREEN CAREERS	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3.0000	10.0000	1.0000	10.0000	10.0000	10.0000	THE URBAN ASSEMBLY SCHOOL FOR GREEN CAREERS	20112012	73.2000	283				124	84	75		71.0000	25.1000	61.0000	21.6000	33	9	5	1.8000	56	19.8000	215	76.0000	5	1.8000	161.0000	56.9000	122.0000	43.1000	53.0000	30	27	93.0000	6.0000	48.0000	8.2000	7.9000	7.7000	8.0000	4.4000	4.2000	5.2000	5.7000	6.3000	6.4000	6.3000	7.2000	6.3000	6.2000	6.4000	7.0000	03M402	The Urban Assembly School for Green Careers	Manhattan	M470	212-787-1189	212-787-1455	9	12	12.0000	M10, M104, M5, M7, M79, M86	1, B, C to 86th St ; 2, 3 to 96th St	145 West 84 Street	New York	NY	10024	www.uagreencareers.org	395.0000	Louis D. Brandeis Educational Campus	CTE School	The Urban Assembly School for Green Careers (U...	All students must choose a Career and Technica...	Spanish	English Literature and Composition	0	0	Internships with external partners (Friends of...	Baseball, Basketball & JV Basketball, Bowling,...	Basketball, Bowling, Softball, Tennis, Volleyball	0	Intramural Basketball, Yoga	Ace Mentoring NYC Association of Energy Afford...	0	New York City College of Technology, The City ...	0	Urban Assembly, Urban Agenda, Regional Plan As...	Jonathan Rose Companies, Thornton Tomasetti, I...	0	New York State Department of Environmental Con...	We require an Academic Portfolio for graduatio...	0	8:30 AM	3:30 PM	This school will provide students with disabil...	ESL	Functionally Accessible	1	Priority to Manhattan students or residents wh...	Then to New York City residents who attend an ...	Then to Manhattan students or residents	Then to New York City residents	0	0	145 West 84 Street\nNew York, NY 10024\n(40.78...	40.7857	-73.9744	03	0.4559
57	03M403	THE GLOBAL LEARNING COLLABORATIVE	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3.0000	84.4000	3.4000	24.9800	20.0000	30.0000	THE GLOBAL LEARNING COLLABORATIVE	20112012	68.4000	358				192	108	58		69.0000	19.3000	69.0000	19.3000	41	7	13	3.6000	99	27.7000	224	62.6000	21	5.9000	184.0000	51.4000	174.0000	48.6000	79.0000	100	24	162.0000	16.0000	47.0000	8.5000	7.9000	7.7000	7.6000	7.2000	7.6000	8.3000	8.2000	7.0000	6.7000	7.1000	7.4000	7.6000	7.4000	7.7000	7.7000	03M403	The Global Learning Collaborative	Manhattan	M470	212-877-1103	212-877-1138	9	12	12.0000	M10, M104, M5, M7, M79, M86	1, B, C to 86th St ; 2, 3 to 96th St	145 West 84 Street	New York	NY	10024	www.theglcnyc.org	480.0000	Louis D. Brandeis Educational Campus	0	At the Global Learning Collaborative, our goal...	Small Group Advisories, Three-Tiered Recitatio...	Arabic, Chinese (Mandarin), Italian, Spanish	Biology, Calculus AB, English Literature and C...	0	0	Model UN, Mock Trial Team, Cooking, Student Go...	Baseball & JV Baseball, Basketball & JV Basket...	Basketball, Bowling, Soccer, Softball, Tennis,...	0	0	0	St. Luke's Hospital School Based Clinic	Hunter College, Fordham University, Columbia U...	Confucious Classroom, American Council of Inte...	Sights for Students	0	0	International Studies Schools Network/Asia Soc...	0	Community Service Requirement, Extended Day Pr...	8:30 AM	3:30 PM	This school will provide students with disabil...	ESL	Functionally Accessible	1	Priority to Manhattan students or residents wh...	Then to New York City residents who attend an ...	Then to Manhattan students or residents	Then to New York City residents	0	0	145 West 84 Street\nNew York, NY 10024\n(40.78...	40.7857	-73.9744	03	0.3604
59	03M417	FRANK MCCOURT HIGH SCHOOL	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3.0000	75.0000	3.0000	25.0000	24.0000	27.0000	FRANK MCCOURT HIGH SCHOOL	20112012	24.0000	219				131	88			2.0000	0.9000	38.0000	17.4000	14	0	15	6.8000	40	18.3000	81	37.0000	81	37.0000	102.0000	46.6000	117.0000	53.4000	98.0000	100	47	97.0000	8.0000	47.0000	8.4000	7.6000	7.3000	7.6000	6.9000	7.0000	7.0000	7.9000	7.3000	7.3000	7.1000	7.7000	7.5000	7.3000	7.2000	7.8000	03M417	FRANK McCOURT HIGH SCHOOL	Manhattan	M470	212-362-2015	212-362-5926	9	12	12.0000	M10, M104, M5, M7, M79, M86	1, B, C to 86th St ; 2, 3 to 96th St	145 West 84 Street	New York	NY	10024	www.fmhsnyc.org	373.0000	Louis D. Brandeis Educational Campus	0	At Frank McCourt High School (FMHS), we prepar...	Advisory, Inquiry-based cooperative group work...	Spanish	0	0	0	Asian Cultures, Community Cares, Model UN, New...	Baseball & JV Baseball, Basketball & JV Basket...	Bowling, Soccer, Softball, Tennis, Volleyball	0	As we expand, we plan to offer intramural spor...	0	0	0	0	0	0	0	0	Our school uses 'problem-based learning' to de...	0	8:40 AM	3:00 PM	This school will provide students with disabil...	ESL	Functionally Accessible	1	Open to New York City residents	0	0	0	0	0	145 West 84 Street\nNew York, NY 10024\n(40.78...	40.7857	-73.9744	03	0.5892
74	05M362	COLUMBIA SECONDARY SCHOOL FOR MATH, SCIENCE, A...	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	5.0000	84.6667	2.8333	25.3667	24.5000	25.8333	COLUMBIA SECONDARY SCHOOL	20112012	46.3000	474	97	96	95	91	95			3.0000	0.6000	2.0000	0.4000	1	0	55	11.6000	95	20.0000	230	48.5000	87	18.4000	235.0000	49.6000	239.0000	50.4000	91.0000	90	44	343.0000	18.0000	159.0000	7.8000	7.7000	7.5000	8.1000	7.3000	6.9000	7.1000	8.3000	6.9000	6.8000	7.0000	7.4000	7.3000	7.1000	7.2000	7.9000	05M362	Columbia Secondary School	Manhattan	M125	212-666-1278	212-666-3805	6	12	12.0000	Bx15, M10, M100, M101, M104, M11, M2, M3, M4, ...	1, A, B, C, D to 125th St	425 West 123 Street	New York	NY	10027	www.columbiasecondary.org	664.0000	0	0	Columbia Secondary School (CSS) is a 6-12 scho...	Seven-year Math, Science and Engineering progr...	Latin, Spanish, Spanish Native Language Arts	Biology, English Literature and Composition, S...	0	0	Amnesty International, Ancient Egypt, Architec...	0	0	0	Co-ed Fitness Program: Basketball, Biking, Cap...	Double Discovery, Harlem Tutorial Program,Urba...	0	Columbia University, Teachers College	0	0	0	0	0	Uniform Required: dark blue shirt with CSS lo...	0	8:00 AM	4:00 PM	This school will provide students with disabil...	ESL	Functionally Accessible	1	Priority to continuing 8th graders	Then to New York City residents	0	0	0	0	425 West 123 Street\nNew York, NY 10027\n(40.8...	40.8109	-73.9569	05	0.2722
83	06M423	HIGH SCHOOL FOR EXCELLENCE AND INNOVATION	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	6.0000	34.0000	2.0000	17.0000	16.0000	18.0000	HIGH SCHOOL FOR EXCELLENCE AND INNOVATION	20112012	99.2000	178				76	48	54		35.0000	19.7000	61.0000	34.3000	27	10	0	0.0000	46	25.8000	129	72.5000	0	0.0000	94.0000	52.8000	84.0000	47.2000	90.0000	100	73	114.0000	13.0000	90.0000	9.2000	8.6000	8.2000	8.4000	8.2000	7.7000	8.3000	8.7000	7.6000	6.2000	6.5000	7.6000	8.3000	7.5000	7.7000	8.3000	06M423	High School for Excellence and Innovation	Manhattan	M052	212-569-1022	212-569-1190	9	12	12.0000	Bx12-SBS, Bx20, Bx7, M100, M3, M4	1 to Dyckman St ; A to Dyckman St-200th St	650 Academy Street	New York	NY	10034	http://schools.nyc.gov/schoolportals/06/M423	223.0000	0	0	At the High School for Excellence and Innovati...	Saturday Academy and PM School provide student...	Spanish	English Literature and Composition	0	0	Arts and Cultural Trips, Photography Class, Co...	0	0	0	Boys: Baseball, Basketball, Flag Football, Tra...	East Side House (ESH) (provides comprehensive ...	New York-Presbyterian Hospital - Center for Co...	Columbia University Medical Center, Hostos Com...	Educational Video Center, New York City Histor...	Urban ARts- Fresh Prep Program Teen Leadership...	Educators for Social Responsibility, reDesign,...	0	Office of Postsecondary Readiness (Intermediary)	Uniform Required: shirt with school logo, Summ...	Extended Day Program, Student Summer Orientation	8:45 AM	3:30 PM	This school will provide students with disabil...	ESL	Not Functionally Accessible	1	Open only to 15-16-year-old students entering ...	0	0	0	0	0	650 Academy Street\nNew York, NY 10034\n(40.86...	40.8660	-73.9249	06	0.7249
103	08X269	BRONX STUDIO SCHOOL FOR WRITERS AND ARTISTS	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	8.0000	87.7143	3.4286	27.2286	24.2857	30.2857	BRONX STUDIO SCHOOL	20112012	85.6000	500	96	91	77	110	83	43		46.0000	9.2000	67.0000	13.4000	11	41	6	1.2000	112	22.4000	374	74.8000	5	1.0000	220.0000	44.0000	280.0000	56.0000	0.0000	28	17	598.2083	9.0000	62.0000	8.5000	7.6000	7.4000	7.8000	6.4000	6.7000	6.0000	6.9000	6.6117	6.0947	6.6203	7.3814	7.3000	7.0000	6.6000	7.2000	08X269	Bronx Studio School for Writers and Artists	Bronx	X392	718-893-5158	718-893-5982	6	12	12.0000	Bx11, Bx17, Bx19, Bx27, Bx35, Bx4, Bx46, Bx4A,...	2, 5 to Intervale Ave ; 6 to Hunts Point Ave	928 Simpson Street	Bronx	NY	10459	http://schools.nyc.gov/schoolportals/08/X269	540.0000	0	0	Our mission is to provide students of all acad...	Advisory, Leadership Classes, Electives in Lit...	Chinese (Mandarin), Spanish	English Literature and Composition, Environmen...	0	0	Student Council, Student Mediators, Art, Dance...	Rugby	Basketball, Rugby, Volleyball	Cross Country	Boys Basketball Team and Intramural 3-on-3 Bas...	Casita Maria, Inc., F.E.G.S., UNITAS	0	0	Afro-Latin Jazz Aliance	Teaching Matters Inc., Elevate NY	0	0	0	Dress Code Required: short or long-sleeved dar...	0	8:20 AM	3:20 PM	This school will provide students with disabil...	ESL	Not Functionally Accessible	1	Priority to continuing 8th graders	Then to New York City residents who attend an ...	Then to New York City residents	0	0	0	928 Simpson Street\nBronx, NY 10459\n(40.82062...	40.8206	-73.8931	08	0.2581
109	08X376	ANTONIA PANTOJA PREPARATORY ACADEMY, A COLLEGE...	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	8.0000	47.0000	2.0000	23.5000	23.0000	24.0000	ANTONIA PANTOJA PREPARATORY ACADEMY	20112012	81.3000	432	91	97	98	97	49			32.0000	7.4000	104.0000	24.1000	48	35	21	4.9000	120	27.8000	285	66.0000	3	0.7000	203.0000	47.0000	229.0000	53.0000	70.0000	92	20	252.0000	24.0000	68.0000	7.6000	6.7000	6.7000	6.8000	5.1000	3.5000	4.1000	5.1000	5.6000	5.9000	6.2000	7.0000	6.1000	5.4000	5.7000	6.3000	08X376	Antonia Pantoja Preparatory Academy: A College...	Bronx	X450	718-824-3152	718-824-3543	6	12	12.0000	Bx22, Bx27, Bx36, Bx39, Bx5	0	1980 Lafayette Avenue	Bronx	NY	10473	http://schools.nyc.gov/schoolportals/08/X376	466.0000	Adlai E. Stevenson Educational Campus	0	Antonia Pantoja Preparatory Academy (APPA) is ...	Individualized university/college, academic an...	French, Japanese, Spanish	0	0	0	Advisory, Chess, Community Service, Drama, Men...	0	0	0	Baseball, Basketball, Capoeira, Rugby, Soccer,...	0	0	Hostos Community College, Fordham University, ...	0	College Board, The Green Institute, DreamYard,...	0	0	0	Uniform Required: white blouse/button-down shi...	Community Service Requirement, Extended Day Pr...	8:00 AM	2:45 PM	This school will provide students with disabil...	ESL	Functionally Accessible	1	Priority to continuing 8th graders	Then to Bronx students or residents who attend...	Then to New York City residents who attend an ...	Then to Bronx students or residents	Then to New York City residents	0	1980 Lafayette Avenue\nBronx, NY 10473\n(40.82...	40.8223	-73.8560	08	0.2987
111	08X432	BRONX BRIDGES HIGH SCHOOL	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	8.0000	53.4000	3.0000	19.0800	17.2000	21.0000	BRONX BRIDGES HIGH SCHOOL	20112012	87.2000	155				75	80			123.0000	79.4000	12.0000	7.7000	9	3	8	5.2000	13	8.4000	129	83.2000	4	2.6000	81.0000	52.3000	74.0000	47.7000	99.0000	100	81	76.0000	5.0000	61.0000	8.8000	8.3000	7.6000	8.5000	9.3000	7.8000	9.6000	9.8000	6.9000	6.3000	6.6000	7.1000	8.3000	7.5000	7.9000	8.5000	08X432	BRONX BRIDGES HIGH SCHOOL	Bronx	X450	718-829-2984	718-829-2987	9	12	12.0000	Bx22, Bx27, Bx36, Bx39, Bx5	0	1980 Lafayette Avenue	Bronx	NY	10473	www.bronxbridges.org	313.0000	Adlai E. Stevenson Educational Campus	0	Our school is designed for English Language Le...	Small advisory groups led by a faculty mentor;...	French, Spanish	Biology, Calculus AB, Spanish Language and Cul...	French Language and Culture, French Literature	Arabic, Bengali	African Dance, Art, Basketball, Community Just...	Baseball, Basketball, Football & JV Football, ...	Basketball, Bowling, Soccer, Softball, Tennis,...	0	Baseball, Soccer; all PSAL sports listed above...	Good Shepherd Services, Ramapo for Children, Inc.	School Based Health Clinic with Montefiore.	0	0	0	Ernst & Young Mentoring Program	0	0	Dress-Code Required: Please contact the school...	Community Service Requirement	8:00 AM	3:45 PM	This school will provide students with disabil...	ESL	Functionally Accessible	1	Open only to New York City residents who are E...	Priority to Bronx students or residents	Then to New York City residents	0	0	0	1980 Lafayette Avenue\nBronx, NY 10473\n(40.82...	40.8223	-73.8560	08	0.8324
123	09X324	BRONX EARLY COLLEGE ACADEMY FOR TEACHING & LEA...	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	9.0000	83.8750	3.1250	27.9625	26.0000	30.0000	BRONX EARLY COLLEGE ACADEMY FOR TEACHING & LEARN	20112012	79.4000	493	85	91	84	77	75	81		54.0000	11.0000	80.0000	16.2000	21	21	15	3.0000	158	32.0000	318	64.5000	1	0.2000	239.0000	48.5000	254.0000	51.5000	88.0000	88	60	323.0000	22.0000	207.0000	8.5000	8.2000	8.0000	8.1000	6.6000	5.1000	6.1000	6.7000	6.7000	6.7000	7.1000	8.2000	7.3000	6.6000	7.1000	7.7000	09X324	Bronx Early College Academy for Teaching & Lea...	Bronx	X166	718-681-8287	718-681-8650	6	12	12.0000	Bx1, Bx13, Bx2, Bx32, Bx35, Bx41, Bx41-SBS, Bx6	4, B to 161st St-Yankee Stadium ; B, D to 167t...	250 East 164 Street	Bronx	NY	10456	www.bronxearlycollegeacademy.com	508.0000	0	0	Bronx Early College Academy (BECA) is an Inter...	iZone School with blended online classrooms; f...	French, Spanish	0	0	0	After-school Club Day, Bronx Arts Ensemble, Br...	0	0	0	Baseball, Basketball, Flag Football, Track and...	Union Square Hospitality Group	Montefiore Medical Center	Lehman College, City University of New York (C...	Lehman College Art Gallery	Literacy Inc., Learning Leaders, PENCIL, Teach...	0	0	Kaplan, Aussie	Dress Code Required: School Shirt and khaki pa...	Extended Day Program Requirement	8:30 AM	3:15 PM	This school will provide students with disabil...	ESL	Not Functionally Accessible	1	Priority to continuing 8th graders	Then to New York City residents	0	0	0	0	250 East 164 Street\nBronx, NY 10456\n(40.8287...	40.8287	-73.9178	09	0.2617
177	12X478	THE CINEMA SCHOOL	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	12.0000	69.6364	3.0909	22.6909	18.7273	25.0000	THE CINEMA SCHOOL	20112012	75.9000	223				91	61	71		9.0000	4.0000	9.0000	4.0000	1	0	10	4.5000	64	28.7000	145	65.0000	4	1.8000	91.0000	40.8000	132.0000	59.2000	90.0000	100	32	118.0000	10.0000	41.0000	9.0000	8.6000	8.3000	8.8000	9.0000	8.6000	9.2000	9.3000	7.5000	7.1000	7.5000	8.1000	8.5000	8.1000	8.3000	8.7000	12X478	THE CINEMA SCHOOL	Bronx	X423	718-620-2560	718-620-2561	9	12	12.0000	Bx11, Bx27, Bx36, Bx4, Bx4A, Q44	6 to Elder Ave	1551 East 172Nd Street	Bronx	NY	10472	www.thecinemaschool.org	318.0000	James Monroe Educational Annex	0	The Cinema School offers a rich liberal arts e...	Mid-year Animation & Movie Institute: develop ...	0	Biology, Calculus AB, English Language and Com...	0	French, German, Italian, Portuguese, Spanish	Film Screenings, Acting & Directing in Film, F...	Baseball & JV Baseball, Basketball & JV Basket...	Basketball & JV Basketball, Softball, Swimming	0	Archery, Basketball, Capoeira, Open Gym, Volle...	Ghetto Film School, our partner organization, ...	0	City of New York (CUNY) - Lehman College: Coll...	Museum of the Moving Image, Lincoln Center Soc...	0	NewsCorp, Wieden + Kennedy, CNN, JP Morgan Cha...	0	New York Cares	0	Community Service Requirement, Extended Day Pr...	8:30 AM	3:45 PM	This school will provide students with disabil...	ESL	Functionally Accessible	1	Open to New York City residents	0	0	0	0	0	1551 East 172Nd Street\nBronx, NY 10472\n(40.8...	40.8314	-73.8783	12	0.5786
178	12X479	BRONX CAREER AND COLLEGE PREPARATORY HIGH SCHOOL	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	12.0000	53.8571	2.5714	21.9429	18.8571	24.1429	BRONX CAREER AND COLLEGE PREPARATORY HIGH SCHOOL	20112012	72.2000	244				118	78	48		41.0000	16.8000	67.0000	27.5000	34	24	6	2.5000	91	37.3000	146	59.8000	1	0.4000	108.0000	44.3000	136.0000	55.7000	61.0000	78	41	91.0000	7.0000	60.0000	8.4000	7.6000	7.3000	7.6000	6.5000	6.4000	6.7000	7.6000	6.5000	5.9000	6.4000	7.4000	7.1000	6.6000	6.8000	7.6000	12X479	Bronx Career and College Preparatory High School	Bronx	X158	718-542-4011	718-542-4377	9	12	12.0000	Bx11, Bx15, Bx17, Bx19, Bx21, Bx27, Bx35, Bx4,...	2, 5 to Intervale Av ; 2, 5 to Intervale Ave	800 Home Street	Bronx	NY	10456	www.bccprep.com	323.0000	0	0	Bronx Career and College Preparatory High Scho...	College & Career Program, Internships, College...	Italian, Spanish	0	0	Spanish, Spanish Native Language Arts	Yoga, Dance, Glee, Mentoring, Music Production...	0	0	0	Boys Intramural Basketball	Affinity Health Plan, Healthy Respect, South B...	0	Lehman College, Bronx Community College	Deep Sea Innertainment, Inc.	Solid Foundations for Healthy Families	Quests & Summits, Inc., New Teacher Center	Bethex Federal Credit Union	0	Personal Technology is not allowed on school g...	Community Service Requirement, Internship Requ...	8:00 AM	2:15 PM	This school will provide students with disabil...	ESL	Functionally Accessible	1	Priority to New York City residents who attend...	Then to New York City residents	0	0	0	0	800 Home Street\nBronx, NY 10456\n(40.82776397...	40.8278	-73.9004	12	0.5288
191	13K527	URBAN ASSEMBLY INSTITUTE OF MATH AND SCIENCE F...	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	13.0000	84.0000	3.3333	24.9000	23.6667	25.6667	URBAN ASSEMBLY INSTITUTE OF MATH AND SCIENCE FOR	20112012	62.2000	469	88	75	83	99	61	63		7.0000	1.5000	62.0000	13.2000	40	4	24	5.1000	372	79.3000	55	11.7000	12	2.6000	0.0000	0.0000	469.0000	100.0000	91.0000	89	39	352.0000	25.0000	144.0000	7.9000	7.6000	7.8000	7.8000	6.8000	6.8000	6.9000	7.6000	5.8000	6.4000	6.6000	7.4000	6.9000	6.9000	7.1000	7.6000	13K527	Urban Assembly Institute of Math and Science f...	Brooklyn	K313	718-260-2300	718-260-2301	6	12	12.0000	B103, B25, B26, B38, B41, B45, B54, B57, B61, ...	2, 3, 4, 5, R to Borough Hall ; A, C, F to Jay...	283 Adams Street	Brooklyn	NY	11201	www.uainstitute.com	508.0000	0	All-Girls School	Our school is an all-girls school designed to ...	Pre-Calculus and Engineering courses at Polyte...	French, Spanish	Calculus AB, English Literature and Compositio...	0	0	Girls Inc. of NYC Teen Program, Digital Design...	0	Basketball	0	Intramural Volleyball, Cheerleading, Power Pla...	Crown Heights Mediation Center, Park Slope Cen...	Long Island College Hospital	Polytechnic Institute of New York University, ...	Learning Through an Expanded Arts Program (LEA...	Urban Assembly, Children’s Aid Society’s Carre...	Thornton-Tomasetti Group, Con Edison, Alexande...	0	New York City Department of Design and Constru...	0	Extended Day Program	8:30 AM	3:20 PM	This school will provide students with disabil...	ESL	Functionally Accessible	1	Open only to female students	Priority to continuing 8th graders	Then to New York City residents who attend an ...	Then to New York City residents	0	0	283 Adams Street\nBrooklyn, NY 11201\n(40.6946...	40.6946	-73.9886	13	0.2751
197	14K322	FOUNDATIONS ACADEMY	s	404.1194	419.6567	399.6627	1,223.4388	Foundations Academy	42.0000	53.0000	153.4500	Total Cohort	FOUNDATIONS ACADEMY	2006	60.0000	41	68.3%	26	43.3%	63.4%	1	1.7%	2.4%	25	41.7%	61%	15	25%	36.6%	14	23.3%	2	3.3%	14.0000	37.0000	1.8333	20.6000	18.5000	22.8333	FOUNDATIONS ACADEMY	20112012	78.7000	141				51	32	27	31	8.0000	5.7000	40.0000	28.4000	9	21	2	1.4000	94	66.7000	42	29.8000	2	1.4000	80.0000	56.7000	61.0000	43.3000	62.0000	100	42	103.0000	14.0000	66.0000	8.4000	7.8000	7.6000	7.7000	6.0000	5.7000	5.9000	6.5000	6.9000	6.4000	7.2000	7.7000	7.1000	6.6000	6.9000	7.3000	14K322	Foundations Academy	Brooklyn	K033	718-302-5092	718-599-1369	9	12	12.0000	B15, B38, B43, B44, B46, B47, B48, B54, B57	G to Myrtle Ave-Willoughby Ave ; J, M to Flush...	70 Tompkins Avenue	Brooklyn	NY	11206	http://schools.nyc.gov/schoolportals/14/K322	110.0000	0	0	We prepare all of our students for career and ...	Leadership, Service Learning, Social Justice	Spanish	Biology, Calculus AB, English Literature and C...	0	0	Debate Team, Math, Mock Trial Team, Model UN, ...	Basketball & JV Basketball, Soccer, Volleyball...	Basketball & JV Basketball, Volleyball & JV Vo...	Bowling, Golf, Outdoor Track	0	Reading Excellence and Discovery (READ) Founda...	0	0	0	Institute for Student Achievement (ISA)	0	0	0	Uniform Required: collared polo or button-down...	0	8:30 AM	3:30 PM	This school will provide students with disabil...	ESL	Not Functionally Accessible	1	Priority to Brooklyn students or residents who...	Then to New York City residents who attend an ...	Then to Brooklyn students or residents	Then to New York City residents	0	0	70 Tompkins Avenue\nBrooklyn, NY 11206\n(40.69...	40.6971	-73.9467	14	0.2979
218	15K667	SUNSET PARK HIGH SCHOOL	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	15.0000	376.7778	13.8889	26.8556	24.0000	30.4444	SUNSET PARK HIGH SCHOOL	20112012	79.9000	988				340	325	323		142.0000	14.4000	220.0000	22.3000	86	28	46	4.7000	77	7.8000	798	80.8000	66	6.7000	501.0000	50.7000	487.0000	49.3000	95.0000	98	47	629.0000	51.0000	304.0000	8.3000	7.9000	7.9000	8.1000	7.0000	7.0000	7.8000	8.4000	6.4000	6.4000	6.9000	7.3000	7.2000	7.1000	7.5000	7.9000	15K667	Sunset Park High School	Brooklyn	K564	718-840-1900	718-840-1925	9	12	12.0000	B35, B63, B70	D, N, R to 36th St	153 35Th Street	Brooklyn	NY	11232	www.sunsetparkhighschool.org	1,309.0000	0	0	Sunset Park High School is a diverse and inclu...	Advisory, Drop Everything and Read, Service Le...	Spanish	Spanish Language and Culture	0	0	Art, Clay Workshop, Creative Writing, Dance, F...	Basketball	Basketball, Softball, Volleyball, Wrestling	0	Baseball, Basketball, Cheerleading, Fitness, F...	Center for Family Life, Youth Employment, Life...	Lutheran Medical Center	Brooklyn College, New York University (NYU), C...	Joyce Theatre, Tribeca Film Festival.	0	0	0	Institute for Student Achievement	0	0	8:45 AM	3:30 PM	This school will provide students with disabil...	ESL	Functionally Accessible	1	Priority to Districts 15 and 20 students or re...	Then to Brooklyn students or residents who att...	Then to New York City residents who attend an ...	Then to Districts 15 and 20 students or residents	Then to Brooklyn students or residents	Then to New York City residents	153 35Th Street\nBrooklyn, NY 11232\n(40.65595...	40.6560	-74.0055	15	0.1306
222	16K688	THE BROOKLYN ACADEMY OF GLOBAL FINANCE	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	16.0000	64.0000	3.0000	21.4750	17.2500	25.5000	THE BROOKLYN ACADEMY OF GLOBAL FINANCE	20112012	57.4000	159				54	61	44		10.0000	6.3000	33.0000	20.8000	6	19	3	1.9000	118	74.2000	33	20.8000	4	2.5000	82.0000	51.6000	77.0000	48.4000	76.0000	100	17	99.0000	12.0000	22.0000	6.0000	5.8000	5.7000	6.2000	3.9000	1.9000	3.8000	3.6000	4.9000	5.8000	5.4000	6.8000	4.9000	4.5000	5.0000	5.6000	16K688	The Brooklyn Academy of Global Finance	Brooklyn	K057	718-574-3126	718-574-3681	9	12	12.0000	B15, B38, B43, B46, B47, B52, B54, Q24	J to Kosciusko St ; M, Z to Myrtle Ave	125 Stuyvesant Avenue	Brooklyn	NY	11221	http://schools.nyc.gov/schoolportals/16/K688	148.0000	0	0	The mission of The Brooklyn Academy of Global ...	National Academy of Finance (NAF) provides an ...	Spanish	English Literature and Composition, Environmen...	0	0	Art, Career Exploring, Chess, Debate Team, Eur...	0	0	0	Team First Basketball Program	National Academy Foundation (NAF)	0	Medgar Evers College Now, Kingsborough Communi...	Virtual Enterprise Platform	0	0	Deloitte Consulting	Brooklyn Borough President’s Office, Team Firs...	0	Extended Day Program, Internship Requirement, ...	8:15 AM	3:12 PM	This school will provide students with disabil...	ESL	Not Functionally Accessible	1	Priority to New York City residents who attend...	Then to New York City residents	0	0	0	0	125 Stuyvesant Avenue\nBrooklyn, NY 11221\n(40...	40.6915	-73.9337	16	0.8115
264	20K609	THE URBAN ASSEMBLY SCHOOL FOR CRIMINAL JUSTICE	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	20.0000	26.2500	2.0000	12.5750	10.7500	15.0000	URBAN ASSEMBLY SCHOOL FOR CRIMINAL JUSTICE	20112012	82.7000	374	63	74	73	89	75			58.0000	15.5000	64.0000	17.1000	46	6	131	35.0000	126	33.7000	82	21.9000	34	9.1000	0.0000	0.0000	374.0000	100.0000	85.0000	92	20	247.0000	24.0000	54.0000	8.3000	7.8000	7.7000	7.8000	7.8000	7.5000	8.1000	8.3000	7.7000	7.2000	7.8000	8.4000	7.9000	7.5000	7.9000	8.2000	20K609	Urban Assembly School for Criminal Justice	Brooklyn	K223	718-438-3893	718-438-3527	6	12	12.0000	B11, B16, B35, B67, B8	F to Ditmas Ave	4200 16 Avenue	Brooklyn	NY	11204	www.uascriminaljustice.org	485.0000	0	All-Girls School	The Urban Assembly School for Criminal Justice...	Accelerated Classes, Guest Speakers, Field Tri...	Spanish	Calculus AB, Chemistry, English Literature and...	0	0	Advanced Art, Model UN, Double Dutch, Soccer, ...	0	0	0	Double Dutch, Flag Football, Softball	The Urban Assembly, Generation Citizen	0	Duke University, New York City College of Tech...	Smack Mellon, Center for Urban Pedagogy	Urban Assembly	Baker & Hostetler LLP; Simpson, Thacher, Barle...	0	New York Police Department (NYPD)	Uniform Required: shirt with school logo, blac...	0	8:45 AM	3:45 PM	This school will provide students with disabil...	ESL	Functionally Accessible	1	Open only to female students	Priority to continuing 8th graders	Then to Brooklyn students or residents who att...	Then to New York City residents who attend an ...	Then to Brooklyn students or residents	Then to New York City residents	4200 16 Avenue\nBrooklyn, NY 11204\n(40.634908...	40.6349	-73.9815	20	0.3450
269	21K468	KINGSBOROUGH EARLY COLLEGE SCHOOL	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	21.0000	71.8000	3.0000	24.6300	22.4000	27.1000	KINGSBOROUGH EARLY COLLEGE SCHOOL	20112012	70.0000	472	89	69	77	87	80	70		13.0000	2.8000	74.0000	15.7000	49	0	34	7.2000	118	25.0000	107	22.7000	211	44.7000	273.0000	57.8000	199.0000	42.2000	97.0000	100	72	383.0000	26.0000	263.0000	7.9000	7.5000	7.3000	7.8000	7.4000	8.0000	8.4000	8.5000	6.4000	6.3000	6.5000	7.2000	7.2000	7.3000	7.4000	7.9000	21K468	Kingsborough Early College School	Brooklyn	K400	718-333-7850	718-333-7875	6	12	12.0000	B1, B3, B4, B6, B64, B82	D to 25th Ave ; N to Ave U ; N to Gravesend - ...	2630 Benson Avenue	Brooklyn	NY	11214	www.KECSS.info	551.0000	Lafayette Educational Campus	0	At Kingsborough Early College School (KECS), a...	Associate Degree, Advisory, Enrichment Cluster...	Spanish	0	0	0	All Subject Tutoring/Regents Preparation, Book...	Basketball & JV Basketball, Football & JV Foot...	Basketball, Bowling, Outdoor Track, Soccer, So...	0	Basketball, Flag Football, Flag Rugby, Lacross...	Bill and Melinda Gates Foundation, The Leaders...	Coney Island Hospital (Pediatric Unit)	Kingsborough Community College	Safety, Teamwork, Attitude, Respect, Responsib...	Penny Harvest	Merrill Lynch	0	0	Uniform Required: navy blue shirt with school ...	0	8:00 AM	2:20 PM	This school will provide students with disabil...	ESL	Functionally Accessible	1	Priority to continuing 8th graders	Then to New York City residents	0	0	0	0	2630 Benson Avenue\nBrooklyn, NY 11214\n(40.59...	40.5936	-73.9847	21	0.2734
319	28Q284	YORK EARLY COLLEGE ACADEMY	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	28.0000	64.0000	2.5455	25.1091	21.7273	28.5455	YORK EARLY COLLEGE ACADEMY	20112012	60.2000	489	87	82	85	81	78	76		0.0000	0.0000	47.0000	9.6000	31	0	115	23.5000	314	64.2000	50	10.2000	3	0.6000	250.0000	51.1000	239.0000	48.9000	99.0000	88	39	394.0000	23.0000	144.0000	8.3000	8.0000	7.5000	8.2000	7.3000	7.2000	7.2000	8.1000	6.6000	6.2000	6.8000	7.8000	7.4000	7.2000	7.2000	8.0000	28Q284	York Early College Academy	Queens	Q008	718-262-8547	718-558-4257	6	12	12.0000	Q111, Q112, Q42, Q5, Q60	0	108-35 167 Street	Jamaica	NY	11433	http://schools.nyc.gov/schoolportals/28/Q284	592.0000	0	0	The mission of York Early College Academy is t...	Early College	Spanish	0	0	0	Chess, Art, Culture, Dance, Debate Team, Drama...	Basketball	0	Rugby	Girls Step Team	0	0	York College, Early College Initative; City Un...	0	Beacon Program	0	0	0	Dress Code Required: white polo shirt, blue je...	Community Service Requirement, Extended Day Pr...	8:00 AM	3:00 PM	This school will provide students with disabil...	ESL	Functionally Accessible	1	Priority to continuing 8th graders	Then to Queens students or residents	Then to New York City residents	0	0	0	108-35 167 Street\nJamaica, NY 11433\n(40.6969...	40.6969	-73.7870	28	0.2639
321	28Q325	HILLSIDE ARTS & LETTERS ACADEMY	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	28.0000	45.5000	2.0000	22.7500	21.2500	24.2500	HILLSIDE ARTS & LETTERS ACADEMY	20112012	65.6000	200				109	91			25.0000	12.5000	22.0000	11.0000	16	4	56	28.0000	78	39.0000	42	21.0000	13	6.5000	94.0000	47.0000	106.0000	53.0000	97.0000	100	33	87.0000	9.0000	29.0000	8.2000	7.9000	7.5000	8.2000	8.0000	8.2000	8.1000	8.9000	6.4000	6.2000	6.5000	7.4000	7.6000	7.4000	7.4000	8.2000	28Q325	Hillside Arts & Letters Academy	Queens	Q470	718-658-1249	718-658-1613	9	12	12.0000	Q1, Q17, Q2, Q25, Q3, Q30, Q31, Q36, Q43, Q6, ...	F to 169th St	167-01 Gothic Drive	Jamaica	NY	11432	http://schools.nyc.gov/schoolportals/28/Q325	420.0000	Jamaica Educational Campus	0	The mission of Hillside Arts & Letters Academy...	Art, Music, Writing, Pre-Calculus Honors, Smal...	Spanish	Art History, Biology, English Literature and C...	0	0	Music, Student Government, Studio Art, Drama, ...	Baseball, Basketball, Bowling, Fencing, Footba...	Basketball, Bowling, Cross Country, Indoor Tra...	Fencing	Cheerleading, Cricket	Queens Community House	0	0	Jamaica Center for Arts and Learning	0	0	0	0	0	Student Summer Orientation	8:15 AM	3:00 PM	This school will provide students with disabil...	ESL	Not Functionally Accessible	1	Priority to Queens students or residents who a...	Then to New York City residents who attend an ...	Then to Queens students or residents	Then to New York City residents	0	0	167-01 Gothic Drive\nJamaica, NY 11432\n(40.71...	40.7136	-73.7965	28	0.6451
326	28Q686	QUEENS METROPOLITAN HIGH SCHOOL	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	28.0000	305.3333	9.5000	29.5500	27.5000	30.5000	QUEENS METROPOLITAN HIGH SCHOOL	20112012	47.3000	663				294	369			24.0000	3.6000	106.0000	16.0000	41	20	80	12.1000	32	4.8000	256	38.6000	268	40.4000	329.0000	49.6000	334.0000	50.4000	81.0000	81	33	328.0000	22.0000	131.0000	8.2000	7.3000	7.4000	7.1000	6.4000	6.0000	6.7000	6.9000	6.2000	6.1000	6.4000	6.9000	6.9000	6.5000	6.8000	7.0000	28Q686	QUEENS METROPOLITAN HIGH SCHOOL	Queens	Q686	718-286-3600	718-286-3601	9	12	12.0000	Q11, Q23, Q53, Q54, Q55	0	91-30 Metropolitan Avenue	Forest Hills	NY	11375	http://schools.nyc.gov/schoolportals/28/Q686	1,139.0000	Metropolitan Educational Campus	0	Queens Metropolitan High School is a college p...	Dance, Theatre, Visual Arts, Chorus, Guitar, C...	French, Italian, Spanish	Biology, Calculus AB, Calculus BC, English Lan...	0	0	Cheerleading, Drama, Glee, Law, Multicultural,...	Baseball, Basketball & JV Basketball, Cross Co...	Basketball, Cross Country, Indoor Track, JV Ba...	0	Triathlon Team	0	0	LaGuardia Community College	0	0	0	0	0	0	Student Summer Orientation	8:00 AM	2:50 PM	This school will provide students with disabil...	ESL	Functionally Accessible	1	Priority to students who live in the zoned area	Then to Queens students or residents	Then to New York City residents	0	0	0	91-30 Metropolitan Avenue\nForest Hills, NY 11...	40.7104	-73.8506	28	0.1946
335	29Q326	CAMBRIA HEIGHTS ACADEMY	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	29.0000	54.6000	2.4000	22.3000	21.4000	23.2000	CAMBRIA HEIGHTS ACADEMY	20112012	71.1000	147				87	60			3.0000	2.0000	20.0000	13.6000	10	5	5	3.4000	128	87.1000	11	7.5000	3	2.0000	81.0000	55.1000	66.0000	44.9000	95.0000	100	93	70.0000	7.0000	67.0000	8.7000	8.1000	7.7000	7.9000	8.6000	8.5000	9.1000	9.3000	7.1000	6.8000	7.3000	7.8000	8.1000	7.8000	8.1000	8.3000	29Q326	Cambria Heights Academy	Queens	Q799	718-776-2815	718-776-2818	9	12	12.0000	Q110, Q17, Q2, Q3, Q36, Q76	0	188-04 91St Avenue	Hollis	NY	11423	www.nycacademy.org	336.0000	0	0	At Cambria Heights Academy, we believe that st...	Software Engineering Program (SEP), Robotics, ...	Spanish	English Literature and Composition, Environmen...	Calculus AB	English, French, Spanish	Art, Basketball, Bowling, Chorus, Dance, Envir...	Basketball, Indoor Track, Outdoor Track	Basketball, Indoor Track, Outdoor Track	Indoor Track, Outdoor Track	Basketball, Bowling, Flag Football, Soccer, Track	Helping Hand Daycare, NYPD Career Explorers, N...	0	York College	Purelements: An Evolution in Dance, Afrikan Po...	Haitian Americans United for Progress (HAUP), ...	0	0	Partnership with Council Member Daneek Miller'...	Dress Code Required: solid-colored collared sh...	Extended Day Program, Internship Requirement, ...	9:00 AM	4:00 PM	This school will provide students with disabil...	ESL	Not Functionally Accessible	1	Priority to Queens students or residents who a...	Then to New York City residents who attend an ...	Then to Queens students or residents	Then to New York City residents	0	0	188-04 91St Avenue\nHollis, NY 11423\n(40.7118...	40.7118	-73.7712	29	0.8777
338	30Q286	YOUNG WOMEN'S LEADERSHIP SCHOOL, ASTORIA	s	404.1194	419.6567	399.6627	1,223.4388	0	129.0288	197.0385	153.4500	0	0	0	193.8710	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	30.0000	92.8571	4.2857	21.5714	20.2857	23.0000	YOUNG WOMEN'S LEADERSHIP SCHOOL ASTORIA	20112012	68.1000	495	91	80	87	78	79	80		27.0000	5.5000	26.0000	5.3000	10	1	194	39.2000	21	4.2000	200	40.4000	80	16.2000	0.0000	0.0000	495.0000	100.0000	99.0000	100	85	422.0000	28.0000	331.0000	8.9000	8.0000	8.1000	8.2000	7.5000	6.6000	7.1000	7.6000	8.1000	7.1000	7.7000	8.3000	8.1000	7.2000	7.7000	8.0000	30Q286	Young Women's Leadership School, Astoria	Queens	Q739	718-267-2839	718-728-0218	6	12	12.0000	M60, Q100, Q102, Q103, Q18, Q19, Q69	N, Q to 30 Ave-Grand Ave	23-15 Newtown Avenue	Astoria	NY	11102	http://www.ywlnetwork.org/network_schl_astoria...	576.0000	0	All-Girls School	The Young Women’s Leadership Schools (TYWLS) w...	CollegeBound Initiative, small interdisciplina...	Spanish	0	0	0	After-School Tutoring, Chorus, RowNY, College ...	0	Outdoor Track, Rugby	0	Annual Field Day, Basketball, RowNY, Soccer, T...	Learning Leaders; SAYA (South Asian Youth Acti...	Mount Sinai Queens, New York Center for Rehabi...	Barnard College, Columbia University, New York...	Museum of the Moving Image	Young Women's Leadership Network, Girls Learn ...	High Water Women	0	Urban Advantage, Christodora, City Parks Found...	Uniform Required: official school uniform avai...	Community Service Requirement, Extended Day Pr...	8:00 AM	3:20 PM	This school will provide students with disabil...	ESL	Functionally Accessible	1	Open only to female students	Priority to continuing 8th graders	Then to Queens students or residents	Then to New York City residents	0	0	23-15 Newtown Avenue\nAstoria, NY 11102\n(40.7...	40.7713	-73.9246	30	0.2607

In [27]:

combined["Num of SAT Test Takers"].value_counts().head()

Out[27]:

s     28
54     8
72     8
48     7
63     6
Name: Num of SAT Test Takers, dtype: int64

Observations¶

The scatter plot comparing SAT scores to the percent of students taking AP exams showed some interesting patterns.

First, to answer the primary question, there does not appear to be a strong correlation between the two values. The schools with the highest SAT scores do have a large number of students taking AP exams. But there are many more schools with the same number of students taking the AP exam that have average SAT scores.

Second, there are two large groups of schools with similar SAT scores but notably different numbers of AP exam takers. There is a group that has about 5-15% of the students taking the AP exam and another with about 20-30%. This is a little interesting.

Third is a grouping of schools with identical SAT scores. Looking at the data set shows 28 schools with a SAT score of 1223.4388. This line shows up in the other scatter plots but is very obvious in this one. These schools also have the same numbers of AP exam test takers, AP exams taken, and AP scores of 3,4, or 5. They all also have the only non numeric value in the `Num of SAT Test Takers` column, namely `s`. Each of the groups of students does represent a different percentage of students in the school.

Conclusions¶

This initial look at academic and societal data for NYC schools suggests that the relationship between subgroups can be more nuanced than might first appear.

Schools that have high average SAT scores also have high safety and respect scores. While many schools with high safety and respect scores have average SAT scores, none of the schools in the bottom half of this group score above average SAT scores. This is a very important finding.
There doesn't seem to be a very strong connection in most high schools between high SAT scores and common demographic groups. Removing magnet schools and schools where the SAT has less emphasis or relevance (such as locations with very high percentages of international students) normalizes the distribution. It would be interesting to see what would happen to the overall data set if these students were re-introduced to schools in the same geographic area.
About 7% of the schools in the data set appear to share a group of students taking the SAT and AP exams. These schools represent key demographic data but their influence on the overall data set needs to be considered before further analysis is made.