Create a spreadsheet – part 2

Lesson goals:

• Enter data into a spreadsheet
• Understand the concept of rows, columns, and cells
• Choose an appropriate graph
• Create a spreadsheet from scratch
• 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.

Age	1990	2000
Under 5 years	443,155	461,982
5 to 9 years	424,361	395,084
10 to 14 years	398,531	495,955

4. Select Edit and then Select All.

5. Select Options and then Make Chart.

6. Experiment with different chart types from the Gallery, which type is the best to display this data?

7. Go to the web site U.S. Census Bureau Kids' Corner @ factfinder.census.gov/home/en/kids/kids.html and find the population facts for the state of Virginia. Find out the correct population number for kids age 5 to 9 years in the year 2000 and update your spreadsheet. See how the chart automatically updates.

8. Add a column to calculate the change in population from 1990 to 2000. Use formula =C2-B2.

9. Add this column to your chart by double-clicking on the chart. Select General. Edit Chart Range - change D3 to D4 and OK.

10. Save your work on your memory stick.

11. Create a new spreadsheet.

12.Use the U.S. Census Bureau Kids' Corner to create a spreadsheet that compares the population trends from 5 different states for the 10-14 year category between 1990 & 2000. Remember to provide a title row.

13. Create a chart from this data. Which chart type is the best to display this data?

14. Add a column to calculate the increase or decreases in population between the 2000 and 1990 numbers. Create a formula that will calculate this for you.

15. Add this column to your chart.

16. Save your work on your memory stick.