Skip to contents

Database backends

init_tracking_db()
Initialize a tracking SQLite database
connect_tracking_db()
Connect to an existing tracking SQLite database
connect_postgres_tracking_db()
Connect to a PostgreSQL tracking database
create_schema()
Create the tracking database schema

Tracking attempts

track_attempt()
Record a simulated tutorial attempt
get_attempts()
Read recorded attempts
get_tracking_student_id()
Read the tracking student identifier
track_gradethis_attempt()
Track an attempt from a gradethis check

Metadata and configuration

register_students()
Register expected students
get_students()
Read registered students
register_courses()
Register courses
get_courses()
Read registered courses
register_tutorials()
Register tutorials
get_tutorials()
Read registered tutorials
register_questions()
Register expected tutorial questions
get_questions()
Read registered tutorial questions
create_tracking_config_template()
Create a tracking configuration template
read_tracking_config()
Read a tracking configuration
load_tracking_config()
Load a tracking configuration into a database

Scoring and exports

compute_scores()
Compute summarized tutorial scores
gradebook()
Build a gradebook with expected questions
check_pilot_readiness()
Check pilot readiness before teacher exports
export_results()
Export attempts or scores to CSV
moodle_grades()
Create a Moodle-ready grade CSV table
export_moodle_grades()
Export Moodle-ready grades to CSV
canvas_grades()
Create a Canvas Gradebook CSV table
export_canvas_grades()
Export Canvas Gradebook grades to CSV
tracking_export_data()
Prepare rich export data
export_tracking_bundle()
Export a rich tracking CSV bundle

learnr helpers

get_learnr_tracking_env()
Read learnr tracking launch environment
setup_learnr_tracking()
Set up tracking for a learnr tutorial
open_learnr_tracking_db()
Open the tracking database for a learnr context
tracked_question()
Create a tracked learnr question
tracked_question_radio()
Create a tracked learnr radio question
tracked_question_checkbox()
Create a tracked learnr checkbox question
tracked_question_text()
Create a tracked learnr text question
tracked_question_numeric()
Create a tracked learnr numeric question

Dashboard, analytics, and reports

dashboard_data()
Prepare dashboard data
run_dashboard()
Run the teacher dashboard
run_dashboard_connection()
Run the teacher dashboard from an open DBI connection
run_dashboard_postgres()
Run the teacher dashboard from PostgreSQL
summarise_questions()
Summarise tutorial questions
summarise_students()
Summarise tutorial students
detect_difficult_questions()
Detect potentially difficult questions
detect_stalled_students()
Detect potentially stalled students
teacher_report_data()
Prepare teacher report data
generate_teacher_report()
Generate an HTML teacher report

Privacy utilities

delete_student_data()
Delete one student's tracking data
pseudonymise_results()
Pseudonymise student identifiers in result tables
anonymise_results()
Remove direct identifiers from result tables