Silent Excel

  Today we did a similar excel activity, only this time we worked on an assessment in complete silence (or attempted to anyway). We analyzed the test scores of males, females, traditional and non traditional students, like in the last activity, but we also compared the scores of graduate students and inservice graduate students. We found the averages of the scores by selecting the cell in which we wanted the answer to appear, typing in an equals sign and then finding average on the formula toolbar. We learned how to use the count and countif; count the same technique as average, and for countif we had to enter the information that we wanted counted. Custom sort makes it much easier because if all the numbers in the category you want to count are grouped together, you can just select it and use the count function. A ttest calculates whether or not the differences in scores are statistically significant ( if the result of the test  is less than 0.05, it isn’t, if it is greater, it is). We found that inservice students scored the lowest, and traditional students scored the highest of any category,however, according to the T-test run, this is not statistically significant.

I think this activity promotes technology standard 2.d because it was an example of a formative and summative assessment aligned with content and technology standards.