ISP 120 Week 5

1
ISP 120 Week 5

• Final Project Midterm

2
Assignment 3 - 1
NO LEGEND
You should know everything you need to know about
the graph just by looking at it!
3
2
4
NO LEGEND
5
3
6

• a.  What type of graph is this graph?  Bar graph
• b. True or False The graph shows that women with
  bachelor's degree or higher earn more than men
  with bachelor's degrees or higher. Briefly
  explain your answer.
• c. In a 5-7 sentence paragraph , carefully
  describe what this graph tells about changes in
  women's and men's earnings from 1979 to 2003. 
  Address the following questions in your
  paragraph
• The changes in the data across the categories. 
  (Compare men and women.)
• The changes in the data within the categories. 
  (Only look at women and then only look at men.)

7
Greater Increase Greater Percent Increase
Greater Increase
Greater Percent Increase
8
4
1. The y-axis scales are not the same which
misleads the reader to think that the bookstores
have as many books in stock as they have titles
in the database
2. Location of labels makes Barnes and Noble
look taller than they are

• Width of columns make Barnes and Noble look more
  substantial/larger Bigger Better

4. No title ? purpose?
9
Activity 5

• Each year, the federal government sets a
  household income level threshold, below which a
  household qualifies for income assistance.  This
  threshold is called the poverty level or poverty
  line. In 2003, the poverty level for a family of
  four was approximately 18,810.
• a.  Assuming that a family of four living at the
  poverty level includes only one adult who is
  working  full time (40 hours a week, 50 weeks a
  year), how much is that person making per hour? 
  Show your calculations. 
• 18,810/(4050) 9.41

10

• b.  Before proceeding to look at the data,
  briefly discuss among your group your
  speculations regarding 1) approximately what
  percentage of the population as a whole is below
  the poverty line and 2) which states have the
  highest percentage of persons below the poverty
  level and which states have the least. In your
  Word document, write a paragraph responding to
  these two questions along with a brief
  explanation of your reasoning. 

11

• http//qrc.depaul.edu/Excel_Files/StatePoverty.xls
  
• c. list the two states with the most people below
  the poverty line and in a sentence explain why we
  can't necessarily conclude that these two states
  are the poorest.

12

• d. Fill column D with the percentage of the
  population that is below the poverty level.
• e. Using Excel's column sorting tools, determine
  the three states that had the highest percentage
  of persons below the poverty level and which
  three states had the lowest percentage.

13

• f. Calculate the percentage of all persons in the
  50 states who are below the poverty level and
  paste the result in your Word document.
• g. Comparing the results of  the questions in e
  and f to your group's speculations, how well did
  your group do? Were you surprised at all?

14

• h. We will now make a shaded map of the poverty
  data. Give the map a title like Poverty Rates by
  State, 2003
• i. In a short well-written paragraph, describe
  the geographic patterns of poverty in the US. 
  What regions have the highest levels of poverty? 
  Which have the least?  Are there some outliers?

15
Explain why this map is not nearly as revealing
as the map you made and why?
16

• http//qrc.depaul.edu/Excel_Files/SportsInjuries97
  .xls
• According to the sorted data, of all the sports,
  which has the highest and lowest number of
  injuries?  Basketball, Archery
• Can you conclude that a sport with a high number
  of injuries is dangerous?  Why or why not? No,
  it depends on the number of participants.

17

• 3.    Fill column D with the rate of number of
  injuries per participant. Unlike a percent, a
  ratio or rate is left in decimal form. Increase
  or decrease the number of decimal places so that
  the rate has 4 decimal places.   Sort the data on
  column D. Of all the sports, which is the most
  and which is the least dangerous sports according
  to injury rate?
• Ice Hockey, Billiards

18

• 4. Look at bowling and explain what its rate
  means. It may be helpful to write the rate as a
  fraction.
• 5 out of 10,000 are likely to get into an
  accident bowling
• 5.  Often, instead of per person (as a decimal
  point), rates are expressed as per 1000 people or
  per 100,000 people if the number divided by is
  very large.  Use what you said in question 4 to
  convert the rates in column D to number of
  injuries per 10,000 participants.  Fill column E
  with these values.  What is the rate per 10,000
  for tennis?
• 20 out of 10,000

19

• 6. In a well written paragraph explain the
  different views you obtain by sorting by the
  number of injuries and sorting by the injury
  rate.  In your paragraph give an example of a
  sport whose ranking changes significantly when
  looking at absolute numbers and when looking at
  rates, and briefly explain how and why
  (mathematically speaking) the ranking of that
  sport changes. 
• Ice Hockey

20

• 7. Based on what we said in class about the
  differences among the types of relative
  quantities, why was a rate used in this activity
  and not a percent or ratio?
• We are comparing two different types of
  variables injuries per participant
• Percent compares parts of wholes
• Ratio compares same type of data from 2 sources
• The rate gives us a better picture of how many
  people are injured per 10,000 people

21
FINAL PROJECT

• Paper (15 of final grade)
• A written project involving a variety of
  different computer and analytical tools from the
  course
• At least 3 pages NOT including graphs
• No more than 8 pages
• PowerPoint Presentation (10 of final grade)
• Must be based on your written report
• All group members must be a part of the
  presentation
• Time requirements depends on group size

22
DEMO

• Power Point Demo.ppt
• Notice that you will be working with animated
  graphs

23
Group Time Limits

• 1 person group
• 5 minute presentation
• 2 person group
• 6 minute presentation
• 3 person group
• 7 minute presentation

24
Stages Due Dates

• ALL 3 stages must be completed to get a
• grade for the project
• Reviewing the data
• In-class activity due February 13
• Making charts for your final project
• Take-home assignment due February 20
• The paper and presentation
• Paper due at time of presentation March 13

25
Questions for Midterm???