• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  • Level: GCSE
  • Subject: Maths
  • Word count: 3205

Mayfield data handling

Extracts from this document...



For this piece of coursework, I’m going to look at Mayfield High School. I was given data on Key stage 2 subject results. There were 19 spreadsheet pages of data which had the number, Year Group, gender, IQ and KS2 subject results of the students who attend Mayfield High School.

Statistical information shows that there are 1,183 students in total, of which there are:                                282 students in Year 7                                                                                                                                                                 270 students in Year 8                                                                                                                            261 students in Year 9                                                                                                                            200 students in Year 10                                                                                                                           170 students in Year 11.                                                                                                                            Also the statistics show that 4 students in Mayfield High School achieved KS2 level 0                                                                                                                            17 students achieved KS2 level 2                                                                                                                            246 students achieved KS2 level 3                                                                                                                            552 students achieved KS2 level 4                                                                                                                            345 students achieved KS2 level 5                                                                                                                            19 students achieved KS2 level 6.

My assignment was to look at correlation between the IQ and the KS2 results. In order to find out the relationship between the two variables, I will be looking at a random sample of students in Mayfield High School in terms of their IQ and their KS2 results in Math.


The key relationship I will be looking at is:

The relationship between the IQ and the KS2 results in Math.

I predict that:

  1. Students who have low IQ’s will have a lower KS2 result.
  2. While the IQ increases the KS2 results for maths will also increase.
  3. Students who have low IQ’s but work hard will have higher KS2 results than students who have high IQ’s.

Collecting the information

The variables linked with my hypotheses are the IQ’s and the KS2 Math results of students in Mayfield High School. This information will represent the whole school of Mayfield High School, taking account of all five year groups and all the results from level 0-6.

...read more.


A SELECTIVE sample is one which every nth term is chosen, where n is selected at random e.g. taking every 10th piece of data.

A STRATIFIED sample is one which the population is divided into groups called strata and each stratum is randomly selected.

A RANDOM sample is one in which each member of the population is equally likely to be selected.

I will use a RANDOM sample; this is because I want every student in Mayfield High School to have an equal chance to be selected.

The initial sample that I will use to look at is 15 students, regardless of gender, from each KS2 results. In order for me to do this, I used the random button on my scientific calculator to get random numbers of students. The calculation I used was: Total number of students to be sampled × SHIFT Ran# = Keep pressing the = button to get another random number.

Recording the Data

Below are the randomly selected students with their IQs:


Below shows the Frequency and the Cumulative Frequency table of the IQs:


I used a table to record the IQs of all the KS2 results, I then calculated and conducted a cumulative frequency table. Afterwards, I used my data to plot cumulative graphs to find out accurately the Lower-Quartile, Upper quartile, Inter-Quartile Range and the Median. In the end, I drew box and whisker plots on one scale so I could easily analyse the data.

The tables show the IQs for each KS2 results, the mean is the weighted average and is worked out by the sum of frequency multiplied by the mid points of each class. The formula is ?fx divided by the sum of all the frequencies.


Level 2

...read more.




Overall, girls had a lower lower-bound of 95, a lower lower-quartile of 102.5, a lower median of 106.25, a lower upper-quartile of 110, a lower upper-bound 0f 121 and a lower mean of 107.1. Basically, we can see that there is a consistent pattern of boys doing better at all the factors of data handling.


My hypothesis was correct; I predicted that boys will do better. One reason why my hypothesis is correct is because I used my knowledge of my first extension to influence my hypothesis. This extension suggests that boys are really doing better than girls and outpacing them. However, it doesn’t mean that all boys around the country are doing better than girls in secondary; we’re just looking at on e school so we can’t assume that my findings somehow portray the performance of genders in schools.


I think I found sufficient information from Mayfield High School to deduct that boys are doing better. One reason why this assignment was quite easy was because I did a similar project for my Sociology coursework, thus, I applied my previous knowledge to this assignment. However, one thing that confused me was how to calculate the stratified sample, in Sociology, when I studied types of samples, we had slightly different meanings - so I was a bit lost in this section.

If I had to do this project again, I would use histograms and present my findings much neater. Due to insufficient time and lack of knowledge on how to do graphs on Microsoft excel limited the creativity of my work.

On the whole, at first I was confused about this assignment but then as I started working on it, the project made sense and I began to get the hand of it.

...read more.

This student written piece of work is one of many that can be found in our GCSE Height and Weight of Pupils and other Mayfield High School investigations section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE Height and Weight of Pupils and other Mayfield High School investigations essays

  1. A hypothesis is the outline of the idea/ideas which I will be testing and ...

    firstly find the mean and the average IQ Level of the Data that I have chosen and also the average number of hours of TV watched per student. Mean IQ of Student in my sample I will now find the Mean, Mode of the Frequency that I have found and

  2. Math Coursework-Mayfield High Data Handling

    You can calculate skew by: Upper Quartile - Median = x Median - Lower quartile = y If x is equal to y, then the distribution is normal.

  1. Data Handling Project

    x 20 = 4.8 rounded to 5 Year 9 boys = (118 � 604) x 20 = 3.9 is rounded to 4 Year 10 boys = (106 � 604) x 20 = 3.4 is rounded to 3 Year 11 boys = (84 � 604)

  2. The purpose of this research paper is to present our findings on how the ...

    where the focus should be on factors such as autonomy and achievement. Males who find it difficult to progress through these two stages of the hierarchy will definitely have difficulty achieving their academic potential and becoming what they are truly capable of (self actualization).

  1. Maths: Data Handling Coursework

    = 35 85/712*300 = 36 Total 149 151 This table shows the sample sizes of the years 7, 9 and 11. I have obtained the sample sizes by dividing the number of pupils in each year group by the overall total of people from the three years.

  2. Statistics coursework - hypotheses based on students statistics

    88 1.70 65 8 Latimer Jade 13 0 Female 109 1.65 45 8 McMahon Gaynor 13 6 Female 110 1.60 45 8 Neelam Kate 13 8 Female 103 1.44 50 8 Rooster Hally 13 2 Female 103 1.60 44 8 Timpson Zoe 13 6 Female 107 1.72 48 9 Adnan

  1. Maths Data Handling

    This is because the school is growing each year and so it is likely that year 7 will contain a vast amount of pupils. This will effect my investigation because of the relationship between age, height and weight, which will be studied later in the project.

  2. Maths newspaper data collection project

    = 16800/100 = 168.00 x 2 = 336 Sentences * Local Paper = 1521/100 = 15.21 x 10 = 152.1 Sentences Next, I found how many sentences I would have to count for each section in each paper by dividing the amount of sentences in the paper by one hundred

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work