Module Information

Module Identifier
Module Title
Spreadsheets for University Students
Academic Year
Semester 1
Reading List
Other Staff

Course Delivery



Assessment Type Assessment length / details Proportion
Semester Assessment 3 Assignments Practical exercises with spreadsheets.  100%
Supplementary Assessment Resubmission of failed/non-submitted coursework components or ones of equivalent value Practical exercises with spreadsheets.  100%

Learning Outcomes

On successful completion of this module students should be able to:

Use software in a confident way to solve very basic IT tasks, such as:
1. Importing Data.
2. Using formulas.
3. Producing charts.
4. Using VBA for more advanced tasks.

Brief description

This module provides an introduction to using spreadsheets and VBA programing. The emphasis will be on using spreadsheets effectively to analyse and visualise data.


The module aims to increase students’ speed and fluency at using the computing equipment at Aberystwyth, with an emphasis on skills necessary for their future course.


This module will be taught in a number of blocks, entirely in a computer lab. In each block students will be introduced to a feature of the software and then asked to use it in a small task.

Block 1 (weks 1 & 2): Finding your way around Excel. Running the program, reading, writing and importing data, sheets, referencing cells. Summative task 20%

Block 2 (week 3-6): Using formulae in Excel to solve a problem. Producing charts. Dragging formulae and using the $ notation. Summative task 40%

Block 3 (weeks 7-11): Using VBA in Excel to solve a problem. Basic VBA programming. Summative task 40%

Module Skills

Skills Type Skills details
Application of Number Yes
Communication Yes in assignments
Improving own Learning and Performance No
Information Technology Yes in assignments
Personal Development and Career planning No
Problem solving Yes in assignments
Research skills Yes in assignments
Subject Specific Skills Yes, basic programming
Team work No


This module is at CQFW Level 3