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

Mayfield data handling

Extracts from this document...

Introduction

Introduction

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.

Hypothesis

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.

Middle

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:

image00.jpg

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

image01.jpg

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.

Analysis

Level 2

...read more.

Conclusion

image05.jpg

Analysis

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.

Conclusion

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.

Evaluation

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.

    Whether all of these points can be found in reality will be analyzed in the following point. Empirical data of both all-male and all-female talk has been collected to prove or correct the existing studies. 4. Empirical Analysis a) all-female informal talk See transcript a Context: S and M have come to visit N in her new flat.

  1. Maths Data Handling

    the frequency tables, but I will have to round to one decimal place, meaning the mean will not be completely accurate. I will also find out the modal class interval in the production of the frequency tables as the class interval with the highest frequency will be the modal class interval.

  2. Maths: Data Handling Coursework

    However, the box plots for year 9 may show that the boys are "catching up" to the height and weight of girls, i.e. the boys in year 9 are taller and weightier than girls in year 9. This table contains information about the number of students in the years 7, 9 and 11 from Mayfield Secondary School.

  1. mayfield high school handling data coursework

    lower quartile=43.5 median=49 upper quartile=52 range=74-33=41 key stage 4 girls heights 1.3 7 1.4 0,7 1.5 0,2,5,5,6,6,8,9 1.6 0,1,1,2,3,5,5,6,7,7,8,9,9 1.7 0,0,0,2,3,3,3,3,4,5,8 1.8 0,3 1.9 0 mean=1.65 lower quartile=1.5825=1.58(3 sig fig) median=1.665=1.67(3 sig fig) upper quartile=1.73 range=1.9-1.37=0.53 Key stage 4 girls weights 3 0 4 0,0,2,2,4,5,5,5,5,5,5,5,7,8,8,8,8,8 5 0,0,0,1,1,2,4,4,4,4,4,6,9 6 0,0,0,0,6,6 mean=50.02632=50.0( 3 sig fig)

  2. Data Handling - GCSE Coursework

    Now I'm going to do a tally of the pupil's information. I'm going to do the boys and the girls separately and combined so I can use their individual data and combined data to make a variety of graphs. Boys Height, h, (cm)

  1. Maths - Handling Data

    Year Group Height (m) Weight (kg) 10 1.80 60 10 1.62 48 10 1.55 65 10 1.75 56 10 1.47 45 10 1.60 47 10 1.72 50 10 1.73 42 10 1.80 60 10 1.68 50 10 1.73 57 10 1.75 57 10 1.56 45 10 1.63 56 10 1.57

  2. Data Handling Project

    girls and vary the amount of samples taken from each year to keep the sample unbiased. This was done as the different year groups had different numbers of pupils and it would be unfair to take the same number of samples from each year group.

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