 |
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.
|
| Suggested Time | 70 student learning hours
|
| Prescription Expiry Date | Nov 2002
|
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
| | | | 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
| | | | > | 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
| | | | > | Identify and document the inputs and processes required to solve a given set of related business problems.
|
top
| | | | > | 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. |
|
|
|
