# Dr. Steven M. Graves

## Tutorials - Labs - Assignments

### Dr. Graves' Geography Tutorials

The links below are to the tutorials, labs and other assignments from various courses taught by Dr. Graves. They are presented here, in table format to help students find "how to" guides to various skills presented in class, especially after they've moved on to other courses and want a refresher on specific techniques and concepts.

Warning: Some of these are a bit dated and the software to which they refer may have changed, thereby altering the quality of the instructions.

### Tutorials

The table below contains an assortment of assignments, labs and techniques presented to students in my various courses.

Tutorial or Assignment Skills Course(s) Software Video
Introduction to Microsoft Excel
2012
Video Only
Basics: Sorting Data, preparing data,
filling columns with serial data
Many Excel 2010 Yes - Echo 360

Preparing Cenus Data in Excel for joining with ArcMap
(2012) - Video Only: Part 2
Using concatenate and text-to-column tools in Excel to prepare census data for table join in ArcMap 10.1 Many Excel 2010 Yes - Echo 360

Geocoding, Importing address data in to ArcMap
**Batchgeo's outstanding web service has been disabled, so only the latter half of this tutorial is useful.

Many
Web, Excel, Arc Map
Geocoding, Importing address data in to ArcMap
Many
Web, Excel, Arc Map
No

Economic, Medical, Gateway
Web, Excel
No
Preparing data in Excel 2003 for ArcMap 9.3,
Joining spreadsheet data to map files, troubleshooting join problems.
Economic, Medical, Gateway
Web, Excel 2003, ArcMap 9.3
Yes -Wink
Comparing maps, calculating correlation coefficients, hypothesis testing
Intro to Human
Web
No
Making site location decisions
Intro to Human, Medical
No
Making point maps with Google Earth
Intro to Human
Making simple point maps.
California
No
Finding the center point of many points
Economic, Medical
Excel, Arc Map
No
Making Buffers around points
How to create buffers around point features
(or polygons or line features)
Many
Arc Map
Finding potential trade area of points
Economic, Medical
Arc Map
No
California, Intro to Physical
Web, Excel
No
World Regional
Finding spatial concentration of activities
Economic, Medical
Excel
No
Many
Excel ('03 & '07), Web
Calculating several basic statistics, making some graphs
Economic, Medical, Gateway
SPSS
No
Calculating the likely amount of spatial interaction between two places, trade areas of cities.
Economic, Medical
Excel
No
Simple Field Calculations in ArcMap
Video detailing how to add a new column (field) of data to a map and how to calculate values inside the new column
Many
ArcMap
Finding minimum travel distances for customers, deliverers of goods
Economic, Medical
Excel
No
How to use Google Docs to create a survey, questionnaire or data collection device
Many
Calculating the distribution of people, businesses, wealth, etc.
Economic, Medical
Excel
No
Ordinary Least Squares Regression
Checking to see the relationship between a group of causal variables and an dependent outcome variable
Many
Arc Map
Spatial Autocorrelation
Checking to see if the variables in space are unduly affecting the behavior of their neighbors
Many
Arc Map

If you need to contact me, my email, postal and electronic addresses can all be found at the bottom of the left-hand navigation bar.

About Dr. Graves | Site Map | Contact Dr. Graves | ©2003 Steven M. Graves - Geography Department, California State University - Northridge