skip navigation
Geography Department Banner. Click to link to Geography Department Website
California State University, Northridge Logo. Click to link to the C.S.U.N. home page.

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.

Table of Links
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
download sample data here (.xls)
Many Excel 2010 Yes - Echo 360
         
         
Downloading Census Data (2012) - Video Only: Part 1 Downloading Data from the American Factfinder 2012 Many Web, 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

Downloading Census Data from County Business Patterns
Economic, Medical, Gateway
Web, Excel
No
Downloading Census Data,
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
Web, Google Earth
No
Making point maps with Google Earth
Intro to Human
Web, Google Earth
Making simple point maps.
California
Web, Google Docs
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
Downloading climate data, making graphics
California, Intro to Physical
Web, Excel
No
Reading maps, globes; finding the Qibla using Google Earth
World Regional
Google Earth, Web
Finding spatial concentration of activities
Economic, Medical
Excel
No
Downloading Census data, sorting data, descriptive statistics, correlation coefficients
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
Google Form or Survey
How to use Google Docs to create a survey, questionnaire or data collection device
Many
Google Docs
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.

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