Light Saber Labs 

Below are links to a series of exercises designed to introduce students to a variety of problem solving strategies used by working geographers.

Many of the exercises also introduce students to common tools-of-the trade used by geographers and other scientists.

Most of these exercises are also available for download / use in a learning management system, like Canvas , Blackboard or Moodle.

Data Analysis for Community Organizations

This page contains links to some of the videos and accompanying files for a few of the video tutorials posted on my YouTube Channel.

VIDEO LINK DEMONSTRATED SKILLS FILES

1. Downloading Census Data Downloading Demographic Data from US Census Website (2021) -None

2. Download Data from Los Angeles Data Hub  Downloading Data from Government Data Hub (Los Angeles Police Department Data) -None

3. Convert Vertical Data to Horizontal with Pivot Table Convert Vertical Download Data to Horizontally Arranged Data with Pivot Table LA County Ethnicity Data- Census Tracts, 2010  Excel

4. VLOOKUP Tool to Join Datasets  Join/Merge two tables with a common identifier. Convert numeric data to text.  Text to column tool.  VLOOKUP tool.  EPA and Census Data  Excel

5. Pivot Tables to Join Datasets  Join two tables with a common identifier. Convert numeric data to text.  Text to column tool.  Pivot Table.  EPA and Census Data.  Excel

6. Basic Descriptive Statistics   Part 1 Part 2

7. Calculate Mean, Median, Standard Deviation, Skewness, etc. using formulas and Data Analysis too.  Create Simple Histogram of Data. California Income Tax data by ZIP Code. Excel

8. Calculating Percentiles and Z-Scores Part 1  Part 2  Calculate Percentile Score and Z scores in Excel  California School Enrollment & Lunch Data Excel

9. Calculating T-Tests Part 1 Part 2, One Sample & Two Sample Difference of Means t-Tests Paired Samples Difference of Means t-Test Los Angeles Police Department Data Excel (large file)

10. Calculating Correlation Coefficients Part 1 Part 2, Calculate Pearon’s R Correlation Coefficient & Spearman’s Rho for Ranked Data (skewing) California EPA Data,  Excel

11. Linear Regression, Part 1, Part 2, Creating a Linear Regression Model, Preparing Data for Regression, Interpreting Output Diagnostics, Los Angeles County Fast Food Data (Census) and California Dept. of Education Data, ZIP Code Level, Excel