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

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%

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

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.

×