BUAD307

Module code

BUAD307

Module title

Spreadsheets

Prescription

To provide students with the knowledge and skills to produce a spreadsheet for organisational use.

Programmes

NZQA Level

Level 3

NZQA Credits

3

Delivery method

Learning hours

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.

BUAD307 – Spreadsheets