Drop each export below — identified and assigned automatically. Arbor incident data includes behaviour and achievement records.
⚠ For best results load files in this order: 1. Carry-forward file → 2. Edulink callout CSV → 3. Arbor exports
Arbor / Edulink exports
Incident data
not yet loaded
REQ
Attendance
not yet loaded
OPT
Suspensions
not yet loaded
OPT
Detentions next
not yet loaded
OPT
Detentions last completed
not yet loaded
OPT
Edulink exports
Callout log
not yet loaded
OPT
Hub carry-forward file
Detention history
not yet loaded
OPT
Weekly snapshots
not yet loaded
OPT
P5 timetable + LIC/OSD
not yet loaded
OPT
Staff timetable
not yet loaded
OPT
Drop files here or click to browse
accepts .xlsx · multiple files supported · identifies each automatically
Drop your combined hub import file — all sheets loaded in one go.
Drop file here or click to browse
accepts .xlsx · combined hub import format
Load incidents and achievements directly from Arbor, then optionally layer in attendance, suspensions, detentions, and other local files.
Incidents / achievements
Main live behaviour feed.
Attendance
Optional live attendance feed.
Detentions
History and upcoming detentions.
Suspensions
Optional live suspension feed.
P5 room
Optional live P5 timetable / room feed.
Live Arbor feeds are configured on the server for this hosted proof of concept.
Refresh
Separate each Arbor feed into its own box. The hub will combine whichever live feeds you fill in. Optional local imports below can still be used for internal suspensions, callouts, snapshots, and timetable data.
Your form group · Detention focus · Action prompts
📊
Curriculum Leader
Department overview · Staff logging · Student patterns
Waiting for data to load — if this is a packaged file, the dropdown will populate automatically in a moment. If you're loading data manually, use Pastoral / SLT access first.
Enter your department password
OHA Form View
Dashboard
Form List
Reports
OHA HOD View
Department
Staff
Students
Hotspot
No C3 data for this department
OHA Behaviour Hubv4.20
Export data
📄
Current view as CSV
Filtered incidents · active tab
📊
Current view as Excel
Filtered incidents · active tab
🗂️
All data as CSV
Full unfiltered dataset
📋
All data as Excel
Full unfiltered dataset
Dashboard
Student Profile
Year Group
LMGT
Reports
Hotspot
Staff
Suspensions
Detentions
PT Briefing
Homework
Achievement
Attendance
⚙ Settings
Year Group
All years
AllClear
Form / Class
All forms
AllClear
Behaviour Type
All types
AllClear
From
To
Group by
Metric
Period A
vs
Period B
Year-on-year comparison · 24/25 vs 25/26
Behaviour over time
↑ Click a bar to drill down
Term boundary
Half term
⚙INSET / OAT closed
Top behaviour types
↑ Click a bar to drill down
Day so far briefing
Students by category
Keep the live list tight and sortable. Click a row to open the student snapshot.
Today's context
Keep the live picture readable: where pressure sits, who is logging it, and what has landed most recently.
C3 exits by subject
↑ Click a bar to see top students & staff
🔍 C3 concentration
Students where top teacher ≥ threshold % of C3s · click name to open profile
C3s by staff
📊 Detention effectiveness
⚠ Escalation flags
WeekMetricConsecutive rising weeks
Students whose weekly total has risen for N consecutive weeks, or is sustained above their personal average · click to open profile
Students ranked by risk
#
Risk
Name
Year
Form
Points
Incidents
C3s
Susps
Susp days
Truancy
Isolation
Week-on-week comparison
Weeks to show
Metric
Year group
All years
AllClear
Form group
All forms
AllClear
Student
Behaviour type
All types
AllClear
📈 Longitudinal trends
Metric
Year group
Phase 1
Intervention workspace is being rebuilt next.
This tab will become the proper home for next steps, PSP drafting, meeting brief outputs, intervention tracking, and rank context. In this phase those actions remain in the hero so the landing page stays clean and usable.
Use the hero actions while this deeper page is rebuilt.
⭐ Achievement record
#
Date
Achievement type
Points
Awarded by
🔍
Search for a student above
Year
C3 Cohort Concentration
Trend over time
Weekly normalised per teaching day · click a point to drill
C3s by Class
Lesson Lates by Class
Top Students
click column to sort
C3s by Form
C3s by Recorder
Points logged over time
↑ Click a bar to drill down
Top behaviour types logged
↑ Click a bar to drill down
Staff Logging Health
Teaching staff only · based on timetable data · amber = rarely logged · red cell = never logged
Callout vs Incident Audit
This table cross-references Edulink callout data with C3 exits logged on Arbor for timetabled teaching staff only. For each staff member it counts how many days they sent a callout, then checks whether they logged at least one C3 on Arbor on that same day. A "gap day" is a day where a callout was sent but no C3 was logged. Not every callout is a C3 — some will be medical, missing students, or general support requests — so a gap does not automatically indicate a logging issue. Flags are based on two conditions: the gap percentage (proportion of callout days with no C3 logged) and whether total C3s logged are less than a third of total callouts. Staff logging C3s at a reasonable rate relative to their callout volume are likely to have no concerns.
● Log gap — worth a conversation — 15+ callout days, 70%+ gap, and C3s less than a third of callouts ● Some gap — worth monitoring — 10+ callout days, 50%+ gap, and C3s less than a third of callouts ● No concerns — below those thresholds, or C3s are at least a third of callouts
#
Staff Member
Callouts
C3s Logged
Days w/ Callout
Days w/ Callout but No C3 ▾
Gap %
Flag
Staff ranked by points logged
↑ Click a name to see their full profile
#
Staff Member
Points Logged ▾
Incidents
Unique Students
Period A
vs
Period B
Points logged over time
↑ Click a bar to drill down
Breakdown by behaviour type
↑ Click a segment to drill down
Students receiving most points from this staff member
#
Student
Year
Form
Points
Incidents
C3s
Lates
Timetable hotspot — C3 exits by day & week type
↑ Click a cell to drill into those C3 exits · timetable slots shown where available
Show
C3 exits only · Week A/B based on OHA teaching week count · intensity = relative to peak cell · timetable slots: amber = on call · grey = non-teaching
🔔 Suspensions
Rolling Suspension Picture
Fast recent picture of suspension pressure. These cards focus on the last 28 days and last 12 weeks, and each one opens the students or events behind the number.
Suspensions by week (from suspension events · click to drill)
By year group (click to drill)
Suspension Reasons
Most common recorded reasons in the current filter. Click any bar to open the underlying suspension events.
Recent Suspension Events
Latest individual suspension records in date order, so you can quickly see who was suspended most recently, for how many days, and why.
Repeat Suspensions
Students with 2 or more suspension events in the last 12 weeks, ranked by repeat count and total days lost. This is the quickest list for spotting sustained escalation rather than one-off incidents.
Students ranked · ■ ≥30 days
■ 20–29 days
■ 10–19 days
Click a row to open student profile · Click a KPI above to drill into that group
#
Student
Year
Form
Suspensions
Days
Days to PEx
No suspension data loaded — ensure your data file includes a Suspensions sheet
⚠
⚠
✓
Year Group
All years
AllClear
Form / Class
All forms
AllClear
Detention attendance over time
Weekly attendance rate across all sessions · click a bar to drill
Compare
Failure rate by day of week
Which days students most frequently fail to attend
📊 Detention effectiveness
Window
Year group
This section measures whether detentions are changing behaviour. Served → reoffend shows what percentage of students who attended their detention went on to get another C3 exit within the selected window. Failed → reoffend shows the same for students who missed their detention. The deterrent effect is the gap between the two — a positive number means students who serve detentions are less likely to reoffend. Concentration shows whether detentions are spread across many students or dominated by a small repeat group.
Reoffend rate: served vs failed
Detention volume over time
Repeat offenders — students with most detention bookings
Upcoming Detention — Collection Priority List
3+ failed — Collect first
1–2 failed — High priority
0 failed — Standard
Lunch detentions
Separate list for lunch detentions
000
📋 PT BRIEFING DATA(Tue–Mon, last completed cycle)
Year group
Form
Staff
From
To
⚠ No homework incidents found. Homework incidents are identified from behaviour records where the type contains "homework". Check your data includes these incident types.
Homework incidents per week
Day-of-week pattern
Incidents by staff member (top 15)
📚 Subject breakdown
Homework incidents by subject · English, Maths & Science highlighted
📊 Homework incidents by student and subject
Click column headers to sort · click a student to open profile
🔁 Repeat offenders
Students with 3+ homework incidents in any rolling 3-week window · click to open profile
Student league table
↑ Click a student to open their profile
#
Student
Year
Form
Subjects
Incidents ▾
Points
Last incident
Peak 3-wk
Staff issuing homework incidents
Ranked by volume of homework incidents recorded
#
Staff member
Incidents ▾
Students
Points total
Last recorded
Compare
Period A
vs
Period B
Widget year
Achievement points over time
↑ Click a bar to drill down
Top achievement types
↑ Click a bar to drill down
Staff — achievement points awarded
Click a row to see full staff profile
#
Staff Member
Points Awarded ▾
Awards
Students Recognised
Points awarded over time
Breakdown by achievement type
Students recognised most by this staff member
#
Student
Year
Form
Points
Awards
Students — achievement points received
↑ Click a student to open their profile
#
Student
Year
Form
Points ▾
Awards
Behaviour monitoring — escalation ladder
Level is calculated from weeks since first 20-point trigger: L1 PT (wks 1–2) → L2 HOY (3–5) → L3 RSL (6–9) → L4 BD (10–13) → L5 VP (14+).
↓ Step-down applies if a student scores below 12pts for 2 consecutive weeks — they drop one level.
⚡ Quick escalation applies if a student hits 50+ points in any single week — they skip immediately to the next level regardless of time served at their current level.
${activeOnly ? ' · Active only: showing students who hit 20pts in the last 4 weeks. Toggle off to see full historical list.' : ' Showing all students who have ever triggered — toggle Active only to filter to current concerns.'}
Year group
Subject
Show
Attribution
🔥
No incident data loaded
⚙
Settings
Adjust risk score weightings and app behaviour
🎯 Risk Score — Base Weights
Weights determine the relative contribution of each factor to the base score before vulnerability multipliers are applied. Higher = more influence. Weights are normalised automatically — you don't need to make them sum to 100.
Incident frequency
How many incidents in the rolling window
Average severity
Mean points per incident (weighted)
Detention miss rate
Weight for credibility-adjusted miss rate (Bayesian — see prior below)
Det. miss prior (k)
Bayesian sample size prior — higher = more dampening on small samples. Default 5.
Volume of 5+ pt incidents (C4, fixed penalty, serious)
C3 volume
Count of 3-pt incidents — persistent defiance pattern
Achievement inverse
Students with low/no achievement pts vs cohort get a mild risk uplift
LIC history
Ever placed in the Learning Intervention Centre — past serious intervention
OSD history
Ever placed on Off-Site Direction — past serious intervention
⏱ Time Decay — Incident Window Weights
Recent incidents count more than older ones. These values are percentage weights applied to incidents in each rolling time band. Older incidents never fully disappear — they're just down-weighted.
Last 4 weeks
Full weight for very recent behaviour
%
4–12 weeks ago
Half-weight for mid-term behaviour
%
12+ weeks ago
Low weight for historical behaviour
%
🔴 Vulnerability Multipliers
Each vulnerability flag increases the multiplier applied to the base score. Flags stack additively up to the cap. A student with 3+ flags will always receive the maximum multiplier.
0 flags
No vulnerability flags
×1.0 (fixed)
1 flag multiplier
PP, LAC, EAL, SEN K, or EHCP
×
2 flags multiplier
×
3+ flags multiplier (cap)
×
📌 Future: Achievement Points as Protective Factor
Once the achievement data is better established, achievement points will be available as a protective factor that actively lowers a student's risk score. A student with high incidents but strong achievement engagement tells a different story to one with the same behaviour record and zero recognition. This setting will appear here when ready.
📋 Report Card — Incident Type Matching
These strings are matched against Arbor incident type names. C3 exits use a contains match. All others are case-insensitive exact matches. Lates use year-aware matching — enter the Y7/8 version and Y9+ version separately.
C3 exits (contains)
Any incident type containing this string counts as an exit