Instructions to Candidates
This paper consists of fouractivities.
Work through the activities and tasks in order.
Do not spend too much time on any one activity.
For all tasks, you MUST enter the task number, your name, candidate number and centrenumber BEFORE
Saving.
This table shows the available activities
ACTIVITY
1. Using Art/Imaging and Graphics Software (AG)
2. Using DTP/Word Processing Software (WP)
3. Using Web Authoring Software (WA)
4. Using Presentation Software (PS)
Scenario
Mermaid Pearl Hotel is owned by Roger Allen
The company rents out cottages in Scotland.
These are the contact details for the company.
Address:
142–144 Highlands Road
Scotland
Telephone:
01632 960444
Website:
www.thr2000.co.uks
E-mail
mplrentals@mpl.com
1
Activity 1 – Using Art/Imaging and Graphics Software (AG)
Roger has created a logo for the company. He has saved the logo as MERMAID.
Task AG1
Open a new document using word processing software.
Enter Task AG1, your name, candidate number and centre number in the footer of thedocument.
SAVE the document as TASK AG1.
(a) (i) Insert the graphic MERMAID into the document TASK AG1.
(ii) Roger is not happy with the design of the logo.
In document TASK AG1, identify two aspects of the design that should be improved. (4)
RESAVE TASK AG1.
DO NOT PRINT at this stage.
Open a suitable graphics package.
(b) Create a new logo for the company.It must be fit for purpose and include:
• one suitable image from the IMAGES folder (3)
• the words ‘Mermaid Pearl Hotel’ (3)
SAVE the logo as MPH.
Paste a copy of MPH into TASK AG1.
RESAVE TASK AG1.
DO NOT PRINT at this stage.
In document TASK AG1, Using text boxes explain 3 aspects why your logo design is an improvement
on MERMAID. (4)
RESAVE TASK AG1.
Task AG2
Open a new document using word processing software.
Enter Task AG2, your name, candidate number and centre number in the footer of thedocument.
SAVE the document as TASK AG2.
Roger wants to use the image HOTEL in a presentation.
Open the image HOTEL in a suitable graphics package
(a) The image must remain rectangular.
Crop the image to remove:
• the silver color vehicle on the left of the (3)
• as much of the sky as possible without cropping the tree tops (3)
• the cyclist at the bottom of the picture (3)
2
Edit the Image,
• So that two people in the right side no longer visible (3)
Add the text ‘Mermaid Pearl HotelGroup’ to the top right corner of the picture (4)
SAVE the image as NEW HOTEL
Paste a copy of NEW HOTEL into TASK AG2.
RESAVE TASK AG2.
Activity 2 – Using DTP/Word Processing Software (WP)
Task WP1
Rogerwants a new letterhead for the company.
Open a new document using word processing software.
SAVE the document as TASK WP1a.
Create a letterhead for ‘Mermaid Pearl Hotel’using:
• the company contact details from the file COTTAGE (4)
• the logo you created in part (b) of Task AG1. (3)
RESAVE TASK WP1a.
Task WP 2
Roger wants to send a memo to Frederick, Manager of the Queens hotel, to remind him that the annual
award ceremony of the hotel group will be held in his hotel.
The ceremony will be held on Tuesday18 July 2018 at 10:30am in the Conference Suite
Open the document TASK WP1a that you have saved in the above activity
SAVE the document as TASK WP2
Create a memo from Roger to Frederick on the document TASK WP2
The memo should include
Today’s data (3)
All standard components of a Memo (8)
A suitable message (4)
Make sure the memo is fit for purpose.
RESAVE TASK WP2.
3
Activity 3 – Using Spreadsheet Software (SS)
Roger uses the Hotel Rental spreadsheet to store data about the rented rooms and to calculate income.
Task SS1
Open the Hotel Rental spreadsheet.
Enter Task SS1, your name, candidate number and centre number in the footer of the worksheet.
Rojer has arranged a new Room. The details are:
Room Name: Wheaten
Daily Rate : £30
Days Rented: 143
Add this information to the worksheet.
Sort the data in ascending order of Room
Enter formulae to calculate:
(i) the Income from each cottage
(ii) the Total Income (in cell D36).
The number of days that each room was available for rental in 2017 is shown in cell E6.
Martin wants to know the Number of days that each room was vacant in 2017.
Enter the Title Days Vacant in call F8
Using a formula find the Days Vacant for each Room
Find the total number of days vacant in Cell F36
Rojer has planned to add 20% tax on each room from 2018. Information is available in Cell G6.
Enter the Title New Rate in call G8
Using a formula find the New Rates after the tax for each Room
Rojer wants to add a discount on new rates
Enter the Title Discount Rate in call H8
Rojer wants to add a 5% discount on new rates if the New Rate is more than £100, if not display the same
rate.
Use a suitable formula to find the Discount Rate for each room.
Format the worksheet so that:
Currency values show the currency symbol with no decimal places
All data is visible
The presentation is improved
4
