Basic Computer Skills Course

Overview

The course targets learners working towards a qualification or are working within a computer and information technology environment, where acquisition of competence against the computer skills will add value to their job. The course covers word and excel skills.

The qualifying learner will be capable of:

Training Outcomes

  • The explanation of the purpose of basic computer system elements is correct and demonstrates an awareness of the latest technology in use.

  • Knowledge of computer hardware must be demonstrated that is consistent with the latest developments.

  • The analysis and definition of electronic data interchange are consistent with the latest developments in electronic data interchange and corporate information technology systems.

  • Microsoft Windows is identified and used.

  • Information within a window is correctly resized and moved.

  • Menus and dialogue boxes are correctly used.

  • The help function is correctly used.

  • My Computer function is correctly used.

  • Windows Explorer function correctly used.

  • A document is created and saved on a storage device.

  • Text is manipulated within a document.

  • Borders and shading are correctly applied to a document.

  • Bullets and numbering are applied to paragraphs.

  • Graphics are inserted into a document.

  • A document is formatted and printed.

  • Grammar and spelling are checked and corrected in a document.

  • Importing and exporting text files.

  • Consolidating and linking data within spreadsheets.

  • Applying filters and use forms in a spreadsheet.

  • Creating and using macros.

  • Combining and comparing large sets of data in a spreadsheet.

  • The explanation of the purpose and functions of workbooks and worksheets is consistent with organisational requirements for numerical and financial management information and reports.

  • Different workbooks, worksheets and cells are accessed and used concurrently.

  • Worksheets are named saved and retrieved correctly.

  • The correct basic formulas are applied for the manipulation of data within a worksheet.

  • Data is edited within a worksheet correctly.

  • Worksheet information is enhanced correctly.

  • Basic financial worksheets are developed which are applicable to the transportation environment and are consistent with organisational requirements and expectations.

  • A number of documents are opened, in order to switch control between them.

  • Documents are sized so that at least two documents can be seen at the same time.

  • Text is manipulated between active documents.

  • A border is applied to text and removed from text to enhance the look and feel of a document.

  • Shading is applied to text and removed from the text.

  • Shading also refers to a filling.

  • The current date and time are added.

  • The use of an automatic field added capability of the word processor is demonstrated, in terms of its purpose and use to speed up typing of words and sentences.

  • Date, time, document information.

  • Special characters and symbols are inserted into an existing word processing document.

  • Hyphenation is activated and applied to an existing word processing document.

  • At least one of the following: Automatic, soft, optional.

  • Special effects are applied to text in an existing word processing document.

  • Animation, text border.

  • Character Spacing is changed in an existing word processing document.

  • Tabs are set, reset and removed from an existing word processing document.

  • The default tab setting is changed in an existing word processing document.

  • Bullets are applied to and removed from an existing word processing document.

  • Bullet formats are changed within an existing word processing document.

  • The difference between numbered text and outline numbered text is explained in terms of their use in an existing word processing document.

  • Numbering is applied to and removed from selected text in an existing word processing document.

  • Numbering formats are changed within an existing paragraph.

  • A border is applied to and removed from an existing word processing document.

  • Paragraph spacing is changed in an existing word processing document.

  • The page format of a document is changed according to the given specifications.

  • Manual Page breaks are inserted into an existing word processing document.

  • Page breaks are deleted from an existing word processing document.

  • A border is applied to and removed from an existing word processing document.

  • Methods of automatically formatting a document are explained.

  • A header is added to and removed from a document.

  • A footer is added to and removed from a document.

  • Page numbers are added to a document.

  • A document is split into sections according to given specifications.

  • Endnotes and footnotes are inserted into a document.

  • A document is created using an existing template.

  • A document is saved as a new template with a specific name and in a specific folder.

  • A created template is used to have pre-defined default options when starting a new word processing document.

  • The spreadsheet is defined in terms of its purpose and use.

  • Examples of spreadsheets that can be produced using a spreadsheet application are provided.

  • The benefits of using a spreadsheet application for producing and working with spreadsheets are explained.

  • Examples of spreadsheet programs are named.

  • Properties of a spreadsheet are identified and described in terms of its purpose and use.

  • The spreadsheet application program is opened.

  • A new spreadsheet is created.

  • Methods of moving the cell cursor are demonstrated in order to move about the spreadsheet.

  • Saving spreadsheets is explained in terms of their purpose and the destination of the saved file.

  • The spreadsheet is saved with a specific name in a specific folder.

  • The spreadsheet is closed.

  • An existing spreadsheet is opened and closed.

  • The spreadsheet application program is closed.

  • A spreadsheet is produced with the required data from the given specification. Types of data include text, numbers, and dates.

  • A formula is entered to achieve the given specification. Types of formulae that will be assessed include addition, subtraction, division, multiplication, and sum.

  • The differences between data cells, label cells, and formula cells are explained.

  • The spreadsheet is in accordance with the given specifications.

  • Practices are demonstrated to ensure the integrity of the data.

  • The benefits of saving a file in different formats are explained. Formats include text, CSV, HTML, other software versions, other software types.

  • A spreadsheet is saved in a different format.

  • An existing spreadsheet is opened.

  • Cells are selected for manipulation and de-selected. This includes selecting a single cell, cell range, an entire column, an entire row and an entire spreadsheet.

  • Cells are manipulated.

  • Use the automatic fill feature to automatically enter data in cells.

  • Text is located and replaced in a spreadsheet by using features of the application.

  • Cells are formatted using the formatting features of the spreadsheet application. Formatting features include the following: Style, Alignment, Font, Background colour, at least one option listed out of each formatting feature must be performed: Style (Text, number, date, currency, percentage), Alignment (left, centre, right, justified, text direction), Font (type, size, style – italic, bold, underlined, colour, strikethrough, superscript, subscript), Background colour.

  • Rows are formatted. Formatting features include height and automatic fit.

  • Columns are formatted. Formatting features include the width and automatic fit.

  • The dictionary to be used for spelling and word usage is set up.

  • Text is entered and corrected automatically while entering.

  • Text is checked for spelling and grammar and corrections made based on judgement.

  • Words are added to the custom dictionary.

  • The printing of gridlines is altered.

  • A row is selected to print on each page of the printed spreadsheet.

  • Different ways of printing sheets within a spreadsheet are demonstrated, according to given specifications.

Add These Skills To Your Skill Set