Wednesday, July 18, 2012

Excel Data




This^^^ is a scatter plot of the NAEP test scores, overall, for 2011, based on state. The points are organized alphabetically, with Washington DC and DoDEA included, West virginia scored an average of 214, with the highest state being Massachusetts earning a little more than 236 on average, and the lowest, Washington DC, earning an average score of a little over 200.

1. How well are we, WV, doing? Not so great, we are 44th out of 53 areas  in terms of overall scores.
2. How many states are below WV?In terms of on the chart? 43. In terms of scores? 9.
3. How many are above your state? Chart? 9. Scores? 43
4. Are you above or below average? Average: 221 WV Males: 210. Below average

Our state isn't doing so hot in terms of test scores.

     This project was done with MS Excel, with a spreadsheet and data from Naep Tests.
     I can fit this project under standards 1b. and 2a. It shows students the true data from an actual source of information that applies to them in a real-life scenario.




No comments:

Post a Comment