How would you plan a spreadsheet?

By consolidating the data and creating a plan

What factors do you need to consider when evaluating your model?

How well it reflects the scenario

What will happen if the data is inaccurate

Errors will produce poor results in the data model

What is the scenario?

The context to the work and assignment

Where are functions found and what are they?

Functions are complex calculations inside the spreadsheet, Functions are ways to colour data

What is verification?

When data entry is checked to make sure that it is correct

Which answer below is an example of data formatting?

Changing the colour or appearance

What does an effective data model accomplish?

Analysing numbers and interpreting to make it understandable

Why do we check the currency of data?

Because the data will be less useful

A good data model would be able to…

Generate several possible solutions

Which 2 are part of stages to do with decision making?

Understanding the scenario, analysing information

The most important part of analysis is to

Know what data needs collecting and how to processed it

What choices do you need to justify in the decision-making process?

Your choice of information sources

What is a Block diagram?

Diagram that uses rectangles to represent parts of a system

studbud

Data Modelling Unit 5

27 termsStudBud Administration31 plays

#Questions that cover Learning Aim A

Flashcards27 cardsFPractice quizPHost liveL

Questions 27

Answers

1
How would you plan a spreadsheet?
By having no ideas and talking to the client about them
By spreading Nutella on a sandwich
By consolidating the data and creating a plan
By planning the UI
2
What does formulae start with?
*
=
-
%
3
What factors do you need to consider when evaluating your model?
Can the model be made on Mars
Communicating decisions
Whether you require a wireless mouse
How well it reflects the scenario
4
What will happen if the data is inaccurate
Errors will produce poor results in the data model
The worksheet will never be complete
The formulas will not work
A Korean dance move will conquer the entertainment industry
5
What is the scenario?
The context to the work and assignment
A fantastic dream where you meet a friend and have ice cream
A clip from a person's favourite movie
The work you do in a place of work and get paid to do so
6
What factors are there to consider about impacts and consequences?
Differences in cost
All of the above
Risk
Differences in timescales
7
Where are functions found and what are they?
functions are actions to data and are made by the user
Functions are complex calculations inside the spreadsheet
Function are used to lay out data into tables
Functions are ways to colour data
8
What is verification?
When data entry is analysed
When data entry is presented to the user
When data entry is checked to make sure that it is correct
A summary of data processed for statistics
9
How many stages are there in the decision making process?
8
7
6
9
10
What external factors can affect the data?
All of the above
New products on the market
Competition from other companies
A change in the weather
11
What do you call the thing you collected information from?
Bytes
Data
Source
Bits
12
Which answer below is an example of data formatting?
When data entry is checked
Changing the colour or appearance
Entering data into a worksheet
When data is linked between workbooks
13
What does an effective data model accomplish?
It contains data that is not understandable to the user
Good looking graphs
It contains unorganised information
Analysing numbers and interpreting to make it understandable
14
Why do we check the currency of data?
Because the data is always up to date
because the data will be wrong
Because of the wonderful Wizard of Oz
Because the data will be less useful
15
A good data model would be able to…
Generate several possible solutions
Generate no solutions
Show unorganised information
Generate one single solution
16
What are the rules you should go by when creating a spreadsheet?
The law
Data Validation
Data Protection Act
Protocols of the internet
17
Which 2 are part of stages to do with decision making?
Having a complete idea, communicating to others
Understanding the scenario, analysing information
Totally realising and then forgetting the question
Understanding the scenario making sure anyone can understand
18
What does currency of data mean?
How recent the data is
Who made the data
How accurate it is
How much data there is
19
The most important part of analysis is to
Know how long a piece of string is
Know what data needs collecting and how to processed it
Find out historical facts in order to create a news article
Produce scientific evidence before going on a picnic
20
Where is the data held in a spreadsheet?
Cells
Tabs
Rows
Columns
21
What is one of the better ways to present data?
Numbers
Graph
Text
Drawings
22
What is the final stage of the decision-making process?
Identify information sources
Communicating decisions
Understanding the scenario
Analysing Information
23
What can validation of and verification reduce?
functions
same data
Data entry errors
all of the above
24
What choices do you need to justify in the decision-making process?
Your choice of font
The thickness of borders
Your choice of information sources
The need for wireless connections
25
What is a good way of communicating with the client?
By text
Ignore them and they might go away
Through the supervisor
In person at meetings
26
Where do we get our valid information from?
Directly from the contact and company
The internet
Both answers 1 and 2
27
What is a Block diagram?
A diagram which uses shapes and lines to show decisions
Diagram that uses rectangles to represent parts of a system
A diagram which uses shapes and lines to show decisions
A diagram that calculates the meaning of life

Data Modelling Unit 5 Flashcards | StudBud