In the new, fast-paced, technological society in which we live, it is beneficial for teachers to understand and use this technology to their advantage. This blog is the process of my learning to do so.


Thursday, September 30, 2010

Excel

Today we practiced our Excel skills by performing the same actions we've been learning by ourselves with a separate group of data. We learned to perform various functions: count, average, sum, and ttest. We also learned to sort data. **Beware, when sorting data more than one different way, any functions performed in the specified cell ranges may change. Reenter the numbers without the formula to ensure they stay the same. Also important to note, GoogleDocs Spreadsheet does not have the TTest. (I didn't even know about the ttest before this class). In order to keep your document exactly the same, keep it in its original format. This is my document.
This assignment fuflfills NETS Standards:
1. Facilitate and Inspire Student Learning and Creativity
b.engage students in exploring real-world issues and solving authentic problems using digital tools and resources.
We determined the average test scores by classification and gender and determined if they were statistically significant.
2. Design and Develop Digital-Age Learning Experiences and Assessments
a.design or adapt relevant learning experiences that incorporate digital tools and resources to promote student learning and creativity.
This exercise teaches the students to use Excel.

2 comments:

  1. We're sorry, ricpierce@gmail.com does not have permission to access this spreadsheet.

    ReplyDelete
  2. I've fixed this. It should be public now.

    ReplyDelete