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 Go to Module 5 : Database Management using OpenOffice 2.0 Base

Metapages

• Issue tracker
• Style guide

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. Outcomes 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. Preknowledge 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 Section 4.1 - Getting to know the application Section 4.2 - Working with and in cells Section 4.3 - Managing Worksheets Section 4.4 - Working with Formulas and Functions Section 4.5 - Formatting cells Section 4.6 - Creating charts and graphs Section 4.7 - Preparing the spreadsheet for distribution 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 Module 4: Spreadsheets Attribution: OpenICDL Module 4 (Spreadsheets) Author: Olabisi Kuboni, UWI Distance Educatiion Centre Based on Open Office Version 3.0 Created under a Creative Commons Attribution Share-Alike license