{"id":426,"date":"2012-11-30T13:01:07","date_gmt":"2012-11-30T11:01:07","guid":{"rendered":"http:\/\/www.mrallsophistory.com\/revision\/?p=426"},"modified":"2016-09-17T08:08:08","modified_gmt":"2016-09-17T06:08:08","slug":"teacher-resources-for-ocr-history","status":"publish","type":"post","link":"https:\/\/www.mrallsophistory.com\/revision\/teacher-resources-for-ocr-history.html","title":{"rendered":"Teacher Resources for OCR History"},"content":{"rendered":"

PLEASE NOTE<\/strong><\/span><\/p>\n

This page no longer reflects the OCR coursework or controlled assessment requirements. It is kept here in case teachers wish to adapt the spreadsheet for other purposes.<\/strong><\/span><\/p>\n

Coursework and paperwork and the monitoring of target grades against current student performance seems to take for ever, and so to help speed up the completion of cover sheets, labels, and candidate authentication forms, I’ve created a set of mail-merges that will do it all for you.<\/p>\n

This Excel file<\/a> is designed to be used to input Year 11 GCSE mock grades (Levels and Marks) and will calculate total percentages, and map it against a rough set of grade boundaries.\u00a0 There are separate sheets for each of the 2 papers, and a third sheet for coursework marks.\u00a0 The coursework calculator is designed for the “off-the-peg” coursework on Russia which I currently teach.\u00a0 Assignment 1 is marked out of a straight 25 marks, while Assignment 2 is marked out of 50 marks and then halved to get the mark out of 25 for submission to OCR.\u00a0 The sheet is easy to edit if you need to.<\/p>\n

The fourth sheet pulls in marks from Paper 1, Paper 2 and the coursework element and does a quick calculation to work out the rough ratio between each part before then mapping it onto a final grade.\u00a0 I show this to my students to show how the different elements of their course work together, and it is a good indicator of predicted marks.<\/p>\n

The\u00a0 Word documents load data from the coursework data sheet of the Excel file and once mail-merged produce all the relevant paperwork to be sent off to OCR.\u00a0 Here are the Coursework Cover Sheet<\/a>, the Candidate Authentication Form<\/a>, Coursework Labels<\/a> and the Coursework Summary Form<\/a> which outputs student data in ascending candidate number order as required by OCR.<\/p>\n

\n

\"\"To make the files work for you, right-click and select “save target as” to a location on your computer – ideally downloading all the files to the same directory.<\/p>\n

Load the Excel file “OCR History B marksheet” and after selecting the “Paper 1” tab at the bottom of the screen, fill in your class’s names and candidate numbers as indicated.\u00a0 I’ve put in the imaginary “Bob Bobson, candidate number 1234” to give you an idea. The name and number will be updated automatically on the other sheets, so now you just need to mark the student papers and coursework (groan) and input the marks on the spreadsheet.\u00a0 There are spaces both for the answer level and the mark.\u00a0 The level is not required to make the sheet work, but I like to use it for my own reference.<\/p>\n

As you fill in the marks, the columns at the far-right of the spreadsheet will begin to update themselves with the total mark, total percentage, and an indicative grade mapped against rough grade boundaries which are set in the “Grades” sheet.\u00a0 You can change the grade boundaries on this sheet if you need to, by simply changing the percentage.<\/p>\n

The coursework sheet is completed in the same way with levels and marks, but is set to process Assignment 1 (AO 1) to be marked out of 25, and Assignment 2 (AO 2 and 3) to be marked out of 50.\u00a0 The spreadsheet then halves the mark for Assignment 2 to get a mark out of 25 and gives an overall mark and percentage.<\/p>\n

The total marks from Paper 1, Paper 2, and the Coursework sheets then appear in the “Overall” sheet, which works out a rough mark ratio of exam-to-coursework and overall grade.<\/p>\n

To process the coursework paperwork first load the Word document you wish to work on.\u00a0 You will be warned that “opening this document will run…”\u00a0 Click “Yes<\/strong>“.\u00a0 You will now need to point Word to the location of your saved Excel spreadsheet.\u00a0 Once you’ve located it and clicked “Open<\/strong>” you need to make sure that “Coursework$<\/strong>” is selected, and click “OK<\/strong>“.\u00a0 The sheet will now load.<\/p>\n

You’ll notice some strange codes in some boxes such as \u00abF1\u00bb<\/strong> – these load the names and candidate numbers from your spreadsheet, so leave them as they are.\u00a0 However, you will need to fill in the blank boxes for your school and examination year along with the teaching class\/set if appropriate.<\/p>\n

Go to the menu bar and click Tools<\/strong> > Letters and Mailings<\/strong> > Mail Merge…<\/strong>\u00a0 This will open a window at the right-hand side of yoru screen.\u00a0 Click “Edit recipient list<\/strong>” and ensure that the boxes at the side of all your candidates are ticked.\u00a0 Click “OK<\/strong>” and then in the main mail-merge window click “Next: write your letter<\/strong>“.\u00a0 You don’t need to change anything here, so just click “Next: preview your letters<\/strong>“.\u00a0 If you scroll down the main window you will see that the \u00abF1\u00bb <\/strong>codes have been replaced with your students’ information.<\/p>\n

As long as everything looks right, click “Next: complete the merge<\/strong>“.\u00a0 If you want to double-check all the merged sheets, you can select to “Edit individual letters…”, otherwise just click “Print…” and the sheets will update themselves with individualised information on each of your students, ready to be sent to OCR and hopefully saving you an ENORMOUS amount of time writing them out by hand!<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

PLEASE NOTE This page no longer reflects the OCR coursework or controlled assessment requirements. It is kept here in case teachers wish to adapt the spreadsheet for other purposes. Coursework and paperwork and the monitoring of target grades against current student performance seems to take for ever, and so to help speed up the completion […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rop_custom_images_group":[],"rop_custom_messages_group":[],"rop_publish_now":"initial","rop_publish_now_accounts":{"twitter_2462029770_2462029770":""},"rop_publish_now_history":[],"rop_publish_now_status":"pending","footnotes":""},"categories":[101,69],"tags":[],"class_list":["post-426","post","type-post","status-publish","format-standard","hentry","category-ocr-history","category-teachers"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t