3.4-3.6 Flashcards
(13 cards)
Identify the data analysis tool that would be used to complete this analysis.
Justify your choice.[4]
- Trend and pattern identification/Data visualisation (1st)
A pattern can be seen (1) relating, to the fastest competitors (1) in
each event in each class (1)
- A comparison (1) can be identified
across different classes (1) for each
class / gender (1) - Charts / graphs / example (1)
showing trends / patterns (1) for
interpretation of the results (1)
Explain what happens during the ‘identify potential sources’ stage of data analysis [3]
identify a range of sources /
target audience (1)
which must be
reliable (1)
to ensure the collected
information is suitable/ is relevant
(1)
Identify and describe the next data analysis stage [3]
Source / select information (1st)
Information is gathered (1)
Based on the sources selected in
previous stage (1)
The most useful gathered
information is selected / not useful
information is discarded (1)
Identify one other data analysis stage.
Identify the need (1)
Define the scope (1)
Select the most appropriate tools
(1)
Process / analyse data (1)
Record / store information (1)
Share results (1)
Justify the use of the visualisation of data analysis tool to present the data [4]
Visualisation includes the use of
charts / graphs (1)
which can show
the analysed data in a clear and
easily understandable way (1)
Data presented visually (1)
can clearly show trends and patterns (1)
One type of visualisation of data analysis tool that could be used to present the data is a bar chart.
Identify two other types of visualisation of data analysis tools that could be used to present the
data. [2]
Line (1)
Pie (1)
Column (1)
Scatter (1)
Area (1)
Each car has a tracking system which enables its location to be found.
Identify the data analysis tool the tracking system would be included in. [1]
Location mapping/Geo….
Identify and describe two stages of data analysis. [4]
- Identify the need (1st) what is
needed / - Share results (1st) results
published for client / stakeholders
(1).
A school holds records, in a database, about its students and staff. The records include personal
details including name, gender, date of birth, any disabilities or medical problems and contact details.
The database uses separate tables to hold details of the students and the staff.
Explain one advantage of using separate tables for students and staff.
[4]
Allows school to limit access to the
staff table (1) to those who need to
see the information (1) such as HR
staff (or other relevant example) (1)
Can differentiate between staff &
students (1) as the same names
may be for staff and student (1) so
searching may have a higher
confidence rate (1)
A hotel is redeveloping its booking website.
Identify the type of information system structure into which the booking website would be included.
[1]
Open system
Describe one benefit and one limitation of using open systems structure for the
booking website. [4]
Enables interaction with other
systems (1) so customer can use
the booking website (1)
Limitation:
More susceptible to hackers (1) so
is not secure / data/information may
be stolen (1)
A library is removing borrowers from its database who have not borrowed a book for three or more
years.
Identify the data analysis tool which would be used to complete this task. Justify your choice.
[4]
- Data cleaning (1st)
- is the process of removing data
from the database (1) - usually done
when data is found to be inaccurate/outdated (1) borrowers
who have not used the library for 3
or more years are classed as out of
date data (1).
Required by the DPA (1) to remove
old data (1) as data must not be
kept longer than required (1).
Identify one example of an item that could be used to define the scope in phase 2.
Content (1).
Detail (1).
Timescales (1).
Constraints (1).
