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

Subject Specific Practical Skills

Having successfully completed this module you will be able to:

  • 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
Subject Specific Intellectual and Research Skills

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

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 Study59
Workshops12
Total study time75

Resources & Reading list

Barlow JF. Excel Model for Business and Operations Management. 

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

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

Winston WL. Operations Research: Applications and Algorithms. 

Ritchie C. Relational Database Principles (Letts Educational). 

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

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

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

Rolland FD. The Essence of Database. 

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

Assessment

Summative

MethodPercentage contribution
Database modelling 30%
Spreadsheet modelling 70%

Referral

MethodPercentage contribution
Coursework assignment(s) 100%

Repeat Information

Repeat type: Internal & External

Costs

Costs associated with this module

Students are responsible for meeting the cost of essential textbooks, and of producing such essays, assignments, laboratory reports and dissertations as are required to fulfil the academic requirements for each programme of study.

In addition to this, students registered for this module typically also have to pay for:

Books and Stationery equipment

Course texts are provided by the library and there are no additional compulsory costs associated with the module

Please also ensure you read the section on additional costs in the University’s Fees, Charges and Expenses Regulations in the University Calendar available at www.calendar.soton.ac.uk.

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.

×