Spatial Social Sciences Training Series LEVEL 1: FOUNDATIONS OF SPATIAL SOCIAL SCIENCES (BEGINNER)

Session 1 Exercise Workbook

Training Dataset

A beginner-friendly introduction to cartography for spatial social science. Learn how visual hierarchy, color theory, and good map design turn raw data into clear, meaningful, and accessible maps. Perfect for anyone learning to communicate insights through spatial visualization.

This is Lesson 2 Part 2

Part 3: Data Quality & Preparation
○ Common data quality issues in social datasets
○ Cleaning and validating spatial attributes
○ Practical Exercise: Cleaning a messy survey dataset

Part 3: Data Quality & Preparation
○ Common data quality issues in social datasets
○ Cleaning and validating spatial attributes
○ Practical Exercise: Cleaning a messy survey dataset

Geocoding Fundamentals (30 min)
○ Address matching and geocoding services
○ Coordinate systems and projections for social data

Hands-on: From Excel/CSV to Map (1 hour)
○ Importing tabular data into QGIS
○ Adding XY coordinates (lat/long conversion)
○ Geocoding addresses using MMQGIS plugin
○ Reverse geocoding techniques
○ Exercise: Geocode a household survey dataset

Joining Non-Spatial Data to Spatial Boundaries (30 min)
○ Table joins: demographic data to census tracts/wards
○ Spatial joins: attaching contextual information
○ Exercise: Join poverty data to administrative boundaries

📋 LEARNING OBJECTIVES
By the end of this session, you will be able to:
● [ ] Import CSV data with coordinates into QGIS as point features
● [ ] Understand coordinate systems and projections
● [ ] Geocode addresses using MMQGIS plugin
● [ ] Perform table joins to link demographic data to spatial boundaries
● [ ] Perform spatial joins to attach contextual information
● [ ] Export spatial data for future use

Cartographic Principles for Social Research (30 min)
○ Visual hierarchy and focus
○ Color theory: sequential, diverging, categorical schemes
○ Accessibility considerations (colorblind-friendly palettes)

Cartographic Principles for Social Research (30 min)
○ Visual hierarchy and focus
○ Color theory: sequential, diverging, categorical schemes
○ Accessibility considerations (colorblind-friendly palettes)

By the end of this session, you will:
1. Understand cartographic principles for social research
2. Create choropleth maps for continuous data
3. Use proportional symbols for count data
4. Choose appropriate color schemes
5. Create heat maps for density visualization
6. Design maps that communicate effectively