Tomorrow, year 4 will be in the ICT suite recording data from our traffic survey last week in Excel.
Here’s a quick beginners guide:
1. Open Excel – click on the green X at the bottom of the screen:
2. Open a new blank workbook. You are now in a blank sheet – use the arrow keys or mouse to move to different boxes, or ‘cells’ as they are known as in Excel.
3. Choose appropriate headings and labels for the data you collected – e.g.
4. Enter your data.
5. Select your data by dragging and dropping and click on the Insert menu, then Chart – see what you can produce!
Years 5 and 6 have been playing the packet game to understand how data flows around the internet here are 6A and 6B showing how data can flow, sometimes smoothly, sometimes not!
Years 3 and 4 have been acting out how to move data around a network. Here are some examples…
For the next couple of weeks, years 5 and 6 will be analysing data. We will be following the data handling process below:
Here are two traffic videos – one shot in the morning…
And one in the afternoon.
What could we find out from these two videos?