Module Information
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
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