HSTA Students Analyzing Data

Health Sciences & Technology Academy

HSTA Lifestyles Project
Analyzing Data
Health Sciences & Technology Academy
Home
 Overview     Intro to HSTA     How to Gather Data     How to Analyze Data     Available Survey Results
- NIH Modules
- Lifestyles Project
-Teleconference
- Multicultural Education in Science Teaching
- Publications

Related Links
-2005 Biomed Curriculum
-HSTA Teacher Grad Courses
-HSTA Teacher Workshops
-Teacher Facilitator Guide

-FWS & Forensics Outline
- Preventing Chronic Disease.
Special Issue
Evaluation Tools
-Rubric for "Threaded Discussion"
-Research Project Presentation Rubric
-Community Service Project Rubric

-
Blank Question Sheet
-Walkability Project
HSTA in News
-HSTA Students to Study Brain Function via Telecast
-HSTA Students to Learn Forensic Science at WVU



 

Search HSTA
Search
Web

powered by FreeFind

 


HSTA Students say: "Now that I filled out survey forms with participant’s data, how do I draw conclusions???"

Its’ easy! Just follow the steps:

Enter your data in Excel: You need the completed survey forms and Lifestyles Excel file.

1.

Open the Lifestyles Data Excel file (e-mail Jenny for this)

2.

Examine the worksheets at the bottom of the excel file.

3. Click on the worksheet named 'blank'.
4.

Enter all your data from the survey forms into the appropriate columns (headings at top).

Click here for
Instructions for entering Blood Pressure, or Yes/No/Not sure, other

Please note: Never use a person’s real name.
5. You can copy/paste your data into the total Lifestyles excel file OR copy/paste some of the total Lifestyles data into your worksheet to make comparisons.
6. Add columns or change column names to a name you like.
Rename this ‘blank’ worksheet with a new name by ‘right clicking’ (e.g., your club name).
Save as’ your Excel file and give it a new name that you will remember.

Eyeball your data: What questions might you have about relationships in your data?

1st Set Examples: How similar or different one measurement is from another…?

Example: Is the heart rate for females the same or different for males?
Example: Is the lo-fat intake of participants in WV the same or different from Mali?
Example: Do females tend to take vitamins more than males?
Example: Is the heart rate for females the same or different for males?
Example: Are the bmi’s for females the same or different for males?
Example: Is the pre/top/bp number different between Mali males and WV males?

If you ask these types of questions, click on TTEST.

2nd Set Examples: If one measurement increases or decreases, does it affect another measurement…?

Ex: Does a person’s heart rate go up as their bmi goes up?
Ex: If a person has a high bmi, does this mean they are likely to have high blood pressure?
Ex: If a person has a low bmi, does this mean they are likely to have a lower heart rate?
Ex: If a person has a low pre/top/bp number (initial systolic), is their heart rate likely low?
Ex: For persons who report lo sugar diets, are they likely to also have low bmi?

If you ask these types of questions, click on CORRELATIONS.

Contact Us