Font size
WorksheetsJ808 ICT Exam December 2020
Total questions: 34
Worksheet time: 1hrs 19mins
Identify the correct order for the phases of a project life cycle. [1]
A Planning Evaluation Initiation Execution
B Planning Execution Initiation Evaluation
C Initiation Planning Execution Evaluation
D Initiation Planning Evaluation Execution
A pivot chart is used to visually represent data. [1]
True
False
Identify TWO advantages of using consumer panels as a method for collecting data. [2]
Identify the legislation that relates to the misuse of personal data. [1]
Identify TWO outputs from the execution phase of a project life cycle. [2]
Complete the following sentence by selecting one of A, B, C or D. Unauthorised access to systems with malicious intent to steal, exploit and sell data is called…. [1]
A phishing.
B ransomware.
C grey hat hacking.
D black hat hacking.
Progress X is an IT company that uses social media to promote its services. Identify TWO benefits to Progress X of using social media to promote its services. [2]
Read this scenario and select the key-points read
Progress Gaming Zone (PGZ) is a business where gamers can purchase time to use specialist computers with high-speed internet connections. Gamers can then play a range of online multiplayer games.
Gamers will be given a unique username and password to access the specialist computers.
PGZ will collect data about the amount of time gamers spend online. The PGZ Network Manager has been given a project to develop a system that will be used to record
and monitor online usage. The new system will automatically create invoices for gamers who use
the specialist computers.
Head Office has requested a monthly report on the trends in online usage by gamers and the generated income.
collect data about the amount of time gamers spend online
unique username and password to access the specialist computers
Head Office has requested a monthly report
gamers can purchase time to use specialist computers
develop a system that will be used to record
and monitor online usage
The PGZ Network Manager will set SMART targets for the project.
(a) State what the ‘S’ in SMART stands for. [1]
(a)
(b) State what the ‘A’ in SMART stands for. [1]
(a)
(c) Identify two SMART targets that could be set for this project. [2]
(d) The PGZ Network Manager will carry out a phase review at the end of the initiation stage.
Is this statement true or false? [1]
True
False
9 Identify one storage method that PGZ could use to store data about the amount of time gamers
spend online. Justify the storage method you have chosen.[3] Write METHOD then JUSTIFICATION
10 Gamers will be given a username and password to access the specialist computers.
Describe how usernames and passwords could reduce the vulnerability of the specialist computers. [2]
11 The PGZ Network Manager is preparing the monthly report on online use and income generation for Head Office. He will create an integrated document for this purpose. Discuss the advantages and disadvantages of using an integrated document for this purpose. [10]
Tick each key-point that is from the scenario.
Pro-Taxis (PT) is a taxi firm which is used to pick up customers and take them to their destination.
Customers will phone PT to make a booking for a taxi. This data is currently recorded on a paper schedule plan.
The IT Manager at PT has started a project to digitally collect, store and sort data about its customers and their bookings. PT is also looking into using mobile technology by developing a mobile app that customers can use to book a taxi rather than phoning PT direct. To register to use the mobile app, customers will have to enter their phone number and their name and address.
Pro-Taxis (PT) is a taxi firm
customers will have to enter their phone number and their name and address
they started a project to digitally collect, store and sort data about its customers and their bookings.
Customers will phone PT to make a booking
data is currently recorded on a paper schedule plan.
12 PT has decided to use a database software application to store customer details. This will allow
PT to query customer information and produce reports.
(a) Identify THREE DATA TYPES that would be used in the database software application. [3]
12 (b) Explain TWO reasons why a database software application would be more appropriate than a
spreadsheet software application for storing customer details. [4]
12 (c) Identify and describe TWO drawbacks to PT if inaccurate data is entered into the database
software application. [4] write DRAWBACK then DESCRIPTION
13 Identify two success criteria that PT would need to consider when reviewing the effectiveness of
the mobile app that customers use to book a taxi. [2]
14 The IT Manager needs to test the mobile app.
Identify the TWO phases of the project life cycle which include the test results. [2]
15 Testing of the mobile app was successful. The mobile app can now be used by customers.
A customer is using the mobile app over a public wireless network when PT’s server is hacked.
(a) Identify and describe one possible consequence to the customer of this cyber-security attack. [3] write CONSEQUENCE then DESCRIPTION
15 (b) Identify ONE action customers could take, other than not using a public wireless network, to reduce the risk of a cyber-security attack on their mobile device. [3] write ACTION then JUSTIFICATION
Read this scenario and select the key-points read
Progress Utility (PU) supplies electricity to over two million customers. PU estimates how much electricity it needs. If it underestimates, there will not be enough electricity for its customers. A decision has been made that PU will launch a project to install SmartMeters (physical display
units) in its customers’ homes to collect hourly meter readings. The data from the SmartMeters will
be automatically sent back to PU. The data will be processed allowing PU to:
• make more accurate estimates as to the amount of electricity it needs;
• provide its customers with accurate utility bills.
PU will follow the project life cycle at all times.
PU estimates how much electricity it needs
Progress Utility (PU) supplies electricity to over two million customers
Underestimates result in there not being enough electricity
PU will follow the project life cycle at all times.
PU will launch a project to install SmartMeters
16 One input for the planning phase in the project life cycle will be the feasibility report. Identify and explain TWO benefits to PU of using a feasibility report for this project. [4] Write BENEFIT and then EXPLANATION for each of the two.
17 Identify one software type that PU could use to schedule the work of individual project team members.
Justify the software type you have chosen for this purpose. [3]
state the SOFTWARE TYPE and then JUSTIFICATION.
18 (a) The data from the SmartMeters is sent to PU.
Describe how this data becomes information. [2]
18 (b) The SmartMeters will increase the reliability of the collected data.
Describe what is meant by the term reliability. [2]
18 (c) Identify TWO considerations PU must take into account when holding customer data. [2]
18 (d) PU has completed the installation of SmartMeters into the homes of its customers. Discuss the benefits and drawbacks to PU of introducing the SmartMeters.
You must refer to different types of vulnerability in your answer. [8]
Tick each key-point that is from the scenario.
The PU Board of Directors has asked for a monthly report comparing the electricity generated by PU with the electricity usage of its customers. The Board has also asked that online surveys are used to gather feedback from customers on the use of SmartMeters.
Directors has asked for a monthly report
Board has also asked that online surveys are used
gather feedback from customers on the use of SmartMeters.
comparing the electricity generated by PU with the electricity usage of its customers.
19 The monthly report includes statistical information. The statistical information will be presented
using dynamic charts. Explain one advantage to PU of using dynamic charts to present this statistical information.
20 (a) Identify and explain TWO advantages to PU of using online surveys to gather feedback from its existing customers. [4] State the ADVANTAGE and then the EXPLANATION for each of the TWO.
20(b) Other than online surveys, identify one other method PU could use to gather feedback from
its existing customers. [1]
