| Name | OL # | School | Cohort | H&L | SHPT | Orient. | Staff | # Contacts | Last Contact | Last Login | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading… | |||||||||||
| Name | OL # | School | H&L | SHPT | Orient. | # Contacts | Last Contact | Last Login |
|---|---|---|---|---|---|---|---|---|
| No cases assigned to you yet. | ||||||||
Use this if you already have the per-school orientation dashboard workbook with H&L / SHPT / Staff / Notes filled in. Upload the single consolidated CSV (built from all 11 per-school tabs of the workbook) and every record lands in one shot — including school, cohort, staff assignments, and the full outreach note history. The CSV must include a School and Cohort column on every row.
📦 Drop the consolidated workbook CSV here, or click to browse
Required columns: Application ID, School, Cohort. Optional: Last Name, First Name, Gender Pronoun, Home Phone, Cell Phone, Emergency Contact - Phone, Email, Second Email, YEPS Orientation Complete (H&L), SHPT, Orientation Attendance, Staff, Note
Use the same Application Report CSV you've been using all along (the one with Application ID, Service Option, SB School Name, DOE School, etc.). The app will detect cohort (YY/OY) from Service Option and pull school from any of the school-name columns. This is non-destructive — existing outreach logs and H&L/SHPT statuses stay intact for any participants already tracked.
📁 Drop the master enrollment CSV here, or click to browse
Looks for: Application ID, Service Option, Last Name, First Name, Email, Second Email, Cell Phone, Home Phone, Emergency Contact, SB School Name, DOE School, Other School
Or upload one workbook tab at a time (e.g., IAM OY)
If your workbook tab is already populated with H&L / SHPT / Staff / Notes, save that tab as CSV and upload here. The app will preserve those values.
Upload the latest Hats & Ladders report (the CSV with Application Id, Name, Date, Orientation Completed). For every row marked Yes, the matching participant's H&L status is set to complete and a timeline entry is logged. Rows marked No are skipped — nothing is overwritten or rolled back. Safe to upload as many times as you want.
🎓 Drop the H&L report CSV here, or click to browse
Looks for columns: Application Id, Orientation Completed
attendance collection and updates each participant's "Orientation Attended" flag. Match is by App ID first, then primary email, then secondary email.| Staff | Today | This week | Caseload |
|---|---|---|---|
| Loading… | |||
Loading…
Loading…