At Risk Student Tracker Guide
Specialized Intervention Sheet
At-Risk Student Tracker
High school dashboard blueprint featuring Missouri Option, credit tracking, and MTSS alignment.
AT-RISK UNIT
Google Sheets Design
This tracker is engineered specifically for counseling and admin teams to monitor credit-deficient students, grade progression, and eligibility for alternative pathways like the Missouri Option Program (for credit-deficient students who are at least 16 and at risk of not graduating).
At-Risk Sheet Layout Mockup
A
B
C
D
E
F
G
ID
Student Name
Grade
Credit Deficit
Missouri Option
Risk Flag
Active Interv.
01
Jackson, Marcus
11
-4.5 Credits
YES (Active)
🔴 HIGH RISK
GED Prep / Core Recov
02
Rios, Samantha
12
-1.5 Credits
No (Eligible)
🟡 MOD RISK
After-School Academy
03
Thompson, Leo
10
0.0 Credits
Not Eligible
🟢 ON TRACK
None
Column Configurations & Verification Rules
Configure these exact column headers and dropdown lists in Google Sheets to track credits and Missouri Option candidacy correctly.
| Column Header | Data Type | Dropdown / Verification Values | Purpose |
|---|
| Missouri Option | Dropdown | YES (Active), No (Eligible), Not Eligible, Completed | Marks active or eligible status for Missouri Option pathway. |
| Credit Deficit | Decimal/Number | Negative Number (e.g., -3.5, -1.0) | Calculates credit deficiency relative to the state graduation track. |
| Academic Status | Dropdown | Passing All, Failing 1 Course, Failing 2+ Courses | Indicates real-time classroom grade issues during quarter updates. |
| MTSS Intervention | Dropdown | Tier 1 (Core), Tier 2 (Targeted), Tier 3 (Intensive) | Directly aligns academic tracking with multi-tiered team support. |
AT-RISK STUDENT SPREADSHEET BLUEPRINT PAGE 1 OF 3
Automation Engine
At-Risk Formulas
Copy-paste formulas to flag credit gaps and determine Missouri Option eligibility.
GOOGLESHEETS
At-Risk Specific Logic
1. Missouri Option Candidacy Qualifier
Output: Text Status
Checks if student is age 16 or older (Col F), grade 11 or 12 (Col C), and has severe credit deficit of 3 or more missing credits (Col D).
Cell G2 Formula =IF(AND(F2>=16, OR(C2=11, C2=12), D2<=-3.0), "Eligible Candidate", "Not Eligible")
2. Compound Academic Risk Status
Output: Alert String
Flags critical status if credit deficit is severe (-4.0 credits or worse) or if the student is currently failing 2 or more core classes (Col H).
Cell I2 Formula =IFS(
OR(D2<=-4.0, H2="Failing 2+ Courses"), "🔴 CRITICAL",
OR(D2<=-1.5, H2="Failing 1 Course"), "🟡 WARNING",
TRUE, "🟢 ON TRACK"
)
3. Real-Time Credit Deficit Calculator
Output: Numeric Deficit
Calculates deficiency (negative number) by comparing expected credits-to-date (Col J) with student's earned credits (Col K).
Cell D2 Formula =K2 - J2
At-Risk Color Formatting Keys
Set these rules for active monitoring so administrative staff can scan and route high-risk files instantly.
Critical Flag
Value: Cell is equal to "🔴 CRITICAL". Rows immediately turn soft red to highlight severe credit deficiency.
Warning Flag
Value: Cell is equal to "🟡 WARNING". Colors text amber for intermediate intervention needs.
Missouri Option Candidate
Value: Cell is equal to "Eligible Candidate". Marks potential Missouri Option pathway transfers in soft indigo.
AT-RISK STUDENT SPREADSHEET BLUEPRINT PAGE 2 OF 3
Credit Recovery Integration
Intervention Guide
Structured workflows and action log templates for counselor review meetings.
MO OPTION PROTOCOL
Intervention Sheet
Missouri Option (MO Option) Eligibility Checklist
To enroll a flagged student into the Missouri Option Program, they must meet the following criteria:
Age Threshold: Student is at least 16 years of age.
Credit Gap: Student is at least one full calendar year behind their graduating class.
Official Request: Parental permission form signed and filed in student permanent records.
Enrollment State: Registered in the local public high school program full-time during study.
At-Risk Student Intervention Profile
Draft notes here before updating the central tracking spreadsheet.
Date: ________________
Student Name:
Grade Level:
Total Earned Credits:
Missouri Option Target?
⬜ Yes ⬜ No ⬜ Pending
Academic Risk Factors Identified:
Severe Credit Gap Chronic Truancy Failing Math/ELA Special Ed Needs
Counselor / Support Team Discussion Log:
Actionable Graduation Pathway Plan (e.g. Credit Recovery, Missouri Option, Night School):
AT-RISK STUDENT SPREADSHEET BLUEPRINT PAGE 3 OF 3
Online Enrollment Tracker Guide
Virtual Learning Administration
Online Enrollment Tracker
Design framework for full-time online, part-time, hybrid, and remote student rosters.
ONLINE UNIT
Google Sheets Design
This specialized blueprint helps administrators and online coordinators monitor virtual students. By separating full-time online, part-time, and hybrid learners, schools can ensure customized pacing, equitable access, and timely virtual wellness checks.
Online Enrollment Sheet Layout Mockup
A
B
C
D
E
F
G
ID
Student Name
Enrollment Type
Sync Attendance
At Risk
Tech Barrier
Engagement Indicator
01
Carter, Benjamin
Full-Time Online
52.0%
YES
Broken Device
🔴 OFFLINE DISCONNECT
02
Gomez, Isabella
Part-Time / Hybrid
81.5%
No
None
🟡 SLOW PACE
03
Nguyen, Tyler
Full-Time Online
96.8%
No
None
🟢 HIGHLY ACTIVE
Field & Validation Setup Rules
Build these specific dropdowns into the online roster sheet to simplify tracking of part-time, full-time, and hybrid learner states.
| Column Header | Data Type | Dropdown / Validation Values | Purpose |
|---|
| Enrollment Type | Dropdown | Full-Time Online, Part-Time / Hybrid, Remote Async | Filters roster immediately between virtual-only and hybrid models. |
| Online At-Risk? | Dropdown | YES, NO | Cross-references academic at-risk flags directly in the online system. |
| Tech Barriers | Dropdown | None, Device Issue, Wi-Fi Issue, Software Locked | Identifies the hardware/software bottleneck blocking active logging. |
| Last Virtual Touch | Date Only | Valid Date (MM/DD/YYYY) | Flags weeks of silence or non-response in fully virtual modes. |
ONLINE ENROLLMENT SPREADSHEET BLUEPRINT PAGE 1 OF 3
Automation Engine
