Excel 1

Used NCES site and looked at the state comparisons to assess where we are in terms of the national educational landscape.

Sort the scores Ascending / Total Score.

Compute the descriptive statistics for the total score column.

West Virginia is fairly low when it comes to comparing National Center for Education Statistics National Assessment of Educational Progress 8^th grade math scale scores to other states.  There are merely 5 states below West Virginia, leaving the remaining 57 states included in this study above West Virginia.  By looking at the scatterplot above, you can see that West Virginia isn’t close to average; we are actually below it by quite a bit. 


 

 ISTE NETS T - Standard 1 & 2- During this activity, students are expected to complete an assignment using digital tools (Jing), technology system (Excel) and media. Students are expected to be active in their own learning and understanding of the content. Digital communication aides in the advancement of resources and support. This activity is a great summative assessment due to the nature of the outcomes. The scatter plot offers some sort of data that should be relevant to the assignment.