Font size
WorksheetsU2 2.1 2.4 3.3 3.4 3.5
Total questions: 89
Worksheet time: 45mins
Yes or No is what information style?
(a)
Used to present data in a way that is easy to visualise and spot trends
Tactile images
Charts and Graphs
Text
Numerical
Spreadsheets
Stores data in an organised way ready for analysis
Tables & Spreadsheets
Text
Subtitles
Audio
Animated graphics
Can be used to make information more appealing and eye catching
Text
Audio
Braille
Animated graphics
Subtitles
Allows blind users to feel and interpret physical objects
(a)
Can be used for a foreign film so that you understand the dialogue
Subtitles
Braille
Numerical
Video
Text
What is a disadvantage of video?
Some people find video less engaging
Videos can take up a large amount of storage space
Video cannot be rewound and repeated
Audio can be included alongside the video
What information style is used in the age field?
Numerical
Text
Database and Spreadsheet
Graphic
Boolean
What information style is used in the qualification field?
Numerical
Text
Database and Spreadsheet
Graphic
Boolean
What information style is used in the marital field?
Numerical
Text
Database and Spreadsheet
Graphic
Boolean
Statistical and financial data
Text
Numerical
Audio
Subtitle
Boolean
Logos and photos
Graphics
Animated graphics
Video
Tactile images
Boolean
Which information styles are particularly useful to those with disabilities and accessibility issue?
Subtitles
Audio
Braille
Tactile
Disadvantage of text?
Provides detailed summary and explanation
Format can be changed to suit the need
Can be time consuming to read
Can contain spelling and grammatical errors
Recorded sound
(a)
Boolean is equivalent to
Closed questioning
Open questioning
What information style?
(a)
What information style?
(a)
What information style is shown here as well as video?
(a)
What type of animation is this?
Entertainment
Advertising
Instructional
Educational
This animation showing people how to do CPR is for what purpose?
Entertainment
Advertising
Educational
Instructional
This animation showing how photosynthesis works is for what purpose?
Entertainment
Advertising
Instructional
Educational
This Shaun the Sheep animation is used for what purpose?
Entertainment
Advertising
Educational
Informational
What information style is shown here?
(a)
What information management process is being described?
"through interviews/questionnaires/observations/filling in forms etc"
Collecting
Storing
Retrieving
Processing
Transmitting
What information management process is being described?
"usually requires some form of database or spreadsheet, ideally electronic but could also be a manual filing system"
Collecting
Storing
Retrieving
Processing
Transmitting
What information management process is being described?
"use of queries, should return relevant information. Manual databases will be more time consuming"
Collecting
Storing
Retrieving
Processing
Transmitting
What information management process is being described?
"changing data so that it can be processed “more easily”; this could involved sorting the information in categories and sub-categories or summarising the information"
Securing
Manipulating
Retrieving
Storing
Transmitting
What information management process is being described?
"turning the original information into an output that is appropriate"
Collecting
Processing
Retrieving
Storing
Transmitting
What information management process is being described?
"information is looked at so that patterns can be identified"
Analyse
Processing
Retrieving
Storing
Transmitting
What information management process is being described?
"protected from external and internal threats"
Analyse
Processing
Retrieving
Securing
Transmitting
What information management process is being described?
"Once the information has been prepared it may need to be shared within or outside of an organisation"
Analyse
Processing
Retrieving
Securing
Transmitting
What stage is missing?
(a)
(a)
(a)
(a)
What are methods of transmitting data?
Emails
Presentations
Meetings
Reports
Select the physical security methods
Tokens
Anti-virus
Encryption
Locks
Privacy screens
Select digital security methods:
Firewalls
Permissions
RFID
Shredding
Passwords
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
looking for patterns in annual rainfall in an area is an example of...
collecting, storing and retrieving
manipulating and processing
analyzing
securing
Transmitting
storing patient records on an encrypted hard drive is an example of...
collecting, storing and retrieving
manipulating and processing
analysing
securing
Transmitting
posting a printed report to a parent is an example of...
collecting, storing and retrieving
manipulating and processing
analyzing
securing
Transmitting
what information is needed?
identify the need
define scope
identify potential sources
source and select information
What do we want to find out?
identify the need
define scope
identify potential sources
source and select information
content, detail, time scales, constraints
identify the need
define scope
identify potential sources
source and select information
sales figures, customer surveys
identify the need
define scope
identify potential sources
source and select information
determine the accuracy and reliability of the sources, selecting the best
identify the need
define scope
identify potential sources
source and select information
write a report based on the results
identify the need
share results
identify potential sources
record and store information
send the report to shareholders
identify the need
share results
identify potential sources
record and store information
trend and pattern identification
line graph of last years sales per month
report
database
table
data cleaning example
deleting data
removing customers who have not made a purchase in 2 years
optimising the servers
leaving customers who have not made a purchase in 2 years
Using fairy liquid on the data
Which is best for identifying trends and patterns?
A well-structured database uses one data table for different types of information.
TRUE
FALSE
What is shown?
(a)
Why have different tables of data?
Better organised data
Less time consuming to store
More efficient to search
Access can be provided to specific people
Backs up the data
Organising data from A-Z is known as:
Sorting
Filtering
Querying
Calculating
Deleting
Organising data so only certain crtieria such as 'hair colour = brown' is shown is known as:
Sorting
Filtering
Querying
Calculating
Deleting
Asking a question of the data is known as
Sorting
Filtering
Querying
Calculating
Deleting
Adding data values together is known as
Sorting
Filtering
Querying
Calculating
Deleting
Data cleaning is also known as
Sorting
Filtering
Querying
Calculating
Deleting
Which statements are true?
The highest result was in December
The lowest result was in August
The third highest result was in October
The 2nd highest result was in November
The lowest result was in July
What can be spotted from the following visualisation?
(a)
Data cleaning is the process of removing or improving out of date data.
TRUE
FALSE
Why should you take data cleaning seriously?
Keeps database efficient and clean
Keeps you in compliance with all legislation
Because dirt can build up in even the smallest of places
Ensures you have the correct information for your customers / products
You shouldn't; data can never go out of data
(a)
Staff can be tracked so that delivery times can be confirmed with customers. Allowing customers to plan their day.
Individual items can be tracked so that they may be fond if lost.
What is described?
(a)
Create an accurate model of key markets/target audiences
knowledge management and creation
MIS - management information systems
Marketing, promotion and sales
financial analysis and modelling
monitor staff training in a hospital
knowledge management and creation
MIS - management information systems
Marketing, promotion and sales
financial analysis and modelling
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
personnel record of all staff in a department store
knowledge management and creation
MIS - management information systems
Marketing, promotion and sales
financial analysis and modelling
identify patterns or trends in sales figures
knowledge management and creation
MIS - management information systems
Marketing, promotion and sales
financial analysis and modelling
determine top selling products
knowledge management and creation
MIS - management information systems
Marketing, promotion and sales
financial analysis and modelling
work out cash flow each week /month/year
knowledge management and creation
MIS - management information systems
Marketing, promotion and sales
financial analysis and modelling
keep track of appointments in a doctors surgery
Contact management
decision making
internal and external communication
big data
Decide number of tents to send to a disaster area by the charity
Contact management
decision making
internal and external communication
big data
decide how many computers to buy for a new school suite
Contact management
decision making
internal and external communication
big data
let staff know about a scheduled computer update when systems will be down
Contact management
decision making
internal and external communication
big data
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
annual web clicks of a major online retailer
Contact management
decision making
internal and external communication
big data
Health data on the population of an entire country
Contact management
decision making
internal and external communication
big data
