Welcome to Statistics

Project 1 - Public High Schools and their incoming classes

The data has Deering's and Portland's 9-14th grade classes with their gender, sending school and 8th grade NWEA.

Overarching questions:

• Have the ability of incoming students changed over that last 6 years?
• Do students come more prepared to other HS?
• Do some students come more prepared from certain middle schools?
• How bad was the drop this year (was it more dramatic from one school)[maybe due to Covid]?

In pairs, each of you will take one grade. In the pair, one of you take Math, the other Reading and find:

1. Basic numerical summaries:
• find the average NWEA score for the grade
• find the average NWEA score for each middle school
• find the average NWEA score for each gender
2. histogram of nwea scores (use a bucket size of 10)
3. pie graph of the gender breakdown (so percent male and female) for the grade [only one of you will need to do this]
4. bar graph of how many students from each school come to that HS[only one of you will need to do this]
5. Exceeds: pie graph of a brakedown of above/at/below grade level for math/english. You will need some clever ifs statements (see below)
6. Exceeds: 5 Number summary + BoxPlot for NWEA score (see video)

Looking at everyone's data: each group will do one of these - signup on the overview sheet

• write one slide with these time series graphs showing over time:, (each group must do one, if extra, skip)
• avg NWEA math at each high school over the years (all on one graph)
• avg NWEA reading at each high school over the years(all on one graph)
• On one graph # of students coming to DHS from King/Lyman/Lincoln/All
• avg female math score at each middle school coming to DHS over the years (all on one graph)
• avg male math score at each middle school coming to DHS over the years (all on one graph)
• percent female at each high school over the years (all on one graph)
• Males avg score at each high school over the years (all on one graph)
• Females avg score at each high school over the years (all on one graph)

• On each slide, each group puts concluding insights from their work

Exceeding:

• pie graph for the NWEA classifications (see below) for the entire grade
• . So you will need to find how many kids are below, at or above grade level.  To do that you will use =countifs and you will make a table like below and make a pie graph of that.

Now put everyone's research together in one google slideshow. (slideshow) Try to make it as uniform as possible. Together write concluding statements about what you have learned.

At the top of the each slide put names and what grade each person worked on.