Order this Assignment Now: £89
LO1: Apply a range of facilities on Excel spreadsheet such as those of computational, financial and logical nature.
2021-09-02T03:29:46+00:00
BA3005 - Using and Managing Data and Information (2021/22)
Module specification
2021/22
Module title
Using and Managing Data and Information
Module level
Foundation (03)
Credit rating for module
30
School
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
In-Course Test
10%
In class multiple choice test - 2 hours
Group Presentation
20%
15 min presentation
Coursework
70%
Using Excel for basic data analysis
2021/22
Period Campus Day Time Module Leader
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]
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.
Order this Assignment Now: £89
Email: care@academiasupport.co.uk
100% Plagiarism Free & Custom Written, Tailored to your instructions