In the era of data and accountability, both classrooms and schools are required to supply longitudinal data. Upon request, PLD supplies a range of ready-made Excel spreadsheets. The Excel tracking provides a medium to record student progress on a termly basis. The excel sheets are provided as templates and can be adapted to suit a school’s needs. If you would like to receive a FREE copy of these spreadsheets, please go here and request the 2018 Excel tracking sheets.

General Year 1-6 Guidelines (for recording results) using the ‘The Phonic & sight word sequence
Placement Test’

Step 1: Locate the correct screen. The beginning of the year screen is located on page 10 and the end of term reviews are located on pages 23 and 24 in the 2018 Phonic & sight word sequence

Step 2: It is essential that the screening commences from stage 1. Although it might seem attractive to shortcut the placement process, by limiting the number of stages presented, this is NOT recommended. Refer to the examples provided on pages 13-15 in the 2018 Phonic & sight word sequence Please note that the testing templates on pages 11 and 12 all commence from stage 1. The following approach is not recommended.

Step 3a: When marking the spelling test, remember to convert student scores into percentages. Below is a quick reference table to make this a time efficient process:

Step 3b: Remember when marking to judge what level you are going to base your next term's teaching on. Typically this is where students drop below 85% in their scores (but keep in mind a degree of teacher judgement may be required for some students).

Step 4: Enter the percentages into excel. For each student, highlight the cell that indicates what you intend to teach over the next cycle/term.

Step 5: Finally, so that the Excel documents are organised in a practical and user friendly way, it is possible to group students together who have similar needs. To do this, highlight rows, right click and cut and paste to group like students together. The following examples have students clustered in 3 ability groups.

If you require additional support, we recommend taking a look at the short online courses . Each of the courses recommend screening to track student development and to assist programming. The courses can be viewed here.

Alternatively, do not hesitate to contact the PLD office.
Was this article helpful?
Thank you!