Skip to main content

Part of UT Health San Antonio

Teacher Enrichment Initiatives (TEI) - UT Health San AntonioTeacher Enrichment Initiatives (TEI) - UT Health San Antonio

Part of UT Health San Antonio

Support TEI
Menu
  • Free Activities (curriculum)
  • Teacher Enrichment Leadership Academy (TELA)
  • Home
  • About TEI
  • Teacher Resources
  • Blog

You are here

  • Home
  • Activity 5A: Means of HHIE-S Scores

Activity 5A: Means of HHIE-S Scores

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.
  1. Click on the cell where you want to display the average of the English Scores (i.e., H103). Type =average(h2:h101).
  2. Click on the cell where you want to display the average of the Spanish Scores (i.e., I103). Type =average(i2:i101). 
  • PDF icon Sorting Teacher Answer Key 5A
  • PDF icon 100-entry spreadsheet - Student Handout 5A
  • PDF icon Sorting Student Worksheet 5A
Keywords: 

Computer skill, mean, calculation, spreadsheet, cross cultural adaptation, HHIE-S, hearing handicap inventory elderly

 

Activity Icon - %2
Activity Code: 
5A
Unit Reference: 
Embracing Diversity
Lesson Reference: 
Lesson 5: Computer Skills
map

UT Health San Antonio
Teacher Enrichment Initiatives

7703 Floyd Curl Drive
San Antonio, TX 78229

210-450-1000

Stay connected

  • About Us
  • Contact Us

 

We make lives better ®

We're a part of UT Health San Antonio, provider of comprehensive health,  dental   and  cancer care,  advanced academics  and  life-saving research.

Teacher Enrichment Initiatives | The University of Texas Health Science Center | School of Medicine | Department of Medicine
Division of Geriatrics Barshop Institute | Web Policy | National Institutes of Health | National Institute on Aging
National Heart, Lung, and Blood Institute

Links provided from UTHSCSA pages to other web sites do not constitute or imply an endorsement of those sites, their content, or products and services associated with those sites. Its content is solely the responsibility of the authors and does not necessarily represent the official views of the NIH.