Introduction to Computers in Public Management II

Lecture Notes

Ses #	Topics	Notes
Lecture 1	Introduction To 11.208 And Thematic Mapping Producing and printing thematic maps	Part I: (PDF) Part II: (PDF)
Lab A	Building 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)	Part I: (PDF) Part II: (PDF)
Lab B	Essential 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	(PDF)
Lecture 4	Introduction To Relational Databases, Part I Introduction to the relational model Intermediate queries: aggregation functions (grouping), multi-table queries	(PDF)
Lab C	Build 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	Part I: (PDF) Part II: (PDF) Part III: (PDF) Part IV: (PDF) Part V: (PDF)
Lab D	Extracting 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)	(PDF)
Lecture 7	Database Management In Planning An overview of planning uses of database management, both now and in the future.	(PDF)
Lab E	Lab session emphasizing Census data and applying the relational model
Lecture 8	Preparing Effective Maps Tips on preparing maps that communicate accurately, clearly, and persuasively	(PDF)
Lab F	Enhancing 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	(PDF)
Lab G	Integrating 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	(PDF)
Panel Discussion