Tag Archives: data

Recording data in Excel

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!