Guidelines:
Use the
same excel workbook for all 4 data tables and 4 graphs
For each
set of data, place the graph on a separate worksheet
You must
use 4 different types of graphs
Consider the
following when you format your work(both table and
graph):
·
include titles and simple readability
formatting to your data tables
·
Put a clear title on your graphs
·
Label the x- and y-axis appropriately (be sure to
indicate what numbers mean)
·
Use a legend if needed
·
Pick a graph type that suits your data and be able to
explain your choice
·
Use simple colors and font types
·
Label the 6 worksheets appropriately
·
spell and punctuate everything,
everywhere correctly
1.
HOW YOU SPEND YOUR TIME
The first
graph you make will be based on the data you collected the past three
days. Here are the steps that you were
shown in class yesterday:
·
Enter all the data from your worksheet
·
Use AUTOSUM formulas to check the totals for each day---if they are not
24 each day make adjustments
·
Format the table so it looks good (bold titles, proper spelling and
caps, merge/center main title)
·
Insert a new column next to your list of things you do
·
Title that Averages
·
Use the AVERAGE formula to calculate the average of how much time you
do each thing
·
Make a PIE GRAPH
·
Move the chart to its own worksheet
·
Title both worksheets
·
Format your graph by making sure titles are sized well, colors are
good, there is a main title, etc.
2. WEATHER
GRAPH
For your second
chart, choose three different cities (on three different continents) and one
weather variable (for example “rainfall in inches”). Then enter the data over
a period of twelve months (January to December-- Do not include the yearly totals with your data!!!), a Get
your information here: http://www.weatherbase.com/
Once you have a data table
set up and formatted, make a line graph.
Format and make it look good.
3. INTERNET DATA . . .
For you third graph
you will find data on the internet, input that into your own data table, and
then create a graph. Be sure you
format everything according to the list above.
For an A,
you must use at least 2 sets of data per graph, with at least 5 items.
A.
Sports Stats, 2006 to 2008 (three years). Pick ONE statistic (for example, “home runs” or
“free throw percentage ”) and FIVE different
players. Find data for the 2004, 2005, and 2006 seasons, and make a chart.
Get your data here:
http://sports.espn.go.com/
B.
Internet domain names,
1996 to 2006. Use .COM, .NET, and .EDU, and chart how many registered domain
names there were every year from 1996 to 2006. Use
the data from the CLOSEST MONTH TO JANUARY that is posted. Get your data
here:
http://www.ngi.org/trends.htm
C.
Price Comparisons:
Think of two stores that sell similar products (Walgreens and Bartells, QFC
and Safeway, etc.). Come up with a
list of five different items that you would like to buy. Then find the prices
for each of the items at the 2 stores you chose on the internet, by visiting
the stores or through a newspaper flyer.
D. New Car Mileage:
Graph the city MPG, highway MPG and average MPG for 10 different cars.
Go to the individual car websites for the data.
E. Population of Cities:
Find the population of different cities and graph that---better yet,
show growth of population in those cities. You can get info at: http://www.census.gov/
You
may also come up with your own idea
or a graph that you can use in another class.
You will need to get data from the internet that can be graphed
effectively. Please get your idea
approved before you start.
4.
SURVEY SAYS . . .
Your fourth an final graph will be based on a survey that you will
conduct Monday and Tuesday---make sure you have the data for this by
Wednesday!!! For an A, you must have a sample
size of a minimum of 50 people and
classify your data into at least 2 sets (gender, grade, age, race,
etc.). Be sure that you have a clear
question with well though-out choices first, and
that you begin collecting data today.
You may want to create a table in word to collect your data.
Extra
Credit: Do a fifth graph
|