learning-target-tracker-5sc
Designing scalable AI prompt architectures for diverse learning contexts, from K-12 chemistry scaffolding to undergraduate research assistance. This project validates custom prompts that maximize student self-efficacy, minimize factual error, and provide equitable linguistic support across educational levels.
The LT Tracker (5-SC)
A specialized, error-proof Learning Target tracking system built on Google Sheets for the AI-in-Education project.
Overview and Core Design
This system is built around a single, reusable template file that you can copy for each new **Learning Target**. It features automated reporting and is designed for fast, error-proof data entry on both desktop and mobile devices.
For student privacy, the tracker is designed to work with either student names or anonymous **Student IDs**. Simply choose which identifier to use in your data entry and dashboard tabs to generate either standard or confidential reports.
How the LT Status is Determined Automatically
The **LT Status** column provides a summative judgment on whether a student has mastered the overall Learning Target. It is calculated automatically based on a flexible, data-driven rule.
**The current rule is:** A student has “✅ Met” the Learning Target if the percentage of their graded Success Criteria marked as **High** or **Expected** is 80% or more.
The formula automatically performs these three steps:
- Counts the total number of Success Criteria you’ve graded for a student.
- Counts how many of those grades are **High** or **Expected**.
- Calculates the percentage of success based only on the graded work.
- Compares that percentage to the 80% threshold and displays the final status.