Spreadsheet: 796043d1663078913-countif-cells-within-a-range-and-are-filtered-afl-data-help
Sheet: KS2 Data

AfL Data - collected each term to inform planning, targets and learning
Use the filters to choose just a class, year group etc. Input score and look to the analysis tab for info |  |  |  |  |  | Reading (decoding) |  |  | Reading (understanding) |  |  | Spelling |  |  | Mental Maths
Forename | Surname | DOB | Gender | Year | Reg | Aut 1 | Spr 1 | Sum 1 | Aut 1 | Spr 1 | Sum 1 | Aut 1 | Spr 1 | Sum 1 | Aut 1 | Spr 1 | Sum 1
Florence |  |  |  |  | Year 3/4 Lloyd Evans | 3
[NAME] |  |  |  |  | Year 3/4 [NAME] | 4
Mara |  |  |  |  | Year 3/4 Lloyd Evans | 12
[NAME] |  |  |  |  | Year 3/4 [NAME] | 14
[NAME] |  |  |  |  | Year 3/4 [NAME] | 15
Penelope |  |  |  |  | Year 3/4 [NAME] | 20
[NAME] |  |  |  |  | Year 3/4 [NAME] | 25
Matilda |  |  |  |  | Year 3/4 [NAME] | 11
[NAME] |  |  |  |  | Year 3/4 Lloyd Evans | 9
Olly |  |  |  |  | Year 3/4 [NAME] | 4
Freddie |  |  |  |  | Year 3/4 [NAME]
[NAME] |  |  |  |  | Year 3/4 [NAME]
[NAME] |  |  |  |  | Year 3/4 [NAME] | 20
[NAME] |  |  |  |  | Year 3/4 [NAME]
Tirion |  |  |  |  | Year 3/4 [NAME] | 10
[NAME] |  |  |  |  | Year 3/4 [NAME] | 21
Leo |  |  |  |  | Year 3/4 [NAME] | 23
Molly |  |  |  |  | Year 3/4 [NAME] | 30
[NAME] |  |  |  |  | Year 3/4 [NAME]
[NAME] |  |  |  |  | Year 3/4 [NAME]
[NAME] |  |  |  |  | Year 3/4 [NAME]
Dahlia |  |  |  |  | Year 3/4 [NAME]
Tess |  |  |  |  | Year 3/4 [NAME]
Elijah |  |  |  |  | Year 3/4 Lloyd Evans
[NAME] |  |  |  |  | Year 3/4 Lloyd Evans
[NAME] |  |  |  |  | Year 3/4 [NAME]
Tarynn |  |  |  |  | Year 3/4 Lloyd Evans
Phoebe |  |  |  |  | Year 3/4 Lloyd Evans
[NAME] |  |  |  |  | Year 3/4 Lloyd Evans
[NAME] |  |  |  |  | Year 3/4 [NAME]
[NAME] |  |  |  |  | Year 3/4 [NAME]
[NAME] |  |  |  |  | Year 3/4 [NAME]
Anna |  |  |  |  | Year 3/4 [NAME]
[NAME] |  |  |  |  | Year 3/4 Lloyd Evans
[NAME] |  |  |  |  | Junior STF [NAME]
[NAME] |  |  |  |  | Year 3/4 [NAME]
Caleb |  |  |  |  | Junior STF [NAME]
[NAME] |  |  |  |  | Year 3/4 Lloyd Evans
[NAME] |  |  |  |  | Year 3/4 Lloyd Evans
[NAME] |  |  |  |  | Year 3/4 [NAME]
Olivia |  |  |  |  | Year 3/4 Lloyd Evans
[NAME] |  |  |  |  | Year 3/4 [NAME]
Esme |  |  |  |  | Year 3/4 [NAME]
[NAME] |  |  |  |  | Year 3/4 Lloyd Evans
[NAME] |  |  |  |  | Junior STF [NAME]
Kitty |  |  |  |  | Year 3/4 Lloyd Evans
Charlotte |  |  |  |  | Year 3/4 [NAME]
Steffan |  |  |  |  | Year 3/4 Lloyd Evans
Grace |  |  |  |  | Year 3/4 [NAME]
Brody |  |  |  |  | Year 3/4 Lloyd Evans
Bow |  |  |  |  | Year 3/4 [NAME]
Felix |  |  |  |  | Year 3/4 Lloyd Evans
[NAME] |  |  |  |  | Year 3/4 [NAME]
Georg |  |  |  |  | Year 3/4 [NAME]
Mariia |  |  |  |  | Year 3/4 [NAME]
Molly |  |  |  |  | Year 3/4 [NAME]
Maisie |  |  |  |  | Year 3/4 Lloyd Evans
[NAME] |  |  |  |  | Year 3/4 [NAME]
Skyler |  |  |  |  | Year 3/4 [NAME]
Alys |  |  |  |  | Year 3/4 Lloyd Evans
[NAME] |  |  |  |  | Year 3/4 Lloyd Evans
Lily |  |  |  |  | Year 3/4 [NAME]
Callum |  |  |  |  | Year 3/4 Lloyd Evans
Thea |  |  |  |  | Year 3/4 [NAME]
[NAME] |  |  |  |  | Year 3/4 Lloyd Evans
Efa |  |  |  |  | Year 3/4 [NAME]
Jessica |  |  |  |  | Year 3/4 [NAME]
Florence |  |  |  |  | Year 3/4 Lloyd Evans
[NAME] |  |  |  |  | Year 3/4 [NAME]
[NAME] |  |  |  |  | Year 3/4 [NAME]
[NAME] |  |  |  |  | Year 3/4 [NAME]
[NAME] |  |  |  |  | Year 3/4 [NAME]
[NAME] |  |  |  |  | Year 3/4 [NAME]
Lillie-Rose |  |  |  |  | Year 3/4 [NAME]
[NAME] |  |  |  |  | Year 3/4 [NAME]
Claudia |  |  |  |  | Year 3/4 Lloyd Evans
[NAME] |  |  |  |  | Year 3/4 [NAME]
[NAME] |  |  |  |  | Year 3/4 [NAME]
[NAME] |  |  |  |  | Year 3/4 Lloyd Evans
[NAME] |  |  |  |  | Year 5/6 Holly Stevenson
Olivia |  |  |  |  | Year 5/6 [NAME]
Tor |  |  |  |  | Year 5/6 Holly Stevenson
Elias |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 [NAME]
Summer |  |  |  |  | Junior STF [NAME]
[NAME] |  |  |  |  | Year 5/6 [NAME]
Autumn |  |  |  |  | Year 5/6 [NAME]
Seb |  |  |  |  | Year 5/6 [NAME]
Finley |  |  |  |  | Year 5/6 [NAME]
Ava |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 Holly Stevenson
Anabel |  |  |  |  | Year 5/6 Holly Stevenson
Eve |  |  |  |  | Year 5/6 [NAME]
Luca |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 Holly Stevenson
[NAME] |  |  |  |  | Year 5/6 [NAME]
Holly |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 Holly Stevenson
[NAME] |  |  |  |  | Year 5/6 [NAME]
Toby |  |  |  |  | Junior STF [NAME]
[NAME] |  |  |  |  | Year 5/6 Holly Stevenson
Jemima |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 Holly Stevenson
Jake |  |  |  |  | Year 5/6 Holly Stevenson
[NAME] |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 [NAME]
Eve |  |  |  |  | Year 5/6 Holly Stevenson
Nell |  |  |  |  | Year 5/6 Holly Stevenson
Osian |  |  |  |  | Year 5/6 Holly Stevenson
Betsan |  |  |  |  | Year 5/6 [NAME]
George |  |  |  |  | Year 5/6 Holly Stevenson
Zack |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 [NAME]
Isla |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 Holly Stevenson
[NAME] |  |  |  |  | Junior STF [NAME]
Estelle |  |  |  |  | Year 5/6 [NAME]
Holly |  |  |  |  | Year 5/6 Holly Stevenson
Otis |  |  |  |  | Year 5/6 [NAME]
Sunny |  |  |  |  | Year 5/6 Holly Stevenson
[NAME] |  |  |  |  | Year 5/6 [NAME]
Ava |  |  |  |  | Year 5/6 Holly Stevenson
[NAME] |  |  |  |  | Year 5/6 [NAME]
Evie |  |  |  |  | Year 5/6 Holly Stevenson
[NAME] |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 [NAME]
Matilda |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 Holly Stevenson
[NAME] |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 Holly Stevenson
[NAME] |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 [NAME]
Jaxon |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 [NAME]
Beatrice |  |  |  |  | Year 5/6 [NAME]
Rose |  |  |  |  | Year 5/6 [NAME]
Willow |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 [NAME]
Jessica |  |  |  |  | Year 5/6 [NAME]
Cari |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 [NAME]
Lowri |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 Holly Stevenson
Primrose |  |  |  |  | Year 5/6 Holly Stevenson
[NAME] |  |  |  |  | Year 5/6 Holly Stevenson
Annika |  |  |  |  | Year 5/6 Holly Stevenson
Rohan |  |  |  |  | Year 5/6 [NAME]
Myles |  |  |  |  | Junior STF [NAME]
[NAME] |  |  |  |  | Year 5/6 [NAME]
Ava |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 Holly Stevenson
[NAME] |  |  |  |  | Junior STF [NAME]
Olivia |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 [NAME]
Lucas |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 Holly Stevenson
[NAME] |  |  |  |  | Year 5/6 Holly Stevenson
[NAME] |  |  |  |  | Year 5/6 [NAME]
Lucas |  |  |  |  | Year 5/6 [NAME]
Osian |  |  |  |  | Year 5/6 [NAME]
Poppy |  |  |  |  | Year 5/6 [NAME]
Matilda |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 Holly Stevenson
Ebssitu |  |  |  |  | Year 5/6 Holly Stevenson
Jac |  |  |  |  | Year 5/6 Holly Stevenson
[NAME] |  |  |  |  | Year 5/6 Holly Stevenson
Kes |  |  |  |  | Year 5/6 [NAME]
[NAME] |  |  |  |  | Year 5/6 [NAME]
Destiny |  |  |  |  | Year 5/6 [NAME]