Skip to main content
Home

Information for:

  • Alumni
  • Applicants
  • Current Students
  • Staff
  • Parents
  • Job Vacancies
  • Covid-19
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
      • 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
      • 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
      • Annual Review
      • Our Location
      • Academic Schools and Colleges
      • Services and Facilities
      • University Management and Governance
      • Vice Chancellor’s Office
      • Working with Business
      • Working with the Community
      • Sustainability
      • Contact Us
    • Working for Us
      • Job Vacancies
    • University Management and Governance
      • Policies and Procedures
      • Slavery and Human Trafficking Statement
    • 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
      • Annual Review
      • Our Location
      • Academic Schools and Colleges
      • Services and Facilities
      • University Management and Governance
      • Vice Chancellor’s Office
      • Working with Business
      • Working with the Community
      • Sustainability
      • Contact Us
    • Working for Us
      • Job Vacancies
    • University Management and Governance
      • Policies and Procedures
      • Slavery and Human Trafficking Statement
    • 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

Share this page:
  • Twitter
  • Facebook
  • LinkedIn

Share this page:
  • Twitter
  • Facebook
  • LinkedIn

Module PPP-4012:
Practical Programming

Module Facts

Run by School of Psychology

20.000 Credits or 10.000 ECTS Credits

Semester 2

Organiser: Dr George Houghton

Overall aims and purpose

The course is intended for students who would like to add computer programming to their repertoire of research skills. It does not assume previous experience of programming, but students should have (i) good numeracy skills, as we focus on handling numerical data and numerical computations. (ii) a solid understanding of basic statistics, including descriptive statistics, variance, correlation and the t-test. (iii) previous experience of using Excel, especially to handle experimental data. The course is practically oriented in the sense that (1) it is taught largely by doing, in lab sessions, and assessed by the completion and write-up of working computer programs; and (2) the programs we write are oriented towards the manipulation of data of the form typically generated by psychological experiments (e.g., reaction times).

The programming language we study is Visual Basic (VB), which enables you to create a visual user interface to your program. So as well as studying common elements of computer programming, we also spend time learning about the basics of visual interface design, and the kinds of common visual “controls” (clickable buttons, menus, lists of options etc.) typical of Windows-type interfaces.
A variety of VB, Visual Basic for Applications (VBA), is used as a scripting language in many applications of use in psychological research (Excel, E-Prime, Statistica). We study VBA in the context of Excel to automate data analyses on spreadsheets (e.g., multiple t-tests, adaptive detection and removal of outliers). This is taught in the latter part of the course; prior experience of using Excel to handle data (i.e. of using the spreadsheet interface) is assumed.

The programming environments we use are either made available by the university (e.g., under the MS Office suite) or are freely available. Hence you will be able to work on your programs away from the lab on your home PC or laptop (N.B. Apple Macs are NOT recommended).

Course content

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 Criteria

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

  1. 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.

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

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

Assessment Methods

Type Name Description Weight
Assignment 1 30.00
Assignment 2 30.00
Mini-Project 40.00

Teaching and Learning Strategy

Hours
Practical classes and workshops

Teaching is entirely hands-on in a weekly 3 hour practical class using PCs. Classes are usually scheduled in one of the computer rooms in main arts. Each practical class is accompanied by a written "Walkthrough" available on blackboard; however the classes typically include material not found in the walkthrough, depending on student-tutor interaction during the class. Efforts are made to provide suitable TA support. Written "Course Notes" are also made available on Blackboard; these are reference documents for the central programming structures covered in the course.

There are no formal lectures.

33
Private study

Students are expected to revise and practice the programming principles covered in the class in the their own time. All assessment if by the development and write-up of working computer applications. The assessment grading places emphasis on students showing a productive/creative grasp of the principles taught. This can only be achieved by working on programs in ones own time.

167

Transferable skills

  • Numeracy - Proficiency in using numbers at appropriate levels of accuracy
  • Computer Literacy - Proficiency in using a varied range of computer software
  • Self-Management - Able to work unsupervised in an efficient, punctual and structured manner. To examine the outcomes of tasks and events, and judge levels of quality and importance
  • Exploring - Able to investigate, research and consider alternatives
  • Critical analysis & Problem Solving - Able to deconstruct and analyse problems or complex situations. To find solutions to problems through analyses and exploration of all possibilities using appropriate methods, rescources and creativity.
  • Presentation - Able to clearly present information and explanations to an audience. Through the written or oral mode of communication accurately and concisely.

Subject specific skills

  • Be computer literate for the purpose of processing and disseminating psychological data and information.
  • Use effectively personal planning and project management skills.
  • Work effectively under pressure (time pressure, limited resources, etc) as independent and pragmatic learners.
  • Problem-solve by clarifying questions, considering alternative solutions, making critical judgements, and evaluating outcomes.
  • Use a range of statistical methods with confidence.

Resources

Resource implications for students

Students would benefit from access to a home PC/PC laptop, though in principle all the work can be carried out on University equipment.

Reading list

N/A

Courses including this module

Optional in courses:

  • C8BZ: MRes Psychology year 1 (MRES/PSYCH)
  • C8EY: MSc Applied Marketing Science year 1 (MSC/AMS)
  • C8CU: MSc Neuroimaging year 1 (MSC/N)
  • C8DU: MSc Psychology year 1 (MSC/PSY)
  • C8AL: MSc Psychological Research year 1 (MSC/PSYRES)
  • C807: MSci Psychology year 4 (MSCI/PS)

Home

About Us

Academic Schools and Colleges

  • School of Psychology
    • Home
    • About the School
      • Our Location
      • 360 Tours
      • Bangor and the Area
      • Our Staff
      • Contact us
      • Athena Swan
    • Our Staff
    • Undergraduate Study
      • Why psychology?
      • Order a prospectus
      • University Open Days
      • Why Bangor?
      • Get ready for University
      • Accommodation
      • Scholarships & Bursaries
      • Fees & Finances
      • Applying to Bangor
      • Careers & Employability
      • Student Life
      • Studying at Bangor
      • Student Support
      • UCAS Visit Days
      • Psychology Learning Experience
      • FAQ and links
    • Postgraduate Study
      • Why study with us?
      • Why continue to study?
      • Postgraduate Open Days
      • Order a prospectus
      • Fees & Finances
      • Scholarships & Funding
      • Entry requirements
      • Applying to Bangor
      • Accommodation
      • Student Support
      • Student Life
      • Studying at Bangor
      • Modules
      • Research Seminars
    • International
      • International Students
      • International Student Ambassadors
      • International Study Abroad and Programmes for Students
      • International Mobility for Staff
      • International Experience Year
    • Videos and Student Profiles
    • Order a prospectus
    • Open Days and Visits
      • Undergraduate Open Days
      • Postgraduate Open Days
    • Psychology in Welsh
      • Studying in Welsh
      • Welsh staff members
      • Welsh Modules
      • Scholarships and Internships
      • Further study
      • Contact us
    • Research and Impact
      • Research groups
      • Centres
      • Facilities
      • Research students
      • REF 2014
      • Research Seminars
        • Past seminars: 2020–2021
        • Past seminars: 2019–2020
        • Past seminars: 2018–2019
        • Past seminars: 2017–2018
        • Past seminars: 2016–2017
        • Past seminars: 2015–2016
        • Past seminars: 2014–2015
        • Past seminars: 2013–2014
        • Past seminars: 2012–2013
      • Ethics system
    • Connect on social media
    • News
Home

Follow Us

  • Twitter
  • Facebook
  • Instagram
  • Youtube
  • LinkedIn

Bangor University

Bangor, Gwynedd, LL57 2DG, UK

+44 (0)1248 351151

marketing@bangor.ac.uk

Visit Us

Maps & Directions

Policy

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

Bangor University is a Registered Charity: No. 1141565

© 2020 Bangor University