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
      • 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
    • Explore Bangor
      • Open Days and Visits
      • Virtual Student Experience

    Find a Course

    Order a Prospectus

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

    Student Profiles

    Student Videos and Vlogs

    • Choose Bangor
      • International Home
      • Why Bangor?
      • Location
      • Accommodation
      • Student Support
      • Contact Us
    • Apply
      • Entry Requirements
      • Tuition Fees and Scholarships
      • How to Apply
      • Already Applied
      • Study Abroad
      • Exchanges

    Country Specific Information

    Join us on a Virtual Open Day

    Bangor University International College

    Covid-19 Information

    • Research
      • Research Home
      • About Our Research
      • Research in our Academic Schools
      • Research Institutes and Centres
      • Research Portal
      • Research, Innovation and Impact Office (RIIO)
      • Energy
      • Research News
    • Postgraduate Research Opportunities
      • Postgraduate Research
      • Doctoral School
    • Events and Training Opportunities
      • Researcher Development
    • The University
      • About Us
      • Our Mission
      • Strategy 2030
      • Annual Review
      • 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
      • Funding for Collaborative Research and Development (R&D) & Innovation
      • Business Facilities and Networks
      • Consultancy, Specialist Expertise and Knowledge
      • Commercialisation and Intellectual Property (IP)
      • Student Placements and Internships in Business & Enterprise
      • Training and Continuing Professional Development
      • Degree Apprenticeships
    • Conferencing and Business Dining
      • Conferencing Facilities
      • Business Dining
    • Contacts
      • Research, Innovation and Impact Office (RIIO)
      • Get In Touch
    • News
      • Current News
      • Research News
      • Student News
    • Events
      • Events

    • Study Options
      • Study Home
      • Why Study at Bangor?
      • Undergraduate Study
      • Postgraduate Taught Study
      • Postgraduate Research
      • 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
    • Explore Bangor
      • Virtual Open Days and Visits
      • Virtual Student Experience

    Find a Course

    Order a Prospectus

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

    Student Profiles

    Student Videos and Vlogs

    • Choose Bangor
      • International Home
      • Why Bangor?
      • Location
      • Student Support
      • Contact Us
    • Apply
      • Entry Requirements
      • Tuition Fees and Scholarships
      • How to Apply
      • Already Applied
      • Study Abroad
      • Exchanges

    Country Specific Information

    Join us on a Virtual Open Day

    Bangor University International College

    Covid-19 Information

    • Research
      • Research Home
      • About Our Research
      • Research in our Academic Schools
      • Research Institutes and Centres
      • Research Portal
      • Research, Innovation and Impact Office (RIIO)
      • Energy
      • Research News
    • Postgraduate Research Opportunities
      • Postgraduate Research
      • Doctoral School
    • Events and Training Opportunities
      • Researcher Development
    • The University
      • About Us
      • Our Mission
      • Strategy 2030
      • Annual Review
      • 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
      • Funding for Collaborative Research and Development (R&D) & Innovation
      • Business Facilities and Networks
      • Consultancy, Specialist Expertise and Knowledge
      • Commercialisation and Intellectual Property (IP)
      • Student Placements and Internships in Business & Enterprise
      • Training and Continuing Professional Development
      • Degree Apprenticeships
    • Conferencing and Business Dining
      • Conferencing Facilities
      • Business Dining
    • Contacts
      • Research, Innovation and Impact Office (RIIO)
      • Get In Touch
    • News
      • Current News
      • Research News
      • Student News
    • Events
      • Events

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 2022-23
PPP-4012
2022-23
Ysgol Gwyddorau Dynol ac Ymddygiadol
Modiwl - 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.

Assessment Strategy

-threshold - Adequate answer to the question, largely based on lecture material. No real development of arguments.

-good - Reasonably comprehensive coverage. Well organised and structured. Good understanding of the material.

-excellent - Comprehensive and accurate coverage of the area clarity of argument and expression. Depth of insight into theoretical issues

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

Crynodol

Description

Assignment 2

Weighting

30%

Due date

13/12/2021

Assessment type

Crynodol

Description

Mini Project

Weighting

40%

Due date

17/01/2022

Assessment type

Crynodol

Description

Assignment 1

Weighting

30%

Due date

08/11/2021

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