Enquiries to
Lyn Westwood


E.S.T.A.
Employment Skills Training Assistance
Palmerston North

lyn@esta.ac.nz

Online Course Outline


Module 1 – Basic Concepts of IT

Module 2 – Using the Computing and Managing Files
Module 3 – Word-processing
Module 4 – Spreadsheets
Module 5 – Databases
Module 6 – PowerPoint
Module 7 – Information and Communication

 

 

 
Module 1 – Basic Concepts of IT

Lesson One:  Parts of a Computer

  • Lesson Overview
  • Overview of Computers
  • Input Devices
  • Central Processing Unit
  • Output Devices
  • Storage Devices
  • Lesson Summary
  • Lesson Quiz

Lesson Two:  Hardware and Software

  • Lesson Overview
  • Types of Computer Software
  • Types of  Computers
  • Lesson Summary
  • Lesson Quiz

Lesson Three: Information Networks

  • Lesson Overview
  • Computer Networks
  • Emails
  • The Internet and Intranets
  • Network Connections
  • E-Commerce
  • Lesson Summary
  •  Lesson Quiz

Lesson Four: Health and Safety

  • Lesson Overview
  • Health and Safety
  • Lesson Summary
  • ·        Lesson Quiz

Lesson Five: Data Protection

  • Lesson Overview
  • Information Security
  • Legal Aspects
  • Lesson Summary
  • Lesson Quiz

Summary of Module One

back


 

Module 2 – Using the Computing and Managing Files
Lesson One:
Basics of Windows

  • Lesson Overview
  • Getting started with windows
  • Using desktop icons
  • Working with windows
  • Lesson Summary
  • Lesson Quiz

Lesson Two: Using Features of Windows

  • Lesson Overview
  • Desktop Settings
  • Windows Help
  • Lesson Summary
  • ·        Lesson Quiz

Lesson Three: Organising Files

  • Lesson Overview
  • Creating folders
  • Creating and Saving Files
  • Lesson Sumamry
  • Lesson Quiz

Lesson Four: Managing and Printing Files

  • Lesson Overview
  • Moving and Copying files
  • Managing files
  • File Compression
  • Searching Files
  • Printing Files
  • Virus Attacks
  • Lesson Summary
  • Lesson Quiz

Summary of Module Two

back

 


 

Module 3 – Word-processing

Lesson One:  Word Basics

  • Lesson Overview
  • Introduction to Word
  • Editing Text
  • Moving and Copying Text
  • Saving a document
  • Printing a document
  • Lesson Summary
  • Lesson Quiz

Lesson Two:  Additional Features

  • Lesson Overview
  • Using the Find Tool
  • Using the spell checker
  • Using templates
  • Using the help feature
  • Lesson Summary
  • Lesson Quiz

Lesson Three: Formatting Text

  • Lesson Overview
  • Simple Text Formatting
  • Enhancing text layout
  • Modifying text layout
  • Lesson Summary
  • Lesson Quiz

Lesson Four:  Formatting Pages

  • Lesson Overview
  • Adding headers and footers
  • Changing document views
  • Lesson Summary
  • Summary Quiz

Lesson Five:  Working with Tables

  • Lesson Overview
  • Creating a table
  • Formatting a table
  • Lesson Summary
  • Lesson Quiz

Lesson Six:  Working with Objects

  • Lesson Overview
  • Inserting an object
  • Adding a auto shape
  • Moving a object
  • Lesson Summary
  • Lesson Quiz

Lesson Seven: Using Mail Merge

  • ·        Lesson Overview
  • ·        Creating a mailing list
  • ·        Creating a merged mail document
  • ·        Lesson Summary
  • ·        Lesson Quiz

Summary of Module Three

back

 

 


Module 4 - Spreadsheets

Lesson One:  Introducing Workbooks

  • Lesson Overview
  • Creating a workbook
  • Editing a workbook
  • Advanced Editing
  • Arranging Data
  • Saving a Workbook
  • Lesson Summary
  • Lesson Quiz


 

Lesson Two:  Additional Features

  • Lesson Overview
  • Using the find tool
  • Using the spell checker
  • Using the Help Feature
  • Lesson Summary
  • Lesson Quiz

Lesson Three: Customising Worksheets

  • Lesson Overview
  • Modifying Rows/Colum ms
  • Formatting Text
  • Formatting Text Layout
  • Managing Worksheets
  • Lesson Summary
  • Lesson Quiz

Lesson Four: Customising Printing

  • Lesson Overview
  • Modifying a page layout
  • Printing a worksheet
  • Lesson Summary
  • ·        Lesson Quiz

Lesson Five: Working with Formulas

  • Lesson Overview
  • Inserting a formula
  • Specifying a function
  • Lesson Summary
  • Lesson Quiz

Lesson Six: Working with Objects

  • Lesson Overview
  • Importing an object
  • Moving an object
  • Lesson Summary
  • Lesson Quiz

Lesson Seven: Working with Charts

  • Lesson Overview
  • Creating a chart
  • Modifying a chart
  • Lesson Summary
  • Lesson Quiz

Summary of Module Four

back


 

Module 5 – Databases

Lesson One:  Introducing Access

  • Lesson Overview
  • Introducing a database
  • Opening an access database
  • Lesson Summary
  • Lesson Quiz

Lesson Two: Working in Access

  • Lesson Overview
  • Creating an access database
  • Using help in access
  • Lesson Summary
  • Lesson Quiz

Lesson Three:  Working with Tables

  • Lesson Overview
  • Creating a table
  • Modifying a table structure
  • Relationship between tables
  • Lesson Summary
  • Lesson Quiz

Lesson Four:  Managing Data

  • Lesson Over view
  • Working with records
  • Creating an index
  • Lesson Summary
  • Lesson Quiz

Lesson Five:  Using Forms

  • Lesson Overview
  • Creating a form
  • Entering data
  • Lesson Summary
  • Lesson Quiz

Lesson Six:  Modifying the form Layout

  • Lesson Overview
  • Formatting a form
  • Rearranging objects in a form
  • Lesson Summary
  • Lesson Quiz

Lesson Seven:  Working with records

  • Lesson Overview
  • Finding a record
  • Filtering records
  • Lesson Summary
  • Lesson  Quiz

Lesson Eight:  Working with queries

  • Lesson Overview
  • Creating a query
  • Modifying a query
  • Specifying Multiple Criteria
  • Lesson Summary
  • Lesson Quiz

Lesson Nine:  Getting started with reports

  • Lesson Overview
  • Creating a report
  • Printing a report
  • Lesson Summary
  • Lesson Quiz

Lesson Ten:  Enhancing Reports

  • Lesson Overview
  • Modifying a report
  • Grouping data
  • Lesson Summary
  • Lesson Quiz

Summary of Module Five

back

 

Module Six – PowerPoint

Lesson One:  PowerPoint basics

  • Lesson Overview
  • Introduction to PowerPoint
  • Creating a presentation
  • Using the help feature
  • Lesson Summary
  • Lesson Quiz

Lesson Two:  Modifying Presentations

  • Lesson Overview
  • Editing text
  • Formatting text
  • Formatting Slides
  • Lesson Summary
  • Lesson Quiz

Lesson Three:  Working with Images

  • Lesson Overview
  • Inserting an image
  • Moving an image
  • Lesson Summary
  • Lesson Quiz

Lesson Four:  Working with Objects

  • Lesson Overview
  • Inserting a Shape
  • Formatting a Shape
  • Importing an Object
  • Lesson Summary
  • Lesson Quiz

Lesson Five:  Working with Charts

  • Lesson Overview
  • Creating a chart
  • Creating an organizational chart
  • Lesson Summary
  • Lesson Quiz

Lesson Six:  Finalising a Presentation

  • Lesson Overview
  • Arranging Slides
  • Adding Visual Effects
  • Adding Notes
  • Lesson Summary
  • ·        Lesson Quiz

Lesson Seven:  Giving a Presentation

  • Lesson Overview
  • Running a Slideshow
  • Printing a presentation
  • Saving for the Web
  • Lesson Summary
  • Lesson Quiz

Summary of Module Six

back

 

Module Seven – Information and Communication

Lesson One:  Navigating the Web

  • Lesson Overview
  • Using a Web browser
  • Using a hyperlink
  • Lesson Summary
  • Lesson Quiz

Lesson Two:  Searching the Web

  • Lesson Overview
  • Using a Search Engine
  • Saving and Printing Search Results
  • Downloading Files
  • Using Help
  • Lesson Summary
  • Lesson Quiz

Lesson Three:  Using Favorites

  • Lesson Overview
  • Creating Favorites
  • Organising Favorites
  • Lesson Summary
  • Lesson Quiz

Lesson Four:  Customising Web browser

  • Lesson Overview
  • Setting a Start Page
  • Changing display mode
  • Modifying browser  settings
  • Internet Security
  • Lesson Summary
  • Lesson Quiz

Lesson Five:  Outlook Basics

  • Lesson Overview
  • Receiving emails
  • Sending emails
  • Replying and forwarding emails
  • Lesson Summary
  • Lesson Quiz

Lesson Six:  Outlook Tools

  • Lesson Overview
  • Email Signatures
  • Using Help
  • Lesson Summary
  • Lesson Quiz

Lesson Seven: Modifying Emails

  • Lesson Overview
  • Editing emails
  • Checking spelling
  • Lesson Summary
  • Lesson Quiz

Lesson Eight:  Saving and Printing emails

  • Lesson Overview
  • Saving emails
  • Printing emails
  • Lesson Summary
  • Lesson Quiz

Lesson Nine:  Organising Messages

  • Lesson Overview
  • Moving emails
  • Searching for emails
  • Lesson Summary
  • Lesson Quiz

Lesson Ten:  Updating Address Books

  • Lesson Overview
  • Adding an address
  • Creating a distribution list
  • Lesson Summary
  • Lesson Quiz

Summary of Module Seven

back