# module specification

## BA3005 - Using and Managing Data and Information (2024/25)

Module specification Module approved to run in 2024/25
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

 198 hours Guided independent study 72 hours Scheduled learning & teaching activities 30 hours Placement / study abroad
Assessment components
Type Weighting Qualifying mark Description
Group Presentation 20%   15-20 Min Video Presentation
Coursework 40%   Use of Mathematics in Business
Coursework 40%   Using Excel for basic data analysis
Running in 2024/25

(Please note that module timeslots are subject to change)
Period Campus Day Time Module Leader
Year North Monday Morning
Year North Monday Afternoon
Year North Tuesday Morning
Year North Tuesday Afternoon
Year North Wednesday Morning
Year North Wednesday Afternoon

## Module summary

This module aims to provide students with a thorough overview of the numerical and Excel/spreadsheet skills needed to analyse data in the business context as well as dealing with the numerical aspects of business and management. 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 numerical data 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:   Apply a range of facilities on Excel spreadsheet such as those of computational, financial and logical nature. [LO1]

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

LO3:  Calculate the key descriptive statistics in data analysis using few Excel facilities and interpret them efficiently. [LO3]