Commonwealth Computer Navigator's Certificate/Milestone 4/Pedagogical template/CCNC Module 4 design example

From WikiEducator
Jump to: navigation, search

Module 4 Spreadsheets

Module Overview

Welcome to Module 4 Spreadsheets.

Icon objectives.jpg


By the end of this Module you will have mastered the knowledge and skills to be able to develop, format, modify and use a spreadsheet, which can be useful for a variety of contexts, for example calculating or analysing business data or simply managing personal information more efficiently.

In the process of learning how to work with spreadsheets you will be able to generate and apply standard mathematical and logical formulae and create and format graphs/charts.

Study Tips

Icon preknowledge.gif


Examples include:

  • We recommend you study Modules 1, 2 and 3 before this one, because they provide the essential knowledge for you to work with the spreadsheet functions, including saving files, formatting text and retrieving information from other files

  • We recommend that you spend X amount of time on each chapter
  • It would help you if you have access to some local business data or information you wish to analyse and calculate when attempting the activities in this module.
  • You may find it useful to skim through an entire chapter (or portion of a chapter) first, paying special attention to the headings and introductions then go through a second time for more indepth study and practice
  • We recommend that you do the activities as they appear rather than all at the end. They are essential study materials, so please attempt them.
  • If you have difficulty understanding a section of a chapter, try working at it slowly. If you still do not understand, seek help.

Module Sections

Section 1: Getting to know the Application

Section Overview

CALC is the application we will be using to develop and work with spreadsheets. CALC is one of the applications of the OpenOffice suite.It is similar to Microsoft Excel and you can save your CALC spreadsheets in Excel for sending to Microsoft users. In this section we will become familiar with the basic features of the application and learn how to perform the basic operations that we will rely on later to work with CALC.

Section Objectives

After studying this section you should be able to:

  1. Open and close CALC
  2. Identify the core components of the CALC screen.
  3. Open one and several spreadsheets; close a spreadsheet
  4. Create a new spreadsheet
  5. Save spreadsheets in different locations and under different conditions.
  6. Switch between worksheets in a single spreadsheet.
  7. Use Help functions in CALC
  8. Use tools to adjust settings.

27s_Certificate/Milestone_4/Pedagogical_template/CCNC_Module_4_Section_4.2_design_example Mod 4 Section level design example]

Module References

<List out any references/sources used in creation of the module>

About this Module

Module # <Title>