• 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. Informal vs. formal speech.

    She compares this phenomenon with a "jam session", a spontaneous, improvisatory performance of different kinds of instruments which complement one another to create a perfect harmony. The fact that men tend to talk more loosely when they are among themselves leads to the phenomena that they tend to use a more rude and impolite talking style.

  1. Maths Data Handling

    This is similar to the frequency polygons as I will draw a two frequency polygons on each graph, one for boys and one for girls. This will be done for height and weight. Once they are drawn, I will be able to compare the height and weight of girls and

  2. Maths: Data Handling Coursework

    The reason why I chose this method was because I felt that my results would be more representative if my sample size was in proportion to the original totals. I also felt that this way, I could keep my investigation from being biased.

  1. mayfield high school handling data coursework

    Catherine Jane Female 1.45 41 0.095834 7 Kelly Jessica Louise Female 1.20 38 0.072019 7 Casey Danielle Female 1.46 45 0.993939 7 Dodman Emma Female 1.53 52 0.962121 7 Spencer Angela Cassey Female 1.62 40 0.994235 7 Anderson Zahrah Female 1.56 53 0.383931 7 Lousie Francesca Female 1.42 48 0.013431

  2. Data Handling - GCSE Coursework

    Boys Height, h, (cm) Tally Frequency 130 < h < 140 | 1 140 < h < 150 0 150 < h < 160 | 1 160 < h < 170 ||||||| 7 170 < h < 180 ||||| 5 180 < h < 190 || 2 190 < h < 200 | 1

  1. Maths - Handling Data

    By looking at the two tables, I can see that the modal class for each year group is 1.60 - 1.75 metres. The difference is huge in year 10 but in year 11 the difference is very small and by looking at the data it could be said that more people in year 10 are taller which is very surprising.

  2. Data Handling Project

    Therefore, stratified sampling will be helpful due to the fact that there are different numbers of students in each year, and so there is less chance of unequal representation. I will be investigating 20 boys and 20 girls altogether. I will be calculating my stratified sampling using the table that

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