ACL Data Resources and Tools for Title VI

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

2. CENSUS

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

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

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

6. 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”

7. 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”

8. 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”

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

10. 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 (see Example 1). • Using the Geography Filter Options is another way to search that provides more options but may require some experimentation (see Example 2). • In Geography Filter Options, clicking on Summary Level, clicking on 250 – AIA/ANA/HHL, you will see 1,066 Tribal Geographies.

11. 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”

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

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

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

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

16. Excel File…

17. Example: Results Example: Results

18. AGID

19. ACL Home Page

20. 4 Different Ways to Access Data

21. ACL Custom Tables Tab

22. Custom Tables > Title VI Services

23. Title VI Services by Tribal Organization - Available Filters Step 2 Step 1

24. Title VI Services by Tribal Organization – Data Elements Step 2 Step 1

25. Title VI Services by Tribal Organization - Geography Step 1 Step 3 Step 2

26. Title VI Services by Tribal Organization - Results Step 1

27. Message box please format your Excel file to match the custom table

28. Export – Excel Report