Let's pull it all together today so we can move on. After today, we will be moving on to raster data.

New Skills Learned Today:

1. Excel ratios
2. Projecting to State Plane (feet)
3. Merging shapefiles
4. Creating Personal geodatabases

Exercise #1: What is the % change in the population with cancer within a 5-mile radius around UT Arlington?

• Download prepared SimplyMap data
• To calculate % change, divide the difference by the original number.
• For example, to calculate the % change from a 2000 population to 2010 population:
• (2010Pop - 2000Pop)/2000Pop
• We will also need the Merge Tool: ArcToolbox/Data Mangement Tools/general/Merge
• Is a good idea to join any attributes and export before merging if your tables are by county.
  

Exercise #2: Project the data into State Plane Feet and put inside a Personal Geodatabase

• Create a simple Personal Geodatabase: ArcToolbox/Data Management Tools/Workspace/Create Personal GDB
• Two Methods to Project a Feature Class:
1. ArcToolbox/Data Management Tools/Projections and Transformations/Feature/Project
2. Ensure the Data Frame is set to the desired coordinate system (right-click 'Layers' and select Properties, and go to Coordinate System tab). Then Export the feature class using the same coordinate system as the Data frame.
   

Exercise #3: Determine how many counties intersect a 5-mile radius around your college.

• 1 county = lucky
• 2 county = unlucky
• 3+ county = unreasonable, you may select another college if you wish