https://www.tes.com/teaching-resource/gcse-9-1-mfl-tracking-spreadsheet-2018-video-tutorial-12044094 - Video preview. GCSE 9-1 Spanish Edexcel Mock Tracking Spreadsheet 2018. The spreadsheet includes:
Two tabs, one for higher and one for the foundation tier (also available for other languages and exam boards).
To start enter the marks your students achieved in the mock exam for each skill (listening, speaking, reading and writing). Marks gets scaled automatically (where appropriate) as well as an overall mark and grade.
At the bottom of each column you automatically get and average mark and grade for each skill, so you’ll be able to see which skills students performed better at and plan your interventions accordingly.
If you scroll to the right, you have three additional columns. In the target grade enter what the students are expected to achieve by the end of the year. This will be available from Sims or from whatever system your school uses. In the current grade enter what the student achieved in their mock exam.
The progress score column has now updated automatically and tells you how the student performed in comparison to their target. This will give a clear picture of which students are further away and therefore need to be targeted for interventions.
At the bottom you will be able to see the average current grade, average target grade and progress score. Your school will be looking for a progress score of zero or above which means the class has performed in line or above expectations.
If you do decide to purchase this spreadsheet and find it useful would you do me a favour? Please leave a review. You don’t have to write much if you don’t want to and I would really appreciate it.