Add a pupil — click + Add Pupil. Fill in Known As, Surname, and SCN (Scottish Candidate Number) as a minimum. Use the ASL & Support tab to record LAC, ASN, EAL, support pathway, agency involvement, and active plans (PLP, IEP, CSP, CP).

Edit a pupil — click the pencil icon on the pupil row, or click the pupil's name to open their profile and edit from there.

Off-roll pupils — untick On Roll in the edit form. Off-roll pupils are hidden by default; tick Show off-roll in the filter panel to see them.

Filters — use the filter panel (year group, registration group, gender, SfL support level, LAC/ASN/EAL, SIMD, support pathway, plans, interventions) to narrow the table. Active filters are highlighted; click Clear to reset.

Bulk Edit — click Bulk Edit to tick multiple pupils and update their year group, registration group, or SfL support level in one step. Useful at start of session when pupils move year.

Printing — Print Table prints the filtered cohort view. Print All Profiles prints a one-page summary for every visible pupil.

Add an update — click + Add Update and choose a type:

• Assessment — record a SWST A, SWST B, SWRT, or Baseline score. Standardised scores should be between 40 and 160. Scores are automatically colour-coded and appear on the pupil's profile and progress chart.
• SfL Note — a free-text note about a pupil (e.g. observed difficulty, parent meeting, review outcome). Notes are appended to the pupil's profile for that year group.
• Intervention / Support — record a specific intervention or support strategy being used.

Date — defaults to today. Change it to back-date an entry if needed.

Filtering — filter the log by pupil, type (Assessment / SfL Note / Intervention), date range, or keyword. The count at the top shows how many entries match. When a filter is active it shows X of Y updates — click Clear to see all.

Edit an entry — click the pencil icon on any log entry to correct a note or score.

Delete an entry — click the bin icon. You will be asked to confirm. Deleting an assessment entry also removes the score from the pupil's profile.

Opening a profile — click a pupil's name in the Cohort Tracker, or use the Pupil Profile tab and select a pupil from the dropdown.

Score chart — shows all standardised scores across year groups as a line chart. Hover a point to see the exact score. The colour band (red / amber / green) shows whether the score is below average, average, or above average.

SfL Notes — cumulative notes for each year group, in date order. Edit the most recent note using the pencil icon in the Update Log.

SHANARRI — rate each of the eight wellbeing indicators (Safe, Healthy, Achieving, Nurtured, Active, Respected, Responsible, Included) using the traffic-light buttons. Ratings are saved automatically.

Interventions — view active and past intervention records for this pupil. Add a new one from the Interventions tab, or via + Add Update → Intervention / Support.

Progress Goals — each intervention can have a target score and a review date. A coloured dot next to the review date shows whether it is upcoming (blue), due this week (amber), or overdue (red). A RVW badge appears on the pupil row in the Cohort Tracker when a review is due or overdue.

Print — click Print Profile to print a one-page summary for this pupil.

SfL Tracker uses three standardised assessments:

• SWST A / SWST B — Schonell Word Spelling Test (Forms A and B)
• SWRT — Schonell Word Reading Test
• Baseline — any baseline score (0–100 scale; not colour-coded by band)

Standardised scores are colour-coded:

Valid range for SWST and SWRT is 40–160. The app will warn you if you enter a score outside this range.

All data stays on your device — nothing is sent to any external server. Data is stored in a local .db file that you manage.

Save your database — click Save Database (.db) in Settings after making changes. This downloads an sfl-tracker-YYYY-MM-DD.db file to your Downloads folder.

Sync between Macs — save the .db file to your iCloud Drive or a SharePoint folder. On your other Mac, open the app and use Load Different Database in Settings to pick that file. Always save before switching devices.

Backup — Download Backup saves a timestamped .json file with everything (pupils, scores, notes, interventions, SHANARRI). Keep a copy somewhere safe at the end of each term.

Restore — Restore from Backup loads a backup file and overwrites current data. Use this to recover from accidental data loss.

Export to Excel — produces an .xlsx file with separate sheets for the cohort, update log, and interventions. Use this to share data with colleagues or for reporting.

SfL Tracker is designed to meet school data protection requirements:

• All data is held in a local .db file on your own device — no pupil data is ever uploaded to any server.
• Set an App Password in Settings to lock the tracker on load. Keep this password safe — it cannot be recovered, only reset by clearing all data.
• The .db file is portable — keep it in a location only you (or authorised colleagues) can access, such as a school-managed SharePoint folder.
• Use Clear All Data at the end of the school year or if the device is being repurposed. This removes all pupil records from the current session.
• Always keep a current backup in a secure location. Use Download Backup in Settings to save a JSON copy at the end of each term.