The students will use the computer to view the entire spreadsheet of data. You may wish to make a paper copy of the brief spreadsheet (Filename “100-entry spreadsheet”) to give to the students before they actually work on the computer. This way the student can see what the entire spreadsheet looks like.
The students will now find the mean of the entire set, the one hundred people surveyed. In order for the students to do this using the spreadsheet they must follow the steps provided. Instruct the students on how to do this using the computer. If every student has access to a computer, you can do this as a group. If not you may want to work in pairs with the computer, or you may wish to go over the steps to finding the mean and then have them work on a computer as one is available. After the students have found the mean for both the English and Spanish version, have them compare the averages. You may lead them through a discussion about the data with these questions. What do you notice about the averages? Why do you think the averages turned out the way they did? What does this tell us about the translation of the test? Hopefully the students will realize that since the averages are the same then the translation of the test was probably accurate.
Click on the cell where you want to display the average of the English Scores (i.e., H103). Type =average(h2:h101).
Click on the cell where you want to display the average of the Spanish Scores (i.e., I103). Type =average(i2:i101).
Computer skill, mean, calculation, spreadsheet, cross cultural adaptation, HHIE-S, hearing handicap inventory elderly