This is the Pearson BTEC Level 3 Information Technology, Unit 5, assignment 1. Covering the criteria in detail and was awarded a Distinction. With an easy to follow format and structure, guaranteed to help you get the best grade possible! Led me to receive a Distinction* overall in IT.
Unit 5 : Data
Modelling
Learning Aim A: Investigate Data Modelling and
how it can be used in the decision-making
process
, Contents:
▸ Introduction Slide 3
▸ What is Spreadsheet Software? Slide 4
▸ What is Data/Spreadsheet modelling? Slide 5
▸ A.P1 The stages involved in the decision-making process for data modelling Slide 6-12
▸ A.P2 How the features of spreadsheet software are used to support the decision-making process Slide 13-27
▸ Different types of data models Slide 28-33
▸ A.M1 How the features of spreadsheet software contribute to the decision-making proce
ss
slide 34
▸ A.D1 Evaluation of how spreadsheet software features would help support the leisure centres decision –making Slide 35
2
, Introduction
▸ I am here today because the local leisure Centre would like to
start a new program that will help people to become fitter and
healthier by reducing their Body Mass Index (BMI).
▸ At the end of this process, I will have created a spreadsheet
model that can predict how a person’s BMI would change
throughout 10 weeks minimum, based on their activities and
diet. The model will calculate each week’s calorie intake, the
number of calories burned, the weight change, and their BMI.
▸ However, before developing the model, I will be talking about
features and uses of a spreadsheet within this PowerPoint.
3
, What is Spreadsheet
Software?
Spreadsheet software is a software
application capable of organising, storing
and analysing data in a table form. The
spreadsheet allows you to represent data
in tables, graphs and charts. You are then
able to manipulate the data using
formulas and formatting tools.
4
, What is Data /Spreadsheet
Modelling?
▸ Data modelling is the process of creating a data
model for the data to be stored in a database by
applying certain techniques.
▸ Data Modelling/Spreadsheet Modelling is used
to help consider alternative choices
5
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller AcademicElevateHub. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £7.49. You're not tied to anything after your purchase.
