Create a spreadsheet – part 1

Lesson goals:

• Enter data into a spreadsheet
• Understand the concept of rows, columns, and cells
• Create a bar chart
• Create a formula
  

1. Start Appleworks and select Spreadsheets.

2. Put a header in the spreadsheet with your name and today’s date. Select Format and Insert Header.

3. Enter the following data into the spreadsheet, starting with titles in row 1.

Adult animals	Lowest weight	Highest weight
Gray wolf	55	155
Coyote	25	50
Red fox	8	15
Fennec fox	2	4
Dingo	20	40

4. Select Edit and then Select All.

5. Select Options and then Make Chart.

6. Select Bar from Gallery and then OK.

7. Chart should appear in spreadsheet. Move it under your data.

8. Update the Dingo’s lowest weight to 25 and highest weight to 50. See how the chart automatically updates.

9. Add a column, by entering the title “Mean weight” into cell D1.

10. Select cell D2 and type the formula to determine the average weight of the gray wolf. Type exactly the following into the cell:

=(B2+C2)/2

11. Copy the formula from cell D2 to D3.

· Select cell D2 and select Edit & Copy.

· Select cell D3 and then select Edit & Paste Special. Select Paste Values & Formulas then select OK.

12. Repeat step 11 to copy the formula to cells D4, D5 & D6.

13. Update chart to include Mean weight column. Double-click on the chart. Select General. Edit Chart Range - change C6 to D6 and OK.

14. Update the Dingo’s lowest weight to 30 and highest weight to 65. See how cell D6 automatically recalculates and chart updates automatically.