NACCQ - Qualifications

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
Topics	Highest 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

A	1	Demonstrate advanced skills in the use of at least two of the integrated applications that will enable end-user applications to be developed.



P	2	Analyse a problem and choose, with justifiable reasons, which of the integrated applications are best suited to solving the problem.



P	3	Identify and document the various inputs and processes needed to produce the outputs required to solve a set of related business problems.



A	4	Create a user-friendly and well-documented end-user application based on the inputs, processes and outputs that have been identified.

CONTENT

1	Use 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.

2	Select 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

3	Identify & Document Inputs & Processes


>	Identify and document the inputs and processes required to solve a given set of related business problems.

4	Create 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.


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.