Mayfield data handling

Authors Avatar

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  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 .

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. After thinking about the variables needed in my investigation, I plotted a tally chart so that I could record the IQ’s in each year group.

Source of information

I’ll collect the information from the Mayfield High School booklet available on the official website which has all the data in an Excel spreadsheet format.

Join now!

Reasons for choosing source of information

The main reason why I choose to look at Mayfield High School is because; the data within the booklet is accurate as it is the results of carefully prepared and planned tests, so therefore the results will be very accurate. Also, as the information are based on examinations enforced by the government – the results are more likely to be reliable than that of class tests.

The variables that I will be looking at are based on abilities. The measurements of ability can be quite tedious as there is more than one way of ...

This is a preview of the whole essay