Module Information
Module Identifier
CS01010
Module Title
Spreadsheets for University Students
Academic Year
2017/2018
Co-ordinator
Semester
Semester 1
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%
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