NACCQ - Qualifications

Information and Communications
Technology Qualifications

| Back to list of Prescriptions

Prescription: SP510 Software Packages

Aim of Module	To provide students with an extension of the skills and knowledge of software packages obtained in SP500 Software Applications
Credits	7
Knowledge Assumed From	SP500 Software Applications. This module may be taught in conjunction with SP500.
Student Learning hours	70
Content Revised	Nov 2004
Prescription Expiry Date	Nov 2007

Level and Assessment Schedule
Topics	Highest Skill Level	Suggested Assessment Percentage
1 Word Processing	A	20
2 Spreadsheet	A	20
3 File Management	A	20
4 Accounting	A	25
5 Another Package Type	A	15

		100

LEARNING OUTCOMES The Student Will

A	1	Apply advanced features of a word processing application to produce a business solution.

A	2	Apply advanced features of a spreadsheet application to produce a business solution.

A	3	Apply advanced features of a file management application to produce a business solution.

A	4	Apply advanced features of an integrated accounting package to application to produce a business solution.

A	5	Apply advanced features of a software application of a type not otherwise used in this module to produce a business solution.

CONTENT

1	Word Processing


>	By practical exercises involving the creation of appropriate documents, apply the following advanced features of the word processing application:



	-	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

2	Spreadsheet


>	By practical exercises involving the creation of appropriate spreadsheets, apply the following advanced features of the spreadsheet application:



	-	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

3	File Management


>	Demonstrate the use of a large sub-set of commands in the selected software application.



	-	Using the advanced facilities of the software application, design and write a small program to carry out a data processing task.

4	Accounting


>	Use Debtors, Creditors, General Ledger and Stock modules (including integrated facilities) of an accounting application.

5	Another Package Type


>	By practical exercises involving the creation of appropriate documents, demonstrate a range of standard and advanced features of a software application package that is new to the student (s).


Note
>	This module requires the use of software applications that are in current use in business situations. As the popularity of various packages waxes and wanes, so may the selection of applications for use on this course vary from time to time. The applications selected will have most or all of the features described above. Note that this module is intended to be part of a progression of modules using a common set of applications to gradually increase the expertise of the student in the use of the selected applications.