Microsoft Office Word,Excel,PowerPoint,Access,Outlook

Word
~This unit standard is intended for people who need to create and edit simple databases using a Graphical User Interface (GUI)-based database application either as a user of computers or as basic knowledge for a career needing this competency, like the ICT industry.

~People credited with this unit standard are able to:
-Understand the principles of databases.
-Open and save a simple existing database.
-Produce and edit a simple database from given specifications.
-Data is entered into a simple database table from given specifications.
-Modify the design of a database table.
-Sort and search for records in a database table.

-The performance of all elements is to a standard that allows for further learning in this area.
-This standard is applicable to any database application that operates in a Graphical User Interface (GUI)-based environment.
-This standard is restricted to database applications that run on personal computers, or small computer platforms, rather than mainframe or large computer systems. The database table are physically inside the same computer file (flat file) and does not contain references to tables outside the physical file.
-Where wording are not exact for the chosen operating system, the learner can choose the equivalent item or option to demonstrate competence in the specific outcome or assessment criteria.

~Understand the principles of databases.
-A database management system is defined in terms of its purpose and use.
-Examples of uses of databases are provided.
-At least three examples.
-Properties of databases are described in terms of their purpose and relation to the database as a whole.
-Field, Record, Table, Index, Field Property, Data type.
-Open and save a simple existing databases.
-The database application is opened or started.
-The parts of the database application window are described in terms of their features and use.
-All of: Menu Bar, Toolbar, Status Bar, scroll bar, Object Bar.
-An existing database is opened.
-Data is entered into an existing database table.
-At least 5 records are entered.
-Saving a database giving it a descriptive name related to its purpose and use.
-The database is closed.
-The database application program is closed.

Excel
~ This unit standard is intended for people who need to plan, produce, use and spreadsheets to solve problems using a Graphical User Interface (GUI)-based spreadsheet application either as a user of computers or as basic knowledge for a career needing this competency, like the ICT industry.

~People credited with this unit standard are able to:
~Prepare and produce a spreadsheet to provide a solution to a given problem.
~Adjust settings to customise the view and preferences of the spreadsheet application.
~Work with multiple worksheets.
~Apply formulae to worksheets to provide alternative solutions to a problem.
~Apply simple built-in functions of the spreadsheet application to the given problem.
~Apply formatting to a spreadsheet applicable to the given problem.
~Use special effects to improve the presentation of the spreadsheet.
~Evaluate a spreadsheet.
~The performance of all elements is to a standard that allows for further learning in this area.
~This standard is applicable to any spreadsheet application that runs on any Graphical User ~Interface(GUI) operating system:
~Where wording are not exact for the chosen operating system, the learner can choose the equivalent item or option to demonstrate competence in the specific outcome or assessment criteria.
~Prepare and produce a spreadsheet to provide a solution to a given problem.
~An outline solution is developed to meet the requirements of a given brief.
~The spreadsheet produced addresses the given problem.
~Adjust settings to customise the view and preferences of the spreadsheet application to suite the solution created for the given problem.
~Toolbar menus are switched off and on.
~The view of the spreadsheet is enlarged and made smaller.
~The way that the spreadsheet is viewed is changed.
~Cells are frozen to prevent scrolling.
~Row, column, both.
~The default file location is changed.
~A user name is added to the file.
PowerPoint
This unit standard is intended for people who need to enhance presentation appearance using a Graphical User Interface (GUI)-based presentation application either as a user of computers or as basic knowledge for a career needing this competency, like the ICT industry.

People credited with this unit standard are able to:
Create a graph in a presentation.
Create an organisational chart in a presentation.
Create a drawing in a presentation.
Import images into a presentation.
Images and objects are manipulated in presentation.
Animation effects and transitions are applied or added to a presentation.
Master Slides are customised within a presentation.

The performance of all elements is to a standard that allows for further learning in this area.
The credit value of this unit standard is calculated assuming a person is competent in:
Use generic functions in a Graphical User Interface (GUI)-environment.
Use a Graphical User Interface (GUI)-based presentation application to create and edit slide presentations.
Use a Graphical User Interface (GUI)-based presentation application to prepare and produce a presentation according to a given brief

This standard is applicable to any presentation application that runs on any Graphical User Interface (GUI) operating system.
Where wording are not exact for the chosen operating system, the learner can choose the equivalent item or option to demonstrate competence in the specific outcome or assessment criteria.
Appearance enhancement is done by the use of chart graphs, drawn objects, images, objects. Create a graph in a presentation.
Graph refers to all types of graphs and/or charts.
A new graph is created to represent given data.
Graph colours are changed to enhance appearance.
Graph area, data series.
The graph type is changed to improve usability, according to given specifications.
Graphs are resized to improve usability, according to given specifications.
Create an organisational chart in a presentation.
A new organisational chart is created to present specific given organisational information.
Minimum of three levels and hierarchical elements.
The hierarchical structure of an organisational chart is changed to enhance usability.
Hierarchical elements are added and removed according to given specifications.
subordinate, co-worker, manager.
Create a drawing in a presentation.
Lines are drawn into a presentation and their attributes changed.
Lines include: Straight line, arrow line, curve line, free-form line.
Attributes include: Style, arrow start and finish, colour, width.
Shapes are drawn into a presentation.
At least two of: Box, circle, autoshape.
The orientation of a drawing is changed according to given specifications.
The attributes of a shape are changed.
Any three of: line colour, fill colour, 3-D.
Drawings are resized to improve the layout of the related presentation.

Access

~This unit standard is intended for people who need to enhance document appearance using a GUI-based word processor either as a user of computers or as basic knowledge for a career needing this competency, like the ICT industry.
-People credited with this unit standard are able to:
-Create and edit a table.
-Format a table according to given requirements.
-Create and edit columns in a document.
-Format columns in a document.
-The performance of all elements is to a standard that allows for further learning in this area.
-The credit value of this unit standard is calculated assuming a person is competent in:
-Mathematical literacy and communication skills at least at NQF Level 2.
-Use generic functions in a Graphical User Interface (GUI)-environment.
-Use a Graphical User Interface (GUI)-based word processor to format documents.
-This standard is applicable to any word processor application that runs on any Graphical User
-Interface(GUI) operating system.
-Where wording are not exact for the chosen operating system, the learner can choose the equivalent item or option to demonstrate competence in the specific outcome or assessment criteria.
-Create and edit a table.
-A table is created.
-Table to have at least 4 columns and 4 rows, andat least two of the following methods of creating a table are demonstrated: Insert Table on Standard Toolbar, Insert/Draw Table from Table Menu, Convert Text to
-Table from Table Menu.
-Data is entered into the table.
-Text is selected in the table.
-A word, a sentence, a Cell, a Row, a Column, the Entire Table.
-Text is deleted from a table.
-Text to be deleted includes:
-In a single cell, in an entire row, in an entire column.
- Table cells are inserted and deleted.
-A single cell, a whole column, a whole row.
-Text is copied from one cell range to another.
-A cell, a column, a row.
-Text is moved from one cell range to another.
-A cell, a column, a row.

Outlook

-This unit standard is intended for people who need to use electronic mail to send and receive messages either as a user of computers or as basic knowledge for a career in the ICT industry.
-People credited with this unit standard are able to:
-Understand the concepts and terms of electronic messaging.
-Create and send an E-mail message.
-Receive and respond to e-mails.
-Work with multiple E-mail messages.
-Adjust settings to customise the view and preferences of the E-mail application.
-The performance of all elements is to a standard that allows for further learning in this area.
-The credit value of this unit standard is calculated assuming a person is competent in the following:
-Mathematical literacy and communication skills at least at NQF Level 1.
-Operate a personal computer system.
-Use generic functions in a Graphical User Interface (GUI)-environment.
-This standard is applicable to any messaging application that runs on any Graphical User Interface(GUI) operating system.
-Where wording are not exact for the chosen operating system, the learner can choose the equivalent item or option to demonstrate competence in the specific outcome or assessment criteria.
-Understand the concepts and terms of electronic messaging.
-The structure of an email address is explained using an example.
-Aspects of E-Mail Etiquette are described with examples.
-Aspects: content, subject line, privacy, confidentiality, viruses.
-The benefits of using Email are explained within a specific context.
-May include but is not limited to - speed, cost, time, time zones, portability.
-The limitations of using the Internet are explained with examples.
-May include but is not limited to - viruses, security, inappropriate use of Email, attachments.
-Create and send an E-mail message.
-When creating new E-mails, the message header/subject line of the new E-mail must allow the E-mail to be easily identified in terms of its purpose and content.
-The electronic mail application is opened in order to prepare for working with E-mail messages, and closed once finished working with E-mail messages.
-The message is addressed to the required recipients.
-Single and multiple recipients; addressee and CC.
-The message header (subject) is consistent with the message purpose, and target audience.
-Message test is manipulated and checked for spelling mistakes prior to sending.

Contact Details

Contact Person: 

Anil Salick
Course Details

Unit Standard: 

116936;116940;116930;119078;116945

NQF Level: 

Level 2
Level 3

Credits: 

15

Course Delivery Method: 

Blended Blended

In Class In Class

In House In-House

Course Duration: 

5 days

Cost: 

R 1100.00 per course vat (excluded)

Course fee Includes: 

Course Materials, POE,Certification, Lunch, Teas& Coffees