**Data Handling - Year 5/6**

Objectives/vocabulary

Objectives/vocabulary

Data Handling:

Collecting data and create a spreadsheet/table (1 lesson depending where from and how much data is being collecting)

Write formulae to find totals, average, minimum and maximum results. (1/2 lesson)

Present data as a bar/chart/pie chart

**Introduction**

Data Handling has been an ever present in the ICT/Computing curriculum for many years. We have included it in both Years 3/4 and Year 5/6 because it a skill that should be performed regularly within different subjects. The unit of lessons below is a Geography suggestion but similar data could be used from Science, Numeracy, History lessons etc.

**1. Collecting Data and make a spreadsheet/table (1 Lesson)**

Teacher Input

Teacher Input

As mentioned above, data could be collected within many subjects but here were are using a Geography/map reading example. You can discuss with the pupils what data is and what we could do with it (put it in a table/bar/pie charts).

**Pupil Activities**

Tour De France MapThe pupils can use a map of the stages of the Tour De France. This one (click to enlarge) has blue as the start of the stage and red as the end. |
Google MapsPupils can take the two locations of a stage and add them into the directions section of Google Maps to find the distance in KM. |
Create a tablePupils create a table in Excel or Numbers as above by resizing the cells so they suit the data. Remind the pupils that for the distances they will only need to put the numbers (not KM) as that will cause problems with our charts and formulae later. |

**2. Write formulae to find totals, averages and**

**minimum/maximum numbers**

**Teacher Input**

You can discuss with the class the word formula how it can be used to create a rule to give us different data. Demonstrate the 3 formulae below.

**Pupil Activities**

Sum (Total)All the distances can be added up using the sum formula. Pupils can add the move formula to a cell below their table and select all the distance cells between the two brackets. Press enter to get the total. |
AverageThe same applies for the average which can be put in another cell. |
Maximum/MinimumFinally the max and min formulae can be found. At the end, the formulae can be checked by changing a distance in one the stages and seeing whether the sum, average and max/min numbers automatically update. |

**3. Present data as a bar/chart/pie chart with correct titles**

**Teacher Input**

You could talk to the pupils about why we have bar, line and pie charts (to make data easier and quicker to understand). Below are some examples of different charts or you could find your own and discuss their features such as labels. Also discuss why you would choose a bar chart over a pie chart and visa versa plus when a line graph is useful (showing change of results over time).

Click to enlarge images and right click to save.

**Pupil Activities**

The pupils can create a bar chart or line chart of the distances by selecting all the distance numbers (not titles) and going to

**insert**and choosing a graph. They can then add a

**title and label axis.**

**Extension**

The pupils can check their work from other subjects such as Science to find data that would be more suitable for pie chart. If not then could put the population of England, Scotland, Wales and Northern Ireland into a table and turn it into a pie chart.

**iPad**

If the pupils are using iPads then the Apple

**Numbers**app will achieve the results mentioned above.