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!
Excel is a spreadsheet tool. A spreadsheet is basically a space where you can record numbers and perform calculations. Today, we will look at some of the most powerful features of a spreadsheet.