Has anybody come up with a good spreadsheet layout in excel to keep all the topic/module test results for yr 10 and yr 11, using formula to calculate the grades obtained. My spreadsheet is getting a bit too complicated and mistakes could be made by staff entering in the wrong columns! please email to lthorpe14@purple.esinet.org.uk

 Hi,

 

I've got a simple one that I use for my current KS4 classes (I will email you ASAP). As we are a small school (We only have single form entry this may not be suitable for you.

If you want a copy of my template please email me, using the contact tab on the top right hand side of this message. Don't post your email address. You'll regret it when your inbox is full with spam!
 

 

I have one up and running for year 10, but not year 11 yet, as I have not come across the grade boundaries yet - do you have these? The year 10 one gives 2 grades...the grade they would get if they took no more exams, and their predicted grade, which should both match at the end of the course :) It is designed closely for us, with 6 IAA marks whittled to 3...

Hello,there.  To be honest keeping the 360 Science results on a spreadsheet is turning into a nightmare!  I believe that Edexcel have overlooked the extra demand placed on schools in recording all these tests, IAA's and skills results as well as any resits etc.  It would be good if they could produce a recording spreadsheet themselves.  Anyhow, please could you or anybody possibly email the recording s'sheet that you have for 360 science so I can try to get it back into some useful format.  I would really appreciate it.