X hits on this document

52 views

0 shares

0 downloads

0 comments

1 / 12

Mayfield High School – Higher Tier

Mayfield High is a fictitious school but the data collected is from real students.  You will investigate the relationship between height and weight.  There are mistakes in the data including impossible heights and weights.

Locating the Mayfield Database

In the school Intranet select Subject and Group Sites

Then select Maths Website, followed by Mayfield and click on the word HERE

You will spend some time on the computers obtaining data to work on and producing graphs and statistical calculations, but marks are awarded for your entire write up of the coursework.  Your report must contain the following:

1.

A pilot study (including a commentary)

2.

A detailed plan for your main study

3.

Calculations and graphs produced

4.

Detailed conclusions

5.

An evaluation

Firstly, as you are only interested in height, weight, year and gender you must delete the rest of the data.

Deleting Unwanted Data (leaving Year, Gender, Height and Weight)

Select columns 2 to 7

From the Edit menu select Delete

Now repeat this for columns 3 to 12 and 5 to 11

REMEMBER TO REGULARLY SAVE YOUR WORK INTO YOUR MY WORK FOLDER

Document info
Document views52
Page views52
Page last viewedSat Dec 10 04:20:53 UTC 2016
Pages12
Paragraphs319
Words2772

Comments