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