Really easy to use this simplified spreadsheet to track record and track progress for AQA GCSE MFL with grade boundaries for writing, speaking and overall.
Just add students' names and raw grades for each skill or CA's.
There are 6 sheets:
Sheet 1: Formula for UMS/Grades conversion, foundation reading and listening (you can change values in yellow columns if needed).
Sheet 2: Formula for UMS/Grades conversion, higher reading and listening
Sheet 3: Formula for UMS/Grades conversion, Speaking
Sheet 4: Formula for UMS/Grades conversion, Writing
Sheet 5: Recording CA's marks, formula for Grades
Sheet 6: Mock results - after completing a past paper, copy grades and ums scores from sheet 1,2,3 and 4 which will give you the final grade at that particular stage in a year.
Please leave your feedback, Thank you