As usual I’m sharing excel workbooks that you can use to analyse your cohort level data from Edexcels ResultsPlus … unfortunately these ones don’t have the “multiprint” option (…yet! … I’m working on it!) but I’ve put a blank version in the workbook too as we’ve always printed the blank versions off and got students to fill them in when we use papers for internal assessments as I’m sure these papers will be used by lots of people as mocks next year! What I’ve also done if you want to input the data and produce the sheets for your students yourselves I’ve put some conditional formatting on the sheets for each specific paper so you can see how your groups have performed on certain topics too.
- Edexcel – 2017 Summer – F tier – No Multiprint
- Edexcel – 2017 Summer – H tier – No Multiprint
- QLA Instructions
I’ve also managed to get hold of the format of the download data from Emma Bell for the Foundation tier and so between us (she did most of the work to be honest!) I can also share QLA sheets for the Edexcel legacy papers … (Higher tier is now added below too!) … Now … if you want to really help out our colleagues in FE for your students that got a grade D who will be having to resit the new GCSE it might be worth printing off a copy and sending to your ex-students saying that their tutors in college may find the information useful!
Any finally, on the basis that we’ve never asked teachers to input question level data (I’m not saying there is anything wrong with it but I’m just not convinced it adds value and I find students get so much out of actually doing it themselves but “each to their own”) I’ve also put together some manual sheets that may be of use if you’re going to be using the 9-1 AQA papers …. (I’ll also try to get OCR done at some point!)
UPDATE:
I am also adding versions below for AQA that include instructions to produce QLA from the download from their systems …
- QLA Instructions – AQA
- AQA – 2017 Summer – H tier – QLA – No Multiprint
- AQA – 2017 Summer – F tier – QLA – No Multiprint
UPDATE 2:
Below you will find versions for the OCR Summer papers.
Just awesome as usual, massive thank you as I will be utilising this year.
Thanks 😁😁
Superb…I usually do my own but this is brilliant…
Hi Mel. Thanks a lot for these. I have input our student data into my local files, and all works well.
Just re-read the filename “No-Multiprint”. Does that mean at the moment I would need to manually change the number in cell reference E1 on the Analysis sheet in order to print out?
I gather there will be a multiprint version. Any idea when? I could probably work out how to do it myself, but don’t want to mess up your lovely spreadsheet.
Thanks, Dominic.
Hiya,
yep … enter each students number into E1 … sorry .. not sure about timescales.
Could you put an excel or word version of the AQA ones so that I can put them into my own spreadsheet? Thanks
I just have ..
Hi Mel Have you or do you know of anyone that has produced a similar QLA for EDEXCEL Secure Mocks 3 ? Best wishes and thanks for your continuing fabulous blog, resources,support etc.
just emailed you the foundation version
Hi
Do you have a higher version for secure mock3? Thanks
Yes I do … email me. Mel
Hi Mel
We are using the Summer 2017 Higher QLA with Macros sheet but when clicking on the ‘create and print student sheets’ button, nothing happens. Do you think its an issue with the sheet/code itself or our version of Edexcel (or could it be due to a missing add-on)?
Many thanks.
Ash
I’m not sure the macros work .. I’ll have a look ..
Works for me … make sure you enable macros then enable content.