cesa logo

Commercial Education Society of Australia

SYLLABUS FOR STUDENT-GRADE EXAMINATIONS IN
OFFICE COMPUTING

Issued 2011

The Society offers assessment in the following areas:

Assessment for all office computing examinations will be by practical exercises, problem solving, short-answer questions, and a skills and techniques checklist completed by a supervisor, and may include portfolios. Papers will be marked Credit, Pass or Fail except for Word Processing 4 which will be marked Distinction, Credit, Pass or Fail.

SKILLS AND TECHNIQUES CHECKLIST (THIRD PARTY REPORT)

Please refer to Syllabuses for Student-Grade Examinations in Occupational Health and Safety regarding the Skills and Techniques Checklist (Third Party Report).

The Skills and Techniques Checklist incorporates —

The Skills and Techniques Checklist is part of all examination papers where candidates are required to operate a computer. Marks are received for competency in this respect as well as partial Recognition of Prior Learning (RPL) towards achieving competency BSBOHS201A - Participate in OHS processes.

COMPUTER CONCEPTS

Time allowed: 2 hours plus 10 minutes for reading the paper.

There is no equivalent competency in the Business Services Training Package BSB07.

The purpose of this examination is to assess knowledge of all aspects of computer terminology and technology currently being used in the office. It is a theory examination and candidates may also be asked to draw diagrams. They will not be required to use a computer and this examination must not be conducted in a computer room.

Candidates for the Computer Concepts examination should have a knowledge of the following topics. Examination questions will be based on these topics but not all topics will be covered in the one examination.

Answers are to be written on the examination paper itself, and the whole paper is to be returned for marking.

Although candidates may use an English language dictionary during this examination, it is a closed book examination and they must not have or refer to a computer dictionary or other technical manual.

Papers will be marked Credit, Pass or Fail.

DATABASE

The Society offers assessments in this area at two levels. They are:

All database assessments will be marked Credit, Pass or Fail.

DATABASE FUNDAMENTALS

Time allowed: 2 hours plus 10 minutes for reading and 2 additional minutes for reading instructions to candidates.

Recommended preparation: Operating a personal computer and developing keyboard skills.

COMPETENCIES TO BE ASSESSED IN DATABASE FUNDAMENTALS
from the Business Services Training Package BSB07
BSBITU301A — Create and use databases

BSBITU301A — Create and use databases
The elements of this competency are:

The purpose of this examination is to assess, in a simulated work environment, the candidates’ competency in creating and using simple two table relational databases with reports and queries, for the storage and retrieval of information while following workplace safety procedures.

The assessment will take the form of a situation or problem. Candidates must be able to ascertain from reading the text what they are expected to do, and then complete the practical exercises required.

The examination paper will be structured as follows:

DATABASE 3

Time allowed: 2 hours plus 10 minutes for reading and 2 additional minutes for reading instructions to candidates.

Recommended preparation: Operating a personal computer and developing keyboard skills.

COMPETENCIES TO BE ASSESSED IN DATABASE 3
from the Business Services Training Package BSB07
BSBITU301A — Create and use databases
BSBITU401A — Design databases

BSBITU301A — Create and use databases
The elements of this competency are:

BSBITA401A — Design databases
The elements of this competency are:

The purpose of this examination is to assess, in a simulated work environment, the candidates’ competency in designing and developing a database (including queries, forms and reports) to meet a defined need using existing data.

The assessment will take the form of a situation or problem. Candidates must be able to ascertain from reading the text what they are expected to do, and then create the database taking into consideration:

Papers for all database examinations will be marked Credit, Pass or Fail.

ELECTRONIC PRESENTATIONS

Time allowed: 2 hours plus 10 minutes for reading and 2 additional minutes for reading instructions to candidates.

Recommended preparation: Operating a personal computer and developing keyboard skills

COMPETENCY TO BE ASSESSED IN ELECTRONIC PRESENTATIONS
from the Business Services Training Package BSB07
BSBITU302A - Create electronic presentations

BSBUTU302A — Create electronic presentations
The elements of this competency are:

The purpose of this examination is to assess, in a simulated work environment, the candidates’ competency in using a computer presentation software package to design and produce electronic presentations for speakers, for self access and for on-line access

The assessment will take the form of a situation or problem. Candidates must be able to ascertain from reading the text what they are expected to do, and then create the presentation taking into consideration:

KEYBOARDING

The Society offers assessments in this area at two levels. They are:

KEYBOARDING

Time allowed: 1 hour plus 5 minutes for reading

Recommended preparation: Operating a personal computer

COMPETENCIES TO BE ASSESSED IN KEYBOARDING
from the Business Services Training Package BSB07
BSBITU102A — Develop keyboard skills

BSBITU102A — Develop keyboard skills
The elements of this competency are

The purpose of this examination is to assess, in a simulated work environment, the candidates’ competency in developing basic keyboarding skills using touch typing techniques while participating in Occupational Health and Safety processes.

As commercial computer training programs are available, it is expected that candidates will be using the keyboard of a computer when undertaking this examination. Examination tasks will be based on the following:

Papers will be marked Pass or Fail.

COMPETENCY TO BE ASSESSED IN KEYBOARDING SPEED AND ACCURACY
from the Business Services Training Package BSB07
BSBITU307A — Develop keyboarding speed and accuracy

BSBITU307A — Develop keyboarding speed and accuracy
The elements of this competency are:

The purpose of this examination is to assess, in a simulated work environment, the candidates’ competency in entering text and data with speed and accuracy. On successful completion of this unit, individuals must be assessed in accordance with the current version of AS 2708: 2001 and issued with a speed statement.

As a commercial computer program is available for testing keyboarding speed, it is expected that candidates will be using the keyboard of a computer when undertaking this examination. In this case, the printout of the results of the computer program test is acceptable evidence to the candidate’s competency.

If a commercial computer testing program is unavailable, the candidates should use a word processing program and Supervisors should follow the rules and regulations in AS 2708: 2001 regarding, preparation, timing, passage length and conduct of test.

Ninety-eight percent (98%) accuracy is required and papers will be marked Pass or Fail.

SPREADSHEETS

The Society offers assessments in this area at two levels. They are:

SPREADSHEETS 2

Time allowed: 2 hours plus 10 minutes for reading and 2 additional minutes for reading instructions to candidates

Recommended preparation: Operating a personal computer and developing keyboard skills

COMPETENCIES TO BE ASSESSED IN SPREADSHEETS 2
from the Business Services Training Package BSB07
BSBITU202A — Create and use spreadsheets

BSBITU202A — Create and use spreadsheets
The elements of this competency are

The purpose of this examination is to assess, in a simulated work environment, the candidates’ competency in correctly creating and using simple spreadsheets and charts through the use of spreadsheet software.

The assessment will take the form of a situation or problem. Candidates must be able to ascertain from reading the text what they are expected to do, and then create the spreadsheet taking into consideration:

SPREADSHEETS 3

Time allowed: 2 hours 30 minutes plus 10 minutes for reading and 2 additional minutes for reading instructions to candidates

Recommended preparation: successful completion of Spreadsheets 2.

COMPETENCIES TO BE ASSESSED IN SPREADSHEETS 3
from the Business Services Training Package BSB07
BSBITU304A — Produce spreadsheets

BSBITU304A — Produce spreadsheets
The elements of this competency are

The purpose of this examination is to assess, in a simulated work environment, the candidates’ competency in correctly interpreting and categorising raw data and creating and using simple spreadsheets and charts through the use of spreadsheet software.

The assessment will take the form of a situation or problem. Candidates must be able to ascertain from reading the text what they are expected to do, identify and categorise the raw data and then create the spreadsheet taking into consideration:

All spreadsheets examinations will be marked Credit, Pass or Fail.

WORD PROCESSING

The Society offers assessments in this area at three levels. They are:

WORD PROCESSING 2

Time allowed: 2 hours plus 10 minutes for reading and 2 additional minutes for reading instructions to candidates

Recommended preparation: Operating a personal computer and developing keyboard skills

COMPETENCIES TO BE ASSESSED IN WORD PROCESSING 2
from the Business Services Training Package BSB07
BSBITU201A — Produce simple word processed documents

BSBITU201A — Produce simple word processed documents
The elements of this competency are

The purpose of this examination is to assess, in a simulated work environment, the candidates’ competency in preparing and producing short routine letters, notes, memos and records using word processing software.

The assessment will require reproducing a one-page document as close as possible to a given example; editing a pre-saved document according to instructions; creating a table and carrying out mail merge procedures taking into consideration —

Assessment will be by practical exercises, problem solving, short-answer questions, and a skills and techniques checklist completed by a supervisor, and may include portfolios. Papers will be marked Credit, Pass or Fail.

WORD PROCESSING 3

Time allowed: 2 hours plus 30 minutes plus 10 minutes for reading and 2 additional minutes for reading instructions to candidates

Recommended preparation: Successful completion of Word Processing 2

COMPETENCIES TO BE ASSESSED IN WORD PROCESSING 3
from the Business Services Training Package BSB07
BSBITU303A — Design and produce text documents
BSBITU309A — Produce desktop published documents

BSBITU303A — Design and produce text documents
The elements of this competency are

This unit describes the performance outcomes, skills and knowledge required to design and develop predominantly text based documents using advanced features of word processing software.

BSBITU309A — Produce desktop published documents
The elements of this competency are

This unit describes the performance outcomes, skills and knowledge required to design and produce desktop published documents.

Because of sophisticated Word Processing software available, Word Processing 3 is an holistic examination combining design, development and production of text based and desktop published documents.

This assessment will require the production of documents incorporating —

Assessment will be by practical exercises, problem solving, short-answer questions, and a skills and techniques checklist completed by a supervisor, and may include portfolios. Papers will be marked Credit, Pass or Fail.

WORD PROCESSING 4

Time allowed: 2 hours plus 30 minutes plus 10 minutes for reading and 2 additional minutes for reading instructions to candidates

Recommended preparation: Successful completion of Word Processing 3

COMPETENCIES TO BE ASSESSED IN WORD PROCESSING 3
from the Business Services Training Package BSB07
BSBITU401A — Design and develop complex text documents
BSBITU404A — Produce complex desktop published documents

BSBITU401AA — Design and develop complex text documents
The elements of this competency are

This unit describes the performance outcomes, skills and knowledge required to design and develop business documents using complex technical features of word processing software.

BSBITU3A — Produce desktop published documents
The elements of this competency are

This unit describes the performance outcomes, skills and knowledge required to design and produce complex desktop published documents.

Because of sophisticated Word Processing software available, Word Processing 4 is an holistic examination combining design, development and production of complex text and complex desktop published documents. Word Processing 4 is an advanced Level 4 examination and may possibly, in the future, be used in Recognition of Prior Learning (RPL) applications.

This assessment will require the production of complex documents incorporating —

Assessment will be by practical exercises, problem solving, short-answer questions, and a skills and techniques checklist completed by a supervisor, and may include portfolios. Papers will be marked Distinction, Credit, Pass or Fail.


© Copyright CESA 2017
Disclaimer