Font size
WorksheetsCambridge Technical in IT Unit 2 LO3
Total questions: 50
Worksheet time: 25mins
Which stages of data analysis identifies what information is needed?
Identify the need
Define scope
Identify potential sources
Source and select information
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 sends the report to shareholders?
Select the most appropriate tools
Share the result
Record and store information
process and analyse data
Which stages of data analysis identifies the sales figures, customer surveys?
Identify the need
Define scope
Identify potential sources
Source and select information
Which stage of data analysis processes sales data to produce charts that indicate sales?
Select the most appropriate tools
Share the result
Record and store information
process and analyse data
Which stages of data analysis identifies what we want to find out?
Identify the need
Define scope
Identify potential sources
Source and select information
Which stages of data analysis writes a report based on the results?
Select the most appropriate tools
Share the result
Record and store information
process and analyse data
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
Which stage of data analysis selects what is needed to process, manipulate or present the information?
Select the most appropriate tools
Share the result
Record and store information
process and analyse data
What causes most errors in a database?
SQL
Humans
Servers
Internet access
A column name in a database is known as a ______ .
Field
Table
Row
Record
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
Addition, subtraction, multiplication, division, and exponentiation are examples of what?
Formulas
Conditional formatting
Functions
Spreadsheet data
Which of these are not an example of how a spread sheet can be used?
Budget
Research Paper
Track sales
Track Inventory
What is the purpose of spreadsheets?
To present information on different engaging slides
To deliver a speech to a crowd
To perform basic and complex math computations in an organized way
To excel your research papers and citations
I need a pie chart of sales for 5 leading trainers, what should I use?
Spreadsheet
Database
What should I use to store the stock and customers for an online shopping website?
Database
Spreadsheet
Which of the following would be used for trend and pattern identification?
Table
Report
Database
Line graph
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 is a benefit of an open system?
More opportunities (making more connections with others)
quality of communication is lower (relationships, information etc)
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
A closed system is where the data can only flow inside the system. Nothing comes in and nothing goes out.
True
False
Which of the following systems are more secure?
Open system
Closed system
Which Category of information is the following in?
Send an email
Communication
Education & training
Entertainment
Planning
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?
A student checking a print off or online record to view her current grades and feedback
Communication
Education & training
Entertainment
Planning
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 is the following in?
reading a film review
Communication
Education & training
Entertainment
Planning
Which Category of information is the following in?
Look up a recipe online
Research
Location dependent
Entertainment
Financial
Which Category of information is the following in?
Search for an emergency doctor while on holiday
Research
Location dependent
Entertainment
Financial
Which of the following is an advantage of using information before choosing a film to watch is (Select 2)
I can choose a genre/theme I like
I can choose a film based on ratings, i'll know it is good!
I can review it myself
The information can be misleading
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 creates an accurate model of key markets/target audiences?
Knowledge management and creation
MIS - management information systems
Marketing, promotion and sales
Financial analysis and modelling
Which category of information works out cash flow each week /month/year?
Knowledge management and creation
MIS - management information systems
Marketing, promotion and sales
Financial analysis and modelling
Which category of information monitors staff training in a hospital?
Knowledge management and creation
MIS - management information systems
Marketing, promotion and sales
Financial analysis and modelling
Which category of information identifies patterns or trends in sales figures?
Knowledge management and creation
MIS - management information systems
Marketing, promotion and sales
Financial analysis and modelling
Which category of information determines top selling products?
Knowledge management and creation
MIS - management information systems
Marketing, promotion and sales
Financial analysis and modelling
Which category of information stores the personnel records of all staff in a department store?
Knowledge management and creation
MIS - management information systems
Marketing, promotion and sales
Financial analysis and modelling
Which category of information keeps track of appointments in a doctors surgery?
Contact management
Decision making
Internal and external communication
Big data
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 category of information decides how many computers to buy for a new school suite?
Contact management
Decision making
Internal and external communication
Big data
Which category of information lets staff know about a scheduled computer update when systems will be down?
Contact management
Decision making
Internal and external communication
Big data
Which category of information decides the number of tents to send to a disaster area by a charity?
Contact management
Decision making
Internal and external communication
Big data
Which category of information lets 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
Which category of information uses the health data on the population of an entire country?
Contact management
Decision making
Internal and external communication
Big data
