Data Analytics

Learning Outcomes

Learning Outcomes

Having successfully completed this module you will be able to:

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

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

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

workshops; 4 hours of lectures.

Summative

This is how we’ll formally assess what you have learned in this module.

Referral

This is how we’ll assess you if you don’t meet the criteria to pass this module.