An introduction to Spreadsheets Using OpenOffice


  1. If you do not have OpenOffice, download it for free from OpenOffice.org
  2. To learn to create and use spreadsheets, view and listen to each of the tutorials below. Let Mrs. Carrier see your work after Tutorial 5 and 8..
  3. After completing the tutorials complete the Art of Budgeting Assignment.
  4. Next complete the Assignments - Planets.
  5. View Statistics on TED


View and listen to the OpenOffice Spreadsheet Tutorials: Open an OpenOffice Spreadsheet on your computer. Follow along with the instructions.

1. Enter Data



2. Edit Data




3. Format Numbers



4. Cells, Formatting, Formulas




5. Formatting, Graphs & Charts, Column Widths

  • You need a spreadsheet with data to crate the chart. Enter the following information on a spreadsheet with the words Week 1 in cell C3.
  • You can copy the data below and paste in a spreadsheet to get it started.
  • Note that my numbers below do not exactly match those on the tutorial, but they are close enough to use for the graph.
  • The title is Takings for the Week. The X axis is Weeks and the Y axis is Value in Dollars.
  • Show the completed graph to Mrs. Carrier.

Week 1
Week 2
Week 3
Week 4
Monday
12.80
17.30
11.36
14.97
Tuesday
14.80
18.80
17.48
17.17
Wednesday
6.80
14.76
12.56
12.23
Thursday
3.40
7.48
5.23
5.08
Friday
58.90
61.90
29.00
10.47



6. Sorting Data




7. AutoSum Formula





8. Entering Formulas - (Note: He messes up the first formula but then gets it right!)

  • Show the completed work to Mrs. Carrier




After completing the Tutorials above, complete each of the assignments below.

  1. Assignments - Planets.

  2. Art of Budgeting Assignment