Blog
Making the most of Edexcel ResultsPlus- updated for Jan 2013
7th March 2013
Read on to find out how to print out individual grade reports for all your students using the complete results spreadsheet you can download from ResultsPlus
With A-Level results day upon us, I’ve been creating up-to-date mail merges for the Business Unit 1, 2 and 4 January exams. With these Word documents you simply need to download the spreadsheet for your students’ results from the Edexcel ResultsPlus website, modify it slightly, and then you’ll have individual print-outs for each student indicating their overall grade and grades for each individual question. This then allows them to quickly and easily see where they went wrong, and also if they want to consider reviewing their paper or requesting a re-mark. Just follow the instructions below and, hopefully, your students will find this additional information useful.
(N.B. These instructions assume you are using Office 2010)
1. Download & open the relevant Word mail merge document:
(Apologies I haven’t done unit 3 as none of our students are taking this exam in January)
2. Download your students’ results as a spreadsheet csv file from ResultsPlus. Open this in Excel and highlight the student's data. Copy this to the clipboard and then, in a new sheet, 'transpose' the spreadsheet (this is one of the paste options). Then delete some rows so the top row contains the appropriate headings, e.g. 'name', 'Q01', etc. Now close the spreadsheet
3. Open the relevant Word file and, under ‘mailings’, click on ‘select recipients’ and then ‘use an existing list’ and then navigate to your spreadsheet file
4. Click on ‘preview results’ to check everything looks OK and make any necessary changes
5. Now click on ‘finish & merge’. You can merge straight to a printer. I usually merge to a new file just to check they’re all OK and then print that file.
Please note that this document is set as A5 paper so you either need to print onto A5 paper or change the page layout to A4