notes (old) book data ref the dump research links

Project 1 - Deering's sending schools

IMPORTANT FIRST STEP: In your group, one person first - click the data link (data 9th-12th grade) make a copy of it and then share that (with edit permissions) with each person in your group.


Each of you will take one grade and create

  1. Basic numerical summaries:
    • find the average NWEA (math and reading) score for the entire grade
    • find the average NWEA (math and reading) score for each middle school
    • find the average NWEA (math and reading) for each gender
  2. pie graph of the gender breakdown(so showing percent of grade that is male and female)
  3. bar graph of how many students from each school come to Deering
  4. pie graph for the NWEA classifications (see below) for the entire grade
  5. histogram of nwea scores
  6. Create concluding insights from above

Now put everyone's research together in one google slideshow. Each student will use at least 2 slides. Look at this example. Try to make it as uniform as possible.



  • write one slide with these time series graphs showing over time:, (each person must do one, if extra, skip)
    • NWEA math (Class of 2021 does this one)
    • NWEA reading(Class of 2020 does this one)
    • # of students coming to Deering(Class of 2019 does this one)
    • % below grade level math(Class of 2018 does this one)
    • % below grade level reading(Class of 2017 does this one)
    • #avg female math score(Class of 2016 does this one)
    • # avg male math score(Class of 2015 does this one)
    • # of Lincoln students(Class of 2014 does this one)
    • # percent female(Class of 2013 does this one)


  • concluding statements about what you have learned and compare all grades.


Send me an email with everyones names and emails and a link to the slideshow. In the email say what grade each person worked on.



Computer Notes:



This is going to be a 8 point project. 1 point for each bullet above and 1 point for putting it all together, 1 point for group concluding statements




NWEA Classifications:

  • Math: NWEA below grade level 230, Around grade level 230-239 Above grade level 240+
  • Reading: NWEA below grade level <220, 220-230 at grade level, 230+ above grade level



Extra credit:

  • Create a frequency distribution table for scores (+1 point)
  • +1 time series graph for different schools (all on one graph)