- Before
- Finds out which programs might qualify from memory and the catalog, then chases a schedule from each program lead.
- Now
- Opens one plot with each program inside or outside the rectangle, the rule each one misses, and what it would take for the rest.
A phlebotomy program's workforce Pell review, from schedule to signed packet
One weekday in the fall at the college: 41 noncredit programs on three campuses, and the state's spring review window closes in 23 days. Here is how Phlebotomy Technician, and the programs around it, move through the working solution, screen by screen.
A worked example on sample data. Names, IDs and figures on the screens and in this section come from the demo.
- 01Overnight
Each short program read and placed before the office opens
Seven agentsBetween 2:00 and 2:14 AM the agents re-read 94 section schedules, 41 course outlines, 19 articulation agreements, 63 employer letters, the 2026–27 state in-demand list and the latest second-quarter state wage file. On the eligibility map, 26 programs sit inside the rectangle of 150 to 599 clock hours and 8 to fewer than 15 weeks, 14 of them pass each check, and 15 sit outside, each with the rule it misses written beside it.
The state window closes in 23 days, and 4 items wait for the dean.
- 029:10 AM
Commercial Truck Driving sits outside, and the agent says what it would take
Dean of workforce programsCDL Class A is a hollow dot labeled "below 8-week minimum": 160 clock hours, but only 4 weeks, Monday to Friday from 7:00 AM to 3:50 PM. The agent keeps the 160 hours and spreads them over 8 weeks of evenings and Saturday mornings, 20 clock hours a week, then dates it against the one-year rule: the first evening section in January, a year at that length by the next January, and the earliest request to the state then. The dean has until a set date to send it to the program lead or decline it with a reason.
The 4-week day version keeps running without Pell.
- 03One click
Phlebotomy Technician, inside the rectangle, with its checklist under the plot
Dean of workforce programs168 clock hours over 10 weeks. Under the plot: completion 81% within 150% of normal time, placement 74% in the second quarter after exit, phlebotomists (31-9097) on the 2026–27 in-demand list, and 4 credits toward the AAS Medical Assisting. Under "Also checked": offered at this length for years, and 0% delivered by another organization. Each value opens its source passage.
- 04From the schedule
Workforce Pell clock hours counted to the federal definition
Program Reader agentThe catalog says 180 contact hours. The agent counted 80 for lecture and lab; 40 for the Saturday skills lab, not 45, because the last 30 minutes of each session is not a clock hour under 34 CFR 600.2; and 48 for the externship, the hours each student is guaranteed, not the 55 listed. Each line opens last spring's schedule, page 2, or the course outline, page 4.
80 + 40 + 48 = 168, twelve fewer than the catalog, and each difference is cited.
- 05Before the dean signs
Eleven rules, the agents' run, and a question answered
Dean of workforce programsThe program review lists eleven rules, from clock hours and weeks to accreditor inclusion and excluded coursework, each with a cited value and a confidence from 0.95 to 0.99, and shows the agents' run step by step. The dean asks why the count is 168 and not 180, and the answer cites 34 CFR 600.2, the schedule and the outline. A dean who disagrees with a finding overrides it with a reason code.
- 06Certified the week before
Completion and placement against 70%, with the arithmetic and in aggregate
Institutional research analystLast year's cohort: 78 entered, 63 completed within 15 weeks (81%); one completer ordered to military service is excluded; 46 of 62 were employed in the second quarter after exit (74%), from the state wage file. The analyst certified the rates at 11:40 AM the week before. Medical Coding Specialist, at 70.4% placement, waits for the analyst, because it is within two points of 70%.
Earnings outlook for 2030–31: median $36,880 minus $23,475 (150% of the poverty line) is $13,405, against $1,640 in tuition and fees. It would pass today.
- 074:15 PM
The state packet signed, with a rule beside each claim
Dean of workforce programsThe Workforce Pell coordinator prepared the packet the day before at 4:02 PM: eight sections and 31 citations, with completion and placement in aggregate and cells under 10 suppressed. The dean ticks the attestation and signs at 4:15 PM. The vice president of instruction approves submission at 4:32 PM, and the packet goes to the state approval portal at 4:33 PM, with a decision date set by the state.
Approve stays locked until the dean signs, and one person cannot do both.
- 08Due in a week
A question from the state, answered from three employer letters
Packet agentSeven programs are preparing for the state window, five are with the state and two are approved by the Department. For Emergency Medical Technician the state asked for at least two employer statements on hiring requirements. The Packet agent found three employer letters in document management and drafted the answer with the program's 78% placement rate, for a person to approve and send.
- 09The same day
Title IV confirmed only after the Department approves
Director of financial aidStructural Welding I has passed each gate: dean signed, vice president approved, state certified, Department approved. The Aid Setup agent drafted its setup in the financial aid system, 320 clock hours over 12 weeks in two payment periods of 160 clock hours and 6 weeks each under 34 CFR 668.4(c), and the director confirms it, so it can be packaged from its start date. Phlebotomy Technician stays locked.
Phlebotomy Technician: locked, with the state since 4:33 PM.
- 10Audit-ready
Each reading, signature and certification on one trail
Internal auditorThe dean's signature, the vice president's approval, the rate certification with its reason code and each agent's overnight reading sit on one append-only trail, kept 3 years after the award year under 34 CFR 668.24. The auditor filters it by people, agents, signatures or program, and exports an evidence pack for the state reviewer, the Department, the accreditor or internal audit.