Commonwealth Computer Navigator's Certificate/Milestone 3/Curriculum mapping/Module 4 mapping

Module 4: mapping

Use the ECDL syllabus V4.0 document for the detailed explanation of the knowledge requirements for each knowledge area listed below. The mapping information below is taken directly from ECDL Syllabus Version 4.0.

Under each syllabus item please list and create links to the materials within the Open ICDL content or indicate if there is a 'gap'.

Module 4 Spreadsheets requires the candidate to understand the concept of spreadsheets and to demonstrate the ability to use a spreadsheet application on a computer. The candidate shall understand and be able to accomplish tasks associated with developing, formatting, modifying and using a spreadsheet8 of limited scope ready for distribution. He or she shall also be able to generate and apply standard mathematical and logical formulas using standard formulas and functions. The candidate shall demonstrate competence in creating and formatting graphs/charts.

4.1 Using the Application

• 4.1.1 First Steps with Spreadsheets
  • Location:
• 4.1.2 Adjust Settings
  • Location: THE MATERIALS REVIEWED MAP EXACTLY ON TO THE ECDL SYLLABUS; ALL CONTENT DEVELOPED ARE BASED ON THE ECDL SYLLABUS ITEMS

4.2 Cells

• 4.2.1 Insert Data
  • Location:
• 4.2.2 Select Cells
  • Location:
• 4.2.3 Rows and Columns
  • Location:
• 4.2.4 Edit Data
  • Location:
• 4.2.5 Duplicate, Move, Delete
  • Location:
• 4.2.6 Search and Replace
  • Location:
• 4.2.7 Sort Data
  • Location:

4.3 Worksheets

• 4.3.1 Handling Worksheets
  • Location:

4.4 Formulas and Functions

• 4.4.1 Arithmetic Formulas
  • Location:
• 4.4.2 Cell Referencing
  • Location:
• 4.4.3 Working with Functions
  • Location:

4.5 Formatting

• 4.5.1 Numbers/Dates
  • Location:
• 4.5.2 Contents
  • Location:
• 4.5.3 Alignment, Border Effects
  • Location:

4.6 Charts/ Graphs

• 4.6.1 Using Charts/Graphs
  • Location:
• 4.7.1 Worksheet Setup
  • Location:
• 4.7.2 Preparation
  • Location:
• 4.7.3 Printing
  • Location: