Conducted over a one-week period, the in-person training was divided into four main milestones, with a final goal of showcasing project work:
- Milestone I - Introduction & Defining A Question
- Milestone II - Learning Languages
- Milestone III - Presenting Insights
- Milestone IV - Getting and Manipulating Data
| Date | Half Day | Milestone | Activity | Duration (minute) | Start Time | End Time | Description | Responsible |
|---|---|---|---|---|---|---|---|---|
| DAY 1 | ||||||||
| 29/01/ | 1 | Milestone I | Workshop overview and logistics | 0:30:00 | 09:00 | 09:30 | Scoda | |
| 29/01/ | 1 | Milestone I | Introduction: why TI data training | 0:30:00 | 09:30 | 10:00 | To provide an overview of the course and introduce the School of Data Pipeline as an effective framework for working with data. | Scoda |
| 29/01/ | 1 | Milestone I | Introduction: why TI data training | 0:45:00 | 10:00 | 10:45 | To provide an overview of the course and introduce the School of Data Pipeline as an effective framework for working with data. | Scoda |
| 29/01/ | 1 | Milestone I | Exercise: Define Your Project Question | 0:20:00 | 10:45 | 11:05 | To provide an overview of the course and introduce the School of Data Pipeline as an effective framework for working with data. | Scoda |
| 29/01/ | 1 | MORNING TEA BREAK | 0:30:00 | 11:05 | 11:35 | |||
| 29/01/ | 1 | Milestone I | Exercise: Define Your Project Question | 0:20:00 | 11:35 | 11:55 | To also begin define a question to explore as groups for the final data project and presentations. | Learners |
| 29/01/ | 1 | Milestone II | Lesson 1: Introduction to Relational Database Management Systems (RDBMS) | 1:05:00 | 11:55 | 13:00 | Understand the different types of relational database management systems and how they can be used to organise and store relevant dataset for easy manipulation,access and analysis. | Scoda |
| 29/01/ | 1 | LUNCH & BREAK | 1:00:00 | 13:00 | 14:00 | |||
| 29/01/ | 2 | Milestone II | Lesson 2: Structured Query Language (SQL) | 2:10:00 | 14:00 | 16:10 | learn about SQL, one of the most common query languages used by most database systems to store, get, manipulate and analyse data. | Scoda |
| 29/01/ | 2 | AFTERNOON TEA BREAK | 00:20:00 | 16:10 | 16:30 | |||
| 29/01/ | 2 | Milestone II | Exercise: Lesson 1 & 2 | 0:40:00 | 16:30 | 17:10 | Learners | |
| 29/01/ | 2 | Milestone II | Lesson 3: Introduction to the R Programming Language | 1:00:00 | 16:30 | 17:30 | learn to use R, a statistical and graphical programming language and environment used by many data professionals around the world. This lesson will provide basic familiarity with the R syntax and features to serve as a foundation for more advanced data work in subsequent lessons. | Scoda |
| 29/01/ | 2 | Milestone II | Practical Lab: Lesson 3 | 1:00:00 | 17:30 | 18:30 | Breakout Session | Learners |
| Date | Half Day | Milestone | Activity | Duration (minute) | Start Time | End Time | Description | Responsible |
|---|---|---|---|---|---|---|---|---|
| DAY 2 | ||||||||
| 30/01/ | 1 | Recap & Overview | 0:30:00 | 09:00 | 09:30 | Scoda | ||
| 30/01/ | 1 | Milestone II | Lesson 3: Introduction to the R Programming Language | 0:30:00 | 09:30 | 10:00 | Scoda | |
| 30/01/ | 1 | Milestone II | Lesson 3: Introduction to the R Programming Language | 0:30:00 | 10:00 | 10:30 | Scoda | |
| 30/01/ | 1 | MORNING TEA BREAK | 0:30:00 | 10:30 | 11:00 | Scoda | ||
| 30/01/ | 1 | Milestone II | Lesson 3: Introduction to the R Programming Language | 1:30:00 | 11:00 | 12:30 | Learners | |
| 30/01/ | 1 | Milestone III | Group discussions | 0:30:00 | 12:30 | 13:00 | Scoda | |
| 30/01/ | 1 | LUNCH & BREAK | 1:00:00 | 13:00 | 14:00 | |||
| 30/01/ | 2 | Milestone III | Exercise: Data Frames | 1:30:00 | 14:00 | 15:30 | Learners | |
| 30/01/ | 2 | Milestone III | Lesson 2: Visual Design Principles | 1:00:00 | 15:30 | 16:30 | Scoda | |
| 30/01/ | 2 | Milestone III | Exercise: Visual Design Principles | 0:30:00 | 16:30 | 17:00 | Learners | |
| 30/01/ | 2 | AFTERNOON TEA BREAK | 0:30:00 | 17:00 | 17:30 | |||
| 30/01/ | 2 | Milestone III | Lesson 3: Creating Static Presentations | 1:00:00 | 17:30 | 18:30 | Scoda | |
| 30/01/ | 2 | Milestone III | Exercise: Creating Static Presentations (ggplot2) | 0:30:00 | 18:30 | 19:00 | Learners |
| Date | Half Day | Milestone | Activity | Duration (minute) | Start Time | End Time | Description | Responsible |
|---|---|---|---|---|---|---|---|---|
| DAY 3 | ||||||||
| 31/01/ | 1 | Recap & Overview | 0:30:00 | 09:00 | 09:30 | Scoda | ||
| 31/01/ | 1 | Milestone III | Lesson 3: Creating Static Presentations | 0:30:00 | 09:30 | 10:00 | Scoda | |
| 31/01/ | 1 | Milestone III | Lesson 3: Creating Static Presentations | 0:30:00 | 10:00 | 10:30 | Scoda | |
| 31/01/ | 1 | MORNING TEA BREAK | 0:30:00 | 10:30 | 11:00 | |||
| 31/01/ | 1 | Milestone III | Exercise: Creating Static Presentations (R + Presentation Software) | 0:30:00 | 11:00 | 11:30 | Learners | |
| 31/01/ | 1 | Milestone III | Lesson 3: Creating Static Presentations | 1:00:00 | 11:30 | 12:30 | Scoda | |
| 31/01/ | 1 | LUNCH & BREAK | 1:00:00 | 12:30 | 13:30 | |||
| 31/01/ | 2 | Milestone III | Exercise: Creating Static Presentations (R + Vector Graphics Software) | 0:30:00 | 13:30 | 14:00 | Learners | |
| 31/01/ | 2 | Milestone III | Practice Lab: Creating Static Presentations | 1:00:00 | 14:00 | 15:00 | Learners | |
| 31/01/ | 2 | Milestone III | Lesson 4: Creating Interactive Presentations | 0:30:00 | 15:00 | 15:30 | Scoda | |
| 31/01/ | 2 | AFTERNOON TEA BREAK | 0:30:00 | 15:30 | 16:00 | |||
| 31/01/ | 2 | Milestone III | Lesson 4: Creating Interactive Presentations | 1:00:00 | 16:00 | 17:00 | Scoda | |
| 31/01/ | 2 | Milestone III | Exercise: Creating Interactive Presentations (Google Data Studio, Tableau or Plotly) | 0:30:00 | 17:00 | 17:30 | Learners |
| Date | Half Day | Milestone | Activity | Duration (minute) | Start Time | End Time | Description | Responsible |
|---|---|---|---|---|---|---|---|---|
| DAY 4 | ||||||||
| 01/02/ | 1 | Recap & Overview | 0:30:00 | 09:00 | 09:30 | Scoda | ||
| 01/02/ | 1 | Milestone III | Lesson 4: Creating Interactive Presentations (shiny apps) | 0:30:00 | 09:30 | 10:00 | Scoda | |
| 01/02/ | 1 | Milestone III | Lesson 4: Creating Interactive Presentations (shiny apps) | 0:30:00 | 10:00 | 10:30 | Scoda | |
| 01/02/ | 1 | MORNING TEA BREAK | 0:30:00 | 10:30 | 11:00 | |||
| 01/02/ | 1 | Milestone III | Lesson 4: Creating Interactive Presentations (shiny apps) | 0:30:00 | 11:00 | 11:30 | Scoda | |
| 01/02/ | 1 | Milestone III | Practice Lab: Creating Interactive Presentations (shiny apps) | 1:00:00 | 11:30 | 12:30 | Leaners | |
| 01/02/ | 1 | LUNCH & BREAK | 1:00:00 | 12:30 | 13:30 | |||
| 01/02/ | 2 | Milestone IV | Lesson 1: Tidy Data Format | 0:30:00 | 13:30 | 14:00 | Scoda | |
| 01/02/ | 2 | Milestone IV | Lesson 2: Data manipulation with dplyr | 1:00:00 | 14:00 | 15:00 | Scoda | |
| 01/02/ | 2 | Milestone IV | Lesson 3: Databases + R | 0:30:00 | 15:00 | 15:30 | Scoda | |
| 01/02/ | 2 | AFTERNOON TEA BREAK | 0:30:00 | 15:30 | 16:00 | |||
| 01/02/ | 2 | Milestone IV | Exercise: Lesson 1 - 3 | 1:00:00 | 16:00 | 17:00 | Learners | |
| 01/02/ | 2 | Milestone V | Project Work Overview | 0:30:00 | 17:00 | 17:30 | Scoda |
| Date | Half Day | Milestone | Activity | Duration (minute) | Start Time | End Time | Description | Responsible |
|---|---|---|---|---|---|---|---|---|
| DAY 5 | ||||||||
| 02/02/ | 1 | Recap & Overview | 0:30:00 | 09:00 | 09:30 | Scoda | ||
| 02/02/ | 1 | Milestone V | Project Work | 0:30:00 | 09:30 | 10:00 | Learners | |
| 02/02/ | 1 | Milestone V | Project Work | 0:30:00 | 10:00 | 10:30 | Learners | |
| 02/02/ | 1 | MORNING TEA BREAK | 0:30:00 | 10:30 | 11:00 | |||
| 02/02/ | 1 | Milestone V | Project Work | 1:00:00 | 11:00 | 12:00 | Learners | |
| 02/02/ | 1 | Milestone V | Project Work | 0:30:00 | 12:00 | 12:30 | Learners | |
| 02/02/ | 1 | LUNCH & BREAK | 1:00:00 | 12:30 | 13:30 | |||
| 02/02/ | 2 | Milestone V | Project Work | 1:00:00 | 13:30 | 14:30 | Learners | |
| 02/02/ | 2 | Milestone V | Project Presentations | 0:30:00 | 14:30 | 15:00 | Learners | |
| 02/02/ | 2 | Milestone V | Project Presentations | 0:30:00 | 15:00 | 15:30 | Learners | |
| 02/02/ | 2 | AFTERNOON TEA BREAK | 0:30:00 | 15:30 | 16:00 | |||
| 02/02/ | 2 | Milestone V | Project Presentations | 0:45:00 | 16:00 | 16:45 | Learners | |
| 02/02/ | 2 | Feedback & Next Steps | 0:45:00 | 16:45 | 17:30 | Scoda |