|
|
 |
Information and Communications
Technology Qualifications
| Back to list of Prescriptions
| Prescription: SP590 Word Processing & Spreadsheets |
| Aim of Module | The student will acquire skills and knowledge in the use of word processing and spreadsheet software to carry out tasks at an intermediate level of difficulty.
|
| Credits | 7
|
| Knowledge Assumed From | (SF500)SF100 Software Fundamentals
|
| Student Learning hours | 70
|
| Prescription Expiry Date | Nov 2007
|
| Note | This module draws together the word processing and spreadsheet components of SP500(SP100) and SP510(SP110). The accounting, file management and one extra type of software components of SP500(SP100) and SP510(SP110) are drawn together in SP591(SP191).
|
LEARNING OUTCOMES
The Student Will
| | | | | A | 1 | Apply a word processing package to solve problems of an intermediate level of difficulty. | | | | | A | 2 | Apply a spreadsheet package to solve problems of an intermediate level of difficulty. |
CONTENT
| | | | A | | By practical exercises involving the creation of appropriate documents, apply the following features of the word processing package: | | | | | | - Use of formatted and ASCII files | | | | - Printing | | | | - Pagination | | | | - Tabulation | | | | - Editing Features | | | | - Copying Text | | | | - Deleting Text | | | | - Inserting Text | | | | - Document summary sheets | | | | - Headers, footers and end notes | | | | - Widow and orphan control | | | | - Spelling dictionaries | | | | - Printing options such as Print preview | | | | - Multiple copies | | | | - Changing printer types | | | | - Calculations, including all available options | | | | - Merge printing | | | | - Creation of simple forms
|
top
| | | | A | | By practical exercise involving the creation of appropriate spreadsheets, apply the following features of the spreadsheets package: | | | | | | - Data entry and editing | | | | - Cell reproduction | | | | - Relative and absolute addressing | | | | - Titles lock | | | | - Printing | | | | - Graphs | | | | - Cell formatting | | | | - Functions including totalling, average | | | | - Data manipulation including: | | | | - Sorting | | | | - Querying | | | | - Extraction or selection | | | | - Graphs | | | | - Combining spreadsheets | | | | - Three dimensional spreadsheets | | | | - A significant selection of in-built functions | | | | - Macros, including logic structures | | |
|
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. | | |
|
|
