The Shared Password, the Phishing Email and the Parent's Request
A school office stores the medical records of 240 students, including allergy notes, clinic visits and guardian contact numbers, in a single spreadsheet on the office's cloud drive. Five staff members know the shared account password 'office2024', and two of them left the school at the end of last term but were never removed. The office keeps no backup of the spreadsheet. Last month a member of staff received an email that appeared to come from the principal. It addressed her by name, said the results database was about to be deleted, and asked her to click a link and log in with the shared password to 'confirm' the account. The link opened a page that looked identical to the school's cloud login. Separately, a parent has written asking to see everything the school holds about her child.
1. Identify the weaknesses in the office's current arrangements, classify them, and recommend the single change that would reduce the most risk.
Read the worked answer
Weaknesses identified
- Access control: one shared password means no individual accountability, so no one can tell who viewed or changed a record. Departed staff still hold valid credentials, which is an active risk.
- Authentication: the password 'office2024' is short, guessable and built from the school's own name and year; there is no second factor.
- Data protection: medical data about children sits unencrypted in one file with no access levels, so every staff member can see every child's clinic notes.
- Resilience: no backup at all. A deletion, a disk failure or ransomware destroys 240 students' records permanently.
- Human layer: staff have not been trained to recognise phishing, and a shared password normalises the habit of typing credentials into any page that asks.
Single highest-impact change: replace the shared login with individual named accounts on a least-privilege basis, with multi-factor authentication, and disable the leavers' accounts immediately. This is the highest-impact change because it simultaneously closes the ex-staff access, creates an audit trail that makes the other controls enforceable, and blunts phishing, since a stolen password alone no longer grants entry.
2. Analyse the email. Give at least three indicators that it is a phishing attempt and describe the correct response, including what to do if the link was already clicked.
Read the worked answer
Indicators
- Urgency and threat: a database is 'about to be deleted' and action is required immediately. Pressure to act before thinking is the standard social-engineering lever.
- Credential harvesting by link: no legitimate service asks users to re-enter a password through a link in an email in order to 'confirm' an account. The page 'identical to the school's login' is a copy hosted elsewhere, and the giveaway is the address bar, not the design.
- Spoofed sender: a display name of 'Principal' proves nothing; the actual address and reply-to must be inspected, and they will not match the school domain.
- Personalisation: the use of her name and knowledge of a results database suggests prior reconnaissance, possibly from a data leak or from information exposed by the shared account.
Correct response Do not click. Report it to whoever administers IT and to the principal, then verify by a separate channel, such as phoning the principal or walking to the office.
If the link was clicked and credentials entered Change the password immediately, sign out of all sessions and revoke active sessions, enable multi-factor authentication, run a malware scan, and check the drive's activity log for downloads or deletions. The incident must be reported rather than concealed, because the medical records of 240 children may now be exposed.
3. How should the school respond to the parent's request, and what backup arrangement should be put in place for the spreadsheet?
Read the worked answer
Responding to the parent The parent is entitled to know what is held about her own child, but that right does not extend to other children's data. The correct response is to verify her identity and her relationship to the child, then supply an extract containing only that child's rows: allergy notes, clinic visits and guardian contact details. Sending the whole spreadsheet, or a printout with other names visible, would itself be a data breach of 239 other students. The school should also record that the request was made and how it was answered, apply a retention rule so that clinic notes are not kept indefinitely, and tell the parent who to contact if the extract is inaccurate.
Backup arrangement Adopt the 3-2-1 rule: at least three copies of the data, on two different types of media, with one copy kept off site or in a separate cloud account. Backups should run automatically each day, be encrypted because the content is medical data, and be tested by performing an actual restore, since an untested backup is only a hope. At least one copy must be offline or immutable, so that ransomware that encrypts the live spreadsheet cannot reach every copy. Access to the backups should be limited to one or two named people and logged.