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

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

Lesson 2: Spreadsheet
Topic: Language Idioms & Spreadsheets/Statistics

Part of:
Unit: Embracing Diversity


  • Focus: As computers become more available to students, it is important for the student to understand and use different computer programs. In the Challenges and Changes Unit, students can administer a hearing screening survey. The students will look at the data collected from a survey given to 100 participants; this data has been stored in a spreadsheet.

Activities | Introduction | Objectives | Resources & Web Sites


Activities

Activity 2A: Exploring Spreadsheets

(spreadsheet, questionnaire, gerontology, computer skill, hhie-s, cross cultural adaptation, hearing handicap inventory elderly, sampling, data analysis)
 
Activity 2B: Hearing Aid Use
(spreadsheet, computer skill, hhie-s, cross cultural adaptation, data analysis, hearing handicap inventory elderly)
 
Activity 2C: Comparing Spanish and English HHIE-S Scores
(spreadsheet, hhie-s, computer skill, data analysis, cross cultural adaptation, hearing handicap inventory elderly)
 
Entire Lesson Download (5 pages)


top

Introduction

Lesson 2, “Spreadsheet,” introduces students to the set up and structure of spreadsheets.

Background Information: The Hearing Handicap Inventory for the Elderly-Screening Version (HHIE-S) was given to 100 participants. The participants first took the survey in either English or Spanish. The survey was readministered 2 weeks later in the language not used the first time. The purpose of this survey was to see if the HHIE-S had been translated properly. Ideally, the participants should have the exact score in both the English and Spanish, but as you will notice, that is not the case in some of the participants. The average score of the entire group was taken and it turns out that the averages are the same, thus telling us the two language versions are equivalent. A copy of the survey, both the English and Spanish version, can be found in the Challenges and Changes Unit. You may wish to go over this survey to better explain the purpose of this unit.

The spreadsheet files from the HHIE-S survey has been provided for you. The data is in two forms: Excel and Lotus. These formats should facilitate the ability to load the data into any number of spreadsheet applications.

(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 three files are:

  1. SAMPLE : This file contains the sample of 20 subjects that is used in the lessons 2, 3, and 4.
  2. SHORT : This file includes data for all 100 subjects, but does not contain individual item responses for the HHIE-S. This data set is used in lessons 3, 5, and 6.
  3. COMPLETE: This file includes all the data for all 100 subjects including the individual responses to each of the 10 HHIE-S questions in Spanish and in English.

Each data set contains the composite (total) HHIE-S score for the study subjects in both English and Spanish so that the scores may be compared.

top

Objectives

Students will be able to:

  • analyze the spread sheet
  • compare the data from two spread sheet columns
  • write an analysis of the two spread sheet columns

top

Resources & Web Sites

Hearing Handicap Inventory on-line survey http://www.msu.edu/~comdis/hhi/index.html

Spreadsheet Resources http://lttechno.com/links/spreadsheets.html

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