| 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 SP500(SP100), SP510(SP110), SP590(SP190), SP591(SP191),SP592(SP192), and SP600(SP200). |
| Student Learning hours | 70 |
| Prescription Expiry Date | Nov 2007 |
| 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 | |
| 5 Another Package Type | A | 15 | |
| 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. | |
| 5 | Another Package Type |
| A | By practical exercises involving the creation of appropriate documents, demonstrate standard features of another package. |
| 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. | |
| > | It is intended that outcomes 3 and 4 above are completed as a group assignment (2 or 3 to a group) to meet the aim of the applications being created, in a collaborative manner. | |
| > | It is intended that the applications developed in this module should not be solving real world problems, but should be in the nature of a case study that mirrors a real world problem. | |