Graph
We will use Excel to analyze the results of our survey.
A spreadsheet will be used to find
- the total number of students in the survey
- the percentage of students in agreement and disagreement for each question
- a graph or chart to display the results in a graphic format
LET'S GET STARTED!
Step1. Go to https://www.google.com/accounts/ServiceLoginAuth
Step 2. Log in.
Step 3. Open the netquestexcelsheet
Step 4. Type your name and enter your answers from the Wellness Policy Survey
Example:
Wellness Policy Survey Student Name Question 1 Question 2 Question 3 Question 4 Kerry Agree Agree Disagree Agree Mary Ellen Agree Disagree Agree Disagree Anne Disagree Agree Agree Agree Total Number of Student that Agree Number of Student that Disagree Step 5. Once everyone is done entering their results from the Wellness Policy Survey,
we will discuss how to graph our information. At this time we will be divided randomly
into groups and each group will graph each section of the wellness policy. We will
create the graphs with a computer program and/or by hand with a variety of art materials.
Summary:
Why is it helpful to graph our information?
Write a paragraph that answers this question and place it in your project binder along with your
spreadsheet and a copy of the graphs that you have created.
