Skip to content
Ken Blake, Ph.D.
Menu
Home
Free minicourses
Six Rules for Writing a Straight News Lead
Media Writing Tips
A three-part intro to data journalism
Basic Data Analysis with Google Sheets
Data Visualization with Google Sheets
Making Data-Driven Maps with Google My Maps
Data analysis
Spreadsheet basics for journalists
SEJ 2019
Finding gender gaps in pay and promotion: pivot tables, chi squares, and t-tests
Analyzing Superbowl Tweets about Tide Pods
Understanding poll error margins and statistical ties
Digging into the raw College Scorecard data
Making data-driven explanatory videos
Getting API data with Excel
Wolfram Alpha demo
Mapping
Making a quick locator map
Making news maps with Google MyMaps
Map gallery
Murfreesboro area maps
Tennessee maps
Southeastern states
Data sources
Coding
Python
Using Python code to access an API
Latest bills by a member of Congress
TN County-level COVID-19 Spreadsheet Reader
Google Mobility Data Downloader
NYTimes COVID-19 County Data Downloader
GDELT Headline Scrape
R
R Data Analysis Guide
GDELT Headline Fetch
Dive Headfirst into R
Mapping ACS data
National Bridge Inventory map
Typical two-bedroom rent tops $1,300 in Rutherford County
Mapping Small-Area Fair Market Rent by ZIP code
Change in a county-level ACS variable
Slider map (median rent)
Slider map code
Job prospects for J-School grads
More
Teams
About me
OCR Scholar Account Application
A D2L Quick Start
MTSU directory
MTSU A-Z links
Advising
Class schedule
MTSU Dates/Deadlines
Final exams schedule
Undergraduate catalog
Campus map
MTSU forms
Spouse/Dependent Discount Form
Going to J-School
Research & Teaching
MTSU Poll
The Data Reporter
Add D2L course user
Final exam schedule
Walker Library
Research poster template
Home
Introduction to using Excel pivot tables
Excel Pivot Table icon
Excel Pivot Table icon
