English Reading and Writing Skills tracker and reporting to parents document

A spreadsheet to track English Reading and Writing skills.
9 Reading and 9 Writing skills are tracked for each pupil. Teachers grade pupils upon a 1-4 point scale, each skill can be assessed up to 10 times in an academic year.
The reading skills are: Read aloud with fluency, Comprehension, Language Terms, Structure Terms, Analysing Language, Analysing Structure, Relevant Quotations, Comparison, Response to Task
The Writing skills are: Vocabulary Choices, Spelling -Common words, Spelling -Complex words, Clarity, Structural devices, Punctuation between sentences, Punctuation within sentences, Varied Sentences, Handwriting
The spreadsheet will then generate a graded comment upon each skill for each pupil to go into a mail merge document which can be sent out to parents.
Data from SIMS can be entered upon teaching group, forename, surname, Target Level, OPT Level at end of Key Stage, Gender, PP (Pupil premium status), MA (More able status), SEN status, reading and writing scores and reading age upon entry.
The spreadsheet uses macros (Will only work with Microsoft Excel for Windows) that automatically sort with the click of one button pupil data to be sorted by cohort or by teaching group alphabetically, by target Levels, OPT Levels, Reading criteria, Writing criteria, reading age upon entry. This is useful if you or your staff are not very familiar with spreadsheet commands.
The Word document included allows a mail merge to be carried out from the spreadsheet data to produce cohort and group reports which pupils can self evaluate to identify their strongest and weakest skill areas, what is interfering with their progress and how they can make improvement in the future. These documents can be used to show progression over time, aid closing the gap meetings, show intervention strategies in performance management meetings.
Includes: a fully detailed instruction/help power point, the tracking spreadsheet, the mail merge word document
A copy of the helpfile showing what the resource will do can be found at https://www.tes.com/teaching-resource/english-reading-and-writing-skills-tracker-and-reporting-to-parents-document-instruction-help-ppt-12075079