Courses:

Introduction to Computers in Public Management II >> Content Detail



Study Materials



Readings

Amazon logo When you click the Amazon logo tothe left of any citation and purchase the book (or other media) from Amazon.com, MIT OpenCourseWare will receive up to 10% of this purchase and any other purchases you make during that visit. This will not increase the cost of your purchase. Links provided are to the US Amazon site, but you can also support OCW through Amazon sites in other regions. Learn more.


Ses #TopicsReadings
Lecture 1

Introduction To 11.208 And Thematic Mapping

Producing and printing thematic maps

Hutchinson, Scott and Larry Daniel. Inside ArcView GIS. Albany, NY: OnWord Press, 2000. (read Chapter 1: "Introducing ArcView" and Chapter 3: "Getting Started: Projects and Views")

Monmonier, Mark S. How to Lie with Maps. Chicago, IL: University of Chicago Press, 1991. (read "Elements of the Map" and Chapter 2)

Bossard, Earl G. and Haiyan Zhang. "Loosely Coupled PC Programs as a Framework for Spatial Analysis." URISA 1993 Annual Conference Proccedings 3 (1993): 38-47.

Lab ABuilding and printing a simple map from database tables and boundary files
Lecture 2

Crime Case Study and Elementary Database Management

Case study in analytic mapping

Getting data into a database (data import, entry)

Simple queries on a database (selecting fields and records, simple aggregation)

Getting data out of the database (data export)

Ferreira, J. "Spatial Patterns of Property Crimes and Socio-Economic Characteristics." (1986).

Lewis, S. "Data, Computers and Planners."

Ferreira, J. "Database Management Tools for Planning." Journal of the American Planning Association 56, no. 1 (1990): 78-84.

MSQuery Manual: Introduction and Excerpts

Lab BEssential database operations: data input, simple queries, output.
Lecture 3

Making Sense Of The Census, Part I

The 1990 Census of Population and Housing

Tools to extract census data

Using census data: normalization, comparisons over time

U.S. Census Bureau. "Introduction to 1990 Census Products."

U.S. Census Bureau. "Census '90 Basics." 

Lecture 4

Introduction To Relational Databases, Part I

Introduction to the relational model

Intermediate queries: aggregation functions (grouping), multi-table queries

Amazon logo Trimble, J. Harvey and David Chappell. Introducing SQL. New York, NY: John Wiley & Sons, 1989. ISBN: 0471616842. (read Chapter 1, pp. 74-104, 124-137 of A Visual Introduction to SQL)
Lab CBuild and run queries on survey data and urban management records
Lecture 5

Making Sense Of The Census, Part II

The 1990 Census of Population and Housing

  • Tools to extract census data
  • Using census data: normalization, comparisons over time
Hutchinson and Daniel, Chapter 6: "Data Queries," and pp. 78-81 ("Joining Tables," "Joining vs. Link")
Lab DExtracting Census data from STF files
Lecture 6

Principles Of Relational Databases, Part II

Problem Set handed out prior day.

Elements of database design

The relational model of data including "One-to-many" relationships among data tables

Introduction to Structured Query Language (SQL)

Lecture 7

Database Management In Planning

An overview of planning uses of database management, both now and in the future.

Lab ELab session emphasizing Census data and applying the relational model
Lecture 8

Preparing Effective Maps

Tips on preparing maps that communicate accurately, clearly, and persuasively

Hutchinson and Daniel, Chapter 5: "Displaying Data."

Wood, D. "Are Maps Sending Society in the Wrong Direction?" (1993).

Monmonier, M. "Data Maps: Making Nonsense of the Census." Chapter 9 of How to Lie with Maps.

Lab FEnhancing the accuracy, clarity and persuasiveness of the map
Lecture 9

Spatial Analysis And Internet Overview

Introduction to Internet and GIS mapping resources

Web mapping resources

The NCGIA Core Curriculum: NCGIA Core Curriculum in GISci

Marble, D. "The Potential Methodological Impact of Geographical Information Systems." (1990).

Levine J., and Landis, J. "Geographic Information Systems for Local Planning." Journal of the American Planning Association (Spring 1989): 209-220.

Lab GIntegrating orthophotos with census data
Project Demo

Exhibition Of Planning Software And PSS Research Demonstrations of software tools for mapping and spatial analysis

Lecture 10

Course Summary

Introduction to geographical information systems and course summary

Panel Discussion

Drucker, P.F. "Drucker on Management: Be Data Literate -- Know What to Know." Wall Street Journal, December 1, 1992.

Harris, B. "Beyond Geographic Information Systems: Computers and the Planning Professional." Journal of the American Planning Association (1989): 55, 85-90.

Zuboff, S. "Informate the Enterprise: an Agenda for the 21st Century." National Forum (1991).


 








© 2017 CourseTube.com, by Higher Ed Media LLC. All Rights Reserved.