Commonwealth Computer Navigator's Certificate

From WikiEducator
Jump to: navigation, search

Tutorial.png 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

Go to Module 5 :
Database Management using OpenOffice 2.0 Base


Module 4: Spreadsheets using OpenOffice 3.0

Screenshot of first spreadsheet application, Visicalc, running on an Apple II computer

Module Overview

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.

Icon objectives.jpg


Upon completion of this module a learner will be able to...
  • Develop, format, modify and use a spreadsheet
  • Generate and apply standard formulae
  • Create and format graphs/charts

Study Tips

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.

Icon preknowledge.gif


Before beginning this module, we recommend that a learner be
  • Skilled in arithmetic computation: addition, subtraction, multiplication, division, computation with decimal numbers, computation of percents.
  • Skilled at estimating the results of simple calculations, so when entering formula the results can be mentally checked.
  • Logical thinkers, that is, capable of following a series of calculations from one step to the next.

While there is no required sequence to the ordering of the modules, we recommend completing the modules on Computer Applications (Modules 1 and 2) and Wordprocessing (Module 3) before beginning this one.

Module Sections

Module References

Home and Learn. Free Computer Tutorials - Microsoft Excel Tutorials [1] accessed 2007-12-09.

OpenLearn Learning Space. Working with charts, graphs and tables [2] accessed 2007-12-15.

Tutorials for OpenOffice. Calc (Spreadsheet) Tutorials [3] accessed 2009-04-02.

About this Module