Module Information

Module Identifier
CS01010
Module Title
Spreadsheets for University Students
Academic Year
2017/2018
Co-ordinator
Semester
Semester 1
Reading List
External Examiners
  • Dr John Hunt (Chief Operating Officer - Mallon Associates International)
 
Other Staff

Course Delivery

Delivery Type Delivery length / details
Practical 11 x 3 Hour Practicals
 

Assessment

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.

Content

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%

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.

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.

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

Notes

This module is at CQFW Level 3