Load all CAP data tables from S3

Reads every coaching action plan (CAP) data table that was written by the new_update_caps_26 automation and returns them as a named list of tibbles. Tables are stored as Parquet files in the coaching-data-tl S3 bucket.

The returned list contains the following elements:

ids

One row per unique CAP (teacher × cycle). Includes cap_id, teacher_name, district, school, start_date, end_date, cycle_num, coach, content_area, and sheet_id.

area_of_focus

IPG indicator and rationale for each CAP.

smart_goals

The full SMART goal string for each CAP.

metrics

Observable evidence of success ratings, long format.

action_plans

Menu of coaching moves selected for each CAP.

progress_monitoring

Per-date progress monitoring ratings, long format.

decision_log

Decision log entries grouped by date and category.

reflections

Post-cycle reflection question / response pairs.

Usage

get_cap_data(
  cycle = 1L,
  tables = c("ids", "area_of_focus", "smart_goals", "metrics", "action_plans",
    "progress_monitoring", "decision_log", "reflections")
)

Arguments

cycle

Integer scalar (1, 2, or 3). Which coaching cycle's data to return. Defaults to 1.

tables

Character vector naming which tables to load. Defaults to all eight tables. Valid values are "ids", "area_of_focus", "smart_goals", "metrics", "action_plans", "progress_monitoring", "decision_log", and "reflections".

Value

A named list of tibbles.