iGCSE Coursework Tracking

Posted: October 20, 2013 in AfL, Assessment, C not D, Data, Examination, First Language English, Key Stage 4, Management, PiXL, Reporting
Tags: , , , , , ,

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
Comments
  1. ktegan says:

    I love this! Is there any way at all that you could email me this template? I would be really grateful! Thanks, Katie

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s