wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

RO12 online mock 29th April 2020 with Mrs Edwards

Total questions: 33

Worksheet time: 8hrs 46mins

Name
Class
Date
1.

Write down your name in full in this format

SURNAME Firstname

4 lines
2.

Q1. Write in the correct order of the 4 phases of a project life cycle.

4 lines
3.

Q2. A pivot chart is used to visually represent data.


Is this statement true or false?

a)

True

b)

False

4.

Q3. Identify two advantages of using consumer panels as a method for collecting data. (2 marks)


Write your answer in this format :

Advantage 1 :

Advantage 2 :

4 lines
5.

Q4. Identify the legislation that relates to the misuse of personal data. (1 mark)

4 lines
6.

Q5. Identify two outputs from the execution phase of a project life cycle. (2 marks)


Write your answer in this format :

Output 1 :

Output 2 :

4 lines
7.

Q6. Unauthorised access to systems with malicious intent to steal, exploit and sell data is called..... (1 mark)

a)

phishing

b)

ransomware

c)

grey hat hacking

d)

black hat hacking

8.

Q7. 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 marks)


Write your answer in this format :

Benefit 1 :

Benefit 2 :

4 lines
9.

SECTION B


Read the scenario below. Questions shown (from now on till you get to Section C), relate to this scenario:


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.


Q8. The PGZ Network Manager will set SMART targets for the project.

a) State what the "S" in SMART stands for. (1 mark)

4 lines
10.

In relation to Section B scenario,

Q8 b) State what the "A" in SMART stands for. (1 mark).

4 lines
11.

In relation to Section B scenario,

Q8c)Identify two SMART targets that could be set for this project.(2 marks).


Write your answer in this format.

Target 1 :

Target 2 :

4 lines
12.

Q8d) In relation to Section B scenario, The PGZ Network Manager will carry out a phase review at the end of the initiation stage. Is this statement TRUE or FALSE? (1 mark)

a)

True

b)

False

13.

Q9. In relation to Section B scenario,

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 marks)


Write your answer in this format.

Method :

Justification :

4 lines
14.

Q10. In relation to Section B scenario, 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 marks)

4 lines
15.

Q11. In relation to Section B scenario, 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 marks]

4 lines
16.

SECTION C

Read the scenario below. Questions 12–15 relate to this 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.


Q12. 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 marks)

Write your answer in this format :

Data Type 1 :

Data Type 2:

Data Type 3:

4 lines
17.

Q12b) In relation to Section C scenario, explain two reasons why a database software application would be more appropriate than a spreadsheet software application for storing customer details. (4 marks)


Write your answer in this format .


1 :


2 :

4 lines
18.

Q12c) In relation to Section C scenario, identify and describe two drawbacks to PT if inaccurate data is entered into the database software application. (4 marks)


Write your answer in this format.


Drawback 1:

Description :


Drawback 2:

Description :

4 lines
19.

Q13. In relation to Section C scenario, 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 marks)


Write your answer in this format.


Success Criteria 1:

Success Criteria 2:

4 lines
20.

Q14. In relation to Section C scenario, the IT Manager needs to test the mobile app.

Identify the two phases of the project life cycle which include the test results. (2 marks)


Write your answer in this format.


Phase :

Phase :

4 lines
21.

Q15. In relation to Section C scenario, ,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 marks)


Write your answer in this format.


Consequence :

Description :

4 lines
22.

Q15b. In relation to Section C scenario, 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. Justify your answer. (3 marks)


Write your answer in this format.


Action :

Justification :

4 lines
23.

SECTION D

Read the scenario below. Questions 16–18 relate to this scenario.


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.


Q16. 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 marks)


Write your answer in this format.

Benefit 1 :

Explanation :

Benefit 2 :

Explanation :

4 lines
24.

Q17. In relation to Section D scenario, 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 marks)


Write your answer in this format.

Software type :

Justification :

4 lines
25.

Q18a. In relation to Section D scenario, the data from the SmartMeters is sent to PU. Describe how this data becomes information. (2 marks)

4 lines
26.

Q18b) In relation to Section D scenario, the SmartMeters will increase the reliability of the collected data.


Describe what is meant by the term reliability (2 marks)

4 lines
27.

Q18c) In relation to Section D scenario, identify two considerations PU must take into account when holding customer data.(2 marks)


Write your answer in this format.


Consideration 1:

Consideration 2:

4 lines
28.

Q18d) In relation to Section D scenario, 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 marks)

4 lines
29.

SECTION E

Read the scenario below. Questions 19–20 relate to this 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.


Q19, 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. (3 marks)

4 lines
30.

Q20a) In relation to Section E scenario, identify and explain two advantages to PU of using online surveys to gather feedback from its existing customers. (4 marks)


Write your answer in this format.

Advantage 1 :

Explanation :

Advantage 2 :

Explanation :

4 lines
31.

Q20b) In relation to Section E scenario, other than online surveys, identify one other method PU could use to gather feedback from its existing customers. (1 mark)

4 lines
32.

That's the end of the paper.

What is your rating of the paper between score 1 to 10 ( 1 for very easy and 10 for very difficult) ?


Also, if you have some technical difficulties, please write here.

Thank you for your participation! I really appreciate your effort.

4 lines
33.

Which device did you use to complete this mock? (this is not part of the mock questions, just for my understanding)

a)

Laptop

b)

Desktop computer

c)

Smart phone

d)

Tablet