1.1 - Intros & reboots
Introductions to each other and to re-introducing yourself to Excel.
Weekly details
Here are the individual weeks’ pages. The pages more than 3 weeks in advance are expected to change.
1.2 - Data types, and a letter to your future self
The data diary and speeding cops. In every project you have at least one other collaborator: future-you.
2.1 - Filtering and sorting in Excel
Thinking like a data journalist; filtering and sorting in Excel
2.2 - Excel pivot tables and group by
Counting and grouping in Excel with pivot tables
3.1 - Tidy data and learning to read like a writer
Tidy data principles and reading like a writer
4.1 - Excel exam
How to get ready for your Excel exam and a gentle introduction to programming
5.1 - Intro to R and R Markdown
We’re not going to program in R quite yet. Right now, we’ll spend some time getting comfortable with it. If you plan to work on your own computer, spend some...
5.2 - Intro to Data Frames
We’ll start moving from Excel to R, starting with the data used in the exam and working toward new data.
6 - Replicating your work in Excel with R
Filtering, arranging, grouping and summarising. You’ve done it all before, just not with the British spelling.
7.1 Merging in R
A key advantage of data programs like R is the ability to merge to data tables together. You’ll see how here.
10 - Visualization as a reporting tool
Data visualization can help you find the story - don’t think of it as just something for publication.
11 - Scraping web sites
Getting data off of the Web can be easy or hard. You won’t know until you try. This week we’ll go through strategies and concepts of data on the Web.
14 - Data hunt resources
Getting data off of the Web can be easy or hard. You won’t know until you try. This week we’ll go through strategies and concepts of data on the Web.