ACL Data Resources and Tools for Title VI

1. ACL Data Resources and Tools for Title VI Presented by Kristen (Krissy) Hudgins and Kristen Robinson ACL’s Office of Performance and Evaluation October 9, 2019

2. Overview • Welcome and Introduction • Review and explain how to access population data via Census • Review how to access Title VI historical data in AGID

3. Census

4. Steps 1, 2, 3 2. Click on “Explore Data” 3. Click on “Data Tools and Apps” 1. Go to www.census.gov

5. Step 4 4. Click on “American FactFinder (AFF)

6. Steps 5, 6 5. Click on Advanced Search 6. Click on “Show me all”

7. Steps 7, 8, 9, 10, 11 7. Click on “Race and Ethnic Groups” 8. Click on “Detailed Groups” 11. Click on “Close” 9. Click on “Code 009” 10. Click “Add”

8. Steps 12, 13, 14, 15 15. Click on “Close X” 12. Click on “Topics” 13. Click on “Dataset” 14. Click on “2015 ACS 5-year Selected Population Tables”

9. Steps 16, 17, 18, 19, 20 17. Click on “People” 18. Click on “Age & Sex” 16. Click on “Topics” 19. Click on “Age” 20. Click on “Close X”

10. Steps 21, 22, 23 21. Click on “Geographies” 22. Click on “Name” 23. Click on “all geographic types”

11. Searching for Geographies • There are several different ways to search for Geographies: • Entering a geography name in the search bar is the easiest way to search. • Using the Geography Filter Options is another way to search that provides more options but may require some experimentation. • In Geography Filter Options, clicking on Summary Level, clicking on 250 – AIA/ANA/HHL, you will see 1,066 Tribal Geographies.

12. Example: Ex1.2 Click “Go” Ex1.1 Type in geography name Ex1.3 Click Geography Names of interest Ex1.4 Click “Add” Ex1.5 Click “Close X”

13. Example: (continued) Ex1.6. Click “Sex by Age” table

14. Example: (continued) Ex1.7. Click “Download”

15. Example: (continued) Ex1.8 Click “View the data” Ex1.9 Click “Microsoft Excel” Ex1.10 Click “OK”

16. Example: (continued) Ex1.11 Click “Download”

17. Excel File…

18. Example: Results

19. AGID

20. {Hidden}

21. {Hidden}

22. {Hidden}

23. {Hidden}

24. {Hidden} Step 2 Step 1

25. {Hidden} Step 2 Step 1

26. {Hidden} Step 1 Step 3 Step 2

27. {Hidden} Step 1

28. {Hidden}

29. {Hidden}

30. So What?

31. Why is Data Important? • Today, many decisions are based on data; therefore, populations with little or no data are easily overlooked • Helps set goals and priorities • Identifies specific areas of health and social needs • Resource allocation • Relevant actionable data • Assists policymakers, tribal leadership, directorship, and management make decisions based on facts and numbers.

32. Checking Your Data Average Meals a Year = Meal Served/Meal Clients Average Meals a Week = Average Meals a Year/52 weeks per year

33. Importance of Checking Data Entry

34. Questions

35. Contact Information Kristen Robinson Kristen.Robinson@ACL.HHS.GOV 202-795-7428 Kristen (Krissy) Hudgins Kristen.Hudgins@ACL.HHS.GOV 202-795-7732