Gwybodaeth Modiwlau

Module Identifier
CS01010
Module Title
Spreadsheets for University Students
Academic Year
2024/2025
Co-ordinator
Semester
Semester 1
Reading List
Other Staff

Course Delivery

 

Assessment

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.

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