Course Modules:

• Spread Sheet Methods

• Word Processing 2

• Database Methods 2

Module Criteria:

Spread Sheet Methods:

1. Operating Environment

       Equipment
       Media
       Operating System
       Commands
       File Handling
       Data Security

2. Spreadsheet Software, Concepts & Definitions

       Spreadsheet Concepts 
       Data Types
       Arithmetic Operators and Formulae
       Functions

3. Creating Simple Spreadsheets

       Spreadsheet Layout
       Character Data
       Numeric Data
       Formulae
       Functions

4. Editing Spreadsheets

       Structure
       Format
       Spreadsheet Blocks
       Erasing Data
       Moving and Copying Data
       Amending and Replacing Data 
      Calculation

5. Saving, Retrieving and Printing

       Saving Data
       Retrieving
       Printed Output

Word Processing 2:

1. Microcomputer Operation and Operating Environment

       Equipment and Media
       Operating Environment
      Copy and Delete User Data Files
       Make Backup Copies
       Word Processor Environment
       Data Security

2. Creating Documents

       Document Formatting 
       Set Page Length and Size
       Indentation and Tabulation
       Text Entry - Speed Test
       Text Enhancement 
       Document Layout
       Produce Business Letters using Templates

3. Editing Documents

       Proof-reading and Editing
       Use British Standard Proof Reading Symbols
       Correct Errors on Document
       Document Navigation
       Text Deletion and Insertion
       Select, Delete and Copy Text 

4. Saving, Retrieving and Printing

       Saving Data
       Save Documents using Different Formats
       Retrieving
       Preview and Amend Document Prior to Printing
       Load Printer Paper
       Printed Output 

Database Methods 2:

1. Microcomputer Operation and Operating Environment

       Equipment and Consumables
       Operating Environment
       Data Security

2. Database Concepts

       Defining a Database 
       Identify Database Structure
       Identify Data Types

3. Creating and Editing a Database

       Defining Database Structure
       Create a Database File
       Add Records to a Database
       Retrieve an existing Database
       Display and Edit Fields in a Record
       Delete and Modify Database Structure

4. Searching and Sorting a Database

       Search Definition
       Relational Operator
       Single Condition Searches
       Define and Execute Searches for All Data Types

5. Sort Definition and Sort Criterion

       Identify Different Types of Sort
       Define Sort Criterion for all Data Types
       Sort the Records in a File

6. Saving and Printing

       Save a Database File
       Print all Records in a Database File
       Print Sorted Lists
       Print all Records for a given Criterion