Urban Planning 5/6010-001: Urban Research
Fall 2007
Tuesday - Thursday 3:40-5:00 PM
Tuesdays: Lecture BUC 106
Thursday: Lab 1: BEHS 101
Thursday Lab 2: BUC 103

---

Note: Class Website is migrating to WebCT

Lectures from 2006

Introduction to Demographics

Fertility: Definitions and Trends

Mortality: Measures and Trends

Federal Data Sources

Guest Lecture: Paul Allred, Community Development Director, City of Holladay

Demographic Trends Impacting Utah

Fitting Equations to Data

Describing Trends in Time Series Data

Interpolation

Measures of Distribution and Concentration – Excel File with Examples

Survey Data: Error and Limitations

Descriptive Statistics

Inferential Statistics

Microdata - PUMS

Population Estimates

Regional Economics

Labs from 2006

Lab 1

Excel Basics

AnnualExpenses.xls Consolidate.xls Outline.xls good_bad_Tables.xls

Lab 2

Data Evaluation, Validation, Scenarios, and Formulas

ConditionalFormat.xls Subtotal.xls Filter.xls Scenario.xls Validate.xls

Autosum.xls ChangeValues.xls Conditional Format.xls

Lab 3

Data Sources: Locating, Importing, Manipulating

CopyData.doc CopyData.txt TextColumns.xls Database.mdb urpop0090.txt

Lab 4

Creating Charts and Graphs in Excel

good_bad_chart.xls ChartType.xls ExplodePie.xls AddTrendline.xls AddDataSeries.xls MultipleCharts.xls

Lab 5

Pivot Tables and Pivot Charts

Files for Lab 5 are in this folder

Lab 6 & 7

Evaluating a Time Series Variable: Salt Lake County Logarithm Exploration

Interpolation

Lab 8

Measures of Distribution and Similarity

Labs 9 and 10

Sampling Distributions Project 7 Work Sessions

Labs 11

Project 8 Work Session

Recommended On-line Tutorials Covering VERY INTRODUCTORY Excel:
Florida Gulf Coast University
University of North Carolina, Chapel Hill
Naval Academy
University of South Dakota
Indiana University of Pennsylvania