Spreadsheets for University Students

Module Identifier: CS01010
Module Title: Spreadsheets for University Students
Academic Year: 2027/2028
Semester: Semester 1
Co-ordinator: Dr Muhammad Aslam
Reading List: View on Aspire
Other Staff: Dr Muhammad Aslam

Assessment

Assessment Type	Assessment details	Proportion
Semester Assessment	Online tests: 4 Hours - up to 4 online tests throughout the semester	100%
Supplementary Exam	Online tests: 2 Hours - 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.

Aims

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.

Content

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

Notes

This module is at CQFW Level 3