Question
• Place in the header: automated page numbers left aligned a right aligned automated date field to display today’s date in the format dd-MMM-yy
• Place in the footer your name, centre number and candidate number, centre aligned.
• Make sure that: all the alignments match the page margins no other text or placeholders are included in the header and footer areas headers and footers are displayed on all pages.
EVIDENCE 2
Take screenshot evidence of the date field code showing the format used. Place this screenshot in your Evidence Document.
[3]
3 • Create and store the following styles, basing each on the default paragraph style:
House style specifications
Font size (points)
Enhancement
Space Before
Line spacing
Space After
Style name
Alignment
Font style
(points)
(points)
TC-subtitle sans-serif 18 right underline single 0 0
TC-subhead sans-serif 16 centre bold, italic single 0 6
TC-body serif 10 justified none single 0 6
TC-table serif 11 centre italic single 0 0
EVIDENCE 3
Take a screenshot to show that the style settings have been defined for TC-subhead style. Make sure there is evidence that this is based on the default paragraph style.
Place this in your Evidence Document.
[3]
4 • The style name TC-title has already been created, stored and applied to the title text.
• Modify the TC-title style so only the following formatting is applied:
Font size (points)
Enhancement
Space Before
Line spacing
Space After
Style name
Alignment
Font style
(points)
(points)
TC-title sans-serif 32 centre bold, italic single 0 0
EVIDENCE 4
Take a screenshot of the style settings for TC-title style to show that these have been changed. Place this in your Evidence Document.
[2]
5 • Display these custom style names as a list in the style manager/organiser. Provide screenshot evidence of this list.
EVIDENCE 5
Place this screenshot in your Evidence Document.
[1]
6 • Below the title add the subtitle:
Produced by: and add your name. [1]
7 • Apply the TC-subtitle style to this text. [1]
8 • Apply the TC-body style to the rest of the document. [1]
9 • Change the page layout so that the subheading Overview and all following text is displayed in three columns of equal width with a 1 centimetre space between the columns. [2]
10 • Apply bullets to the list of items from:
Shore excursions… to
… Specialty restaurants
• Make sure that: the bullets are aligned at the left margin the list is in single line spacing with no space before or after each line there is a 6 point space after the last item in the list.
[2]
11 • Identify the 7 subheadings in the document and apply the TC-subhead style to each one. [1]
12 • Using the data in the file J229STATS.csv create a vertical bar chart to show the number of cruise passengers for the years 2014 to 2018 only. [1]
13 • Label the chart with the following: title Annual Growth value axis title Passengers
[1]
14 • Display the values as data labels on top of each bar.
• Do not display a legend.
[1]
15 • Format the value axis scale to display: a minimum value of 5000 a maximum value of 13000 increments of 2000
[2]
16 • Insert the chart after the paragraph ending …over the past five years:
• Make sure that: the chart and all data fits within the column width all data labels are displayed in full.
[1]
17 • Import the image J229SHIP.png and place this below the subheading Our Fleet [1]
18 • Format the image so that: it is re-sized to a width of 2.5 centimetres with the aspect ratio maintained it is aligned to the left margin and the top of the paragraph starting We currently operate… the text wraps round the image.
• Save the document with the same file name and format used in Step 1.
• Make sure that today’s date and not the date field code displays in the header.
• Print the document.
PRINTOUT 1
Make sure that you have entered your name, centre number and candidate number on your document.
[2]
19 • Tawara Cruises is planning to publish the annual report data on its company wiki. Evaluate the suitability of a wiki to share this type of data.
EVIDENCE 6
Type your evaluation and recommendations, with reasons, into your Evidence
Document using no more than 100 words.
[3]
[Total: 30]
Task 3 – Database
You are now going to prepare some reports.
20 • Using a suitable database package, import the file J229CRUISES.csv
• Use these field names and data types:
Field Name Data Type Format
Ship_Ref Text
Sail_Date Date/Time dd-MMM-yy eg 26-Jan-19
Cruise_Ref Text
Departure_Port Text
Destination Text
Duration Number Integer
Passengers Number Integer
Board Text
Theme Text
• Set the Cruise_Ref field as a primary key.
• Save the data.
EVIDENCE 7
Place in your Evidence Document screenshot evidence showing the field names and data types used in the table.
[3]
21 • Import the file J229SHIPS.csv as a new table in your database.
• Set the Ship_Code field as a primary key.
• Create a one-to-many relationship between Ship_Code in the ships table and the Ship_Ref field in the cruises table.
EVIDENCE 8
Place in your Evidence Document screenshot(s) showing the relationship between the two tables.
[1]
22 • Add the following as a new record in the cruises table:
Ship_Ref SE06
Sail_Date 19-May-18
Cruise_Ref SE042SE
Departure_Port Seattle
Destination Alaska
Duration 21
Passengers 2100
Board Full
Theme None
[1]
23 • Using fields from the cruises table, produce a tabular report that: selects only the records where:
– Theme is Art or Music
– Departure_Port is Miami shows only the fields Departure_Port, Destination, Sail_Date, Theme, Duration and
Passengers in this order with data and labels displayed in full. Do not group the data sorts the data into ascending order of Sail_Date has a page orientation of portrait fits on a single page wide includes only the text Miami Cruises as a title displayed in a larger font size at the top of the page calculates the total number of passengers in this selection and positions this number under the Passengers column at the end of the report has a label Total passengers to the left of this value has your name, centre number and candidate number in the header so it displays on every page.
• Save and print your report.
PRINTOUT 2
Make sure that you have entered your name, centre number and candidate number on your report.
EVIDENCE 9
Place in your Evidence Document a screenshot showing the database formula used to calculate the number of passengers.
[11]
24 • Using fields from both tables produce a tabular report that: selects the records where:
– Ship_Name includes the text sea
– Duration is 14 or more
– Board is Full contains a new field called Passenger_Nights which is calculated at run-time. This field will multiply the Duration field by the Passengers field shows only the fields Sail_Date, Cruise_Ref, Ship_Name, Departure_Port, Destination,
Duration, Passengers, Board and Passenger_Nights in this order with data and labels displayed in full. Do not group the data sorts the data into ascending order of Destination then descending order of Duration has a page orientation of landscape fits on a single page includes only the text Extended Cruise Sailings as a title displayed in a larger font at the top of the page has your name, centre number and candidate number on the report.
• Save and print your report.
PRINTOUT 3
Make sure that you have entered your name, centre number and candidate number on your report.
[9]
25 • Using fields from both tables produce an extract which: selects only the records where:
– Theme is Taster
– Duration is less than 4
Shows only the fields Cruise_Ref, Ship_Name and Duration in this order with data and labels displayed in full.
• Save the extract.
[3]
26 • Export the extract created in Step 25 in rich text format.
• Save the exported file in your work area.
EVIDENCE 10
Place in your Evidence Document a screenshot to show the exported file saved in your work area. Make sure there is evidence of the file type.
[1]
[Total: 29]
Task 4 – Document 2
27 • Import the extract you saved in Step 26 into your document as a table after the paragraph which ends …cruises operating last year were:
• Make sure that: the table fits within the column width the extract does not contain a title all required fields and their labels are fully visible no text is wrapped within the extract the TC-table style is applied to the extract there is a 6 point space after the table.
[3]
28 • Spell check and proofread the document.
• Make sure that: tables, charts and lists are not split over columns or pages there are no widows or orphans there are no blank pages the house style specification has been followed and the correct styles applied as instructed spacing between all items is consistent.
• Save the document using the same file name and format used in Step 18.
• Make sure that today’s date and not the date field code displays in the header.
• Print the document.
PRINTOUT 4
Make sure that you have entered your name, centre number and candidate number on your document.
[1]
29 • Answer the following questions and record your answers in your Evidence Document:
(a) Explain why styles are used. [1]
(b) State the purpose of spell check software and identify two limitations of its use. [3]
EVIDENCE 11
Type your answers into your Evidence Document using no more than 50 words.
[Total: 8]
Task 5 – Mail merge
You are required to carry out a mail merge.
30 • Create a mail merge letter using the file J229LETTER.rtf as the master document and
J229GUESTS.csv as your data source file.
• Replace the text and chevrons in the master document with the merge fields from the data source file as follows:
Text and chevrons to replace: Replace with merge field
<TLE> Title
<FIRST> First_name
<FAMILY> Family_name
<ADD1> Road
<ADD2> Area
<ADD3> County
<POST> Postcode
<CODE> Memb_code
<LENGTH> Duration
<THE> Theme
<MTH> Month
<DISC> Discount
• Make sure the spacing, punctuation, alignment and enhancements in the original master document are maintained.
[3]
31 • Replace the text Candidate Name with your name.
• Include your name, centre number and candidate number in the footer of the document.
• Print the master document.
PRINTOUT 5
Make sure you have entered your name, centre number and candidate number on your master document.
[1]
32 • Set an automated filter to select members where:
Theme is Taster
EVIDENCE 12
Place in your Evidence Document a screenshot to show the use of an automated selection method.
[2]
33 • Merge and print the letters for the selected members only.
• Save and close the files.
PRINTOUT 6
Print the result of the merge. Make sure you have entered your name, centre number and candidate number on your letters.
[1]
[Total: 7]
Task 6 – Printing the Evidence Document
34 • Print your Evidence Document.
PRINTOUT 7
Make sure that you have entered your name, centre number and candidate number on your Evidence Document.
Task 7 – Presentation
You are going to create a short presentation.
All slides must have a consistent layout and formatting. Unless otherwise instructed, slides should be formatted to display a title and bulleted list.
35 • Create a presentation of 5 slides using the file J229SWOT.rtf
• On slide 1 enter your name after the text Presented by:
[1]
36 • Use a master slide to display only the following features on all slides: your name, centre number and candidate number automatic slide numbers.
[1]
37 • Format the first slide so that: a title slide layout is applied the title and subtitle text are centred in the middle of the slide.
[1]
38 • Add the following text as presenter/speaker notes for the slide with the title Threats:
Can negatively affect perceptions of cruising.
• Print only this slide as presenter/speaker notes.
PRINTOUT 8
Make sure your name, centre number and candidate number are on this slide.
[2]
39 • Save the presentation.
• Print the presentation as a handout using a layout of 6 slides to the page.
PRINTOUT 9
Print this handout. Make sure your name, centre number and candidate number are on all slides.
[1]
[Total: 6]
Mark scheme
23-Apr-19
time navigational performance and energy use across
our fleet.
Themed Cruises The Future
Themed Cruises have become increasingly popular and Exciting times lie ahead for our company in 2019,
Cruise Pricing we see this as the next area of growth within the industry. starting with the first two of our next-generation ships
These are primarily a regular cruise with enhanced or coming into service between June and December. We
Our cruise ticket prices include accommodation and a
additional programming on board. A Themed Cruise are continuing to build strategic stakes and partnerships
wide variety of activities and amenities, including meals
gives guests the opportunity to enjoy a favourite hobby in key areas and we are further investing in new
and entertainment. Prices vary depending on many
or join in a variety of courses to improve their destinations. Our strategy is to attract an array of guests
factors including the destination, cruise length, cabin
knowledge, culture or history. They usually feature by providing a wide variety of itineraries to destinations
selected and the time of year the cruise takes place. Our
special guests such as speakers and performers, or worldwide including Alaska, Asia, Australia, Bahamas,
payment terms require an upfront deposit to confirm a
educational shore excursions. We have responded to the Bermuda, Canada, the Caribbean, Europe, the Panama
reservation, with the balance due prior to the sailing. Our
changing vacation patterns of today’s travellers by Canal and New Zealand with cruise lengths that range
cruises are generally available for sale at least one year
expanding our range of Themed Cruises. from two to 24 nights.
in advance and often as much as two years in advance of
sailing. During the selling period of a cruise, we Interest in ocean cruising is projected to remain strong
continually monitor and adjust our cruise ticket prices
Taster Cruises in 2019. Nearly half (48%) of non-cruisers expressed
for available cabins based on demand, with the objective Last year one in every three of our passengers was on interest in taking an ocean cruise. Based on our planned
of maximising net yields. their first ever cruise. As a result we have expanded the fleet enlargement and a focus on destinations, we intend
range of mini cruises we offer to appeal to the growing to further extend our ability to serve our guests and to
We earn substantially all of our cruise revenues from the
number of people wishing to cruise for the first time. stay on the path towards becoming an even more global
sales of passenger cruise tickets and cancellation fees.
These trips last three nights or under and offer a great cruise line, strengthening our presence in key markets.
While many onboard activities are included in the base
way to try the cruising experience for a fraction of the We believe we are well positioned to attract new
price of a cruise, we realise additional revenues from:
cost and without a large commitment. Customers are consumers to cruising and to continue to bring loyal
Shore excursions able to experience life on board and enjoy a well-earned repeat guests back for their next cruising holiday.
Gift shop items break without having to embark on a long journey that
Casino gaming could take weeks. Mini cruises have also proved popular
Full service spas with guests wanting a few days away or experienced
Internet and communication services cruisers wanting to try a new ship before booking a
Laundry and dry cleaning services longer holiday. Taster cruises operating last year were:
Liquor and some non-alcoholic beverage sales
Cruise_Ref Ship_Name Duration
Photo packages
Specialty restaurants DP049SE Delmara Princess 3
DP052SE Delmara Princess 3
Many of these services are available for pre-booking on
the internet prior to embarkation. These goods and DP054SE Delmara Princess 3
services are provided either directly by us or by DP169SA Delmara Princess 2
independent concessionaires, from which we receive
either a percentage of their revenues or a fee. TH041CA Tawara Hanseatic Star 3
TH043SA Tawara Hanseatic Star 3
VG074VA Varuna Glory 2
Name, centre number, candidate number
PUBLISHED
Title
Correct, 100% accurate 1 mark
Name, centre number, candidate number
Miami Cruises
Name, centre number, candidate number
Departure_Port Destination Sail_Date Theme Duration Passengers
Miami Western Caribbean 03-Jan-16 Music 5 1945
Miami Bahamas 08-Jan-16 Music 6 1880
Miami Western Caribbean 26-Jan-16 Art 5 1802
MiamiSpecified fields, correct order
Western Caribbean 05-Feb-16 Art 1 mark 5 1808
MiamiSort ascending Sail_Date
Western Caribbean 06-Mar-16 Music 1 mark 5 1966
MiamiSail_Date in format dd-MMM-yy
Western Caribbean 30-Mar-16 Art 1 mark 5 1972
MiamiPortrait, singleWestern
page wide, all fields present,
Caribbean no truncation
14-Apr-16 Art 1 mark 5 2041
Miami Bahamas 24-Apr-16 Music 5 1687
Miami Western Caribbean 06-May-16 Art 5 1807
Miami Western Caribbean 11-May-16 Music 5 1785
Miami Western Caribbean 16-May-16 Music 5 1813
Miami Western Caribbean 21-May-16 Art 5 1820
Miami Western Caribbean 26-May-16 Music 5 1884
Miami Western Caribbean 31-May-16 Music 5 1901
Miami Western Caribbean 05-Jun-16 Music 5 1864
Miami Trans-Panama Canal 02-Jan-17 Art 6 2035
Miami Western Caribbean 15-Jun-17 Art 5 1795
Miami Western Caribbean
Select records (44): 02-Sep-17 Music 5 2035
Miami Western Caribbean
Departure_Port is Miami 12-Nov-17
1 mark Music 5 1796
Miami Bahamas
Theme is Art or Music 16-Nov-17
1 mark Art 3 3148
Miami Eastern Caribbean 19-Nov-17 Art 6 3068
Miami Western Caribbean 23-Nov-17 Music 5 2065
Miami Western Caribbean 02-Dec-17 Music 5 1802
Miami Eastern Caribbean 03-Dec-17 Music 6 2758
Miami Western Caribbean 07-Dec-17 Art 5 1612
Miami Western Caribbean 22-Dec-17 Art 5 2073
Miami Western Caribbean 27-Dec-17 Music 5 2034
Miami Bahamas 01-Jan-18 Music 5 1937
Miami Western Caribbean 09-Jan-18 Music 5 2032
Miami Bahamas 13-Jan-18 Art 5 1620
Miami Western Caribbean 18-Jan-18 Art 5 1838
Miami Western Caribbean 02-Feb-18 Art 5 1776
Miami Western Caribbean 27-Feb-18 Art 5 1910
Miami Western Caribbean 09-Mar-18 Music 5 530
Miami Western Caribbean 14-Mar-18 Art 5 1993
Miami Western Caribbean 19-Mar-18 Music 5 2028
Miami Western Caribbean 24-Mar-18 Art 5 1904
Miami Western Caribbean 29-Mar-18 Music 5 1913
Miami Southern Caribbean 08-Apr-18 Art 6 2908
Miami Western Caribbean 09-Apr-18 Art 5 2012
Miami Western Caribbean 13-Apr-18 Art 5 1559
Miami Western Caribbean 18-Apr-18 Art 5 1819
Miami Trans-Panama Canal 08-May-18 Music 6 1790
Miami Western Caribbean 24-Jul-18 Art 5 1960
Calculates total number of passengers 1 mark Total passengers 85725
Positioned under Passengers column at end of report 1 mark
Accurate label entered to left 1 mark
PUBLISHED
Title
Extended Cruise Sailings Correct, 100% accurate 1 mark
Sail_Date Cruise_Ref Ship_Name Departure_Port Destination Duration Passengers Board Passenger_Nights
19-May-18 SE042SE Sea Enchantress Seattle Alaska 21 2100 Full 44100
23-Aug-16 BS001SE Ballerina of the Sea Seattle Alaska 15 2003 Full 30045
19-Aug-17 SE028SE Sea Enchantress Seattle Alaska 14 2225 Full 31150
25-Jun-18 TH062CA Tawara Hanseatic Star Cape Liberty Bermuda 21 2369 Full 49749
New record SE042SE entered accurately and Calculated field
07-Aug-17 TH033CA Tawara Hanseatic Star Cape Liberty Bermuda Heading 14 2284
100% accurate Full 31976 1 mark
record 23-Aug-16, BS001SE still present 1 mark
30-Jul-18 TH065CA Tawara Hanseatic Star Cape Liberty Bermuda [Duration]*[Passengers]
14 2452calculated,
Fullcorrect values
34328 1 mark
11-Sep-17 TH038CA Tawara Hanseatic Star Cape Liberty Canada/New England 14 1986 Full 27804
24-Sep-18 TH072CA Tawara Hanseatic Star Cape Liberty Canada/New England 14 1994 Full 27916
29-Apr-18 TH055SA Tawara Hanseatic Star San Juan Eastern Caribbean 18 2076 Full 37368
22-Oct-18 TH074CA Tawara Hanseatic Star Cape Liberty Eastern Caribbean 14 2055 Full 28770
19-Oct-16 BS030VA Ballerina of the Sea Vancouver Pacific Coast 14 1978 Full 27692
03-Jan-16 TH001SA Tawara Hanseatic Star San Juan Southern Caribbean 15 2256 Full 33840
19-Feb-17 TH020SA Tawara Hanseatic Star San Juan Southern Caribbean 14 2102 Full 29428
14-May-18 BS066RO Ballerina of the Sea Rome Transatlantic 14 2787 Full 39018
27-Nov-16 TH012BA Tawara Hanseatic Star Barcelona Transatlantic 14 1676 Full 23464
25-Sep-18 SE048SE Sea Enchantress Seattle Trans-Panama Canal 17 1968 Full 33456
23-Apr-18 SE040FO Sea Enchantress Fort Lauderdale Trans-Panama Canal 16 1983 Full 31728
04-Dec-17 SE036MI Sea Enchantress Miami Trans-Panama Canal 15 1994 Full 29910
27-Oct-18 SE050SA Sea Enchantress San Diego Trans-Panama Canal 15 1960 Full 29400
23-Oct-17 SE033LO Sea Enchantress Los Angeles Trans-Panama Canal 14 2010 Full 28140
14-Jan-17 BS037FO Ballerina of the Sea Fort Lauderdale Western Caribbean 14 2864 Full 40096
Name, centre number, candidate number Select records (21):
Specified fields, correct order 1 mark Ship_Name contains sea 1 mark
Sort ascending Destination and descending on Duration 1 mark Duration >=14 1 mark
Landscape, fits single page, all base fields present, no truncation on any field 1 mark Board is Full 1 mark
PUBLISHED
1 Header Automated page numbers left aligned, 23-Apr-19
Automated today’s date right aligned 1 mark
Tawara Cruises 2018 Annual Report
Produced by: Candidate Name
Last year was another record year for the global cruise industry with cruising being one of the fastest growing types of holiday. The global popularity of cruise holidays has grown
20% faster than land-based holidays over the past ten years and since 2008 the European cruise market has expanded by a staggering 49%. Over 25.8 million people worldwide took a
cruise holiday in 2018, the largest number in the history of the cruise industry. These Subtitle Produced
figures confirm the cruiseby: entered
industry’s accurately
resilience 1 mark
to economic downturns and the value provided by
this type of holiday. TC-subtitle style seen in EV5 list and applied (sans-serif, 18pt, underline,
During the past twelve months we have further consolidated our position as one of the right aligned,
world’s single
leading cruiseline,
lines.0pt
We space
deliveredbefore/after) 1 mark
the most profitable year in our history, achieving
Evidence of TC-title
record net income style
of $1.8 modified
billion. in EV4
More repeat 1 mark
business appears to have been the key to this growth. These strong results are a credit to the commitment and the passion of our 80,000
(correct
shipboardattributes – sans-serif
and shoreside team members 32pt, centre,
which, when bold,
coupleditalic,
with the support of our valued travel agent partners, are the foundation of our sustained earnings improvement. It is
0 through
beforetheir
andcollective
after, single linewe
efforts that spacing)
were able to overcome significant challenges during the year such as the negative impact from fuel price increases and currency exchange rates.
Columns
Our cruisesSection
are positioned at in
thecorrect
middle and upper end 1 mark ships are scheduled to enter service in 2019 and 2020.
Overview break position
of the cruise holiday industry. They are generally Additionally, we signed a memorandum of
3 columns, 1 cm column spacing
characterised by cruises that are 14 nights or shorter and
1 mark
understanding to build two new ships which are
Our ships operate on a selection of worldwide itineraries
that call on approximately 200 destinations on five feature a casual ambiance, as well as a variety of expected to enter service in the second quarters of 2021
continents. In addition to our headquarters in London activities and entertainment venues. Our brand appeals and 2022, respectively.
and Florida, we have offices and a network of to families with children of all ages, as well as both older
We are prioritising internet connectivity for our
Subheadings
international (7)
representatives around the world which and younger couples. More families are now cruising
passengers in 2019 and are upgrading our systems and
TC-subhead
primarily focus onstyle
sales applied
and market consistently
development. toWeall, with children so the average age of a cruise passenger
technologies across the entire fleet. This investment will
believe
matchescruising continues
style to bein
defined a popular
EV3 holiday choice 1 mark has therefore dropped.
Chart ensure that seamless, latest-generation connectivity is
due to its inherent value, extensive itineraries and variety The average length of cruise taken by our passengers available
of shipboard and shoreside activities. The following Vertical bar chart created using correct data, yeartolabels
satisfypresent
the needs of the1 modern-day
mark
dropped below 10 days in 2018 for the first time in nine holidaymaker. It will enhance the onboard experience
chart details our growth in cruise passenger numbers (in Chart in correct place, within margins, all data fully visible (no overlap) 1 mark
years. Durations were shorter for both summer and and provide guests with fast and reliable web access and
thousands) over the past five years: Labels
winter cruises accurate
primarily as a result– title and
of more y-axis
short labels entered
cruises the ability correctly
to share cherished memories with1 mark
friends and
Data labels
being scheduled. These displayed on or
shorter cruises helpabove
attracteach bar,
lovedno
oneslegend
even while at sea. 1 mark
Annual Growth Y-axis displays minimum 5000, maximum
guests who are new to cruising and will hopefully then 13 000 1 mark
Y-axis increments set at 2000
return for longer voyages. Sustainability Commitment
1 mark
13000
11500
11000 10100 10600
10800 Our Fleet We are making meaningful progress on our 2025
Passengers
9800 sustainability goals focusing on our environmental
9000 We currently operate 10 ships with a impact performance. This year we have reduced our unit
capacity of Image inserted
approximately in correctfuel
16,150 position
consumption by 28%. We remain 1 markcommitted to
7000 Resized to 2.5 cm
berths. This count includes our two wide, ongoing reduction in air emissions1and
aspect ratio maintained markare expanding
newest shipsAligned to top
which entered ourofleet
text andour
left margin,intext
investment wrapped
the use 1 mark
of low carbon fuels. All of our
5000
in November and December 2018. new ships will be powered by environmentally friendly
2014 2015 2016 2017 2018
We expect to introduce a further six liquefied natural gas (LNG). We have also introduced
ships by the end of 2022. We have four ships on order industry-leading shoreside technology to monitor real-
Footer
with a capacity of approximately 12,200 berths. These
Name, centre no, candidate number centre aligned 1 mark
Name, centre number, candidate number
PUBLISHED
2 23-Apr-19
time navigational performance and energy use across
our fleet.
Themed Cruises The Future
Themed Cruises have become increasingly popular and Exciting times lie ahead for our company in 2019,
Cruise Pricing we see this as the next area of growth within the industry. starting with the first two of our next-generation ships
These are primarily a regular cruise with enhanced or coming into service between June and December. We
Our cruise ticket prices include accommodation and a
additional programming on board. A Themed Cruise are continuing to build strategic stakes and partnerships
wide variety of activities and amenities, including meals
gives guests the opportunity to enjoy a favourite hobby in key areas and we are further investing in new
and entertainment. Prices vary depending on many
or join in a variety of courses to improve their destinations. Our strategy is to attract an array of guests
factors including the destination, cruise length, cabin
knowledge, culture or history. They usually feature by providing a wide variety of itineraries to destinations
selected and the time of year the cruise takes place. Our
special guests such as speakers and performers, or worldwide including Alaska, Asia, Australia, Bahamas,
payment terms require an upfront deposit to confirm a
educational shore excursions. We have responded to the Bermuda, Canada, the Caribbean, Europe, the Panama
reservation, with the balance due prior to the sailing. Our
changing vacation patterns of today’s travellers by Canal and New Zealand with cruise lengths that range
cruises are generally available for sale at least one year
expanding our range of Themed Cruises. from two to 24 nights.
in advance and often as much as two years in advance of
sailing. During the selling period of a cruise, we Interest in ocean cruising is projected to remain strong
Bullets
continually monitor and adjust our cruise ticket prices
Taster
Extract (7Cruises
records)
in 2019. Nearlywidth,
half (48%) of non-cruisers expressed
Any for
consistent bullet style appliedwith
to the
correct data 1Last
mark DB extract in correct place, intact, within column
available cabins based on demand, objective year one in every three of our passengers was on interest in taking an ocean cruise. Based on our planned
Bullets aligned at
of maximising net left margin, single line
yields. 1their
mark field headings displayed, no title on extract
first ever cruise. As a result we have expanded the
1 markwe intend
fleet enlargement and a focus on destinations,
We earn substantially all of our cruise revenues from the range of mini Data
cruisesfully visible,
we offer no to
to appeal wrap
the growing to further extend our ability to serve 1ourmark
guests and to
sales of passenger cruise tickets and cancellation fees. number of peopleOnlywishing
fieldstoCruise_Ref
cruise for the |first
Ship_Name
time. | Duration,
stay correctbecoming
on the path towards order an1even markmore global
These trips lastSelect records
three nights – Theme
or under and offerisaTaster
great cruise line, strengthening our presence 1 in key markets.
mark
While many onboard activities are included in the base
way to try theSelect
cruisingrecords
experience–for a fractionisof<4
Duration the We believe we are well positioned1 mark to attract new
price of a cruise, we realise additional revenues from:
cost and without a large commitment. Customers are consumers to cruising and to continue to bring loyal
Shore excursions
TC-table style seen in EV5 list, applied
able to experience life on board and enjoy a well-earned
consistently
repeat 1 mark
guests back for their next cruising holiday.
Gift shop items (serif, 11pt, italic, centre,
break without having to embark on a long journey that single, 0pt space before and after)
Casino gaming could take weeks. Mini cruises have also proved popular
Full service spas with guests wanting a few days away or experienced
Internet and communication services cruisers wanting to try a new ship before booking a
Laundry and dry cleaning services longer holiday. Taster cruises operating last year were:
Liquor and some non-alcoholic beverage sales
Cruise_Ref Ship_Name Duration Page layout
Photo packages TC-body seen in EV5 list and applied consistently
Specialty restaurants DP049SE Delmara Princess 3
(serif, 10pt, justified, no enhancement, single line,
DP052SE Delmara Princess 3 0pt before, 6pt after) 1 mark
Many of these services are available for pre-booking on
the internet prior to embarkation. These goods and DP054SE Delmara Princess 3
services are provided either directly by us or by DP169SA Delmara Princess 2
Document complete/paragraphs intact, A4,
independent concessionaires, from which we receive landscape, spacing consistent, columns aligned at top,
TH041CA Tawara Hanseatic Star 3
either a percentage of their revenues or a fee. no widows/orphans, split chart, list or extract, no blank
TH043SA Tawara Hanseatic Star 3 pages, 6pt after bullet list/extract, no changes to extract
VG074VA Varuna Glory 2 1 mark
Name, centre number, candidate number
PUBLISHED
Task 5 – Mail merge Document
Merge Fields inserted – – placeholders and <> correctly replaced for all
«Title» | «First_name» | «Family_name» | «Road» | «Area» | «County» | «Postcode» correct
position and spacing maintained 1 mark
«Title» | «Family_name» | «Memb_code» spacing, punctuation and bold/underline retained 1 mark
«Duration» | «Theme» | «Month». | «Discount» spacing and punctuation retained 1 mark
Name replaces text in correct position
Name, centre number, candidate number in footer 1 mark
Name inserted correct position
Name, centre number and candidate in footer 1 mark
PUBLISHED
Result of merge – 3 letters printed –
Li Chen, Malak Feki, Katarzyna Nowak only 1 mark
PUBLISHED
Task 6 – Presentation
Slides imported (5), title and bullet layout, no text changes, blank slides,
or overlap of items, name inserted after Presented by: 1 mark
Master slide items (same position and consistent on all slides)
Name, centre no, candidate number/auto slide numbers only 1 mark
Slide 1 layout changed to centred title/subtitle layout 1 mark
Print layout handouts, 6 to page 1 mark
PUBLISHED
Threats slide – speaker notes added – correct position and accurate – 1 mark
Threats slide printed as presenter/speaker notes layout 1 mark
PUBLISHED
Task 7 – Printing the Evidence Document
Step 1 - EVIDENCE 1 File saved as TCREPORT in the format of software 1 mark
Step 2 – EVIDENCE 2 Header date field
Today's date field used, format dd-MMM-yy evidenced 1 mark
Step 3 – EVIDENCE 3
TC-subhead style
TC-subhead text style created, named correctly 1 mark
sans-serif, 16pt, bold, italic 1 mark
centre aligned, single line, 0pt space before, 6pt space after 1 mark
Step 4 – EVIDENCE 4
TC-title – style modified
Evidence of style modified 1 mark
PUBLISHED
Step 5 – EVIDENCE 5
Style list
Includes TC-subtitle, TC-body, TC-table 1 mark
Step 19 – EVIDENCE 6 - Tawara Cruises is planning to publish the annual report data on its
company wiki. Evaluate the suitability of a wiki to share this type of data.
Disadvantages:
Anyone can edit, delete or modify the content
Could make data unreliable
Accessibility – computer/internet needed
Advantages
Allows the company report to be seen by many people
Saves distribution/printing/time costs
Eco-friendly
Recommendations
Should be presented in a non-editable format
Include a link to the published report on the company website
[3 marks]
Step 20 – EVIDENCE 7
DB Structure – cruises table
All field names as given, correct data types 1 mark
Cruise_Ref as primary key 1 mark
Step 21 – EVIDENCE 8
1-to-Many relationship between Ship_Code
and Ship_Ref fields 1 mark
PUBLISHED
Step 23 – EVIDENCE 9
Database formula for total passengers 1 mark
Step 26 – EVIDENCE 10 Extract exported and saved in rtf format 1 mark
Step 29 – EVIDENCE 11
(a) Explain why styles are used:
− consistent format/layout
− to give a corporate image/brand recognition
− saves time editing/formatting (if a paragraph style is altered) [1 mark]
(b) Explain the purpose and limitations of spell check software:
Purpose: to identify potential data entry errors
to assist user to reduce errors [1 mark]
2 Limitations:
− only checks against words in its dictionary/may not recognise technical
names/abbreviations or words in another language/may not recognise proper
nouns/names
− spell checking does not ensure that correct spelling is used for context/does not
eliminate the need for proofreading
− could introduce new errors
− cannot check text in imported images [2 marks]
Step 32 – EVIDENCE 12
Mail Merge selection
Evidence of automated filter 1 mark
Correct selection of Theme is Taster 1 mark