module specification

BA3005 - Using and Managing Data and Information (2018/19)

Module specification Module approved to run in 2018/19
Module title Using and Managing Data and Information
Module level Foundation (03)
Credit rating for module 30
School Guildhall School of Business and Law
Total study hours 300
 
180 hours Guided independent study
120 hours Scheduled learning & teaching activities
Assessment components
Type Weighting Qualifying mark Description
Coursework 30%   Using Excel facilities
Unseen Examination 30%   Mathematics skills
Coursework 40%   Using Excel for basic data analysis
Running in 2018/19
Period Campus Day Time Module Leader
Year (Spring and Summer) City Friday Morning
Year (Spring and Summer) City Wednesday Morning
Year City Tuesday Afternoon
Year City Wednesday Morning
Year (Spring and Summer) City Tuesday Afternoon

Module summary

This module aims to provide students with a thorough overview of the numerical and technological skills needed to analyse data in the context of business analysis. The module encompasses aspects of mathematics, statistics and information technology relevant to not only the business management course but also to all other UG courses. The module focuses on numbers and data and their computational and analysis techniques that leads to the understanding of Accounting, Finance, Business, Aviation and Economics related information. Students will make use of a range of facilities on Excel to calculate, analyse and present efficiently.

Syllabus

Week 1-6     Introduction to Excel as a tool for
                        basic calculations,
                       dealing with percentages and fractions
                       dealing with finance
                       logical situations LO1


Week 7 to 15 Introduction to mathematical aspects such as
                        Precedence rules and rounding
                        Working with fractions and percentages
                       Using proportions and ratios
                       Powers and roots
                    Introduction to basic algebra
                    Linear graphs and their graphs
                    Simultaneous linear equations LO2


Week 16 to 25 Introduction to basic statistical techniques and use of Excel in
                    Labelling categories and naming variables on Excel
                    Analysing Nominal, ordinal and cardinal data
                   Scatter diagram and correlation
                   Time series analysis
                   Decision trees based on expected value LO3
                 
Week 26 to 30 Introduction to project management – Network diagram

Balance of independent study and scheduled teaching activity

PDP and Reflective learning are embedded in all modules at Level 3. In this module students will receive formative feedback on their practice as well as feedback on summative assignments enabling them to reflect on their progress.

Learning outcomes

On successful completion of the module students will be able to:

LO1: explore a range of facilities on Excel spreadsheet such as those of computational, financial and logical nature. [LO1]

LO2:  understand and strengthen the basic mathematical skills prevalent within business, management and commerce. [LO2]

LO3:  develop the basic skills for the statistical data analysis and the use of Excel to carry this statistical analysis efficiently. [LO3]

LO4:  demonstrate a range of skills including academic literacies and presentation skills.

Assessment strategy

 

• The assessment is developed to address the module learning outcomes and provide timely feedback to students. The assessment has three components:
• The first assessment will be on focusing on the use of spreadsheet as a tool for basic calculations, transforming and formatting numbers, saving and borrowing money, and as a logical tool.
• The second assessment will focus on strengthening the number skills and algebraic skills.
• The third assessment will focus on the use of Excel to carry out basic statistical analysis.

Bibliography

Textbooks:

Core Text:
Curwin, J & al, Quantitative Methods for Business decisions, 2013, Cengage

Other Texts:
Oakshott, L, Essential Quantitative Methods, 2012, Palgrave