2023 CCEA GCSE Business and Communication Systems 8240 模擬試題連答案詳解

A loyalty scheme data capture form needs enough information to identify, contact and serve the member correctly. An email address field is essential so the bakery can send digital loyalty offers, points updates and e-receipts. A date of birth field is essential so the bakery can send a birthday reward and confirm the member is of a suitable age to join. A preferred branch field (Newtownards or Comber) is essential so offers, opening-hours updates and promotions can be tailored to the branch the member actually visits. Final answer: Email address (to send loyalty offers/receipts electronically); date of birth (to send a birthday reward and confirm the member is old enough to join); preferred branch (Newtownards or Comber, so offers can be tailored to the branch the member usually visits).

[1] mark for each of any three sensible essential fields (other than name), each with a valid reason, to a maximum of [3]: e.g. email address (contact/digital offers); date of birth (birthday reward/age confirmation); preferred branch (tailored offers); phone number (contact); postal address (posted offers). Field alone with no reason = no mark; field with valid reason = [1].

For a field where there is a small, fixed set of valid answers, such as a choice between two named branches, an interactive drop-down list (combo box) containing only 'Newtownards' and 'Comber' is the appropriate form feature. This is more appropriate than a plain text box because a text box allows the member to type anything, risking spelling mistakes, extra whitespace, or entirely invalid entries (e.g. a different town), whereas a drop-down list restricts the member to selecting one of the two genuinely valid branch names, ensuring the data entered is always accurate and consistent. Final answer: A drop-down list (combo box) containing 'Newtownards' and 'Comber'; this is more appropriate than a plain text box because it restricts the member to selecting one of the two valid branch names, preventing spelling errors, typos or invalid entries.

[1] mark: a valid interactive form feature named (e.g. drop-down list/combo box, radio buttons); [1] mark: correctly identifies that it restricts input to valid options; [1] mark: clear explanation of why this prevents errors compared with a text box. Maximum [3].

A well-designed loyalty scheme data capture form should open with the Strangford Coastal Bakery logo positioned prominently near the top of the page, immediately identifying the business and reinforcing its branding, alongside a clear, bold heading such as 'Loyalty Scheme Membership Form'. The form's colour scheme and font should be consistent with the bakery's existing branding (for example, matching colours used on its packaging or signage), giving the form a professional, recognisable appearance. Fields should be arranged in a logical order (for example, personal details first, followed by contact details and branch preference), laid out vertically with labels aligned consistently to the left and enough space or boxes beside each label for the member to write or tick clearly. Consistent spacing between fields, and section headings if related fields are grouped together, make the form easier to scan and complete accurately, and careful use of margins and spacing ensures the whole form fits neatly on a single A4 page without appearing cramped or cluttered. The form should use the company's logo prominently near the top, a consistent colour scheme and font matching the bakery's branding, a clear heading, fields arranged in a logical, evenly spaced vertical layout with left-aligned labels, adequate space/boxes for each response, and clear section headings if fields are grouped, so the completed form fits neatly onto a single A4 page.

Level 1 (1 mark): A basic, generalised statement about making the form 'look nice' or 'neat', with little specific detail and weak quality of written communication.
Level 2 (2-3 marks): Accurate description of at least two valid styling/layout features (e.g. logo placement, consistent colours, logical field order, aligned labels), with satisfactory quality of written communication.
Level 3 (4 marks): Detailed, well-organised description covering logo/branding, colour/font consistency, logical and clearly aligned layout of fields, and appropriate use of space so the form fits a single A4 page; fluent quality of written communication using appropriate specialist vocabulary.

Following the stated column layout (A = Employee, B = Hours Worked, C = Hourly Rate, D = Overtime Hours, E = Basic Pay, F = Overtime Pay, G = Total Pay), the 'Overtime Pay' heading belongs in column F of row 1, giving cell F1. To keep the spreadsheet's appearance consistent, this heading should be given the same bold font and centred alignment already used for the other headings in row 1. Final answer: Cell F1; formatted in bold and centred, to match the formatting already applied to the other column headings in row 1.

[1] mark: correct cell reference, F1; [1] mark: bold and centred formatting stated, matching the existing headers. Maximum [2].

Storing a constant such as the overtime multiplier in one clearly separate cell, away from the main employee data table, makes the spreadsheet easier to maintain, since the multiplier can be referenced by every row's formula and only needs to be updated in one place if it ever changes. A suitable, clearly labelled cell for this is J1 (in a column beyond the data table), containing the value 1.5. Final answer: Cell J1; value 1.5.

[1] mark: a suitable single cell reference outside the main data table (e.g. J1); [1] mark: the correct value, 1.5, stated. Maximum [2].

The incorrect value in C5, £1.125, should be corrected to £11.25, matching Employee D's actual hourly rate. To ensure all hourly rates in column C display consistently and professionally, the whole column should be formatted using the Currency cell format, so that the £ symbol is shown automatically, and formatted to 2 decimal places, so that every value is displayed to the nearest penny (e.g. £11.25 rather than £11.2 or £11.250). Final answer: £11.25 in C5; column C should be formatted to Currency (GBP) with the £ symbol displayed, and to 2 decimal places.

[1] mark: correct value, £11.25, stated for C5; [1] mark: Currency/£ formatting stated; [1] mark: 2 decimal places stated. Maximum [3].

Since Employee D's record occupies row 5, the next available row for a new employee, directly below, is row 6. Employee E's Hours Worked value, 36, should be entered in cell B6, and their Hourly Rate, £10.00, should be entered in cell C6 (to be displayed as currency once the column formatting is applied). Final answer: Row 6; B6 = 36; C6 = 10.00 (or £10.00).

[1] mark: correct row, 6, stated; [1] mark: B6 = 36 stated; [1] mark: C6 = 10.00/£10.00 stated. Maximum [3].

Overtime Hours only exist when an employee works more than the standard 35-hour week, in which case they equal Hours Worked minus 35; otherwise Overtime Hours is 0. This conditional logic is expressed with an IF function testing whether B2 (Hours Worked) is greater than 35: =IF(B2>35,B2-35,0). Checking this against Employee A's data (B2 = 38): since 38 > 35 is TRUE, the formula returns 38-35 = 3, which matches Employee A's expected 3 overtime hours. Final answer: =IF(B2>35,B2-35,0)

[1] mark: correct IF structure with logical test B2>35; [1] mark: correct 'value if true', B2-35; [1] mark: correct 'value if false', 0. Maximum [3]. Accept minor syntactic variation that produces the same correct result (e.g. =IF(B2>35, B2-35, 0)).

Basic Pay is capped at 35 hours' worth of pay: if Hours Worked exceeds 35, Basic Pay is 35 multiplied by the Hourly Rate; otherwise it is the actual Hours Worked multiplied by the Hourly Rate. This is expressed as =IF(B2>35,35*C2,B2*C2). Checking against Employee A's data (B2 = 38, C2 = 10.50): since 38 > 35 is TRUE, the formula returns 35*10.50 = 367.50, which matches Employee A's expected Basic Pay of £367.50. Final answer: =IF(B2>35,35*C2,B2*C2)

[1] mark: correct IF structure with logical test B2>35; [1] mark: correct 'value if true', 35*C2; [1] mark: correct 'value if false', B2*C2. Maximum [3].

Overtime Pay is Overtime Hours multiplied by Hourly Rate multiplied by the overtime multiplier, giving =D2*C2*J1 in principle; however, because this formula will be replicated (copied down) to later rows, the reference to the multiplier cell J1 must be made absolute, using dollar signs ($J$1), so that it always refers to J1 regardless of which row the formula is copied to, while D2 and C2 remain relative references that adjust automatically for each employee's row. This gives =D2*C2*$J$1. Checking against Employee A's data (D2 = 3, C2 = 10.50, J1 = 1.5): 3*10.50*1.5 = 47.25, which matches Employee A's expected Overtime Pay of £47.25. Final answer: =D2*C2*$J$1

[1] mark: correct multiplication of D2 and C2; [1] mark: reference to J1 correctly made absolute ($J$1); [1] mark: correct overall formula structure that replicates correctly down the column. Maximum [3].

Total Pay is simply Basic Pay plus Overtime Pay for each employee, which can be calculated using the SUM function across the adjacent cells E2 (Basic Pay) and F2 (Overtime Pay): =SUM(E2:F2). Checking against Employee A's data (E2 = 367.50, F2 = 47.25): 367.50 + 47.25 = 414.75, which matches Employee A's expected Total Pay of £414.75. Final answer: =SUM(E2:F2)

[1] mark: SUM function used; [1] mark: correct cell range, E2:F2; [1] mark: formula correctly returns Basic Pay + Overtime Pay with no other cells included. Maximum [3]. Accept =E2+F2 as an equally valid alternative for full marks.

To print the payroll data view cleanly, the print area should first be set to cover only the relevant data table (Employee through to Total Pay, plus the multiplier cell if needed), so that no unrelated worksheet content is printed. The page setup should also be configured to 'Fit to 1 page' (scale to fit), which automatically shrinks the printed content to fit within a single A4 page in portrait orientation, ensuring every column is visible without being split across multiple pages. Final answer: Set the print area to cover only the payroll data table, and use 'Fit to 1 page' (scale to fit) so that all columns print on a single A4 page in portrait orientation.

[1] mark: setting/restricting the print area to the data table stated; [1] mark: 'Fit to 1 page'/scale to fit stated. Maximum [2]. Accept other valid combinations, e.g. adjusting margins/column widths, for partial credit.

By default, a spreadsheet displays the results calculated by its formulas rather than the formulas themselves; to switch to showing the underlying formulas, the keyboard shortcut Ctrl+` (or the 'Show Formulas' option on the Formulas tab of the ribbon) should be used. Once this formula view is displayed, the printout should be clearly labelled 'Formula View', for example by typing this text into the header or footer of the printed page, or into an empty cell positioned above the data table, so the reader can immediately tell it apart from the data view printout. Final answer: Use Ctrl+` (or Formulas > Show Formulas) to display the formulas instead of the calculated values; label the printout 'Formula View', for example by typing this text into a header, footer or an empty cell above the table.

[1] mark: correct method to display formulas stated (Ctrl+`/Show Formulas); [1] mark: a sensible way of labelling the printout 'Formula View' stated (header/footer/cell). Maximum [2].

The chart should be a bar chart with Employee (A, B, C, D, E) on the x-axis and Total Pay (£) on the y-axis, correctly scaled from zero to at least £420, with both axes clearly labelled including the £ unit. Five bars, of equal width and evenly spaced, should be drawn to the correct heights: £414.75 (Employee A), £420.00 (Employee B), £416.50 (Employee C), £360.00 (Employee D) and £365.00 (Employee E). Data labels showing the exact £ value above/on each bar (or a data legend, if colour-coded) should be included so the values are easy to read precisely, and the chart should have a clear, appropriate title, such as 'Total Weekly Pay by Employee'. Final answer: Bar chart: x-axis = Employee (A, B, C, D, E); y-axis = Total Pay (£), scale starting at zero and rising to at least £420; bars of height 414.75, 420.00, 416.50, 360.00 and 365.00 respectively; title e.g. 'Total Weekly Pay by Employee'.

[2] marks: suitable, appropriate title. [1] mark: correct graphical technique (bar chart, equal-width bars/gaps, appropriate for this categorical employee data). [3] marks: accuracy of plotting, awarded in bands (all 5 bars accurate = 3; 3-4 accurate = 2; 1-2 accurate = 1; 0 accurate = 0). [2] marks: conventions (both axes correctly labelled with units, y-axis scale starting at zero, and a data legend/data labels included). Maximum [8].

CustomerID uniquely identifies each customer record, with no two customers sharing the same value, making it the natural choice of primary key for the 'Customers' table. Final answer: CustomerID

[1] mark: CustomerID.

'DateJoined' records when each customer joined the loyalty scheme, which is a calendar date; storing it as Text would allow invalid or inconsistently formatted entries and would prevent dates being sorted or compared correctly, so it should instead be stored as a Date/Time field, ensuring only valid dates can be entered and allowing correct chronological sorting. Final answer: Date/Time

[1] mark: Date/Time.

New records are added to a database table by opening the table in Datasheet View, or by using a linked data capture form, and entering the new customer's details into the first available blank row (marked with an asterisk in most database software), which automatically becomes a new record once data is entered into it. Final answer: Open the Customers table (or a linked data capture form) and enter the details into a new, blank row/record at the end of the table.

[1] mark: correct method described (new blank row in the table, or a linked form, used to enter the new record).

To edit an existing record, the record for CustomerID C014 must first be located within the Customers table, for example by using the Find command to search for C014, or by scrolling/browsing through the table. Once located, clicking into that record's Branch field allows the existing value, 'Newtownards', to be deleted or selected and replaced by typing 'Comber'. Moving the cursor to another field or record (or explicitly saving) then commits the updated value to the table. Final answer: Locate the record for CustomerID C014 in the Customers table (e.g. using Find or by browsing), click into the Branch field for that record, delete 'Newtownards' and type 'Comber', then move to another record (or save) to commit the change.

[1] mark: correctly locating the C014 record (e.g. using Find/searching); [1] mark: correctly editing the Branch field value from 'Newtownards' to 'Comber' and saving/committing the change. Maximum [2].

The relationship between Customers and Orders should be one-to-many, created from the 'CustomerID' primary key in the Customers table to the 'CustomerID' foreign key in the Orders table. This is the correct relationship type because a single customer can place many separate orders over time, but each individual order can only be linked back to one customer, which is exactly the pattern a one-to-many relationship represents (the 'one' side being Customers, the 'many' side being Orders). Final answer: A one-to-many relationship, from Customers to Orders, because one customer can place many orders, but each individual order belongs to only one customer.

[1] mark: correct relationship type, one-to-many; [1] mark: correctly identifies Customers as the 'one' side and Orders as the 'many' side; [1] mark: clear explanation of why (a customer can have many orders, but each order has only one customer). Maximum [3].

A single-criterion SELECT query is created by choosing the fields to display from the Orders table (e.g. OrderID, CustomerID, OrderDate, Branch, OrderValue) and entering one condition in the query design grid: in the criteria row beneath the Branch column, the value 'Comber' is entered. Running this query returns only the order records where the Branch field exactly matches 'Comber', excluding all Newtownards orders. Final answer: A SELECT query built on the Orders table with the single criterion Branch = 'Comber' entered in the criteria row beneath the Branch field, returning only the order records placed at the Comber branch.

[1] mark: correct table (Orders) and relevant fields selected; [1] mark: correct single criterion, Branch = 'Comber', entered in the criteria row; [1] mark: correctly explains that this returns only matching (Comber) records. Maximum [3].

A multiple-criteria SELECT query is created in the same way as a single-criterion query, by choosing the relevant fields from the Orders table, but this time two conditions are entered in the query design grid on the same criteria row: 'Comber' beneath the Branch field, and >20 beneath the OrderValue field. Entering both criteria on the same row applies an AND condition, so the query returns only the order records that satisfy both conditions simultaneously - placed at the Comber branch and worth more than £20 - excluding any Comber order worth £20 or less, and excluding any Newtownards order regardless of value. Final answer: A SELECT query built on the Orders table with two criteria entered on the same criteria row: Branch = 'Comber' in the Branch column, and >20 in the OrderValue column, so that only records meeting both conditions are returned.

[1] mark: correct table and relevant fields selected; [1] mark: correct first criterion, Branch = 'Comber'; [1] mark: correct second criterion, OrderValue > 20; [1] mark: correctly explains that entering both criteria on the same row applies an AND condition, requiring both to be true. Maximum [4].

A professional database report is best created using the Report Wizard, selecting the previously created Orders query (Comber branch, order value over £20) as its data source rather than the raw table, so the report only includes the filtered records required. Within the wizard, grouping should be applied on the Branch field, so records are organised into clearly separated groups by branch, and a sort order should be applied within each group on the OrderDate field, so orders appear chronologically within each branch group. The Strangford Coastal Bakery logo image should then be inserted into the report header (in Design View if needed), so it appears once at the top of the report rather than being repeated on every record, giving the report a professional, branded appearance. Finally, column headings should be clearly labelled, and appropriate spacing and consistent formatting (such as aligned columns and a suitable page title) should be applied so the finished report looks polished and business-appropriate. Final answer: Use the Report Wizard (or Report tool) based on the Orders query, group the report by Branch, sort the records within each group by OrderDate, insert the company logo image into the report header so it appears once at the top of the report, and format headings/totals for a professional business appearance.

[2] marks: correct data source (the previously created query, not the raw table) used, with the Report Wizard/Report tool. [2] marks: correct grouping applied, on the Branch field. [1] mark: correct sorting applied within groups, on the OrderDate field. [1] mark: logo image correctly inserted into the report header (appearing once, not per record). [2] marks: professional, clearly formatted overall appearance (clear headings, consistent alignment/spacing, suitable page title). Maximum [8].

Setting up a mail merge begins by starting the Mail Merge feature in the word processing software and selecting 'Letters' as the type of merge document to be produced. The recipient data source must then be connected: the existing Customers table in Orders.accdb is selected, so the merge can draw each customer's Name, Email and Branch directly from the database rather than the details being typed manually. With the data source connected, the standard letter text is written (or an existing letter opened), and merge fields, such as «Name» and «Branch», are inserted at the appropriate points within the letter wherever personalised information should appear. Before completing the merge, the result should be previewed for at least one sample customer, to check that the merge fields display the correct information and that the letter reads correctly once merged. Finally, the merge is completed (merged to a new document, printer, or email), generating one individually personalised letter for every customer record in the Customers table. Final answer: Start the mail merge and select 'Letters' as the document type; connect to the Customers table (in Orders.accdb) as the recipient data source; type the standard letter text, inserting merge fields (e.g. Name, Branch) at the appropriate points; preview the merge to check the fields display correctly for a sample customer; then complete the merge to generate one personalised letter per customer, ready to print or save.

[1] mark: correctly starts a Letters mail merge; [2] marks: correctly connects/selects the Customers table as the data source; [2] marks: correctly describes inserting merge fields (e.g. Name, Branch) into the standard letter text; [1] mark: correctly describes previewing the merge; [1] mark: correctly describes completing the merge to produce one personalised letter per customer. Maximum [7].

The standard letter must be written once, with merge fields inserted (usually shown between chevrons, «FieldName», in most word processing software) at each point where personalised customer information should appear. Since the greeting needs the customer's title and surname, and the announcement needs to mention their branch, merge fields for these should be inserted directly into the sentence text: 'Dear «Title» «Surname», We are excited to let you know about our new loyalty rewards scheme, now available at our «Branch» branch, where you can start earning points on every purchase.' When merged with the Customers table, «Title» «Surname» and «Branch» will each be automatically replaced with the corresponding value from that customer's record. Final answer: Dear «Title» «Surname», We are excited to let you know about our new loyalty rewards scheme, now available at our «Branch» branch, where you can start earning points on every purchase.

[2] marks: correct greeting structure with appropriate name merge field(s) (e.g. «Title» «Surname» or «Name»); [2] marks: correct merge field for Branch inserted appropriately in the sentence; [3] marks: fluent, professional, grammatically correct letter opening in plain business English, correctly combining fixed text and merge fields. Maximum [7].

Once the mail merge is completed, each merge field in the standard letter is replaced with the corresponding value from that customer's record. For CustomerID C014 (Title 'Mr', Surname 'Murphy', Branch 'Comber'), «Title» is replaced with 'Mr', «Surname» is replaced with 'Murphy', and «Branch» is replaced with 'Comber', while all the surrounding fixed text stays exactly the same. This produces the personalised output: 'Dear Mr Murphy, We are excited to let you know about our new loyalty rewards scheme, now available at our Comber branch, where you can start earning points on every purchase.' Final answer: Dear Mr Murphy, We are excited to let you know about our new loyalty rewards scheme, now available at our Comber branch, where you can start earning points on every purchase.

[2] marks: correctly merged name, 'Mr Murphy'; [2] marks: correctly merged branch, 'Comber'; [3] marks: full sentence correctly and precisely reproduced with only the merge fields replaced, all other text unchanged. Maximum [7].

Slide 1 should have a clear, topic-matching title, such as 'Word Processing Software', so new staff immediately know what the slide covers. The body text should explain a key concept of the topic, for example that word processing software is used to create, edit and format text-based business documents, such as letters and reports, giving new staff a clear, simple understanding of what the software is for. Final answer: Title: 'Word Processing Software'; key concept: word processing software is used to create, edit and format text-based documents such as letters and reports.

[1] mark: clear, relevant title given; [1] mark: accurate key concept explaining word processing software's purpose. Maximum [2].

Slide 2 should have a clear, topic-matching title, such as 'Spreadsheet Software'. The body text should explain a key concept, for example that spreadsheet software organises data into rows and columns and can use formulae and functions, such as SUM or IF, to perform automatic calculations, helping new staff understand its core purpose. Final answer: Title: 'Spreadsheet Software'; key concept: spreadsheet software organises data in rows and columns, and can use formulae and functions to perform automatic calculations.

[1] mark: clear, relevant title given; [1] mark: accurate key concept explaining spreadsheet software's purpose. Maximum [2].

Slide 3 should have a clear, topic-matching title, such as 'Database Software'. The body text should explain two key concepts: first, that a database stores structured data in tables, organised into records (rows) and fields (columns); second, that databases can be searched using queries, allowing specific information to be found quickly, for example filtering customer records by branch. Final answer: Title: 'Database Software'; concepts: (1) a database stores structured data in tables made up of records and fields; (2) databases can be searched/queried to find specific information quickly.

[1] mark: clear, relevant title given; [1] mark: first key concept accurately explained (tables/records/fields); [1] mark: second key concept accurately explained (searching/querying). Maximum [3].

To allow the presenter to move backward through the presentation, a 'Back' or 'Previous' action button, commonly shown as a left-pointing arrow icon, should be inserted on Slides 2 and 3. This type of navigation button is conventionally placed in a bottom corner of the slide, such as the bottom-left, where it is easy for the presenter to click without obstructing the main slide content. Final answer: A 'Back'/'Previous' action button (e.g. a left-pointing arrow), typically placed in a bottom corner of the slide, such as the bottom-left.

[1] mark: correct action button type stated (Back/Previous, left-pointing arrow); [1] mark: sensible placement stated (a bottom corner of the slide). Maximum [2].

For the presenter's copy, the Print menu's layout option should be set to 'Full Page Slides', which prints exactly one slide per page at full size, giving the presenter a clear, large view of each slide. For the new staff handout, the layout option should instead be set to 'Handouts', with '3 Slides' selected as the specific handout layout; this prints three slides per page, each accompanied by ruled lines to the side, giving new staff space to write their own notes next to each slide during the training session. Final answer: Full-size: in the Print menu, select 'Full Page Slides' as the print layout, printing one slide per page. Handout: select 'Handouts' as the print layout and choose '3 Slides' per page, which also adds ruled lines beside each slide for note-taking.

[1] mark: correct 'Full Page Slides' layout stated for the presenter's copy; [1] mark: correct 'Handouts' layout stated for new staff; [1] mark: correctly specifies 3 slides per page (with note-taking lines). Maximum [3].

A key feature of a private limited company is limited liability: the owners (shareholders) are only responsible for the company's debts up to the amount they have personally invested, so their personal assets are protected if the business fails. Final answer: Its owners (shareholders) have limited liability, meaning they are only responsible for business debts up to the amount they invested.

[1] mark: any valid feature of a private limited company, e.g. limited liability; shares cannot be sold to the general public/must be offered privately; owned by shareholders; run by directors.

Advertising a vacancy on the business's own staff intranet only reaches existing employees, which is a method of internal recruitment: filling a vacancy from within the existing workforce, rather than external recruitment, which advertises to people outside the business. Final answer: Internal recruitment (via the intranet).

[1] mark: internal recruitment.

Selection methods, other than an interview, that a business could use to choose a new employee include an application form (or digital application form), a curriculum vitae (CV), testing (for example, a practical task relevant to the job, such as baking), or a presentation. Final answer: Any one of: an application form; a CV; testing (e.g. a practical baking task); a presentation.

[1] mark: any one valid selection method other than interview, e.g. application form/CV/testing/presentation.

Induction training is the training given to a new employee at the very start of their employment, designed to introduce them to the business, its procedures and their specific role. It is important because it helps the new employee settle into the business quickly, understand essential procedures such as health and safety requirements from day one, and become confident and productive in their role sooner than if they had received no formal introduction. Final answer: Induction training is training given to a new employee when they first start a job, to introduce them to the business and their role; it is important because it helps the new employee settle in quickly, understand key procedures such as health and safety, and become productive sooner.

[1] mark: correct definition of induction training; [1] mark: a valid, clearly stated reason why it is important. Maximum [2].

One advantage of using a private recruitment agency is that the agency has specialist recruitment expertise and an existing pool of candidates, and can pre-screen applicants against the job requirements before passing suitable candidates on to the bakery, saving Strangford Coastal Bakery significant time and effort compared with running the whole recruitment process itself. One disadvantage, however, is that private recruitment agencies charge a fee for their service, often a percentage of the new employee's salary, which increases the overall cost of recruitment compared with advertising the vacancy directly. Final answer: Advantage: the agency has recruitment expertise and can pre-screen candidates, saving the bakery time and effort. Disadvantage: the agency charges a fee for its service, increasing the cost of recruitment.

[1] mark: valid advantage identified; [1] mark: advantage clearly explained/developed; [1] mark: valid disadvantage identified; [1] mark: disadvantage clearly explained/developed. Maximum [4].

One advantage of using an interview is that it allows the employer to assess a candidate face to face, judging their communication skills, personality and whether they would fit in well with existing staff and the business's culture, in a way that a written application alone cannot show. One disadvantage, however, is that interviews can be subjective, relying on the interviewer's personal judgement and potentially being influenced by unconscious bias, and a candidate who is simply nervous on the day may underperform and be judged unsuitable despite genuinely having the right skills for the role. Final answer: Advantage: an interview allows face-to-face assessment of a candidate's communication skills and personality, and whether they would fit in with the team. Disadvantage: interviews can be subjective, and a nervous candidate may underperform in the interview despite being genuinely suitable for the role.

[1] mark: valid advantage identified; [1] mark: advantage clearly explained/developed; [1] mark: valid disadvantage identified; [1] mark: disadvantage clearly explained/developed. Maximum [4].

One benefit of staff training is increased productivity: staff who are well trained in their tasks, such as baking techniques or till operation, can work more efficiently, make fewer mistakes, and complete tasks more quickly, directly benefiting the bakery's output and profitability. A second benefit is improved health and safety: staff who receive proper training in correct procedures, for example how to safely operate bakery equipment such as ovens and mixers, are less likely to have accidents at work, reducing the risk of injury to staff and potential costs or liability for the business. Final answer: Training increases productivity, because well-trained staff can work more efficiently and make fewer mistakes; training also improves health and safety, because staff who are properly trained in correct procedures (e.g. safely using bakery equipment) are less likely to have accidents.

[1] mark: first benefit identified (e.g. productivity); [1] mark: first benefit clearly explained/developed with reference to the bakery; [1] mark: second benefit identified (e.g. health and safety); [1] mark: second benefit clearly explained/developed with reference to the bakery; [1] further mark for a well-structured response covering both benefits clearly. Maximum [5].

For teaching a new bakery assistant how to safely operate the industrial dough mixer, on-the-job training is the most suitable method. This is because on-the-job training takes place at the actual workplace, using the real equipment, so an experienced colleague can directly demonstrate correct and safe operation of the specific dough mixer the assistant will actually be using, and the new assistant can practise under supervision straight away. This hands-on, practical approach is more effective for teaching a physical, equipment-based skill than off-the-job training, which would take place away from the workplace (for example, in a classroom or training centre) and would not give the same direct, supervised experience with the actual machine and working conditions the assistant will encounter day to day; on-the-job training is also typically cheaper, since it does not require external training costs or travel. Final answer: On-the-job training is the most suitable method, because the new bakery assistant can be shown how to use the dough mixer safely by an experienced colleague, using the actual equipment in the real bakery environment, which is more effective for a hands-on practical skill than off-the-job training away from the workplace.

[1] mark: correct method identified (on-the-job training); [2] marks: justification linked to the practical, hands-on, equipment-based nature of the task; [2] marks: justification linked to using the real equipment/environment and/or being more effective or cost-effective than off-the-job training. Maximum [5].

One method of primary (field) market research is a customer questionnaire or survey, either handed out in the bakery or shared online, asking customers directly which new cake flavours they would like to see; this generates first-hand, specific data collected by the bakery itself. One method of secondary (desk) market research is reviewing existing published reports or industry data, such as bakery/food trend reports, on current and forecast cake flavour trends; this uses data that already exists, having been collected by someone else, rather than being gathered directly by the bakery. Final answer: Primary research: a customer questionnaire/survey, handed out in the bakery or shared online, asking customers directly which new flavours they would like. Secondary research: reviewing existing published reports or industry data on current cake/bakery trends.

[1] mark: valid primary research method named (e.g. questionnaire/survey); [1] mark: primary method clearly explained/developed; [1] mark: valid secondary research method named (e.g. published/industry reports); [1] mark: secondary method clearly explained/developed; [1] further mark for a clear, well-linked overall response distinguishing the two types correctly. Maximum [5].

Penetration pricing is a pricing strategy in which a business sets a deliberately low initial price for a new product, or in this case a new branch's offering, in order to attract customers quickly and build market share, with the price potentially being raised once a loyal customer base has been established. This strategy might be suitable for Strangford Coastal Bakery when launching a new branch because a low initial price would help attract price-sensitive local customers away from already-established competitors in the new area, quickly building awareness, footfall and a loyal customer base for the new branch before prices are gradually increased towards normal levels. Final answer: Penetration pricing means setting a low initial price for a new product/branch to attract customers quickly and build market share, before potentially raising prices later; it would be suitable for a new branch because it would help attract price-sensitive local customers away from established competitors quickly, building a loyal customer base in the new area.

[1] mark: accurate definition of penetration pricing (low initial price to attract customers/build market share); [1] mark: correctly notes price may rise later; [2] marks: clear, developed explanation of why this suits a new branch launch (attracting customers from competitors, building a loyal base); [1] further mark for a well-structured, business-context response. Maximum [5].

The product life cycle describes the stages a product passes through from its launch to its eventual withdrawal from the market: introduction, when the product is first launched and sales are low; growth, as sales rise quickly; maturity, when sales peak and growth slows; and decline, as sales fall, often as customer tastes change or competitors take market share. To extend the life cycle of one of its cake products once it reaches the maturity or early decline stage, Strangford Coastal Bakery could use an extension strategy such as introducing a new flavour or variation of the existing cake (for example, a seasonal version), which can generate renewed customer interest and boost sales, delaying the product's decline. Final answer: The product life cycle describes the stages a product goes through from launch to decline (introduction, growth, maturity and decline), with sales typically rising then falling over this period; to extend the life cycle of a cake product, Strangford Coastal Bakery could introduce a new flavour or variation of the product to boost sales and delay decline.

[1] mark for each stage of the product life cycle correctly named (introduction, growth, maturity, decline), to a maximum of [3]; [1] mark: correctly notes the general sales pattern (rising then falling); [2] marks: a valid, clearly explained extension strategy (e.g. new flavour/variation, repackaging, new promotion) linked specifically to a Strangford Coastal Bakery cake product. Maximum [6].

Advertising, whether on social media such as Instagram or in a local newspaper, is a way of communicating a product to customers, which is the 'Promotion' element of the marketing mix (alongside Product, Price and Place). Final answer: Promotion.

[2] marks: Promotion, correctly identified as the marketing mix element.

Digital technology has had several positive impacts on Strangford Coastal Bakery's marketing. Social media platforms, such as Instagram, allow the bakery to reach a wide audience at very low cost compared with traditional advertising, and to target offers and adverts at specific customer groups based on their interests or location. Digital technology also benefits customers directly: an online ordering or click-and-collect system offers greater convenience, letting customers order birthday cakes or place large orders without visiting a branch in person, and digital tools such as online reviews and social media give customers an easy way to find out about the bakery and share feedback. However, digital technology also brings costs and risks. Maintaining an effective social media presence and website takes ongoing staff time and cost, and, unlike traditional advertising, negative comments or poor reviews posted online can spread very quickly and damage the bakery's reputation before it has a chance to respond. Collecting and storing customer data digitally, for example through the loyalty scheme or online orders, also raises data security and privacy concerns, meaning the bakery must comply with legislation such as the Data Protection Act 1998 to protect customer information and avoid legal and financial consequences of a data breach. Overall, digital technology's impact on Strangford Coastal Bakery's marketing and customers is predominantly positive, offering low-cost, targeted reach and greater customer convenience, but this benefit depends on the bakery managing the associated costs, reputational risks and data security responsibilities carefully. Digital technology has benefited Strangford Coastal Bakery's marketing by allowing it to reach customers cheaply and widely through social media, target offers to specific groups, and let customers order conveniently online, but it has also brought costs and risks, including the time and expense of maintaining a digital presence, the risk of negative reviews spreading quickly, and data security/privacy concerns, so digital technology's overall impact is positive but must be carefully managed.

Level 1 (1-3 marks): General, undeveloped points about digital technology and marketing, with little or no reference to the bakery's specific context; a one-sided or absent evaluation; weak quality of written communication.
Level 2 (4-6 marks): Accurate description of at least one benefit and one drawback of digital technology for marketing/customers, with some relevant context and specialist vocabulary, but limited or one-sided evaluation; sound quality of written communication.
Level 3 (7-8 marks): Thorough, balanced evaluation of both the benefits (e.g. low-cost/targeted reach, customer convenience) and drawbacks (e.g. cost/time, reputational risk, data security/legislation) of digital technology for the bakery's marketing and customers, supported by accurate specialist terminology and a clear overall judgement; clear, logically structured, fluent quality of written communication.

A stakeholder is any individual or group who has an interest in, or is affected by, the activities and performance of a business. Employees are one stakeholder group of Strangford Coastal Bakery, with an interest in job security, fair pay and safe working conditions, since their livelihood depends directly on the business. The local community is a second stakeholder group, with an interest in local job creation and the environmental impact of the bakery's operations, such as noise, delivery traffic and waste, since these directly affect people living near the bakery's branches. Final answer: A stakeholder is any individual or group with an interest in, or affected by, the activities and performance of a business. Employees are a stakeholder group interested in job security, fair pay and safe working conditions; the local community is a stakeholder group interested in local job creation and the environmental impact of the bakery's operations (e.g. noise, deliveries, waste).

[1] mark: correct definition of stakeholder; [1] mark: first stakeholder group correctly named with a valid interest; [1] mark: second, different stakeholder group correctly named with a valid interest; [1] further mark for clearly and specifically developed explanation of at least one interest. Maximum [4].

Digital trading is the buying and selling of goods and services online or electronically, rather than through a traditional face-to-face transaction in person. The owners' aim in introducing digital trading is to increase efficiency and profit, for example by reaching more customers and reducing queuing time in branches; however, this may conflict with the employees' aim of job security, because if more customers choose to order online rather than in person, the bakery may need fewer till or counter staff, creating a genuine tension between the owners' aim of maximising profit/efficiency and the employees' aim of protecting their own jobs. Final answer: Digital trading is the buying and selling of goods and services online/electronically, rather than in person. The owners' aim of introducing digital trading is to increase profit and efficiency, but this may conflict with employees' aim of job security, since fewer till/counter staff might be needed if more customers order online.

[1] mark: correct definition of digital trading; [1] mark: owners' aim correctly identified (increase profit/efficiency); [1] mark: employees' aim correctly identified (job security); [1] mark: clear explanation of the conflict between these two aims. Maximum [4].

The business document used to formally record what happened at a meeting is a set of minutes. Minutes for the meeting about new opening hours should include who attended the meeting (and any apologies from those who could not attend), so there is a clear record of who took part in the decision, and the decisions or actions agreed at the meeting, including who is responsible for carrying out each action, so that everyone is clear on what was decided and what happens next. Final answer: Minutes; should include: (1) who attended the meeting (and who sent apologies); (2) the decisions/actions agreed at the meeting, and who is responsible for each action.

[1] mark: correct document, minutes; [1] mark: first valid piece of information stated (e.g. attendees/apologies); [1] mark: second valid piece of information stated (e.g. decisions/actions and who is responsible). Maximum [3].

One advantage of using video conferencing is that it saves time and travel cost, since the Newtownards and Comber branch managers do not need to physically travel to a shared location to meet, allowing the meeting to happen more quickly and cheaply. One disadvantage, however, is that video conferencing depends on technology working correctly, so technical problems such as a poor internet connection can disrupt or delay the meeting, and it can also be harder to build rapport or accurately read body language and non-verbal cues over a video call compared with meeting face to face in person. Final answer: Advantage: it saves time and travel cost, since the managers do not need to travel between branches. Disadvantage: technical problems, such as a poor internet connection, can disrupt the meeting, and it can be harder to build rapport or read body language compared with meeting in person.

[1] mark: valid advantage identified and explained (e.g. saves time/travel cost); [1] mark: valid disadvantage identified and explained (e.g. technical problems, harder to build rapport); [1] further mark for a clear, developed, business-context response. Maximum [3].

Effective communication is important for Strangford Coastal Bakery in several ways. Effective communication with suppliers, for example clearly specifying quantities and delivery dates for flour and other ingredients, ensures deliveries arrive on time and in the correct amounts, avoiding stock shortages that could disrupt baking and sales. Effective communication with customers, for example through clear signage or social media posts about allergens in its cakes, is also important, since it directly protects customer safety and helps the bakery build trust and a positive reputation with its customers, which in turn supports customer loyalty and repeat business. Final answer: Effective communication with suppliers ensures ingredient deliveries arrive on time and in the correct quantities, avoiding stock shortages; effective communication with customers (e.g. clear signage or social media posts about allergens) ensures customer safety and builds trust and reputation.

[1] mark: first example identified (e.g. supplier communication); [1] mark: first example clearly explained/developed; [1] mark: second example identified (e.g. customer communication); [1] mark: second example clearly explained/developed. Maximum [4].

Digital technology has had a strongly positive impact on how Strangford Coastal Bakery communicates with many of its stakeholders. Email and social media allow the bakery to communicate with customers and suppliers faster and far more cheaply than traditional letters or phone calls, and to reach a wide audience instantly when informing customers about new products, offers or changes to opening hours. Video conferencing, as considered in the previous question, also allows managers at the Newtownards and Comber branches to communicate and hold meetings without needing to travel, saving time and cost and improving communication between the two branches. However, digital technology has also brought risks to the bakery's communication with its stakeholders. Written digital messages, such as emails or social media posts, can more easily be misunderstood than face-to-face conversation, since tone of voice and body language are lost, increasing the risk of miscommunication with employees, customers or suppliers. There are also security and e-safety risks, such as phishing emails or data breaches, particularly given that the bakery now holds digital customer data through its loyalty scheme, meaning it must comply with legislation such as the Data Protection Act 1998 to protect stakeholders' information. In addition, negative comments or complaints posted publicly on social media can spread very quickly and damage the bakery's relationship with customers and its wider reputation, in a way that a private complaint letter would not. Overall, digital technology has significantly improved the speed, cost and reach of Strangford Coastal Bakery's communication with its stakeholders, but this benefit is only fully realised if the bakery actively manages the risks of miscommunication, data security and reputational damage that come with it. Digital technology has allowed Strangford Coastal Bakery to communicate with its stakeholders faster, more cheaply and more widely, through tools such as email, social media and video conferencing between branches, but it has also introduced risks such as miscommunication in written messages, security/e-safety concerns, and the potential for negative comments to spread quickly, so its overall impact has been positive but requires careful management.

Level 1 (1-3 marks): General, undeveloped points about digital communication, with little or no reference to the bakery's specific stakeholders or context; a one-sided or absent evaluation; weak quality of written communication.
Level 2 (4-6 marks): Accurate description of at least one benefit and one drawback of digital technology for communicating with stakeholders, with some relevant context and specialist vocabulary, but limited or one-sided evaluation; sound quality of written communication.
Level 3 (7-8 marks): Thorough, balanced evaluation of both the benefits (e.g. speed, cost, reach, video conferencing between branches) and drawbacks (e.g. miscommunication, security/e-safety, reputational risk) of digital technology for communicating with a range of stakeholders, supported by accurate specialist terminology and a clear overall judgement; clear, logically structured, fluent quality of written communication.