student achievement how school district compares

[yuqingliu19]

Please complete all of the following sections, or a robot will spookily dance around your issue! A completed version of this template can be found at https://github.com/jsoma/data-studio-projects/issues/1

Pitch

Summary

I want to compare students' performance according to school types and races in different school districts in new york city. basically school types include Elementary, Middle and High school

Details

possible image

Possible headline(s): School in New York City student achievement how school district compares

Data set(s): http://schools.nyc.gov/Accountability/tools/report/default.htm

Code repository:

Possible problems/fears/questions:

Work so far

just find data

Checklist

This checklist must be completed before you submit your draft.

• [ ] I have already spent time with my data set, opening it, exploring it, etc
• [ ] I have created a "DIARY.md" file to save links and list all of the terrible, no good problems I come across
• [ ] My issue issue has [Project] in the title
• [ ] My issue links to my data set(s)
• [ ] My issue links to my code repository
• [ ] My issue explains what I'd like to explore in the data set
• [ ] My issue includes images - either inspiration or what I've done so far
• [ ] I have received two comments of peer feedback on my pitch issue

[adaskalopoulou]

I like the comparison between private and public schools. Do you think that you can find objective data? How is achievement measured?

[simon-pinkmartini]

Nice idea to do this kind of analysis for a city. I would try to narrow down on the research question, maybe focus on one particular school level (high school, elementary).

[JulienAssouline]

I would like to see this on a map. The only concern I would have is that this story type of story has been done before so I trying to find a unique angle might be difficult. I think focusing on the geolocation data though is a good idea, and I don't think I've seen that before, so I would focus on that.

[demetriospogkas]

I like the idea. If comparisons according to race have been covered before, maybe you could check about gender?

[playfairbot]

Hello! This is the Playfair Bot, let's take a peek.

Please post your project draft! It should be posted by Friday. More details available here. If you posted one but I'm not seeing it, make sure you followed the template.

It looks like we need to fix up your pitch a little bit! Edit it by clicking the pencil in the top right-hand corner. It requires:

• A link to your code repository

If you see a lot of errors, make sure you used the templates correctly!

[yuqingliu19]

Update

I got different kinds of schools including Elementary, K-8, Middle school distribution in NYC, you can see the difference between them obviously, Elementary school has the most number, while K-8 are the least.

I also have different races students' rankings in all kinds of schools.

Content

https://github.com/yuqingliu19/Data-Studio-Projects/tree/master/Code/School%20in%20NYC Here are the map I got so far.

number of Asian in all kinds of schools

Any changes in direction or topic?

I don't have enough data about the students' academic performance, maybe I should turn the focus on school.

Problems/Questions

I can't find story so far.

Checklist

• [ ] I have included my visuals
• [ ] I have added writing about my topic
• [ ] I have been updating my DIARY.md with details about my process
• [ ] I have uploaded/updated any Jupyter Notebooks or other datasets into my code repository
• [ ] I have received two comments of peer feedback on my project update

[sarahslo]

It's not clear yet what is the most interesting piece. K-8 schools are rarer in NYC, this is true. There may be more elementary schools but that is likely a function of the fact that they tend to have fewer students. The flipside is also true for high schools, there are many large high schools in NYC so fewer overall schools.

If you are interested in finding out where Asian students are, perhaps do some more work with the data upfront before you map it. Perhaps show us where the most and least Asian students are by school type.

I'd go back to your initial instinct to find another variable about the school. If you look at % of the population that has school lunches that is an indicator of poverty. Schools are also given grades, so you can use this as another filter for the data. How many Asian kids are in the schools that have the highest grade rating and the highest number of school lunches (poor kids), etc.

We definitely need another layer of data here.

Nice start! Keep going!