HU0S011 - Advanced IT 18 Sep 2018 - 31 Aug 2027 | Version 3
Associated Module Information
| Module Code: | HU0S011 | ||
|---|---|---|---|
| Module Title: | Advanced IT | ||
| Faculty: | Faculty of Business and Creative Industries | ||
| Faculty Group: | Culture and Animation | ||
| Faculty Sub Group: | Culture | ||
| Module Leader: | Philip Probert, Adam Poole | ||
| Module Team: | |||
| First Intended Intake: | SEP 2014 | Final Year of Intake: | |
| Date Closed: | |||
| Credit Value: | 20 | Credit Level: | 3 |
| Language: | English | ||
| Percentage of Module Taught in Welsh: | 0 | ||
| Equivalent Module: | |||
| HECOS codes: | 100372 - information technology | ||
| HECOS Code Weighting: | 100 | ||
Document Version Information
| Version | 3 |
|---|---|
| Valid From | 18 Sep 2018 |
| Valid To | 31 Aug 2027 |
Module Aims
To develop learners' ability to edit and organise data within a spreadsheet using appropriate formulae, tools and presentational techniques.
Content Summary
This module will enable learners to create and organise data in a logical and aesthetic fashion within a spreadsheet. They will learn to use inbuilt and created formulae to process a range of data types obtained from a range of sources. Analytic techniques will be applied through the use of tools and inbuilt and/or created functions and formulae.
The learner’s ability to select and apply appropriate presentational forms will be developed through creating charts using a range of differing data. The They will format graphical data representations through axis, titles, applying colour and fonts, and adjusting scales.
Learning and Teaching Methods
| Activity Type | Hours |
|---|---|
| Lecture | 30 |
| Practical classes and workshops | 30 |
| Directed Study | 140 |
| Total Hours Selected | 200 |
Learning Outcomes
| # | Learning Outcome |
|---|---|
| LO1 | To use spreadsheets to enter and structure numerical and other information types making use of a wide range of analytic and other inbuilt and/or created formulae. |
| LO2 | To use appropriate tools and techniques to generate, develop and format spreadsheets and a range of charts and graphs |
Module Requisites
N/A
Assessment Criteria
| Assessment Category | Assessment Type | Description | Duration | Word Count | Weight (%) | Best of? | Pass Mark |
|---|---|---|---|---|---|---|---|
| Written Assignment (CW) | Project (CW) 2 | Application of spreadsheets in the online digital medium | 0 | 1500 | 50 | No | 40 |
| Written Assignment (CW) | Project (CW) 1 | Staged project showing development of spread sheet skills | 0 | 1500 | 50 | No | 40 |
Assessment Matrix
| Assessment Type | Learning Outcomes | ||
|---|---|---|---|
| LO1 | LO2 | ||
| Project (CW) 2 | ✔ | ✔ | |
| Project (CW) 1 | ✔ | ✔ | |