CCNC/CCNC Module 4

{| id="mp-upper" style="margin:5px 0px 0px 0px; background:none;"
 * class="MainPageBG" style="width:5%; border:10px solid #FBEBF5; -moz-border-radius: 8px;background:#f5fffa; vertical-align:top; color:#000;" |

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.



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.

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 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

 * 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