CO320 introduction to Object-Oriented Programming, CO322 Foundations of Computing 1
OverviewThis module introduces students to one of the more important computer tools used in business. The module teaches the use and application of spreadsheets, What–If analysis tools and VBA programming to produce solutions to business problems.
Topics covered include
The solution of linear programming problems, financial analysis, time-series forecasting, critical path analysis, inventory control and optimisation.
The use of macros and VBA to automate spreadsheet processing.
The use of statistical analysis software to summarise and display quantitative data, perform regression analysis and significance tests.
This module appears in:
11 hours of Lectures, 22 hours of class time
This aim of this module is to provide an opportunity for students, as members of a group, to integrate and consolidate the knowledge and skills acquired over the earlier part of the programme, and to experience over an extended period the interdependency of teamwork
Students who successfully complete this module will be able to:
Identify and evaluate alternative solution strategies to a given problem
Analyse, design and implement a computing-based solution to a structured problem
Design and implement a well-documented, maintainable spreadsheet suitable for users other than the author
Build models and carry out analyses of real-world problems using OR methodologies and spreadsheets
Perform custom calculations using the VBA programming language
Use a spreadsheet and /or statistical analysis software to present and analyse quantitative data