Computer Applications - CO329

Location Term Level Credits (ECTS) Current Convenor 2019-20
Medway Spring
View Timetable
4 15 (7.5) DR Y He

Pre-requisites

Pre-requisite: COMP3200 Introduction to Object-Oriented Programming
COMP3220 Foundations of Computing I

Restrictions

None

2019-20

Overview

The module introduces students to data analysis and statistics techniques that are important in the application of computers to business and industry. This includes summarising data, using measures of central tendency and dispersion, and effective graphical representations. Various probability models, including normal and binomial distributions, sampling and inference and predictive techniques are introduced. Regression and time series analysis also covered, along with what-if analysis tools.
The module teaches students to program in software such as Matlab and/or create spreadsheets using VBA scripting. These tools are used to handle data, variables and arrays, to display output data using built-in functions and develop new functions. Various problem-solving techniques and plotting for data visualisation are introduced.

Details

This module appears in:


Contact hours

Total contact hours: 28
Private study hours: 122
Total study hours: 150

Method of assessment

Main assessment methods

Assessment 1 - Excel Fundamentals and What-if Analysis (20%)
Assessment 2 - Linear Programming & Data Analysis (20%)
Assessment 3 - Using Matlab (10%)
Assessment 4 - Data Analysis Project (50%)

Indicative reading

UpSkill Learning, MATLAB - Programming with MATLAB for Beginners: A Practical Introduction To Programming And Problem Solving (MATLAB for Engineers, MATLAB for Scientists, MATLAB Programming for Dummies), 2016
Clarke, G. M, A Basic Course In Statistics, 2004
Jelen, B, Microsoft Excel 2010 in Depth, Que, 2010
Jelen, B, VBA and Macros: Microsoft Excel 2010, Que, 2010
Albright, SC, VBA for Modelers: Developing Decision Support Systems with
Microsoft Office Excel, South Western Educational Publishing, 2011
Hillier, FS, Introduction to Operational Research, McGraw-Hill, 2009
Powell, SG, the Art of Modelling with Spreadsheets, John Wiley & Sons, 2010

See the library reading list for this module (Medway)

Learning outcomes

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 well-documented, maintainable spreadsheets or programs suitable for data analysis tasks
Build models and carry out analyses of real-world problems using OR methodologies and spreadsheets
Perform custom calculations using Matlab and/or VBA or similar programming languages
Write programs and/or develop spreadsheets 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.