The University of Southampton
Courses

MANG2071 Business Analytics Programming

Module Overview

Programming is a structured way of giving a computer unambiguous instructions to perform specific tasks. Knowledge and experience of programming not only improves your employability but it also teaches you analytical skills such as breaking down a problem into smaller parts and recognising and reusing previously solved problems. The purpose of this module is to equip you with the knowledge and skills for writing structured computer programs. Although these fundamentals can be achieved using any high level programming language, e.g. Java and Python, the module introduces Visual Basic for Application (VBA) as the introductory language. VBA is a very versatile, event-driven programming language. Programmers predominantly use VBA algorithms to build customized applications and solutions for Microsoft office applications such as MS-Excel, MS-Word and MS-Access in order to enhance the capabilities of those applications. For example, you can build a VBA algorithm to automate the repetitive task of forecasting future demand for a product upon updating current sales data in Excel.

Aims and Objectives

Module Aims

To provide you with the fundamental knowledge and skills for writing structured computer programs. Although these fundamentals are applicable using any high level programming language, this module will introduce the concepts using Visual Basic for Applications (VBA), a versatile, event driven language.

Learning Outcomes

Knowledge and Understanding

Having successfully completed this module, you will be able to demonstrate knowledge and understanding of:

  • The software development techniques that constitute good programming practice
  • Object-oriented programming
  • The importance of correctness, usability and readability in programming
Subject Specific Intellectual and Research Skills

Having successfully completed this module you will be able to:

  • Design and implement an algorithm to conduct technical calculations, manipulate data and create graphical user interfaces
  • Be able to handle files using a programming language and integration with other packages such as Excel
  • Use techniques for debugging an algorithm
Transferable and Generic Skills

Having successfully completed this module you will be able to:

  • Self-manage the development of learning and study skills
  • Plan and control effectively for successful completion of a personal workload
  • Use your analytic skills in problem solving
  • Communicate effectively, in both oral and written form, using and justifying argument within reports and presentations

Syllabus

1. Overview of Computer Programming: Purpose and nature; the VBA Environment 2. Key Components of Programs: • 1Variables, Constants and Data Types; • Formatting and Identifiers; • Commenting; • Arrays • Conditional Structures and Loops • Routines, Procedures and Functions 3. Debugging 4. Manipulating Excel using VBA 5. Object-Oriented Programming

Special Features

None

Learning and Teaching

Teaching and learning methods

Teaching methods and learning methods include: • Lectures • Interactive case studies • Computer labs • Directed reading • Private/guided study Learning activities include: • Introductory lectures • 2 assignments (individual written coursework) • In class debate and discussion • Private study • Use of video and online materials

TypeHours
Preparation for scheduled sessions12
Wider reading or practice32
Lecture12
Completion of assessment task70
Practical classes and workshops24
Total study time150

Resources & Reading list

Beginning Excel VBA Programming: A concise guide to developing Excel VBA Applications and Macros.

Albright, S. C. (2013). VBA for Modelers: Developing Decision Support Systems. 

Knuth, D. E. (1998). The art of computer programming: sorting and searching, Pearson Education. 

Assessment

Formative

In-class activities

Summative

MethodPercentage contribution
Individual Coursework: Analytics Programming Project  (2000 words) 60%
Individual Coursework: Basic Programming Task 40%

Repeat

MethodPercentage contribution
Individual Coursework: Analytics Programming Project  (2000 words) 100%

Referral

MethodPercentage contribution
Individual Coursework: Analytics Programming Project  (2000 words) 100%

Repeat Information

Repeat type: Internal & External

Linked modules

Pre-requisites: MANG1007 Management Analysis 2016-17 OR MANG1019 Foundations of Business Analytics 2016-17 OR ‘A’ level Maths

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:

Textbooks

Recommended texts for this module may be available in limited supply in the University Library and students may wish to purchase the core/ recommended text as appropriate

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.

×