Font size
WorksheetsBTEC DIT Component 2 Super Quiz
Total questions: 26
Worksheet time: 15mins
Which characteristic describes data?
Has meaning
No structure
Has context
Is processed
Which characteristic describes information?
No meaning
No structure
No context
Is processed
Pick out the correct description of qualitative information.
Information that describes qualities that cannot be represented numerically.
Data that describes data that can be measured and best represented by numbers.
Data that describes qualities that cannot be represented numerically.
Information that describes information that can be measured and best represented by numbers.
Pick out the correct description of quantitative information.
Information that describes qualities that cannot be represented numerically.
Data that describes data that can be measured and best represented by numbers.
Data that describes qualities that cannot be represented numerically.
Information that describes information that can be measured and best represented by numbers.
Select all the sentences below that describe advantages to using text to represent information.
Can be very detailed.
Can be difficult to understand on its own unless it is supported by pictures or diagrams, like in an instruction book or manual.
User needs to understand the language the text is written in.
Provides a permanent record (unlike spoken information that isn’t recorded.)
Can be used in noisy environments where it may be hard to hear someone speaking.
What type of data is being described?
-Data gathered from the original source.
-Reliable as you know the accuracy of the data.
-Takes a long time to gather & therefore is expensive.
(a)
What type of data is being described?
-Data gathered by someone other than the person using the data.
-May be unreliable as you don't know if the data is truthful.
-Quick & cheap as the data has already been collected.
(a)
Select the primary source.
Wikipedia
Opinion Poll
Questionnaire
Textbook
Which company has the record for leaking the largest amount of user data?
Microsoft
Yahoo
Apple
Which type of threat is being described: The unemployed or seriously ill may be targeted by scams.
Invasion of Privacy
Fraud
Vulnerable Groups
Inaccurate Date
Which mathematical symbol do all formulae and functions in a spreadsheet need to start with?
+
/
-
=
What does the COUNT function do?
Counts the number of cells in a range of data.
Counts all the cells being used in a spreadsheet.
Counts the number of cells in a range that meet a certain criteria.
Counts the number of cells in a range that contain numbers.
Which of these VLOOKUP functions will work?
=VLOOKUP(E2,A2:C5,3,FALSE)
VLOOKUP(E2,A2:C5,3,FALSE)
=VLOOKUP(E2.A2:C5.3.FALSE)
=(VLOOKUP,E2,A2:C5,3,FALSE)
What symbol is used to make an absolute cell reference?
£
$
¥
€
What is an absolute cell reference?
Refers to an exact, specific cell.
Refers to a cell that can't be edited.
Refers to an important cell.
Refers to a cell that will change when copied.
What symbol do we use in a formulae or a function to refer to a cell in a different sheet?
=Sheet1‽A1
=Sheet1?A1
=Sheet1;A1
=Sheet1!A1
What is a macro?
A button you can click on a spreadsheet.
A method of automating actions.
A programming language.
A small mammal found in Australia.
What is data validation?
It ensures that data entered is sensible.
It ensures that data entered is correct.
It makes the user enter data into a cell.
It makes the user enter a password to access data.
What spreadsheet feature allows you to make a heat map?
Pivot Tables
Macros
Conditional Formatting
Data Validation
What spreadsheet feature allows you to make a drop down list?
Pivot Tables
Macros
Conditional Formatting
Data Validation
A sweet shop wants to track their total sales each month over the past year. What would be the most appropriate presentation method?
Pie Chart
Table
Line Graph
Bar Chart
What is a pivot table?
A table that can be extended out for when family come for dinner.
A table that is formatted with borders and headings.
A way to quickly and easily summarise large amounts of data.
A graph or chart in a single cell.
Tesco have noticed that every month this year the sales of Bananas have increased by 10%
This is an example of a (a)
Pure Gym Stockport have noticed that they are very busy every Wednesday evening, they always have 15% more members in the gym than on other weekday evenings. This is an example of a (a)
ALDI have discovered that they are 50% busier from mid-November to January every year. Their data analyst is recommending that they should hire teams of temporary employees during the winter period each year to cover the extra shifts this creates. What type of recommendation is this?
Targeted Advertising
Deploying Staff
Adapting Transport Schedules
O2 have hired a data analyst to help them decide which companies phones to stock next year. The data analyst used to work for Apple and is now showing them charts and graphs that always make iPhones look like the best choice. What could be a problem here?
Misunderstanding information
Inaccurate conclusions being made
Information being biased
