Unit Code: OAD405

Unit Name: Spreadsheet Application

Description: This is designed to enhance students skills through advanced features of the MS Excel program. The employs concepts on spreadsheet design, graphs and charts, formulae and functions, templates, workbook security, database management and macros. This focuses on real life situations involving advanced formulas and functions, in addition to finding solutions to various scenarios including the preparation of analysis reports, statistics, graphs or charts.

Learning Target Outcomes:

Prerequisite: OAD403, CIN410, CIN501, CIN506

Prerequisite Sentence: (any of these) or Year 12 pass

Credit Point: 12

Offered In: Semester 2