Commonwealth Computer Navigator's Certificate
|Module 4 : Spreadhseets using OpenOffice 3.0|
Back to Module 3 :
Word Processing using OpenOffice 3.0 Writer
Getting to know the application |
Working with and in cells |
Managing Worksheets |
Working with Formulas and Functions |
Formatting cells |
Creating charts and graphs |
Preparing the spreadsheet for distribution
Module 4: Spreadsheets using OpenOffice 3.0
In this module you will learn how to develop, work with and manipulate spreadsheets using the computer application OpenOffice Calc.
At its core, a spreadsheet is a table of rows and columns, creating a grid of cells in which numeric or text values are displayed. In most situations, spreadsheets are used for manipulating numeric data. The spreadsheet computer application is designed to enable you to model and observe the relationships among data in the respective rows and columns. Spreadsheets can be useful in a variety of contexts, e.g., to analyse business data, to track personal finances, or to create charts for visual interpretation of data.
You may find it useful to skim through an entire block of content first, paying special attention to the headings and introductions, then go through a second time for more in-depth study and practice.
However, we recommend that you do the activities as they appear. They are essential study materials, offering practice in particular skills that will build your proficiency in using spreadsheets.
Keep linking the new content that you are studying with content in this module that you have already covered and with your own general knowledge, to deepen your understanding of the operations you are learning.
If you have difficulty understanding any area, try working at it slowly. If you still do not understand, seek help.
Home and Learn. Free Computer Tutorials - Microsoft Excel Tutorials  accessed 2007-12-09.
OpenLearn Learning Space. Working with charts, graphs and tables  accessed 2007-12-15.
Tutorials for OpenOffice. Calc (Spreadsheet) Tutorials  accessed 2009-04-02.
About this Module