Assignment4 (1)

Assignment 4 | Creating Attribute Data [Add your name here] Objective: In this assignment, you will implement the following:  Working with external data in .CSV or excel file format to perform table joins  Store spatial data and attribute data in geodatabase and/or in external shapefiles (spatial data)  Understand and use correct data types (long integers, short integers, float, double, text) to store various types of data without truncating values, rows, columns, field/variable and naming rules, key fields, joining rules  Create attribute data (quantitative and qualitative) using manual data entry and field calculations  Use python scripts to compute field values  Create technically correct maps (correctly populated data, classifications , use use correct map types, colors, symbols and visual elements) with visual hierarchy  Analyze and describe the algorithm (methodology)  Technical writing (answering technical questions) S ubmit a single word document with the map and the answers to all the questions. For this assignment, you will need to explain the steps you took from beginning until the end to create the map. Make sure to keep screen captures of each step and write down what steps you took. This process is similar to what you see in the lab activity videos. The goal is for you to be able to explain the process to someone so that they can replicate your work using the steps you provided. Q1: Mapping County Data (30 Points) In this question you will join the data, export it to a shapefile and then using a field calculator, you will write a formula using python code to compute population density. Q1.1: Create a Map [8 Pts] 1. Add the Selected_IL_Counties.shp and SchoolEntollment_2013.xls to ArcGIS Pro. If the SchoolEntollment_2013.xls doesn’t work, use the SchoolEntollment_2013.csv file instead. 2. Examine both tables, identify the files to join. Once identified, join the fields. 3. After joining it, export the data into a new shapefile and save it to the geodatabase (.gdb). Provide a suitable name for the new shapefile. 4. Add only the new shapefile to ArcGIS Pro. 5. Open the attribute table for the new shapefile, create a new field called “SchEnDen” with data type as Double. Save the changes you have made. 6. Using the field calculator, compute School Enrollment Density. The formula to compue this is: (note: you will have to translate this formula to match the actual fields in your table) School Enrollment Density = Scholl Enrollement / Sq. Miles ____________________________________________________________________________________ © Nandhini Gulasingam 1

7. Create a map to should the School Enrollment Density for 2013. Source: U.S. Census 2013. Add all map elements. Label the map using County names. Q1.2: Answer the following questions 1. [1 pt] Which county has the highest density? 2. [1 pt] Which county has the lowest density? Q1.3 : Technical Questions: 1. [1 pt] Which fields from both tables did you use to join? 2. [2 pts] What was the reason to use these two fields? (Hint: explain using joining rules discussed in the lectures) 3. [1 pt] Include the screen capture of the newly exported shapefile table. It should include the newly computed field. 4. [1 pt] How many rows are in the newly exported shapefile table (or the exported shapefile table)? 5. [1 pt] How many columns are in the newly exported shapefile table? 6. [2 pts] Explain why we used the data type ‘Double’ to compute and store the new variable value “School Enrollment Density” (SchEnDen)? Could have used any other data type? 7. [12 pts] Explain the methodology - Explain step-by-step on how you created this map from downloading and extracting the shapefiles to completing your final map (For example, the first step is to unzip the compressed shapefiles and save it into a folder, and add the shapefiles to ArcGIS application) . Include screen captures while you explain each step. For each step, include a line indicating the purpose of the step (For example, extracting the shapefile was to uncompress the spatial data so that the GIS application can read and display the file). Rubric: Meet expectation In progress of reaching the benchmark Needs improvement 1. Comply with guidelines 100% of the points : the report/map are written/made clearly and complies with the guidelines. 80% of the points: the report/map are not written/made clearly while following the guidelines over 80% OR the report/map are written/made clearly following the guidelines only 60- 90%. 50% or less of the points: the report/map follows the guidelines less than 50% regardless of clarity. 2. Use computational thinking (CT) * concepts and skills 100% of the points : clear demonstration that you correctly used CRS as CT concepts and skills. 70% of the points: vague demonstration that you used CRS correctly as CT concepts and skills. 25% of the points: you incorrectly used CRS as CT concepts and skills 3. Analyze, describe Algorithm ** 100% of the points : clear demonstration that you correctly used the terminologies, included relevant screen captures and explained all the steps 70% of the points: vague demonstration that you explained the steps or missed critical steps in explain the process of creating the map. 25% of the points: you incorrectly explained or missed most of the steps in explaining how the map was created step-by-step. 4. Design solutions to 100% of the points : a workflow you devised led 70% of the points: a workflow you devised led to correct results, but it is 25% of the points: a workflow you devised led ____________________________________________________________________________________ © Nandhini Gulasingam 2

____________________________________________________________________________________ © Nandhini Gulasingam 4