School of Management, Unit Catalogue 2011/12
|Level:||Certificate (FHEQ level 4)|
|Supplementary Assessment:||Like-for-like reassessment (where allowed by programme regulations)|
|Requisites:||This unit is not available to visiting/exchange students.|
This unit aims to provide students with the knowledge and skills to be able to conduct their own manipulation and analysis of complex datasets in academic and business settings. Both individuals and organisations benefit if work with data is performed by those who understand its context, rather than relying specifically on separate IT Departments. Students will become expert, as distinct from novice, users of the applications covered on the unit and be able to use those applications independently when on placement, in employment or in other settings.
By the end of the unit, students will have:
* acquired competence in a set of advanced features of commonly-used software applications.
* developed an understanding of the uses to which these applications can be put in business.
Intellectual - translation of problem requirements to implemented solutions (facilitated and assessed); understanding of software applications in business (taught).
Practical - ability to use common software packages at an advanced or "power-user" level (taught, facilitated and assessed).
Key skills - use of Information Technology (taught, facilitated and assessed); evaluation of own production (assessed).
The unit is essentially practical in orientation and is based around a series of practical classes and workshops. Lectures are used to set the business and technology context surrounding the use of the software in organisational life. The exercises used will develop competencies in the use of a variety of forms of software which are commonly used in business. Students will also be expected to understand the uses to which those software applications can be put in organisations. Relevant forms of software will vary as the technology changes, but a representative sample would include:
* Spreadsheets: built-in functions; manipulation of data using complex functions and pivot tables; developing user-created functions using Visua Basic for Applications (including conditional statements, loops and programming logic).
* Desktop Database Management System (e.g. MS Access); use of desk-top databases as reporting tools; simple and complex queries; production of reports and summary data; understanding database construction.
MN10004 is Compulsory on the following programmes:School of Management