Some changes were made with both the worksheet and the census site since the video was created.
However, it still provides some useful information that may help you fill out your worksheet.
1. Census
2. Click on 'advanced search.'
3. 'Find a Filter' is on the left hand side of the screen.
Click on 'Geography'
4. Select your geographic locations.
One at a time, select:
Nation > United States
State > Massachusetts
Place > Massachusetts > your community
The geographic locations selected will now be on the left hand side of the screen under 'Filters'.
1. To answer the questions on total population, population by age, population by race/ethnicity, and age: median/mean, you will need to select a table.
Deselect any topics you've searched. Keep your geographies.
Select:
Topics > Populations and People > Age and Sex
Click Search.
Use this table, ACS Demographic and Housing Estimates, for Total Population, Population by Age, Race/Ethnicity and Age: median/mean questions.
1. To find the poverty rate we will need to leave the population table and select a new one.
Deselect any previous filters you searched. Keep your geographies.
Select:
Topics > Income and Poverty > Poverty > Select Poverty
Click Search
Select this Table:
Poverty Status in the Past 12 Months
1. To find our education statistics we will need to leave previous topic and select a new one.
Deselect previous filters you searched other than geographies.
Select:
Topics > Education > Educational Attainment
Click Search.
Use the Table, Educational Attainment.
2. You will look at both the 'population 18 to 24' and 'population 25 years and older' categories.
Look at the lines that your professor asked for information on.
Add numbers together in the two categories, to get 18+ age, total population, educational attainment.
1. To find our unemployment statistics we will need to leave the last table and select a new one.
Under 'Filters', deselect all filters, but geography.
Click Topics > Employment > Employment and Labor Force Status
Select this Table:
Selected Economic Characteristics
2. Scroll through the chart until you find the 'unemployment rate.'
This is the information you need.
1. Click on Population density.
2. It automatically shows the statistics for the United States.
You will need to add Massachusetts and your community.
4. Once you have added in MA and your community, scroll down to the bottom of the chart.
Under 'Geography' you will see 'population per square mile.'
This is the population density.
1. Click on Poverty Thresholds.
2. We will select 2019 to be consistent.
3. The size of the family unit is 4.
Go across the excel sheet until you see the column for two children.
This is the poverty threshold for a family of four.
