Health Occupations - Vital Signs on a Spreadsheet
December 13 & 14 1999
Mr. Dildine for Ms. Hart
Goals:
- Create a spreadsheet for personal vital signs data
- Collect, organize, manipulate, and graph data
- Present findings from data in spreadsheet
- Enter data on the internet
- Use vital signs data from the internet
Mathematics explored
- Statistics (Measures of central tendency)
- Using formulae (Temperature conversions, BMI)
- Reading and interpreting graphs
- Identifying trends and patterns
- Making decisions based on graphs and data
Computer Usage
- Using spreadsheets to collect, organize, manipulate, graph, and present data
- Using the Internet to submit & retrieve information
Why use computers?
- Accurate recording of data
- Accurate and easy graphing
- Categorize and track medical records
- Perform calculations efficiently and accurately
Outline
Day 1 (Dec 13)
- Begin spreadsheet (worksheet) construction
- Decide on important data & input it
- Format spreadsheet to look jazzy
Day 2 (Dec 14)
- Create graphs to represent data in meaningful ways
- Develop questions to answer from data and graphs à
answer them!
- Explore measures of central tendency
- Identify trends and patterns
Qualifications (Requirements) of YOUR spreadsheet
- Front Sheet containing NAME, HOME SCHOOL, PERSONAL STATEMENT, & GRAPHIC
- Second sheet with vital signs data entered
- Third Sheet with Graphs
- Fourth Sheet with statement of conclusions about data you have entered, what did you notice?
- Saved in your directory on the server
- Personalized -- Make it professional and make it say YOU !
Internet Sites to Visit:
http://www.mste.uiuc.edu/dildine/health
- Spreadsheet template (example):
http://www.mste.uiuc.edu/dildine/health
Online calculators and math help: http://www.mste.uiuc.edu/dildine/tcd_files