This tutorial is about how to use the free spreadsheet software Open Office for Kids Calc to create a table of data and a column chart. A chart is made of the colours in a handful of plastic coloured counters commonly found in schools. The main Computing concepts covered in this tutorial are how software can be used to analyse and present data effectively.

Optional challenge activities are:

  • Format the colours of the charts and table cells
  • Insert an additional pie chart
  • Use the sum function to calculate the total of the data

OpenOffice for Kids by EducOOo Education is made available subject to the terms of GNU Lesser General Public License Version 3 http://educoo.org/OOo4Kids.php

Click here to go to the presentation used in this video.