Kia ora koutou,
To assist with managing your e-asTTle writing test data, I have put together a Sheet with formulas and conditional formatting. Either use the drop down boxes or type the 'R' values into each cell (B-H) and it will give you a total (cell I) and a writing level (cell J). Row 36 also gives you a break down of how many of your learners are at each curriculum level, based on their results on their test.
Hopefully you find this resource helpful!
Have a look for yourself by exploring the embedded window of the Sheet below and feel free to make a copy of the Sheet using this link. Also, if you have any questions, feel free to email me - jeremy.ferguson@manaiakalani.org
