Applied Computing

This subject covers the knowledge required to use spreadsheet software to complete business tasks and to produce complex documents.

The Microsoft Excel package is used for development of spreadsheets.

Specific topics include:

• Utilise spreadsheet design software functions and formulae to meet identified requirements
• Format cells and use data attributes assigned with relative and/or absolute cell references
• Develop, edit and use templates to ensure consistency of design and layout for forms and reports
• Import and export data between compatible spreadsheets
• Create graphs with labels and titles from numerical data contained in a spreadsheet file