Skip to main content
Home

Information for:

  • Alumni
  • Applicants
  • Current Students
  • Staff
  • Parents
  • Job Vacancies
  • Covid-19
  • Cymraeg
My country:

Main Menu

    • Study Options
      • Study Home
      • Why Study at Bangor?
      • Undergraduate Study
      • Postgraduate Taught Study
      • Postgraduate Research
      • Executive Education
      • Part-time Courses
      • January Start Courses
      • Degree Apprenticeships
      • Study Abroad
      • Work Experience
    • Study Advice
      • Apply
      • Already Applied?
      • Fees and Finances
      • Scholarships and Bursaries
      • Get Ready for University
      • Widening Access
    • Explore Bangor
      • Open Days and Visits
      • Virtual Student Experience
      • Magical Bangor

    Find a Course

    Order a Course Guide

    Open Days

    Clearing

    • Student Life
      • Student Life Home
      • Bangor and the Area
      • Social Life and Entertainment
      • Student Accommodation
      • Clubs and Societies
      • Sport
      • Virtual Student Experience
      • Videos and Vlogs
    • Your Experience at Bangor
      • Student Support
      • Skills and Employability
      • Study or Work Abroad
      • Fees and Finances

    Student Profiles

    Student Videos and Vlogs

    Welcome 2022

    • Choose Bangor
      • International Home
      • Why Bangor?
      • Location
      • Accommodation
      • Student Support
      • Contact Us
      • Bangor University's China website
    • Apply
      • Entry Requirements
      • Tuition Fees and Scholarships
      • How to Apply
      • Already Applied
      • Study Abroad
      • Exchanges
      • Worldwide Partners

    Country Specific Information

    Bangor University International College

    Find a Course

    Clearing 2023

    • Research
      • Research Home
      • About Our Research
      • Research in our Academic Schools
      • Research Institutes and Centres
      • Research Portal
      • Integrated Research and Impact Support (IRIS) Service
      • Energy
      • REF 2021
      • Research News
    • Postgraduate Research Opportunities
      • Postgraduate Research
      • Doctoral School
    • Events and Training Opportunities
      • Researcher Development
    • The University
      • About Us
      • Our Mission
      • Strategy 2030
      • Annual Report & Financial Statements
      • Our Location
      • Academic Schools and Colleges
      • Services and Facilities
      • Vice-Chancellor's Office
      • Working with Business
      • Working with the Community
      • Sustainability
      • Health and Wellbeing
      • Contact Us
    • Working for Us
      • Job Vacancies
    • University Management and Governance
      • Policies and Procedures
      • Slavery and Human Trafficking Statement
      • Management and Governance
    • University and the Community
      • Pontio
      • Sports Facilities
      • Conference Facilities
      • Places to Eat and Drink
      • Public Events
      • Widening Access
      • Services to Schools
    • Business Services
      • Business Services Home
    • Collaboration Hub
      • Collaboration Hub
    • Conferencing and Business Dining
      • Conferencing Facilities
      • Business Dining
    • Intellectual Property (IP) and Commercialisation
      • Intellectual Property (IP) and Commercialisation
    • News
      • Current News
      • Research News
      • Student News
    • Events
      • Events
    • Announcements
      • Flag Announcements
  • Open Days

    • Study Options
      • Study Home
      • Why Study at Bangor?
      • Undergraduate Study
      • Postgraduate Taught Study
      • Postgraduate Research
      • Executive Education
      • Part-time Courses
      • January Start Courses
      • Degree Apprenticeships
      • Study Abroad
      • Work Experience
    • Study Advice
      • Apply
      • Already Applied?
      • Fees and Finances
      • Scholarships and Bursaries
      • Get Ready for University
      • Widening Access
    • Explore Bangor
      • Open Days and Visits
      • Virtual Student Experience
      • Magical Bangor

    Find a Course

    Order a Course Guide

    Open Days

    Clearing

    • Student Life
      • Student Life Home
      • Bangor and the Area
      • Social Life and Entertainment
      • Student Accommodation
      • Clubs and Societies
      • Sport
      • Virtual Student Experience
      • Videos and Vlogs
    • Your Experience at Bangor
      • Student Support
      • Skills and Employability
      • Study or Work Abroad
      • Fees and Finances

    Student Profiles

    Student Videos and Vlogs

    Welcome 2022

    • Choose Bangor
      • International Home
      • Why Bangor?
      • Location
      • Accommodation
      • Student Support
      • Contact Us
      • Bangor University's China website
    • Apply
      • Entry Requirements
      • Tuition Fees and Scholarships
      • How to Apply
      • Already Applied
      • Study Abroad
      • Exchanges
      • Worldwide Partners

    Country Specific Information

    Bangor University International College

    Find a Course

    Clearing 2023

    • Research
      • Research Home
      • About Our Research
      • Research in our Academic Schools
      • Research Institutes and Centres
      • Research Portal
      • Integrated Research and Impact Support (IRIS) Service
      • Energy
      • REF 2021
      • Research News
    • Postgraduate Research Opportunities
      • Postgraduate Research
      • Doctoral School
    • Events and Training Opportunities
      • Researcher Development
    • The University
      • About Us
      • Our Mission
      • Strategy 2030
      • Annual Report & Financial Statements
      • Our Location
      • Academic Schools and Colleges
      • Services and Facilities
      • Vice-Chancellor's Office
      • Working with Business
      • Working with the Community
      • Sustainability
      • Health and Wellbeing
      • Contact Us
    • Working for Us
      • Job Vacancies
    • University Management and Governance
      • Policies and Procedures
      • Slavery and Human Trafficking Statement
      • Management and Governance
    • University and the Community
      • Pontio
      • Sports Facilities
      • Conference Facilities
      • Places to Eat and Drink
      • Public Events
      • Widening Access
      • Services to Schools
    • Business Services
      • Business Services Home
    • Collaboration Hub
      • Collaboration Hub
    • Conferencing and Business Dining
      • Conferencing Facilities
      • Business Dining
    • Intellectual Property (IP) and Commercialisation
      • Intellectual Property (IP) and Commercialisation
    • News
      • Current News
      • Research News
      • Student News
    • Events
      • Events
    • Announcements
      • Flag Announcements
  • Open Days

Information for:

  • Alumni
  • Applicants
  • Current Students
  • Staff
  • Parents
  • Job Vacancies
  • Covid-19
My country:

Search

Close

Breadcrumb

  • Cymraeg

Share this page:
  • Twitter
  • Facebook
  • LinkedIn

Apply Now

Find out how to apply

Open Days

More information

Order a Course Guide

Order Now

Request Information

Get in touch

Chat to our staff and students

Connect through Unibuddy

Module PPP-4012:
Practical Programming

Practical Programming 2024-25
PPP-4012
2024-25
School Of Human And Behavioural Sciences
Module - Semester 1
20 credits
Module Organiser: George Houghton
Overview

We will cover (at least) the following:

General elements of programming (exemplified in Visual Basic):

  1. Planning your program: What is the problem? How am I going to solve it? How can I break the solution down into steps?
  2. Variables and Data types: How to declare, use and manipulate numbers, strings, arrays, lists, and (VB) objects.
  3. Assigning values: How to give a variable a value.
  4. Scope of variables: local and global variables.
  5. Arithmetic operations: how to add, subtract, multiply etc
  6. Simple string manipulations, e.g., concatenation. How to handle and manipulate file names.
  7. Collections of data: Creating and processing Lists and Arrays.
  8. Subroutines and functions: What they are for, and the difference between them. Passing arguments to and returning values from functions.
  9. If... then ...else .. End if statements. How to make a conditional statement.
  10. Loops: doing something repeatedly: a. For ... Next loops: doing the thing some number of times b. Do Until ... Loop, Do While ... Loop: doing the thing until (or while) some condition is fulfilled.
  11. Basics of “Object-oriented” programming. Object hierarchies. Object.Method, Object.Property.

Visual interface programming

  1. Use of the VB programming environment,.
  2. Graphical user interface (GUI) design.
  3. Controls: what are they? Controls as objects.
  4. VB Forms, placing controls on forms, naming controls. Changing properties of controls.
  5. The object.method and object.property syntax.
  6. How to manipulate common VB controls: Command buttons, text boxes, list boxes, labels, frames, option (radio) buttons, check boxes, data tables, progress bars etc.
  7. Standard methods for the common controls. Linking controls to the underlying program.
  8. File input/output; reading data from a file. Using file dialogs to Open and Save files.

Visual Basic for Applications (VBA): Use in Excel

  1. Starting VBA in Excel: The programming interface
  2. Linking VBA to the Excel worksheet.
  3. The Excel object model: Workbooks, Worksheets, Ranges, Cells.
  4. VBA program modules, and the VBA UserForm.
  5. Programming data manipulation in Excel with VB.

Learning Outcomes

  • Design and program a Windows-type user interface, using a variety of common controls (found in Visual Basic)

  • Learn to automate data analyses and other operations in Excel, using Visual Basic for Applications.

  • Students will gain an understanding of the central constructs and techniques employed in most computer programming; they will learn to employ these techniques to handle and manipulate data. Students will also acquire skills in visual interface design, allowing other people to easily use their programs.

Assessment type

Summative

Weighting

30%

Assessment type

Summative

Weighting

40%

Assessment type

Summative

Weighting

30%

Home

Study

  • Undergraduate Study
Home

Follow Us

  • Twitter
  • Facebook
  • Instagram
  • Youtube
  • LinkedIn

Bangor University

Bangor, Gwynedd, LL57 2DG, UK

+44 (0)1248 351151

Contact Us

Visit Us

Maps & Directions

Policy

  • Legal Compliance
  • Modern Slavery Act 2015 Statement
  • Accessibility Statement
  • Privacy and Cookies
  • Welsh Language Policy
Map

Bangor University is a Registered Charity: No. 1141565

© 2020 Bangor University