Home

Newsletters

Conference

Qualifications


Introduction

Regulations

Module Precriptions


[ .. Back .. ]



Forum

Job Vacancies




Information and Communications
Technology Qualifications


| Back to list of Prescriptions

Prescription: SP210 Integrated Applications

Aim of Module To provide students with skills and knowledge in the use of integrated applications to enable the creation of end-user applications.

Credits 7

Knowledge Assumed From A range of modules such as
SP100, SP110, SP190, SP191,
SP192, and SP200.

Student Learning hours 70 student learning hours

Prescription Expiry Date Nov 2002


Level and Assessment Schedule
TopicsHighest
Skill Level
Suggested
Assessment
Percentage
1 Use Integrated Applications A 35
2 Select a Suitable Application P 15
3 Identify & Document Inputs & Processes P 15
4 Create an End-User Application A 35

100

LEARNING OUTCOMES

The Student Will
A1Demonstrate advanced skills in the use of at least two of the integrated applications that will enable end-user applications to be developed.
P2Analyse a problem and choose, with justifiable reasons, which of the integrated applications are best suited to solving the problem.
P3Identify and document the various inputs and processes needed to produce the outputs required to solve a set of related business problems.
A4Create a user-friendly and well-documented end-user application based on the inputs, processes and outputs that have been identified.

CONTENT

1Use Integrated Applications
The use of Integrated Applications will include the demonstration of skills required, but not limited to:
> Create menus, list boxes, combo boxes, command buttons, form fields.
> Integrate applications including DDE, ActiveX, OLE, Hyperlinking as appropriated for the integrated applications being used.
> Record macros and attach to objects such as command buttons.
> Create queries to import data from other applications and to modify/delete existing data.
> Create complex functions and formulae.
> Create customised user interfaces.
> Create on-line help.
Note that for the purposes of this module, the student does not need to demonstrate skills in the use of the programming language that supports the applications.
top
2Select a Suitable Application
> Analyse a given problem and give justifiable reasons as to which application type is the most suitable.
> Explain the factors involved in determining what type of application is most suited for a particular task including, but not limited to:
- database v. spreadsheet
- database v. word processing mail merge
- presentations package v. word processor
> Explain the factors involved in determining what combinations of applications to use for more complex tasks including, but not limited to:
- mail merge using database data
- databases with attached spreadsheet tables
- graphing database data in a spreadsheet
top
3Identify & Document Inputs & Processes
> Identify and document the inputs and processes required to solve a given set of related business problems.
top
4Create an End-User Application
> Create the end-user application using the inputs and processes identified, and with the applications identified.
> Create end-user documentation including start-up pages with hyperlinks, placeholder text, sticky notes etc.
> Create a document describing the inputs, outputs, processes and objects used.
top
Note
> It is intended that an integrated suite of applications that is in common use at the time is used for the purposes of this module - for example Microsoft Office, Lotus Smart Suite, Corel Office Suite.



| Home | Newsletters | Conference | Qualifications | Forum | Job Vacancies |