 |
Prescription:SP192 Software Packages |
| Aim of Module | To enable the student to acquire skills and knowledge in the use of database management, presentation, personal information management software, and in transferring data between applications.
|
| Credits | 7
|
| Knowledge Assumed From | SF100 Software Fundamentals
Concurrent study of SP190 recommended.
|
| Suggested Time | 70 student learning hours
|
| Prescription Expiry Date | Nov 2002
|
| Note | This module draws together the file management software components of SP100 and SP110. It introduces Presentation and Personal Information Management software and the transfer of data between software applications.
|
LEARNING OUTCOMES
The Student Will
| | | | | A | 1 | Apply a Database Management package to solve problems of an intermediate level of difficulty. | |
| |
A | 2 | Apply a Presentation package to solve problems of an intermediate level of difficulty. | |
| |
A | 3 | Use an extensive list of features of a Personal Information Management package to solve problems. | |
| |
| |
A | 4 | Transfer data between software packages. | |
|
CONTENT
| | | | > | Use the selected package to: | |
| |
| | Create a Database | |
| | Create, Edit tables: | |
| | - Input Masks | |
| | - Data Validation | |
| | Filter and Querying Tables | |
| | Forms | |
| | Create Reports and Mailing Labels | |
| | Enforce Referential Integrity | |
| | Field Concatenation | |
| | Calculated Fields | |
| | Update, Append, Delete, Queries | |
| | Query Parameter passing | |
| | Enhance Forms: | |
| | - Sub-forms | |
| | - Check, Option, and Combo Boxes | |
| | - Macro Buttons | |
| | Customise Reports | |
|
top
| | | | > | Plan a presentation. | |
| |
> | View and edit a presentation. | |
| |
> | Delete and move slides. | |
| |
> | Run a slide show. | |
| |
> | Add a slide footer. | |
| |
> | Preview and print a presentation. | |
| |
> | Change the presentation design. | |
| |
> | Expand slides. | |
| |
> | Modify attributes. | |
| |
> | Insert Media Objects. | |
| |
> | Create a chart | |
| |
> | Add transition and build effects. | |
| |
> | Control a slide show. | |
| |
> | Create interactive navigation buttons. | |
| |
> | Create an interactive presentation. | |
|
top
| | | | > | Transferring data between applications: | |
| |
| | - Object Linking and Embedding | |
| | - ASCII delimited files. | |
| Note: | Use case studies | |
|
top
| | | | > | Manage personal and business information: | |
| | - e-mail messages | |
| | - appointments | |
| | - contacts | |
| | - tasks | |
| | - files | |
| | - track activities | |
| |
> | Share information with a group by using: | |
| | - e-mail | |
| | - group scheduling | |
| | - public folders | |
| |
> | Share information with other software programs. | |
| |
> | Browse and find application files from within the PIM. | |
| |
> | Connect to and share information across the World Wide Web. | |
|
top
| | | | Note | | SELECTION OF PACKAGES | |
| |
> | This module requires the use of software packages which are in current use in business situations. As the popularity of various packages waxes and wanes, so may the packages selected vary from time to time. However, it is expected that packages selected will have most or all of the features as described under content. | |
| |
> | This module is intended to be part of a progression of modules using a common set of packages to gradually increase the expertise of the student in the use of the selected packages. |
|
|
|
