Maths Studies Group
Statistical Analysis of GCSE results at my secondary school summer 2010
For my maths project, I requested for the summer 2010 GCSE Exam results from St Bede’s secondary school Exam moderator; so as to analyse it. Having received the data, I made the names of the students anonymous, to keep their information private. I kept the data in alphabetical order so that my hypothesis would make sense. I identified the gender for the 186 students that wrote the exam; which took a lot of time to get the data ready and to make it private.
I had to search on the internet for the equivalent GCSE grade points so that I could change the grades to points so as to have a good set of data for my analysis. My hypothesis for my maths project base on the GCSE result summer 2010 is the lower down you are in the alphabetical order of the registration the less you do well in the exams and by that having low GCSE results at the end, while the higher up you are in the register the better you do and having a good GCSE result at the end.
So by my hypothesis the graphs that I am going to produce base on my data results should have a negative trend (line of best fit) and for it to have a negative trend showing my hypothesis, what I did was numbered the students starting from the last student on the alphabetical order in the register numbering him/her number 1 and numbering the first student on the alphabetical order register number 186.
The table below shows what point are equivalent to each different GCSE when converted for example an A* has the point of 58 when converted, and the screen shot shows how I came about into changing all the GCSE grades into equivalent point numbers.
The equivalent GCSE grade points
This data is part of the main data showing just the English Language & Literature GCSE points for each student. I am going to compare the total score for each child against their alphabetical order numbering to see if we get any correlation and to prove if my hypothesis is right or wrong.