Where are functions found and what are they?

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

Which answer below is an example of data formatting?

Changing the colour or appearance

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

What does an effective data model accomplish?

Analysing numbers and interpreting to make it understandable

What will happen if the data is inaccurate

Errors will produce poor results in the data model

How good was this quiz?

Not good, Really good, Really really good, Good

How would you plan a spreadsheet?

By consolidating the data and creating a plan

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

Your choice of information sources

What is the scenario?

The context to the work and assignment

What is verification?

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

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

How well it reflects the scenario

The most important part of analysis is to

Know what data needs collecting and how to processed it

Why do we check the currency of data?

Because the data will be less useful

studbud

Practical Data Modelling Unit 5 Assignment 1

27 termsStudBud Administration21 plays

#revision of practical spreadsheet use

Flashcards27 cardsFPractice quizPHost liveL

Questions 27

Answers

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

Practical Data Modelling Unit 5 Assignment 1 Flashcards | StudBud