# 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:

- Students who have low IQ’s will have a lower KS2 result.
- While the IQ increases the KS2 results for maths will also increase.
- 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.

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:

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.

Analysis

Level 2

Conclusion

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.

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