|Delivery Type||Delivery length / details|
|Lecture||11 x 1 Hour Lectures|
|Practical||11 x 2 Hour Practicals|
|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%|
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.
This module provides an introduction to using spreadsheets and VBA programing. The emphasis will be on using spreadsheets effectively to analyse and visualise data.
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.
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%
|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|
This module is at CQFW Level 3