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 5D: Sorting by Gender

Activity 5D: Sorting by Gender

The students will now sort the data into male and female responses. Use the following steps:
 
  1. Click on any cell in the Gender column (D), select DATA then SORT
  2. The SORT window should pop up. Make sure that the first sorting key is "Gender" and that "Ascending" is selected. Click OK.
  3. Click on the cell where you want to display the average of the Male ages (i.e. B104). Type =average(b2:b52). Then in cell B105 type =average(b53:b101) to compute the average of the Female ages.
  4. Either follow the same procedure or copy and paste the formulae into the corresponding cells for Education Years. 
 
After sorting the information, the students will find the average age for both groups and the average grade completed for each group. Record the data on the same sheet used for activities B and C. The students should display the mean age and mean grade using their information on the worksheet onto a bar graph or any other graph that you may be teaching at the time. The graph should include the average age for the entire group, males, and females. The second graph should have the average grade completed for the entire group, males, and females. Have the students show their graphs and discuss their findings. 
 
Note that women have lower average HHIE-S scores than men. Ask the student why this might be so. (Answer: Older men have more hearing loss than older women.) 
 
  • PDF icon Sorting Teacher Answer Key 5D
  • PDF icon Sorting Student Worksheet 5D
  • PDF icon 100-entry spreadsheet 5D
Keywords: 

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

 

Activity Icon - %2
Activity Code: 
5D
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.