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 4 Hours   Online tests  - up to 4 online tests throughout the semester  100%
Supplementary Assessment 2 Hours   Online tests  - single online test  100%

Learning Outcomes

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

Using functions to manipulate data

Using formulas to present data

Preserving data integrity

Visualising data in charts

Using scripting language to produce macros

Brief description

This module provides an introduction to using spreadsheets to process, preserve, analyse and visualise data. It also uses macro scripting to solve problems.


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 is taught through 1 hour of lecture and 2 hours in a computer lab each week.

Week 1: Introduction; spreadsheet basics including calculations and sorting data
Weeks 2 – 3 : Importing data; applying text functions
Weeks 4 – 7: Data validation, data integrity, name manager, conditional formatting., LOOKUP functions, visualising data in charts
Week 8: The strengths and dangers of macros; first steps in macro programming
Week 9: Identifiers, assignments; conditionals, loops & animations
Week 10: More complex animation
Week 11: Debugging code; code quality & commenting

Module Skills

Skills Type Skills details
Application of Number Yes
Communication Yes in assignments
Information Technology Yes in assignments
Problem solving Yes in assignments
Research skills Yes in assignments
Subject Specific Skills Yes, basic programming


This module is at CQFW Level 3