Monday, July 16, 2012

Excel 1 (Updated)



I wasn't happy with the way my scatter plot turned out yesterday so I decided to make another one today. My scatter plot shows the reading scale scores for all states and all students (both male and female). The National Public was 220.0259116 scale score. West Virginia falls below average and 41 other states with 214.3860242 scale score. My state is not doing so well considering WV is only above 9 other states in the US. The NCIS website is where I obtained the information for this assignment. And just because I love Jing so much! - Total Score Data Statistics Summary for All States:



From this assignment, I learned how to install an add on in Excel, the Data Analysis Tool, and I generated Descriptive Statistics with just a few clicks. (Imagine doing this all in your head or on a calculator.) Data and Statistics are SO important in today's world. With almost anything you do, you need data to back it up. I've learned this is just the short amount of time I've spent as a special educator. The total score data statistics shows that the average score was 220.4150705, the minimum was 200.6279879 and the maximum was 236.7738666. For this assignment, I was able to model and facilitate effective use of current digital tools to locate, analyze, and evaluate information about my home state and all other states in the US. I gained global awareness of reading scores and was able to compare the data to my home state in which I am employed.

No comments: