Business Analytics Programming II: Algorithmic Thinking

Learning Outcomes

Subject Specific Intellectual and Research Skills

Having successfully completed this module you will be able to:

• handle files using a programming language and integration with other packageshandle files using a programming language and integration with other packages;
• design and implement an algorithm to conduct technical calculations, manipulate data and create graphical user interfaces;
• use techniques for debugging an algorithm.

Knowledge and Understanding

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

• object-oriented programming;
• the software development techniques that constitute good programming practice;
• the importance of correctness, usability and readability in programming.

Transferable and Generic Skills

Having successfully completed this module you will be able to:

• use your analytic skills in problem solving;
• communicate effectively, in both oral and/or written form.
• plan and control effectively for successful completion of a personal workload;
• self-manage the development of learning and study skills;

1.Overview of Computer Programming: Purpose and nature; the VBA Environment

2. Key Components of Programs:

• Variables, 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

6. Introduction to the Python programming language: syntax and programming structures

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

Formative

This is how we’ll give you feedback as you are learning. It is not a formal test or exam.

In-class activities

• Assessment Type: Formative
• Feedback: - Verbal formative feedback will be given by the lecturer and tutor throughout the module during lectures and classes as well as during office hours. - Written feedback will also be provided by the lecturer and tutor through email communications. - A “Project Corner” will be part of the lectures to guide students in their progress towards Analytics project submission. Moreover, students can submit a draft of a part of their project. Holistic overall feedback based on all submitted drafts will be provided, via blackboard and email, to all students during the Christmas vacation and, where time allows, students who submit a draft will have the opportunity to get one-to-one feedback on their work.
• Final Assessment: No
• Group Work: No

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.

Repeat

An internal repeat is where you take all of your modules again, including any you passed. An external repeat is where you only re-take the modules you failed.