BSQA650 – Applied Computing
Module code
BSQA650
Module title
Applied Computing
Prescription
NZQA Level
Level 6
NZQA Credits
20
Delivery method
- Web-Supported
Learning hours
- Directed hours
- 64
- Self directed hours
- 136
- Total learning hours
- 200
Resources required
- Learning Outcomes
- 1) Students will demonstrate proficiency in using a range of current business software
applications.
Key elements
a) Prescribed software applications:
- spreadsheets, including use of at least four advanced features (eg pivot tables;
creating and editing macros; forms; creating or managing multiple scenarios)
- database management system, including use of at least four advanced features
(eg multi-table queries, use of parameters, main menu interface, data security,
creating and editing macros, data validation)
b) Elective software application(s): at least one of the following, including use of at
least four advanced features:
- word processing
- time and project management/scheduling software
- internet/intranet technologies, which may include:
website design and development
electronic commerce applications
groupware
e-mail and calendar
- other current business applications to enhance productivity
2) Students will customise and integrate business software applications to improve productivity
and efficiency for multiple users.
Key elements
a) Customisation of user interface
b) Integration of multiple applications
3) Students will solve business problems by identifying business requirements and designing
and developing (a) functional solution(s) using appropriate software applications.
Key elements
a) Requirement identification
b) Software application feature evaluation and selection
c) Design and development
d) Test and implement
e) Evaluation and user documentation
4) Students will identify, extract, process and format information to produce reports to aid in the decision making processes of an organisation.
Key elements
a) At least two types of reports (eg exception report, summarised report with group
calculations, detailed report, graphical report) which:
- include required data
- meet decision making needs
- are formatted for ease of interpretation
- are flexible (ie easily modified and/or parameter driven)
