![]() |
||
|
||
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
The Department of Labor has sponsored a special tabulation of Census data on Limited English proficient (LEP) populations as a resource for planning employment and training services. Information is broken out for 39 Census languages and language clusters, and the tabulations are designed to match the service areas of states and local Workforce Investment Areas. Each state and local Workforce Investment Area (LWIA) has a separate Excel workbook file containing six worksheets or pages. In addition to this Introduction page, there are a Glossary, a Quick Reference Guide, and three large tables: Table 1: Total Population (the number of people in the state or LWIA age 5 and older who speak a language other than English at home, along with a self-reported measure of how well they speak English.) Table 2: Adults (the number of adults in the state or LWIA age 18 and older who speak a language other than English at home, along with a self-reported measure of how well they speak English.) Table 3: Characteristics (a socio-economic profile of the population that reports speaking English "not very well" or "not at all" with their employment status, occupation, income, earnings and other labor market characteristics.) Where the Data Come From Source data for the tabulations comes from a 1-in-6 sample of U.S. households contacted for the 2000 Census - - the same source used for many tables available through American FactFinder (http://factfinder.census.gov). The tables presented here were designed by DOL specifically with the workforce investment system in mind, and are not available through FactFinder. If you would like to check on the way your service area was defined for these tables, go to the Definitions of Local Workforce Investment Areas page on this site. What the Data Tables Contain
To view a different table or page of the file: To navigate between tables or pages, just click on the gray tabs that appear near the bottom of your screen. To view the tables on-screen: Use the arrow keys, PageUp/ PageDown keys, and scroll bars to move to different parts of the table. The Zoom feature in the top menu bar (very much like Word's) allows you to reduce or enlarge the view. You can also hold the table headings in view while you move around in the table. Position the cursor at the 'corner' of the top and left-hand labels (cell B7 in Tables 1 and 2, cell B10 in Table 3), and click on Window > Freeze panes in the top menu. Printing: The files are set up to print in landscape format, with column and row headings reproduced on each page. To print just one table, go to that table's worksheet and select File > Print > OK. To print the entire workbook (all tables, plus the Introduction, Quick Reference, and Glossary sheets), check 'Entire workbook' in the lower-left of the print dialogue box. Tables 1 and 2 should print out onto two pages, and Table 3 onto 18 pages. However, Excel files may print differently on different printers, and unnecessary pages can sometimes be generated. To avoid this, select File > Print preview and check for nearly-blank pages. They can usually be eliminated by selecting File > Page setup > Page, and adjusting the scaling to 95% or 90% of normal size. For More Advanced Users: The tables are active Excel spreadsheets. The contents can be reformatted, and new worksheets can be created that analyze the data in different ways -- for example, by regrouping languages or creating new percentage measures. Identifiers and Missing LWIAs LWIA Identifiers. All tables show the state, and an LWIA name and number in the Heading information. Although it will usually be easy to identify your LWIA, some recent name changes may not be reflected in these listings. The LWIA number is the organization's official identifier in the DOL WIASRD database. In a few cases (mostly new LWIAs) the correct number could not be determined, and the LWIA was assigned a 'dummy' number ending in 99. The LWIA name and number can easily be changed before printing. LWIAs with statewide service areas (including District of Columbia, Puerto Rico, and the multi-state Navajo Nation service area) should use the state-level tabulations. Output for some LWIAs was censored because of insufficient population size. In all its published output, Census applies very strict rules to protect the confidentiality of individuals and families. The Census Disclosure Review Board scrutinized the LEP special tabulation very closely because of its very detailed breakout of small language groups, and in some cases determined that the population of an LWIA service area was too small to allow results to be published. Tabulations for 31 LWIAs were censored because of confidentiality concerns. In the ten states where this occurred, data for all excluded service areas within the state are grouped together and presented under the title 'Balance of State.' A list of affected LWIAs appears at the end of these instructions. Limitations of the Data Like all data sources, the LEP special tabulation has limitations to keep in mind:
|
|