What is verification?

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

What is a Block diagram?

Diagram that uses rectangles to represent parts of a system

What does an effective data model accomplish?

Analysing numbers and interpreting to make it understandable

Where are functions found and what are they?

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

A good data model would be able to…

Generate several possible solutions

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 factors do you need to consider when evaluating your model?

How well it reflects the scenario

Why do we check the currency of data?

Because the data will be less useful

How would you plan a spreadsheet?

By consolidating the data and creating a plan

What will happen if the data is inaccurate

Errors will produce poor results in the data model

Which answer below is an example of data formatting?

Changing the colour or appearance

The most important part of analysis is to

Know what data needs collecting and how to processed it

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

Understanding the scenario, analysing information

studbud

Data Modelling Unit 5 Assignment 1

28 termsStudBud Administration194 plays

#Questions that cover Learning Aim A

Flashcards28 cardsFPractice quizPHost liveL

Questions 28

Answers

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

Data Modelling Unit 5 Assignment 1 Flashcards | StudBud