However, I used my SS for database purposes, and although I used the SUM function, I have never been well versed in other functions, such as the one we used for this activity, statistical. So, this was a huge learning curve for me, pardon the pun.....
The first obstacle was figuring out if I could add-on the data analysis tool pack, using Windows 7 Starter, to find my descriptive statistics. I couldn't! I still may decide to buy W7! I thus, did my statistical analysis the manual way, and I hope it is accurate! I tested, and re-tested, so I think most is accurate!
I went through the steps on the NCES website, for the data analysis, then downloaded it to Excel on my netbook, and worked manually to get the descriptive stats in place, and saved all of my stats, including the scatter chart, on one worksheet. I found Excel to be very helpful in annotating my chart, w/o having to use my little buddy Jing! Although, I love Jing!
The only issue I had, is when I uploaded my final document to G-docs, it kinda messed it up, dividing it into three different sheets, and my scatter chart is not formatted to what was in my original document. So, I am going use Jing to capture the chart and embed it in my blog.
I included male/female in this first activity, because it represents part of the whole of the stats, even though I will be isolating the m/f stats for Excel 2.
In a nutshell what I found was, Virginia ranks quite high in comparison to the other states! We rank 84%. There are only 7 states above us, and 44 states below us! Mass. ranks highest, and Washington, D.C. ranks last! (Sorry, D.C.)
The NETS-T standard learned in the activity is :
5. Engage in Professional Growth and Leadership.
State Comparisons, 4th Grade, Reading w/ Accommodations
No comments:
Post a Comment