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

 

Other Related Activities
Scattergrams by Hand (graph, scattergram, hhie-s, spreadsheet, hearing handicap inventory elderly)

 

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 3B: Scattergrams by Computer
Topic: Language Idioms & Spreadsheets/Statistics

Part of:
Unit: Embracing Diversity
Lesson: Checking Test Comparability/Scattergrams

 

Individual Downloads

None

Keywords

graph, scattergram, hhie-s, computer, spreadsheet, computer skill, hearing handicap inventory elderly

Search Curricular Keywords

Activity Description

Have the students create a computer-generated scatter plot of the 100 entries in the full spreadsheet.

File Name: 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 directions for using a spreadsheet in EXCEL are listed below.

  1. Select the cells containing English and Spanish Totals (H2:I101) by highlighting them.
  2. Insert a chart by selecting INSERT and then select CHART. A chart wizard will appear.
  3. Chart Wizard Step 1 of 4: Select XY SCATTER. Click next.
  4. Chart Wizard Step 2 of 4: You will see a small version of the scatter plot. The range should be "=SHORT!$H$2:$I$101". Click next.
  5. Chart Wizard Step 3 of 4: Under the TITLES tab, type chart title: "Hearing Handicap Inventory." The X-axis will be "English Totals" and the Y-axis will be "Spanish Totals." Click on the LEGEND tab. Take the check mark off the SHOW LEGEND by clicking on it. Click next.
  6. Chart Wizard Step 4 of 4: If you want the chart to be a full page, click AS NEW SHEET. If you want the chart to be smaller and embedded within the spreadsheet, click AS OBJECT IN. Click finish.
  7. You can also include a trendline on the chart. Select CHART then select ADD TRENDLINE. Select LINEAR then click OK. Your graph should look like this .

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