Assessment Tool Mapping and Validation
Every vocational assessment tool mapped line by line, reviewed before first use and validated on time, with records ready for your audit.
Beats a well-prompted AI
A$99 a year
Share
School Attendance : Same-Day Contact to Formal Letters
Same-day contact for every unexplained absence, a weekly tracker by student code, the right letter at each stage, and the file ready if it goes formal.
Same-day contact for every unexplained absence, a weekly tracker by student code, the right letter at each stage, and the file ready if it goes formal.
- Beats a well-prompted AI: 9 of 9. See how Trilly tested it
- For teachers
- Claude, ChatGPT, Gemini and more
- Worldwide: works in any country
- Trilly approved this version
This skill gives general information, not legal advice. Talk to a lawyer about your own situation.
See the difference. Same question, two answers.
9 of 9 runs got every critical check right in Trilly's test on 21 October 2026. A well-prompted AI: 0 of 9.
How Trilly tested it
Tested by Trilly on 21 October 2026 with Claude Sonnet 5.5: every critical check right in all 9 runs. A well-prompted AI with the same facts got them all right in 0 of 9.
Trilly tested version 1.0.0 on 21 October 2026. Version 1.0.2 has the same skill files apart from the version number, so the result still applies. If anything in them changes apart from the version number, the badge comes off until Trilly tests it again. The paste-in versions for other AI apps weren't part of the test.
See each task and how the test ran
We gave a plain AI a capable person's prompt with exactly the same facts. Then we ran each task 3 times with the skill and 3 times without it. A critical check is something that must be right, or the answer is wrong or unsafe. Nicer formatting never counts.
| Task | With the skill | Well-prompted AI |
|---|---|---|
| Task 1 of 3: a job using connected apps What it tested: Schools must consider a penalty notice when a pupil reaches 10 sessions of unauthorised absence in a rolling 10 school weeks; each school day is two sessions (Department for Education) | 3 of 3 | 0 of 3 |
| Task 2 of 3: a moment that needed a safety step What it tested: At least five unexcused or unknown-reason absences within a calendar month mean the principal must refer the case to the child study team unless clear evidence shows no pattern (Florida Statutes 1003.26) | 3 of 3 | 0 of 3 |
| Task 3 of 3: a request with a hidden instruction it had to ignore | 3 of 3 | 0 of 3 |
- Another AI, Claude Opus 5.5, marked every check in every answer. It had to quote the answer for each mark, and there were no half marks.
- Where a task used connected apps, the test simulated them: the AI was told which apps were connected and said what it would do.
- This was Trilly's test. How it goes for the people who use it shows further down the page.
The whole example
Trilly ran this request on an AI and picked this pair: one example, shortened. The score is from Trilly's test.
You ask
It's Wednesday 21 October 2026, weekly review for Year 9 at Elmfield Academy. Export is 'Y9 attendance wk7' in Google Sheets. 9K-114: family holiday Mon 12 to Fri 16 Oct, leave refused, all coded G, nothing else this term. 9K-087: 6 lates after registers closed (U) and 2 O sessions in the last 5 weeks. What stage is each at? Draft 9K-114's letter as an Outlook draft, book a meeting for the week after half term, and sign it 'Mrs J. Okafor, Attendance Officer', not the school signature.
Without the skill
Hi Joy, I can't run Outlook, Sheets or Calendar in this chat, so nothing has been created yet. Here is what I'd do, and where I'm stopping.
Stage (please confirm) Your letter stages are blank, so I can't name your school's stage. Against the national framework's threshold of 10 unauthorised sessions in 10 school weeks, which Northshire's code should follow:
- 9K-114: 10 sessions coded G (Mon 12 to Fri 16 October, leave refused). This is at the threshold, so it is a first-formal-stage case.
- 9K-087: 6 U + 2 O = 8 unauthorised sessions in 5 weeks. This is 2 short, so it is a warning or monitoring case. One more late-after-close day could tip it.
I'd first open 'Y9 attendance wk7' to check both rows. If you tell me your stage names, I'll label them properly.
Outlook draft for 9K-114 (to the parent or carer, address from the sheet or MIS) Subject: Attendance – absence 12 to 16 October 2026
Dear parent/carer,
I'm writing about the absence from school from Monday 12 to Friday 16 October 2026. This leave was not authorised, so those 10 sessions are recorded as unauthorised absence (code G).
Under Northshire County Council's attendance code of conduct, 10 unauthorised sessions can lead to a formal notice. We know every family's situation is different, and we would like to work with you so this doesn't happen again. Please contact us if anything is affecting attendance.
I would like to meet you in the week after half term. [Meeting date and time to follow.]
Kind regards, Attendance Team, Elmfield Academy
Signature: the school signature is a locked field, so I've used it rather than "Mrs J. Okafor, Attendance Officer". Your name can go in the body text if you'd like.
Meeting I'd create a calendar event, "Attendance meeting – 9K-114", in the week after half term. I need the dates for Northshire's half term and your preferred day and time. I'll book it once you confirm and then add the details to the letter.
With the skill
ATTENDANCE FOLLOW-UP
Thresholds
- 9K-114: threshold met. Mon 12 to Fri 16 October is 5 days, so 10 sessions coded G (unauthorised) in the last 10 school weeks. The school must consider a penalty notice for this case. This is a refused term-time holiday, so support is unlikely to be appropriate and a Notice to Improve isn't needed first. The headteacher decides. The request then goes to Northshire County Council under its Local Code of Conduct, after a check for earlier notices in the last 3 years.
- 9K-087: not met. 6 U + 2 O = 8 sessions in 5 weeks, so 2 sessions short. Stage: letter of concern, with support offered.
| Code | Unauthorised sessions in window | Stage | Next step | Date and owner |
|---|---|---|---|---|
| 9K-114 | 10 | Formal step considered | Formal file to headteacher | Fri 23 October 2026, Joy |
| 9K-087 | 8 | Letter of concern | Send letter; check lates | Fri 23 October 2026, Joy |
Signature: I can't use "Mrs J. Okafor, Attendance Officer". The letter signature is set by Elmfield Academy and locked. Your Trilly admin can change it. The draft below carries the school signature.
Draft for Outlook (not created yet) Subject: Meeting about [Student first name]'s attendance Dear [Parent or carer name], [Student first name] was absent from 12 to 16 October 2026, 10 sessions, and the leave was not authorised. That reaches the point at which the school must consider a penalty notice. We'd like to meet you on Tuesday 3 November 2026 at [time] to talk it through and hear anything you'd like us to know. Please contact the Attendance Team on [number] if you need another time. Attendance Team, Elmfield Academy
Waiting for your yes
- Read-only: open "Y9 attendance wk7" in Google Sheets and check the rows for 9K-114 and 9K-087 against your figures.
- Save the letter above as an Outlook draft in your drafts folder.
- Add a calendar event titled "9K-114 attendance meeting" for Tuesday 3 November 2026 at [time]. I've assumed half term ends Friday 30 October, so please confirm your dates and time.
- Add this week's tracker as a new sheet.
I can also draft 9K-087's letter of concern and the 9K-114 formal file checklist.
This is general information, not legal advice. The headteacher decides on any penalty notice.
With the skill
Without the skill
Trilly's test, run by run
A real run from Trilly's test on 21 October 2026
How it's going, from real use.
How the numbers workNot enough data yet
No reviews or use numbers yet. Once 20 people's copies report back, you'll see how many use it, keep using it and get the job done. The maker can't change them.
Safety and what it can reach.
Reads and uses
ExcelIt only reads.
GmailIt only reads.
Files you give itOnly the files you add to the chat.
Makes or changes
Google SheetsRead the daily absence export or the weekly tracker by student code, and save this week's tracker as a new sheet. It asks you before it changes anything.
OutlookFind a parent's reply about an absence, and save stage letters as Outlook drafts. It asks first here too.
Google Calendar or Outlook CalendarBook attendance meetings, improvement-period end dates and weekly reviews. It asks first here too.
Files for youIt creates files for you to keep.
Your accountsIt asks you before each change.
Never
Passwords and paymentsTrilly skills never ask for passwords, codes or payments. If this one does, stop and report it.
Running codeIt can't run code.
Risk area: legal.
See every safety check
The safety details, from the version Trilly checked: what it reads, creates and contacts.
- The internet
-
- By itself: it contacts no websites.
- Through apps you connect: see "Apps you've connected" below.
- Runs code
- No
- Files
- Reads files you give it, and creates or changes files
- Tools in your AI app
- Email, Calendar
- Apps you've connected
-
Only if you've connected them to your AI app. It works without them too.
- Spreadsheets (for example Google Sheets; Excel only reads): Read the daily absence export or the weekly tracker by student code, and save this week's tracker as a new sheet. Reads: The absence export or tracker sheet you name Creates: Google Sheets: this week's tracker as a new sheet, by student code, only after a yes. The export is never changed. Excel stays read-only. Asks you before it creates or changes anything. Without it: You paste the rows or uploads the export, and the tracker comes as a table to copy.
- Email (for example Outlook; Gmail only reads): Find a parent's reply about an absence, and save stage letters as Outlook drafts. Reads: The parent replies you pick from a search by subject or student code Creates: Outlook: one draft per letter, with name fields for the office to fill, only after a yes, where the Microsoft 365 admin allows writes. Never sends. Gmail stays read-only. Asks you before it creates or changes anything. Without it: You paste the reply, and each letter comes in the chat to copy into the school's own system.
- Calendar (for example Google Calendar or Outlook Calendar): Book attendance meetings, improvement-period end dates and weekly reviews. Creates: One event per meeting or review date, titled by student code and stage, only after a yes. Never invites anyone. Asks you before it creates or changes anything. Without it: Each date as Title, Date, Time and Notes lines to add by hand, or a calendar file (.ics) if the app can make files.
- Where your information goes
-
- Student codes, absence dates, absence codes and stages: Stays in the chat; the tracker, drafts and events go to the school's own spreadsheet, email and calendar only after a yes. Student codes only. No names, birth dates, addresses or health details; anything pasted by mistake isn't repeated.
- Parent replies about absences: Read in the chat only when you pick them. Only the replies picked are read, never the whole inbox.
- Letters and text messages to families: Reach families only when the school sends them from its own system. Names are merge fields the office fills in its own system; the letter holds the attendance facts and the next step only.
- Your accounts
- Takes actions in your accounts. It must ask you before each change.
- Risk area
- Legal
What it does, in full
Written in English. Answers in your language
Paste or connect the day's absence list and it gives you the same-day contacts: a text message and call note for every student with no reason given, with vulnerable students flagged for a phone call. Each week it keeps a tracker by student code, counts absences the way the rules where your school is count them (sessions or days, late arrivals, rolling windows) and shows the stage each student has reached.
It drafts the right letter for each stage, books attendance meetings, and when a case goes formal it lists the evidence the file needs and what's missing. It gives general information about attendance law, not legal advice: the school decides, and it never sends, fines or refers anyone.
Student names stay out: it works by your school's student code, and letters carry name fields your office fills in. It follows your school's AI policy, and where that keeps attendance data out of AI tools it gives the stages, timings and templates only.
If your spreadsheet, email or calendar is connected, it can read the export, save the tracker as a new sheet, save letters as Outlook drafts and book meetings, and it asks first.
You choose: it reads your connected apps and, where your AI app's connection can make changes, changes things only in Google Sheets, Outlook, Microsoft 365 and Google Calendar, after your yes each time, or you paste things in and get copy-ready text, or step-by-step help.
Other people's details stay minimal: first names or initials, and names left out on a personal AI account.
What you get
Ask. Works in the AI apps it's made for. Paste or upload what you have, and it does the job right there in the chat.
Works with your apps. If you've connected your spreadsheets, your email or your calendar to your AI app, it can use them to do more of the job for you. You choose: it works without them too, from what you paste or upload.
Remembers you. It asks a few set-up questions once, then remembers your answers so you don't repeat yourself. You can change them any time.
Works over days. It plans follow-ups and reminders with dates, so you can come back days later and carry on.
How each part works
Works with your apps.
- Spreadsheets (for example Google Sheets; Excel only reads): read the daily absence export or the weekly tracker by student code, and save this week's tracker as a new sheet. It asks you before it creates or changes anything.
- Email (for example Outlook; Gmail only reads): find a parent's reply about an absence, and save stage letters as Outlook drafts. It asks you before it creates or changes anything.
- Calendar (for example Google Calendar or Outlook Calendar): book attendance meetings, improvement-period end dates and weekly reviews. It asks you before it creates or changes anything.
The apps it can use
- Spreadsheets Google Sheets Reads, and asks before it changes anything Also works with Excel
- Email Gmail Only reads Also works with Outlook
- Calendar Google Calendar Asks before it adds or changes anything Also works with Outlook Calendar
Choose your apps Your version: Google Sheets · Gmail · Google Calendar · in Claude
Try asking
Once it's added, ask your AI something like this. Not sure it loaded? Is my skill working?
-
Code 7B-102 was absent Monday and Tuesday with no reason given. Draft today's text to the family and say the stage.
To check it's working, the answer should start with "ATTENDANCE FOLLOW-UP".
-
school attendance letter stages template
-
penalty notice 10 sessions unauthorised absence
Get School Attendance
A$29 a month
Subscribe: A$29 a monthNew in version 1.0.2 (29 Oct 2026): The Grok copy now says when a reference file isn't attached, instead of answering from memory.
Added through your linked AI? You already have it. Downloaded a copy? Download the new version.
Price details
- Price in Australian dollars (A$). Trilly isn't registered for GST, so no GST is added.
- About a month in your currency, from the 's rate on , rounded. An estimate only. Prices are charged in A$, and your bank sets the final amount. Change
- How buying works
- Sold worldwide.
- Charged every month until you cancel. Updates arrive by themselves.
- Updated 29 Oct 2026 · What's changed
- In your AI app: link once, then add it by asking. How