Posts Tagged ‘Coursework’

In the final throes of marking coursework for the iGCSE Unit 4 in preparation for the November exam, I felt the need for a break. Three days of a poorly baby and 2-4 am feeds have taken their toll! More on the beautiful Mrs P than me, but their toll has been taken!

So I thought I’d share the tracking spreadsheet I’ve come up with.

It’s pretty straightforward, to be honest.

I’m simply recording the score given for Speaking and Listening (out of 30) Reading (out of 10) and Writing (out of 40). There are an additional 50 marks up for grabs in the exam.

I’ve found last year’s grade thresholds. These are out of 125 whereas according to my maths the raw marks add up to 130 but it doesn’t take too much to convert the C threshold of 72 / 125 into 75 / 130; nor the A threshold of 93 / 125 into 97 / 130 raw marks.

If I get the computer to then subtract the total marks so far from the thresholds to indicate how many marks are needed from the exam to achieve either threshold. In order to build in a bit of leeway, I’ve also got the computer to generate a best and worst case scenario to create a target range for students. Best case scenario is 2013 grade threshold x 95%; worst case scenario is 2013 thresholds x 110%.

It’s working out that some of our C/D borderline kids only need between 11 and 13 marks out of 50 to achieve a C!

20131020-142848.jpg

Advertisements