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