A simple school testing tracker for the year

A clear spreadsheet can help you see your child’s testing schedule without hunting through school emails, paper notices and parent portals. With a few columns, you can record test dates, subjects, results and follow-up tasks in one place.

For Australian families, the sheet might include NAPLAN, school-based exams, spelling checks, reading assessments, maths tests and catch-up sessions. Dates can vary between states, year levels and individual schools, so your child’s calendar should be based on notices from their classroom teacher rather than a generic national timetable.

A tracker can also support informed conversations about how assessment affects learning. Families involved in student advocacy may find it useful to read about questions for teachers, especially when asking how results are interpreted and shared.

Choose what to record

Start with a new spreadsheet in Google Sheets, Excel or another tool you already use. Give it a simple name such as “School assessment tracker 2025” and create one row for each testing event.

Useful column headings include date, day, subject, assessment type, year level, location, duration, preparation needed, result, follow-up and notes. You do not need every field from the beginning; a small, usable sheet is better than a detailed file that becomes difficult to maintain.

Set up a practical calendar

Enter the school year’s known dates first. Include NAPLAN testing windows if relevant, school exams, assignment due dates and parent-teacher meetings where assessment results may be discussed. If your child attends a public school in Melbourne, Brisbane or Perth, the school’s online portal may list dates differently from the printed newsletter, so check both sources.

Use a consistent date format, such as 12/03/2025, and add the weekday in a separate column if it helps with planning. A drop-down menu for “scheduled”, “completed”, “rescheduled” and “awaiting result” makes the sheet easier to scan.

Make important days visible

Colour coding can show the type or status of each assessment. For example, use blue for standardised testing, green for classroom assessments, amber for a rescheduled event and grey for a completed task. Keep the colours calm and limited so the spreadsheet remains readable on a phone.

You can also use conditional formatting to highlight tests happening within the next seven days. This is handy during busy periods, such as the weeks around NAPLAN in Australian primary and secondary schools, when families may also be managing sport, music lessons and school excursions.

Add preparation and wellbeing notes

The preparation column should focus on practical support rather than pressure. Record items such as bringing a calculator, checking that a device is charged, revising vocabulary or confirming whether special provisions apply. For younger children, note sleep routines, transport and what time they need to leave home.

A notes field can capture how your child felt before and after the assessment. This may reveal patterns that a mark alone cannot show, such as headaches, anxiety, difficulty concentrating or repeated confusion about instructions. Keep observations factual and avoid turning the spreadsheet into a judgement about your child.

Protect personal information

A testing tracker may contain sensitive details, including results, learning needs and wellbeing information. Store it in a password-protected account, limit sharing permissions and avoid placing identifying information in a public document. If a school sends a spreadsheet, download it only to a trusted device and check who can access the file.

Use initials or a private file name if the document is synced across several family devices. Student data privacy matters whether the information comes from a state assessment, an independent school portal or a classroom teacher. A simple tracker should support your family without creating a new record-keeping risk.

Review the sheet with the school

Set aside ten minutes each fortnight to compare your spreadsheet with new notices. Mark cancelled tests, enter results when they arrive and write down questions for the teacher. A short note such as “What skill was assessed?” or “Will this result change classroom support?” can make a parent-teacher conversation more focused.

The finished sheet can show whether several demanding assessments are clustered together or whether follow-up has been missed. It may also help you distinguish a one-off result from a recurring concern. Bring only the relevant entries to a meeting, rather than expecting the spreadsheet to replace the teacher’s fuller record.

At the start of the next school week, open a blank sheet, add the columns above and enter every testing date currently shown in your child’s school calendar.