Sunday, November 20, 2011

Excel Basics

For this assignment we just had to use the excel basics and prepare our data. We had to implement our text data with numerical data in order to run the tests on the data. This was very simple to do and very effective when running our T-tests. I was also able to sort whatever information I wanted to into different categories.

TPACK
By being able to run excel on data with college sports we are starting to understand why there are so many similar injuries with the same sports. The content theme assessing data on injuries (CK) can be shown by using the excel basics and T-tests run on all the data (P). By using excel (T) there should be a way to prevent certain injuries from happening in the collegiate atmosphere.


Relation to standards

Using excel and all of its features relates to several ISTE NETS T standards, primarily #2 Design and develop digital age learning experiences because it allows athletic trainers to document and track certain injuries in collegiate sports. It also relates to #3 Model Digital- Age Work and Learning which allows athletic trainers to stay up to date on new technology and how we can utilize it.

Research Overview

For the Research Overview assignment we were supposed to install the data analysis tool pack in excel. This was very simple to so but it had been a while since I had done it. I did it about three years ago in a research class in my Undergraduate classes. I was a little rusty on finding it and uploading it but once I got the ball rolling it was very simple.

TPACK
Teaching athletic training has led the profession to keep track of injuries and focus in on how to prevent them. By being able to utilize this data analysis tool pack we can use it to track certain injuries(CK). At conferences and in classes I can show our findings in lectures, presentations, and our research activities (P). By keeping this organization of the data analysis tool (T) it can greatly assist me in by showing other health care professionals of my findings.


Relation to Standards
With this assignment it could relate to #2 Design and Develop Digital-Age Learning experiences and assignments. This could allow me to track my injuries and with what sport they are associated with. Also it could relate to #5 Engage in Professional Growth and Leadership by allowing me to present my findings to a bunch of colleagues and peers.