Healthy Kids Healthy Oakland Opportunity Mapping Update

1. Healthy Kids Healthy Oakland Opportunity Mapping Update Susan Lindell Radke OUSD GIS Analyst/Contract Demographer January 28, 2011

2. Healthy Kids Healthy Oakland Opportunity Mapping Update TASK FORCE GOAL To develop an expanded data framework, including non-traditional indicators and aligned data tools to support a full-service community school district and the needs of the whole child. • Develop a map-based data tool to explore alignment of district-wide socio-economic indicators with school and student based data

3. Healthy Kids Healthy Oakland Opportunity Mapping Update • Current scope of work: • Create map-based tool integrating various school & community databases into a geographic context within an ArcGIS software environment

4. Healthy Kids Healthy Oakland Opportunity Mapping Update • Current scope of work: • Task #1: Create district-wide base maps • US Census Bureau American Community Survey 5 Year Block Group estimates

5. Healthy Kids Healthy Oakland Opportunity Mapping Update The American Community Survey (ACS) is an ongoing statistical survey by the U.S. Census Bureau, sent to approximately 250,000 addresses monthly (or 3 million per year) It regularly gathers information previously contained only in the long form of the decennial census. It is the largest survey other than the decennial census that the Census Bureau administers. American Community Survey. (2011, January 4). In Wikipedia, The Free Encyclopedia. Retrieved 16:28, January 28, 2011, from http://en.wikipedia.org/w/index.php?title=American_Community_Survey&oldid=405965594

6. Healthy Kids Healthy Oakland Opportunity Mapping Update ACS First Release Top Demographic Indicator Maps

7. Healthy Kids Healthy Oakland Opportunity Mapping Update • 2005-2009 Map • 2000 Map • 2005-2009 vs 2000 Data: • Estimate & Margin of Error

8. Healthy Kids Healthy Oakland Opportunity Mapping Update Statistical Significance. The determination of whether the difference between two estimates is not likely to be from random chance (sampling error) alone. Standard Error. The standard error is a measure of the deviation of a sample estimate from the average of all possible samples. Margin of Error (MOE). An MOE is the difference between an estimate and its upper or lower confidence bounds. Confidence bounds can be created by adding the MOE to the estimate (for the upper bound) and subtracting the MOE from the estimate (for the lower bound). All published ACS MOEs are based on a 90 percent confidence level. 2005-2009 Estimate Range: 29.8 to 30.4 (30.1-0.3) to (30.1+0.3) 2000 Estimate Range: 27.0 to 27.4 (27.2-0.2) to (27.2+0.2) Difference: 2.9 (30.1-27.2)

9. Healthy Kids Healthy Oakland Opportunity Mapping Update But, what about the Margin of Error? How significant is it? How does US Census Bureau deal with it? What is research community saying about it?

10. Healthy Kids Healthy Oakland Opportunity Mapping Update ACS Margin Of Error (MOE) Elephant in the room!! aka…an obvious truth that is being ignored or goes unaddressed

11. Healthy Kids Healthy Oakland Opportunity Mapping Update Functionality and Usability of Information from the American Community Survey Committee on National Statistics, October 6, 2006

12. Healthy Kids Healthy Oakland Opportunity Mapping Update Every block…really?

13. Healthy Kids Healthy Oakland Opportunity Mapping Update Given the known error and limitations… • We still thought it was necessary to explore what the ACS showed us about Oakland: • Foreign born • Educational attainment • Below poverty • Median Household Income • Public Assistance

14. Healthy Kids Healthy Oakland Opportunity Mapping Update % Foreign Born US Census Bureau, American Community Survey 5 Year Estimates 2005-2009 MOE

15. Healthy Kids Healthy Oakland Opportunity Mapping Update Highest Educational Attainment: % High School Diploma US Census Bureau, American Community Survey 5 Year Estimates 2005-2009 MOE

16. Healthy Kids Healthy Oakland Opportunity Mapping Update % Below Poverty* US Census Bureau, American Community Survey 5 Year Estimates 2005-2009 *Family of 1 earning below $10,830. (FY 2009/2010 Federal Poverty Guidelines) MOE

17. Healthy Kids Healthy Oakland Opportunity Mapping Update Median Household Income US Census Bureau, American Community Survey 5 Year Estimates 2005-2009

18. Healthy Kids Healthy Oakland Opportunity Mapping Update % Public Assistance US Census Bureau, American Community Survey 5 Year Estimates 2005-2009

19. Healthy Kids Healthy Oakland Opportunity Mapping Update • Other sources of OUSD data: • Free & Reduced Price Meal Plan • California Healthy Kids • Physical Fitness Test • Oakland Housing Authority

20. Healthy Kids Healthy Oakland Opportunity Mapping Update Free and Reduced Price Meal Plan % Free and reduced price meal plan students at each school School-level data mapped to individual student address School-level data mapped to individual student address / interpolated district-wide

21. Healthy Kids Healthy Oakland Opportunity Mapping Update • Where do we go from here? • Search for other sources of socio-economic data to complement ACS data • Map student data at school level: • California Healthy Kids • Physical Fitness Test • Oakland Housing Authority