Saturday, March 30, 2013

Excel 2

Using the same data from the Excel 1 assignment, we were to determine the statistical data using only the male/female data.  To accomplish this, I would need to choose the "t-Test: Two-Sample Assuming Equal Variances" option of the data analysis.  Next I had to choose both the male and female data from the various states (again I deleted DC and DoDEA) and clicked ok.














The null hypothesis: there is no significant difference between reading scores of 4th grade males/females.  Although  I know that females scored higher (according to the previous data from Excel 1 assignment), I should reject the null hypothesis.  But according to the above data, I should accept it.  So I've come to the sad conclusion that I've probably botched this assignment somehow (because looking at some of my fellow classmates blogs, they are VERY different than mine).

The NETS-T Standards that apply to this assignment are as follows:
Standard 2d: Provide students with multiple and varied formative and summative assessments aligned with content and technology standards and use resulting data to inform learning and teaching.
Standard 3b: Collaborate with students, peers, parents, and community members using digital tools and resources to support student success and innovation.
Standard 3c:  Communicate relevant information and ideas effectively to students, parents, and peers using a variety of digital age media and formats.
Standard 3d:  Model and facilitate effective use of current and emerging digital tools to locate, analyze, evaluate, and use information resources to support research and learning.
Standard 5c:  Evaluate and reflect on current research and professional practice on a regular basis to make effective use of existing and emerging digital tools and resources in support of student learning.

In essence: Data drives instruction!

No comments:

Post a Comment