INFORMATION FOR BUSINESS AND MANAGEMENT

SHE Level 1
SCQF Credit Points 10.00
ECTS Credit Points 5.00
Module Code M1L112552
Module Leader n/a
School INTO
Subject INTO
Trimesters
  • A (September start)
  • B (January start)

Pre-Requisite Knowledge

None

Summary of Content

This module provides an understanding of the processes associated with the transfer of data to information and the presentation and analysis of such information to support management decision making. This includes numeracy and quantitative skills incorporating data analysis, interpretation and extrapolation. The module imparts the skills required to allow the student to gather and sort basic data sets and to understand the appropriateness of data and using packages from the Microsoft Office Suite to manipulate and analyse various data types. This involves - i) A combination of principles of elementary modelling, including logical tests and simple formulae creation; ii) statistical analysis - including collation, central tendency and dispersion; iii) database development - including table structures, querying, form creation; reporting and integration. Overall pass mark of 40% is required for the module, both components of which must have a minimum mark of 30%.

Syllabus

The module adopts a philosophy of exploring the transformation of business data into business information. In undertaking such a transition process the student will be exposed to concepts and techniques of data searching and search design, e.g. data processing, statistical collation and analysis. The statistics section of the module establishes principles of data analysis before applying appropriate technology (e.g. database and spreadsheet work) to analyse data in the context of appropriate business concepts.

Learning Outcomes

On successful completion of this module a student should be able to:Examine and manipulate business data in the context of the student's chosen programme.Sort, select, format and visualise data to support statistical analysis and evaluation.Perform selected quantitative data analysis with a view to supporting business decisions and solving business problems, pertaining to the student's programme.

Teaching / Learning Strategy

This module is delivered via three direct contact modes and is supported by directed independent learning. A range of course materials and practise exercises are provided. Feedback is provided through a number of channels - 1.By tutors during supervised labs 2.Through sample answers on Blackboard 3.Through computerised automated marking The practical laboratory work is devoted to: (i) dedicated spreadsheet work, (ii) development and use of databases. (iii) statistical data analysis using practical labs in conjunction with Excel-based applications. The practical laboratory work is timetabled to provide two supervised hours per week, where students study the aforementioned range of course materials and develop solutions to the practise assessment exercises. In addition, a two-hour Drop-in Clinic will be available each week, where students can access additional tutor support as needed.

Indicative Reading

Manzo, J, Excel 2007 in Business, , 2008, Pearson, ISBN 978-0-13-174344-1 Manzo, J, Access 2007 in Business, , 2008, Pearson, ISBN 978-0-13-174341-0

Transferrable Skills

The students will develop a range of cognitive and intellectual skills together with techniques specific to the management of information. In particular the student will develop effective problem solving and decision making skills around the transformation of data to information and its presentation. In this respect, numeracy skills in the interpretation of data based on a business context will be developed.

Module Structure

Activity Total Hours
Independent Learning (FT) 3.00
Practicals (PT) 18.00
Lectures (FT) 1.00
Assessment (PT) 40.00
Tutorials (FT) 38.00
Tutorials (PT) 38.00
Lectures (PT) 1.00
Assessment (FT) 40.00
Independent Learning (PT) 3.00
Practicals (FT) 18.00

Assessment Methods

Component Duration Weighting Threshold Description
Exam (School) 1.00 50.00 35% Structure and develop a database to solve an identified business problem; generating a report and query information retrieval.
Exam (School) 1.50 50.00 35% Spreadsheet Development including statistical analysis