|
|
 |
Information and Communications
Technology Qualifications
| Back to list of Prescriptions
| Prescription: SP592 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 | SF500(SF100) Software Fundamentals
Concurrent study of SP590(SP190) recommended.
|
| Student Learning hours | 70
|
| Prescription Expiry Date | Nov 2007
|
| Note | This module draws together the file management software components of SP500(SP100) and SP510(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 - Sorting and Grouping data | | | | - Importing data from other applications (eg spreadsheets) | | | | - Exporting data to other applications (eg spreadsheets, word processing) | | | | - Uploading static data to web site | | | | - Switchboards or the equivalent | | | | | | | |
|
top
| | | | > | Plan a presentation. | | | | | | > | View and edit a presentation. | | | | | > | Edit the master slides for the 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 objects from other applications - embeded and linked | | | | | > | Insert Media Objects. | | | | | > | Create a chart. | | | | | > | Insert linked charts from a spreadsheet package. | | | | | | > | Add transition and build effects. | | | | | | > | Control a slide show. | | | | | | > | Create interactive navigation buttons. | | | | | | > | Create an interactive presentation. | | |
|
top
| | | | > | Manage personal and business information: | | | | - e-mail messages, including attachments | | | | - 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. |
|
|
