Font size
Worksheetsuntitled
Total questions: 55
Worksheet time: 1hrs 17mins
Which type of data validation ensures that a value falls within a specific range?
Input mask
Range check
Limited choice
Presence check
What type of data validation verifies that a required field is not left blank?
Range check
Limited choice
Format check
Presence check
Which data validation type allows you to select an option from a predefined list?
Range check
Presence check
Limited choice
Input mask
What type of data validation enforces a specific format, such as a phone number or email address?
Range check
Presence check
Limited choice
Format check
Which data validation type specifies a pattern or template for entering data?
Range check
Presence check
Limited choice
Input mask
What type of data validation ensures that data is entered in a specific format, such as using uppercase letters or numerical values?
Range check
Presence check
Limited choice
Format check
What validation type would ensure that letters have been entered instead of digits on a form?
Length Check
Data Type Check
Presence Check
Which of the following statements is false?
Validation can check that the data is sensible
Validation can check that the data falls between certain allowable boundaries
Validation can check that the data is correct
I want to ensure that users enter a name into the Surname field. Which type of validation should I use?
Length check
Check digit
Presence check
Format check
I want to ensure that users enter a national insurance number that follows the pattern letter letter number number number number number number letter?
Length check
Format check
Check Digit
Presence Check
One of these is a type of validation
Hardware
Emotional
List
Spreadsheet
Which of the following is NOT a method of verification?
Double entry - typing the data in twice and getting the computer to check the second version against the first
Using presence, range and length checks to make sure that no mistakes happen
Printing out what you have typed in and comparing it against the source data
An error message saying "The pupil must be aged between 11 and 16" is an example of a
Range check
Lookup check
Format check
Presence check
Checking that data entered matches the original source is...
Verification
Validation
Voldemort
Checking that the data entered is sensible is called:
(a)
Checking thst the data entered is what was intended is called:
(a)
Which interval represents the greatest number of songs
2.5 - 2.99
3 - 3.49
3.5 - 3.99
4 - 4.49
How many students have a shoe size bigger than 8?
2
3
9
4
Which two animals combine to equal 60?
seahorse and octopus
jellyfish and starfish
octopus and jellyfish
starfish and seahorse
How many more pretzels were sold on Friday than on Tuesday?
50
45
40
35
Molly collected data about the number of hours students studied and their scores on a test. The results are shown in the scatter plot. Which statement about the data is true?
As study hours increase, test scores decrease.
As study hours increase, test scores increase.
As study hours increase, test scores stay the same.
As study hours decrease, test scores increase.
STAGE 1: IDENTIFY THE N (a) (write the full word)
stage 2: define the s (a) (type the full word)
make sure any information you gather is un-b (a) (type full word)
final stage of data analysis: s (a) the results (type full word)
draw a sad clown
draw a graph that shows how much you enjoy school the longer the day goes on
This is...
Information
Data
What is data?
A formula for converting information.
Raw facts and figures before they have been processed.
Information in context.
Processed information.
Which are the correct data types?
Text.
Currency.
Division.
Fraction.
Single letter.
What are the main points of data?
Data has no meaning
Data is information open to the public
Data is raw facts and figures before they have been processed
Data can be made up of letters, numbers, symbols, graphics and sound
True or False belongs to which data type?
Alphanumeric
Text
Boolean
Limited choice
What is information?
Information when processed creates data
Information is nothing without data
What type of data is this?
01825-764844
Number
Text
Alphanumeric
Raw
What type of data restricts the choice by a user often example is a drop-down list or radio button or tick list
Object
Limited choice
Boolean/logical
Integer
What type of data is the following "1960"
Integer
Alphanumeric
Currency
Real
Which value is an Integer?
64
"cat"
True
0.5
What are numbers, pictures or words without context known as?
Data
Information
Knowledge
What does putting data into a framework or structure provide?
More information
Rules
Context
What is the ability to understand information and to then form judgements, opinions, make predictions and decisions based on that understanding also known as?
Data
Infomation
Knowledge
Which of the following is NOT an example of data?
301062
Blue
32, Primrose Hill
'The petrol gauge was showing almost empty. I decided to look out for the next petrol station'. What is the statement 'I decided to look out for the next petrol station' an example of?
Data
Information
Knowledge
Q11. How many students spent 7 hours doing homework that week?(1 mark)
6
5
7
4
Q12. How many total students are represented by the histogram?(1 mark)
32
31
35
8
Q13. What is the MEDIAN of this data?(1 mark)
95
90
100
40
Q14. What was the difference between the cars sold on Monday and Tuesday than the cars sold on Friday and Saturday? (1 mark)
4
3
2
1
Q15. What is name of the chart pictured below? (1 mark)
Graph chart
Pie chart
Line chart
Bar chart
Q16. What is name of the chart pictured below? (1 mark)
Graph chart
Pie chart
Line chart
Bar chart
