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

 

Other Related Activities
Means (calculation, spreadsheet, statistic)
Medians (calculation, spreadsheet, statistic)
Modes (calculation, spreadsheet, statistic) Ranges (calculation, spreadsheet, statistic)

 

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 4E: Calculating Statistics with a Computer
Topic: Language Idioms & Spreadsheets/Statistics

Part of:
Unit: Embracing Diversity
Lesson: Mean, Median, Mode and Range

 

Individual Downloads

None

Keywords

calculation, computer, median, hhie-s, statistic, mean, computer skill, spreadsheet, mode, range, hearing handicap inventory elderly

Search Curricular Keywords

Activity Description

The students will use the computer to check their answers as well as their graphs. Use the following instructions to guide them on the use of the computer and spreadsheet.

(If your students have not done Lesson 2 then go over the components of the spreadsheet with them before beginning this activity.)

File Name: sample.xls (Excel)
sample.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.)

These directions are for Excel.

Statistics Formulas

  1. Statistics for ENGLISH TOTALS
    1. Click on the cell H25 and type the following formula: =average(h2:h21)
    2. Click on the cell H26 and type the following formula: =median(h2:h21)
    3. Click on the cell H27 and type the following formula: =mode(h2:h21)
    4. Click on the cell H28 and type the following formula: =min(h2:h21)
    5. Click on the cell H29 and type the following formula: =max(h2:h21)
    6. Click on the cell H30 and type the following formula (for the range): =h29-h28
  2. Select the cells H25:H30 by highlighting them.
  3. Select EDIT and then select COPY.
  4. Click on the cell I25.
  5. Select EDIT and then select PASTE.
  6. The statistics for the SPANISH TOTALS should now be displayed in cells I25:I30.

Bar Graph Creation

  1. Select the cells G24:I30 by highlighting them.
  2. Insert a chart by selecting INSERT then select CHART. A chart wizard will appear.
  3. Chart Wizard Step 1 of 4: Select BAR. Click next.
  4. Chart Wizard Step 2 of 4: You will see a small version of the graph. The range should be "=SAMPLE!$G$24:$I$30". Click next.
  5. Chart Wizard Step 3 of 4: Under the TITLES tab, type chart title: "Hearing Handicap Inventory." The X-axis will be "Statistics" and the Y-axis will be "Total Score." Then 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. 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