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