The University of Southampton
Courses

MATH6147 Data Analytics

Module Overview

The module provides an introduction to the use of spreadsheets and databases for modelling in Operational Research.

Aims and Objectives

Module Aims

• Understand how spreadsheets can be used to help solve standard problems in Operational research, e.g. queueing theory and linear programming • Use a standard spreadsheet package (e.g. Microsoft Excel) to carry out calculations • Appreciate the value of spreadsheets for solving small-scale practical problems • Carry out a practical project using a spreadsheet • Run basic queries to obtain information from a database • Understand the basic principles of database design • Use R for data manipulation and visualisation

Learning Outcomes

Learning Outcomes

Having successfully completed this module you will be able to:

  • Understand how spreadsheets can be used to help solve standard problems in Operational Research, e.g. queueing theory and linear programming
  • Appreciate the value of spreadsheets for solving small-scale practical problems
  • Understand the basic principles of database design
  • Use a standard spreadsheet package (e.g. Microsoft Excel) to carry out calculations
  • Carry out a practical project using a spreadsheet
  • Run basic queries to obtain information from a database
  • Use R for data manipulation and visualisation

Syllabus

1. Introduction to Excel: basic file operations; entering data; using formulae. 2. Linear programming: optimisation using Goal Seek and Solver 3. LookUp tables, random sampling and queueing models 4. Importing data and Pivot Table/Chart analysis 5. Introduction to database systems: entity-relation models; practical database design 6. Working with queries: creating a query; introduction to some basic SQL 7. Introduction to R: data input, manipulation and visualisation

Learning and Teaching

Teaching and learning methods

The module will be taught using a mixture of lectures and computer workshops: 12 hours of computer workshops; 4 hours of lectures.

TypeHours
Teaching4
Independent Study146
Total study time150

Resources & Reading list

Robert L. Phillips (2005). Pricing and Revenue Optimization. 

Weida N, Richardson R & Vazsonyi A. Operations Analysis Using Microsoft® Excel. 

Lehmann M & Zeitz P. Statistical Explorations with Microsoft® Excel. 

Liengme BV. A Guide to Microsoft Excel for Business and Management. 

Winston WL. Operations Research: Applications and Algorithms. 

Rolland FD. The Essence of Database. 

Ritchie C. Relational Database Principles (Letts Educational). 

Thomas T. Nagle, John F. The Strategy and Tactics of Pricing: A Guide to Growing More Profitably. 

Software requirements. Microsoft Excel; Microsoft Access (or other database software)

Barlow JF. Excel Model for Business and Operations Management. 

Assessment

Summative

MethodPercentage contribution
Database modelling 30%
Spreadsheet modelling 70%

Referral

MethodPercentage contribution
Coursework assignment(s) 100%

Repeat Information

Repeat type: Internal & External

Share this module Share this on Facebook Share this on Google+ Share this on Twitter Share this on Weibo

We use cookies to ensure that we give you the best experience on our website. If you continue without changing your settings, we will assume that you are happy to receive cookies on the University of Southampton website.

×