Abbotskerswell Primary School Logo

Abbotskerswell Primary School

Slade Lane,  Abbotskerswell, Newton Abbot,  Devon,  TQ12 5NS

Telephone

(01626) 353605

@

Facebook Twitter Flickr Vimeo

Computing | Data Handling

In this unit of work, each class will find out how to present data using different websites or software. The following information gives you a main overview of what each class will learn. Each class may also have other activities to complete. These activities and any websites mentioned below can be accessed by the children from their own class pupil pages.  

Back | Computing Curriculum Abbotskerswell Primary School

Puffin Class | Reception

Puffin Logo Left

Links to the Early Years Foundation Stage Curriculum:

40 – 60+ Months: Completes a simple program on a computer.  

40 – 60+ Months: Interacts with age-appropriate computer software. 

Early Learning Goals: They select and use technology for particular purposes.

Puffins will explore creating pictograms by using the Just2Easy website.

Just2Easy Pictograms

They will use the website to:

  • Select a theme for their pictogram from the templates.

  • Ask a relevant question to their friends, for example, "What is your favourite fruit?".

  • Input the answers they collected by using the + and - icons.

  • Discuss what they have found out.

  • Select the 'new' icon to start another pictogram.

Visit | Just2Easy

Robin Class | Year 1 & Year 2

Robin Logo - Left Facing

Links to the Computing Key Stage 1 National Curriculum:

  • Use technology purposefully to create and organise digital content.

Robins will create pictograms by using the Just2Easy website.

Just2Easy Own Pictograms

They will use the website to:

  • Create a pictogram using the 'blank' template.

  • Select a theme for their pictogram from the 10 different picture categories or colour options.

  • Drag the pictures/colours to the blue shapes at the bottom of the blank template to show the options for their pictogram.

  • Add or remove more columns if needed by using the + and - icons to the right of the blank template.

  • Ask a relevant question to their friends, for example, "How did you travel to school this morning?".

  • Input the answers they collected by using the + and - icons.

  • Enter a title for their pictogram.

  • Label the options at the bottom of their pictogram on the x-axis.

  • Discuss what they have found out and record a verbal response using the microphone option next to the heading.

Visit | Just2Easy

Robins will enter data into a simple table which will automatically create a block chart. They will use the Just2Easy website.

Just2Easy Block Charts & Tables

They will use the website to present data that they have already collected by:

  • Typing headings for the columns of the table.

  • Adding the options/items they used under the first column.

  • Entering the numerical data they collected in the correct rows of the table.

  • Pressing the 'enter' key to move the cursor to the cell below when entering data into the table.

  • Selecting the colours to represent each row of data for the block chart.

  • Hiding or showing the gridlines of the block chart by clicking on it.

  • Entering a title for their block chart.

  • Discussing what they have found out and record a verbal response using the microphone option next to the heading.

Visit | Just2Easy

Please note: Some websites may work better or look different in the various internet browsers (e.g. Internet Explorer, Microsoft Edge, Google Chrome). Some of the websites may not work on tablets either. Some features may not work as we only use the free features of the websites.

Visit | Pupil Pages

Swift Class | Year 3 & Year 4

Links to the Computing Key Stage 2 National Curriculum:

  • Select, use and combine a variety of software (including internet services) on a range of digital devices to design and create a range of content that accomplish given goals, including collecting, analysing, evaluating and presenting data and information.

Swift will create bar charts by using the Just2Easy website.

Swift Logo Left Just2Easy Block Charts & Tables

They will use the website to present data that they have already collected by:

  • Typing headings for the columns of the table.

  • Adding the options/items they used under the first column.

  • Entering the numerical data they collected in the correct rows of the table.

  • Pressing the 'enter' key to move the cursor to the cell below when entering data into the table.

  • Selecting the colours to represent each row of data for the bar chart.

  • Choosing the bar chart option to the left of the table.

  • Hiding/showing the gridlines of the bar chart by clicking on it.

  • Entering a title for their bar chart.

  • Discussing what they have found out and record a verbal response using the microphone option next to the heading.

  • Using the 'snipping tool' or 'print screen' button to copy their bar chart and pasting it into Microsoft Word to analyse their data.

Visit | Just2Easy

Swift will collect data from a website. They will use the UK Safari website as an example.

UK Safari

They will use the website to:

  • Pose a relevant question, for example, "Which habitats do the different birds live in?".

  • Collect the data from the website in the form of a tally chart.

  • The options for the tally chart will grow as they research more information from the website.

Visit | UK Safari

Swift will create a table and a bar chart using Microsoft Excel.

Microsoft Excel - Bar Chart

They will use this software to present the data they collected from the UK Safari website to:

  • Create a table by typing the headings in cells A1 and B1.

  • Resize the columns to fit the text in the cells.

  • Enter the categories in each row of the A column.

  • Enter the numerical data in the relevant cells in the B column.

  • Highlight the table and use the borders tool to add gridlines.

  • Highlight the table (except the headings) and insert a bar chart by selecting the correct tool.

  • Edit the chart title.

  • Label the axes by clicking on the chart and selecting the option from the green plus sign.

  • Resize the chart using the circles around the edge.

  • Copy the table and chart and paste them into Microsoft Word to analyse their data.

 

If you do not have the software at home, some of the features can be used for free online:

Visit | Microsoft Online

Swift will create a table and a time/line chart using Microsoft Excel.

Microsoft Excel - Time Or Line Chart

They will use this software to present continuous data that they have either been given or have already collected to:

  • Create a table by typing the headings in cells A1 and B1.

  • Resize the columns to fit the text in the cells.

  • Enter the categories in each row of the A column.

  • Enter the numerical data in the relevant cells in the B column.

  • Highlight the table and use the borders tool to add gridlines.

  • Highlight the entire table and insert a time/line chart by selecting the correct tool.

  • Edit the chart title.

  • Label the axes by clicking on the chart and selecting the option from the green plus sign.

  • Resize the chart using the circles around the edge.

  • Copy the table and chart and paste them into Microsoft Word to analyse their data.

 

If you do not have the software at home, some of the features can be used for free online:

Visit | Microsoft Online

Kingfisher Class | Year 5 & Year 6

Links to the Computing Key Stage 2 National Curriculum:

  • Select, use and combine a variety of software (including internet services) on a range of digital devices to design and create a range of content that accomplish given goals, including collecting, analysing, evaluating and presenting data and information.

Kingfishers will create a table and a pie chart using Microsoft Excel.

Kingfisher Logo Left Microsoft Excel - Pie Chart

They will use this software to present previously collected data by:

  • Creating a table by typing the headings in cells A1 and B1.

  • Resizing the columns to fit the text in the cells.

  • Entering the categories in each row of the A column.

  • Entering the numerical data in the relevant cells in the B column.

  • Highlighting the table and use the borders tool to add gridlines.

  • Highlighting the entire table and insert a pie chart by selecting the correct tool.

  • Editing the chart title.

  • Displaying the percentages and labels by selecting the option from the green plus sign.

  • Resizing the pie chart using the circles around the edge.

  • Copying the table and pie chart and pasting them into Microsoft Word to analyse their data.

 

If you do not have the software at home, some of the features can be used for free online:

Visit | Microsoft Online

Kingfishers will collect continuous data from a website. They will use the Met Office website as an example.

They will use the website to research the maximum and minimum temperatures of a particular area of the United Kingdom by:

  • Clicking on a red dot on the map of the United Kingdom for their chosen location.

  • Selecting the 'Averages table' tab.

  • Collecting the data they need to input into Microsoft Excel.

Met Office Visit | Met Office

Kingfishers will create a table and a time/line chart with 2 variables using Microsoft Excel.

Microsoft Excel - Time Or Line Chart - 2 Variables

They will use this software to present the continuous data that they collected from the Met Office website to:

  • Create a table by typing the headings in cells A1, B1 and C1.

  • Resize the columns to fit the text in the cells.

  • Enter the month 'January' into cell B1, select that cell and drag the 'fill handle' (small square) down the column to automatically fill the rest of the months.

  • Enter the numerical data in the relevant cells in the B and C columns.

  • Highlight the table and use the borders tool to add gridlines.

  • Highlight the entire table and insert a time/line chart by selecting the correct tool.

  • Edit the chart title.

  • Label the axes by clicking on the chart and selecting the option from the green plus sign.

  • Move the position of the x axis by selecting the following options from the green plus sign: axes - more options - label position - low.

  • Resize the chart using the circles around the edge.

  • Copy the table and chart and paste them into Microsoft Word to analyse their data.

 

If you do not have the software at home, some of the features can be used for free online:

Visit | Microsoft Online

Kingfishers will use formulas to interpret their data using Microsoft Excel.

Microsoft Excel - Formulas

They will use this software to interpret the data that they have previously collected from the Met Office website and have already presented in a table by:

  • Highlighting a column of data and using the 'AutoSum' feature to find the total, average, maximum and minimum values.

  • Typing the formulas themselves by selecting a blank cell and entering the relevant formula in the formula bar: =SUM(C2:C13), =AVERAGE(C2:C13), =MAX(C2:C13) and =MIN(C2:C13).

 

If you do not have the software at home, some of the features can be used for free online:

Visit | Microsoft Online

Kingfishers will use the skills they have learnt using Mircosoft Excel to present and interpret data from the Tour De France website.

Tour De France

They will use this software and website to:

  • Create their own table of data.

  • Present their data in an appropriate graph.

  • Use the formulas to interpret their data.

  • Use a new formula to convert the data from kilometres to metres: =CONVERT(number,"m","mi"). The children need to replace number with the actual numerical value.

 

If you do not have the software at home, some of the features can be used for free online:

Visit | Microsoft Online Visit | Tour De France