Funding Sources for our Programs Site Index Home
About Us Curriculum Teacher Resources Student Resources
Newsletters & Publications Search

 

Other Related Activities
Means of the Age of Subjects (computer skill, mean, calculation, spreadsheet)
Means of Education Levels (computer skill, mean, calculation, spreadsheet)
Sorting by Gender (computer skill, spreadsheet)

 

media, persuasion, bias, stereotype, body image, logo, slogan, message, audience anatomy, hearing disorder, amplification, caregiving, hearing handicap inventory, audiogram, auditory pathway, auditory cortex, temporal lobe, decibel, sound wave, vibration, amplitude anatomy, detached retina, macular degeneration, glaucoma, hemianopsia, cataract, diabetic retinopathy, visual acuity, visual field, depth perception, visual pathway, optic nerve, occipital lobe, visual cortex, depth perception, presbyopia, myopia, astigmatism, hyperopia sleep habit, sleep pattern, sleep deprivation, sleep disorder, nightlight, light pollution research, organize, graphic organizer, Big 6, strategy, source, synthesis, evaluation lung, diaphragm, breath, pollutant, air quality anatomy, brushing technique, calcium, calculus, demineralization, caries, flossing technique, fluoride, oral hygiene, plaque fat minder, calorie, energy balance, body fat, Archimedes Principle, mass, volume, density, exercise, physical activity adolescent nutrition, activity level, algorithm, analysis, basal metabolism rate, body mass index, caloric intake, caloric need, energy balance, energy need, fad diet, nomogram, obesity, overweight, dietary guideline food group, food pyramid, recommended serving, classifying, combination food, nutrition mobility, movement, physics, gait, gait cycle, laboratory, chart, graph, calculate, mobility compromise, balance, sway, stabilometer stereotype, ageism, media, book analysis, poetry personal narrative, personal milestone, lifeline, timeline, family tree, past, present, future levers, effort, move, joint, movement, resistance, force interviewing, biography, timeline, lifeline, research, note taking, historical context spreadsheets, computer skills, sampling, data analyses, graphing, scattergrams, calculations, mean, statistics, median, mode, range idioms, culture, language, aging themes, translations health career, job arteries, anatomy, atherosclerosis, stroke, pulmonary embolism, heart attack, organ damage, aneurysm brain, anatomy, dementia, neural function, sensory, motor, homunculus, cerebrum, cerebellum, memory, learning style glucose, blood sugar, insulin, pancreas, hypoglycemia, glucose tolerance test, atherosclerosis, nutrition, obesity, thrifty gene statistic, population, percentage, longevity, life expectancy, life span, graph, map, population pyramid, entrepreneurship mobility, movement, physics, gait, gait cycle, laboratory, chart, graph, calculate, mobility compromise, balance, sway, stabilometer blood, blood transfusion, scientist, timeline, history, scientific knowledge, blood type, blood supply, organ, organ donation, plasma, blood disorder

Get Adobe Reader
 

 

Embracing Diversity

Activity 5A: Means of HHIE-S Scores
Topic: Language Idioms & Spreadsheets/Statistics

Part of:
Unit: Embracing Diversity
Lesson: Computer Skills

Entire Activity Download (4 pages)

Individual Downloads

Sorting Teacher Answer Key

"Short.*" Student Handout

Sorting Student Worksheet

 

Keywords

computer skill, mean, calculation, spreadsheet, cross cultural adaptation, hhie-s, hearing handicap inventory elderly

Search Curricular Keywords

Activity Description

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 “SHORT.*”) to give to the students before they actually work on the computer. This way the student can see what the entire spreadsheet looks like.

Filename: short.xls (Excel)
short.wk4 (Lotus)

(In Internet Explorer, you will need to "Save As" when the file is opened, then manually open your spreadsheet program. In Netscape, your spreadsheet program will open automatically.)

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).

top

 
   
UTHSCSA Teacher Enrichment Initiatives
Positively Aging® & M.O.R.E. Curricular Programs
2007-2008 © The University of Texas Health Science Center at San Antonio
Homepage: http://teachhealthk-12.uthscsa.edu