BUAD307 – Spreadsheets
Module code
BUAD307
Module title
Spreadsheets
Prescription
To provide students with the knowledge and skills to produce a spreadsheet for organisational use.
Programmes
- EF1805
- EU7000
NZQA Level
Level 3
NZQA Credits
3
Delivery method
- Web-Enhanced
Learning hours
- Total learning hours
- 30
Resources required
- Learning Outcomes
- Produce a spreadsheet for organisational use.
- Content
- -Work with two or more workbooks
-Solve problems using formulas, and functions, date and time calculations, absolute cell referencing; two of logical, statistical or financial functions, formatting and editing techniques, charting; and efficiency techniques
-Data integrity techniques and practices, audited formulas, accuracy of totals. - Teaching and Learning Strategy
- Teaching methods involve theoretical and practical classes, online activities and a project.
- Assessment Criteria
- Portfolio of evidence100
- Learning and Teaching Resource
- Resources, including learner workbook, will be supplied by the tutor at the commencement of the module.
