Student Resources

Description

Resources will be released on this companion site as they become available.

Downloadable PDF tutorials
Video tutorials
Student exercises
Downloadable data sets from in-text case studies

Please send all corrections to questions@thedatajournalist.ca

Explore Resources:

Appendix A

Data Integrity and Cleaning

Data Integrity and Cleaning

Introduction to HTML and CSS

Building a Twitter Bot

Introduction to JavaScript

Building Your First News App

Extracting Tables from PDF Files

Live Exercise Based on Published Story, with Downloadable Data from the Story

Getting Data into Your Spreadsheet

Calculating Percentages of Totals

Creating and Using an Excel Chronology

Doing Cool Stuff with Paste Special

Working with Specialized Functions and Formulas in Excel

Sorting and Filtering in a Spreadsheet

Using Pivot Tables in Excel

Installing and Configuring the MySQL Server

Exploring the Microsoft Access User Interface

Exploring Navicat and Sequel Pro

Backing Up Your Data in Access and MySQL

Making Tables and Importing Data into Access

Making Tables and Importing Data into MySQL

Getting Started Writing Queries in Access

Getting Started Writing Queries in MySQL

Indexing Tables in Microsoft Access

Indexing Tables in MySQL

SQL Queries to Add, Modify, and Delete Table Data

Exporting Data from Access and MySQL

Building Maps with Google Fusion Tables

Building Maps with ArcGIS Online

List of Online Geocoding Services and Costs

Building Maps with Carto

How to Install QGIS

Quick Tour of ArcGIS Desktop

Quick Tour of ArcGIS Pro

A Quick Tour of QGIS

Joining Maps to Other Datasets in ArcGIS

Joining Maps to Other Datasets in ArcGIS Pro

Joining Maps to Other Datasets in QGIS

Selecting Features in ArcGIS Desktop

Data for Selecting Features in ArcGIS Desktop

Selecting Features in ArcGIS Pro

Selecting Features in QGIS

Buffering in ArcGIS Desktop

Buffering in ArcGIS Pro

Buffering in QGIS

Spatial Joins in ArcGIS Desktop

Spatial Joins in ArcGIS Pro

Spatial Joins in QGIS

Making Choropleth Maps in ArcGIS Desktop

Making Choropleth Maps in ArcGIS Pro

Making Choropleth Maps in QGIS

Geocoding in ArcGIS Desktop

Geocoding in ArcGIS Pro

Geocoding in QGIS

Working with Projections in ArcGIS Desktop

Working with Projections in ArcGIS Pro

Working with Projections in QGIS

Modifying Layers in ArcGIS Desktop

Modifying Layers in ArcGIS Pro

A Guide to Coordinate Systems

A Guide to Tableau Public Visualizations

A Guide to Google Fusion Tables Visualizations

Scraping Programs and Online Utilities

Using Development Tools to Examine Webpages

Choosing a Code Editor

Getting Python Up and Running

Running Python Scripts

Dealing with Errors in Python

Your First Multi-Page Scrape

Scraping Sites with Search Form

Scraping Sites that Use JavaScript and AJAX

Scraping Sites that Don’t Want to be Scraped/Scraping Sites that Use Search Forms

Scraping Using Regular Expressions

Using the Facebook and Twitter APIs

Printed from , all rights reserved. © Oxford University Press, 2024