tf-fm-analysis

This repository contains the code used for the analysis of data for ThinkForward's FutureMe programme. The findings from this analysis are described in the report produced by Dartington Service Design Lab in March 2024.

Getting started

• Clone the repository.
• Populate the folder Datasets in order for the code to run, according to the datasets specified under each notebook in the section below. The dataset filenames must match those specified for each notebook and they must be loaded in .csv format.
• Run the notebooks in the order specified below.

R setup

• Each notebook installs and then loads only the packages it requires.
• The here package is used to set the working directory, ensuring consistent file paths.

Notebooks

v3_cleaning.Rmd

Cleaning and reshaping the demographics & Ready4Work Passport activity dataset (these were provided as a single dataset) and the follow-up calls dataset. Run this notebook first.

Required datasets:

• v3_dem_r4w.csv
• v3_followups.csv

v3_status_change_analysis.Rmd

Contains the code for plotting the follow-up status graphs and producing the status change table. Requires v3_cleaning.Rmd to run first.

v3_11s_unique_dates_analysis.Rmd

Prepares the 1:1 coaching dataset for analysis. Exploratory plotting of 1:1 sessions counted as unique dates. Requires v3_cleaning.Rmd to run first.

Required datasets:

• 1:1attendance.csv

Required scripts:

• v3_simplified_find_year.R

v3_11s_sessions_analysis.Rmd

Prepares the 1:1 coaching dataset for analysis. Exploratory plotting of 1:1 sessions counted as unique entries. Requires v3_cleaning.Rmd to run first.

Required datasets:

• 1:1attendance.csv

Required scripts:

• v3_simplified_find_year.R

v3_group_analysis.Rmd

Prepares the group coaching dataset for analysis. Exploratory plotting of group coaching sessions. Requires v3_cleaning.Rmd to run first.

Required datasets:

• group_coaching.csv

Required scripts:

• v3_simplified_find_year.R

v3_combined_attendance.Rmd

Joins 1:1 and group coaching counts and proportions. Calculates the combined completion proportions. Merges completion dataset with follow-up status. Produces plots for the combined completion by status, and separate plots for 1:1 and group coaching. Requires v3_cleaning.Rmd to run first.

Required datasets:

• 1:1attendance.csv
• group_coaching.csv
• v3_followups.csv

Outputs

A folder for saving outputs.

Scripts

Contains scripts used in this analysis. Ensure that this folder is defined as the source before running a script.

v3_simplified_find_year.R

A script to find the programme year based on the date of an acitivity and an individual's start date.

Graphs

Some of the notebooks will output .png images to the Graphs folder.