Computer Applications - CO329

Location Term Level Credits (ECTS) Current Convenor 2017-18 2018-19
Medway Spring
View Timetable
4 15 (7.5) DR Y He

Pre-requisites

CO320 introduction to Object-Oriented Programming, CO322 Foundations of Computing 1

Restrictions

None

2017-18

Overview

This 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.

Details

This module appears in:


Contact hours

11 hours of Lectures, 22 hours of class time

Preliminary reading

See the library reading list for this module (Canterbury)

See the library reading list for this module (Medway)

Learning outcomes

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

University of Kent makes every effort to ensure that module information is accurate for the relevant academic session and to provide educational services as described. However, courses, services and other matters may be subject to change. Please read our full disclaimer.