Grant's Crime Lab

Blank Text Values in Excel - Conditional Formatting to Delete

Excel: =UNIQUE function to generate list

Excel: Calculating Z-Scores

Excel: Date Creation from Day of Year Number

Blank Text Values in Excel - Conditional Formatting to Delete

By Hand Example: Mean - Median - Standard Deviation - Z Score

ArcGIS Pro: New Select based on a Selected Feature

ArcGIS Pro: Layer to KML

ArcGIS Pro Table Join and Spatial Join

Mapping State and County Level Data in Excel

SPSS: Date and Time Wizard

ArcGIS Pro: Multiple Spatial Joins for Counts to Identify Top Neighborhoods

Exporting from ArcGIS Pro to Google Earth Web for Storytelling

Google Scholar: Quick Searches, Saving, and Making Libraries

ArcPro: Zonal Statistics from Crime Kernel Density Estimation (Hotspot Map)

SPSS: Frequencies

Sp23 In-Class: ArcGIS Pro - Adding Field to Calculate Block Group Crime Rates

Sp23 In-Class Week10: Geocoding Crime Incidents and Calculating Crime Rates per Block Group

CrimeStat IV: Primary File and Spatial Descriptives

New Role - Update

ArcGIS Pro: Generate Near Table to move offset crime points to street centerline

Sp23 In-Class: ArcGIS Pro Buffer & KDE (hotspot)

Sp23 In-Class Week 11: ArcGIS Pro - Tools and Average Nearest Neighbor

Sp23 Assignment #7: ArcGIS Pro Select by Attribute and Location

ArcGIS Pro - Table Join - Spatial Join - Summary Within - Clip

Using Excel VLOOKUP to Assign Latitude and Longitude

Excel: Statistic Formulas Available in Formulas Tab

Excel VBA for Geocoding with Google

ArcGIS Pro - Fishnet & KDE

Excel: Merging Datasets with Power Queries

Textafter & Textbefore in Excel to Extract Cell Contents

ArcGIS Pro: Custom Sort

Excel: =SWITCH function to recode

Excel Pivot Table - Percent Row Total & Column Total

SPSS: Introduction & How to Open a Dataset

CrimeStat IV: Introduction & How to Download

Sp23 In-Class Week 2: Temporal Data in Excel

Sp23 Assignment 8: ArcGIS Pro Table & Spatial Join

Beyond Crime Data: CDC PLACES Local Data for Better Health - Zip Code Example (ZCTA)

Excel: How to Rank Values

Creating a Final Map in ArcPRO with Crime Data

ArcPro: Creating a Kernel Density (hotspot) Map and Converting to Point

ArcGIS Pro - Legend - Converting to Graphics

ArcGIS Pro: Using the 80-20 Tool for Law of Crime Concentration

Sp23 Week 6: ArcGIS Pro Selecting by Attribute and Exporting Feature

ArcGIS Pro: Multiple Ring Buffer - Average Nearest Neighbor - SDE and MC

ArcGIS Pro: How to Dissolve Street Layer and then Planarize

Excel: Pivot Table - Temporal Heat Map

ArcPRO Select by Attribute & Export Feature

Excel Data Tools - Remove Duplicates - Consolidate - Text to Columns - Flash Fill