Font size
WorksheetsCambridge Technical in IT Unit 2 LO1-5
Total questions: 60
Worksheet time: 30mins
Which stages of data analysis identifies the content, detail, time scales, constraints?
Identify the need
Define scope
Identify potential sources
Source and select information
Which stages of data analysis identifies the sales figures, customer surveys?
Identify the need
Define scope
Identify potential sources
Source and select information
Which stages of data analysis determines the accuracy and reliability of the sources, selecting the best?
Identify the need
Define scope
Identify potential sources
Source and select information
Data _____ helps ensure that incorrect data is not entered.
Integrity
Checks
Accuracy
Validation
A spreadsheet program is used to store data in:
A database
A text document
Rows and columns
Letters and numbers
A ___________________ is a visual representation of data
Spreadsheet
Border
Chart
Table
Which of the following is an example of data cleaning?
Deleting data
Removing customers who have not made a purchase in 2 years
Optimising the servers
Removing customers who have purchased an item last month
Select 3 examples of a geographic information system or location mapping.
Tracking shipping containers
Google maps
Locating the phone of a criminal
Website
Which of the following 2 statements describe a closed system?
A playground for hackers
You can't use it unless you have access
Where anyone can access and use it
Where you can't access it unless you have permission
Which is a disadvantage of open systems?
More effective communication.
More effective planning
More effective problem solving
It requires specialist knowledge to set up and run
An open system is a system where data can flow in and out freely
True
False
Which Category of information is the following in?
Use a bank statement to plan for a holiday
Research
Location dependent
Entertainment
Financial
Which Category of information is the following in?
Use a shared calendar to plan meeting dates
Communication
Education & training
Entertainment
Planning
Which category of information stores location and contact details of each charity worker in a disaster area?
Knowledge management and creation
MIS - management information systems
Marketing, promotion and sales
Financial analysis and modelling
Which category of information stores the annual web clicks of a major online retailer?
Contact management
Decision making
Internal and external communication
Big data
Which of these is not a type of information style?
Colour
Text
Table
Audio
Information which is regarded as _________ is subject to stricter rules
sensitive
important
additional
dangerous
An example of non-sensitive information is an address of a shop, true or false?
True
False
What information classification is about the individual?
Personal
Classified
Confidential
Sensitive
Information is NOT confidential in which of the following circumstances?
If no one has told you the information is confidential
If you think telling will not hurt anyone
The information can be found in public records.
The information is not on the Internet yet.
Adding new members to a database is an example of...
Collecting, storing and retrieving
Manipulating and processing
Analyzing
Securing
Transmitting
Producing a graph from a table of data is an example of...
Collecting, storing and retrieving
Manipulating and processing
Analyzing
Securing
Transmitting
Which of the following is described by this description:
"The information should not be taken from one source as the collectors of the information may have collected this for a specific purpose."
Bias
Validity
Reliability
Accurate
Complete
Which of the following is described by this description:
"Should be selected/gathered from a source which can be verified for example the BBC."
Bias
Validity
Reliability
Accurate
Complete
When creating a survey, which of the following should be considered in order to collect good quality information?
Target a range of demographics
Include a range of question types
Include mostly boolean answers
Information should be reliable, valid, biased and relevant
Which of the following are negative impacts of poor quality information?
Decreased sales due to an increasing client base
Reputation is increased through negative reviews on social media
Profits decrease due to management decisions based on the information
Sales are impacted due to negative reviews
What is a series of audio recordings that you can listen to via the internet?
Radiocast
Podcast
Screencast
Broadcast
Best information format for the partially sighted for up to date news headlines
Podcast episode
Streaming video
Static website content
Braille newspaper
Posting a printed report to a parent is an example of...
Collecting, storing and retrieving
Manipulating and processing
Analyzing
Securing
Transmitting
let customers know of a potential security breach and ask them to change their passwords as a precaution
Contact management
decision making
internal and external communication
big data
What can we use to gather primary data?
Surveys
Interviews
Drawings
Experiments
All of the above
In the data flow diagram (DFD). The arrows represent which way the data goes (in or out), these are called...
External entitles
Processes
Data stores
Data flows
This is the symbol for
External entitles
Processes
Data stores
Data flows
This is the symbol for
External entitles
Processes
Data stores
Data flows
This is the symbol for
External entitles
Processes
Data stores
Data flows
What is an advantage of Solid State Media?
It is relatively expensive
It is Robust
It is relatively inexpensive
It holds more data
What do you call a software application used to access and view web pages?
search engine
web browser
internet
none of the above
Which of these is a description of the internet?
A network that is not connected to the internet and is only available to those within an organisation
Worldwide network of interconnected networks
A website that provides restricted access to resources for an authorised set of users from outside the organisation
Which of these is a description of the intranet?
A network that is not connected to the internet and is only available to those within an organisation
Worldwide network of interconnected networks
A website that provides restricted access to resources for an authorised set of users from outside the organisation
Which of these is a description of the extranet?
A network that is not connected to the internet and is only available to those within an organisation
Worldwide network of interconnected networks
A website that provides restricted access to resources for an authorised set of users from outside the organisation
Which one of these computer systems is best for office tasks AND multitasking?
Desktop PC
Smart Phone
Tablet Computer
Laptop Computer
Which one of these computer systems is best for a Police Officer needing to communicate with headquarters and contact various services while on the move?
Mobile Smart Phone
Laptop Computer
Desktop Computer
Tablet Computer
Which of the following wireless communication methods can reach approximately 50 meters?
WiFi
Bluetooth
Infra Red
Why might a group of online gamers prefer to have a wired network than a wireless network for their computers? (Select 2 options)
Wired is faster to transfer data
Wired has a more reliable up time
Wired is cheaper
Wired has more resonance
If you were travelling for long periods and needed a computer system what would you consider in selecting your device? (Choose 2 options)
Battery Life
Connectivity Options
Cost of Device
Quality of operating system
What is the difference in access to digital resources in different areas of the world called
Digital resource difference
Dividing the nations
Digital Divide
Technology devide
Paper is a type of storage media
True
Flase
Which law is broken if you buy a pirate copy of a DVD?
The Data Protection Act
The Copyright, Designs and Patents Act
Freedom of information Act
Computer Misuse Act
Which law is broken if your email account is hacked?
The Data Protection Act
The Copyright, Designs and Patents Act
Freedom of information Act
Computer Misuse Act
In Green IT, there are the 3 R's... What are they?
Rethink, Reuse, Repair
Reduce, Rethink, Reuse
Refuse, Reduce, Recycle
Reduce, Reuse, Recycle
a robust storage media is on that:
is less like to be damaged, often because it has no moving parts
is quick to access data as the heads located the disk pointers quicker
has a large capacity for storing data
is a portable device that can be used on any platform
