This module introduces students to the tools, techniques and best practices of spreadsheet development applicable to project environments. It examines the core concepts and applied techniques for effective analysis of project data. It introduces the importance of the risks associated with developing spreadsheets and the importance of data driven decision making support organisational agility.
Date & Time Formulas
Pivot Tables
String Functions
Financial Functions
Data Visualisation Techniques
Big Data Analysis
Spreadsheet Auditing
Spreadsheet Modelling
What If Analysis
This module will apply a hybrid approach of teacher-centred and student-centred learning approaches which will assign a significant responsibility to the student in the learning process.
The module will also incorporate a range of learning teaching methods including webinars, web based learning platforms, online assessment and class discussions.
Teaching Contact Hours may also be delivered online via Webinar or Virtual Learning Environment.
| Module Content & Assessment | |
|---|---|
| Assessment Breakdown | % |
| Other Assessment(s) | 100 |