CCEA GCSE · thinka-original Practice Paper

2025 CCEA GCSE Business and Communication Systems 8240 Practice Paper with Answers

Thinka Jun 2025 CCEA GCSE-Style Mock — Business and Communication Systems 8240

175 marks180 mins2025
An original Thinka practice paper modelled on the structure and difficulty of the Jun 2025 CCEA GCSE Business and Communication Systems 8240 paper. Not affiliated with or reproduced from CCEA.

Section Unit 1: Task 1 - Word Processing / DTP Poster

Use word processing or desktop publishing software along with the provided company logo to create an effective, professionally formatted A4 promotional poster including all required event details.
4 Question · 11 marks
Question 1 · Essential Information Inclusion
4 marks
Mourne View Adventures, an outdoor activity centre based at 14 Shore Road, Newcastle, Co. Down, BT33 0AB, is holding a Family Fun Day on Saturday 14 June, 11 am to 4 pm, to launch its new junior kayaking programme. You have been asked to design an A4 promotional poster for the event using word processing or DTP software, working from the provided company logo file (MVA_logo.png).

State four essential pieces of information about the event that must be included on the poster.
Show answer & marking scheme

Worked solution

A promotional poster must give a reader everything needed to decide whether to attend and how to find the event. This means clearly stating the name of the event, the date and time it takes place, the venue or location (address), and a short description of what the event involves, alongside contact details or booking information.

Marking scheme

1 mark for each of any four of: name/title of the event; date and time; venue/location (address); description of the activities/what the event involves; contact details or how to book/find out more. Max 4 marks.
Question 2 · Image / Logo Insertion
1 marks
State where on the poster the Mourne View Adventures company logo should be positioned, and give one reason for this choice of position.
Show answer & marking scheme

Worked solution

Placing the logo prominently near the top of the poster, such as in a corner or centred above the heading, ensures it is one of the first things a reader sees, immediately identifying the organiser and reinforcing brand recognition.

Marking scheme

1 mark: a sensible position (e.g. top of the poster/near the heading) justified by prominence/immediate brand recognition.
Question 3 · Supplementary Contextual Data
2 marks
State two supplementary pieces of information (beyond the four essential details) that could be added to the poster to make it more informative or appealing to families.
Show answer & marking scheme

Worked solution

Beyond the essential facts, a family-focused poster benefits from reassuring, practical extras, such as confirming the event is suitable for all ages and requires no prior experience, noting that free parking and refreshments are available on site, offering an early-booking discount, or advising what to bring or wear.

Marking scheme

1 mark each for any two suitable supplementary details relevant to a family event, e.g. suitability for all ages, free parking, refreshments available, early-booking discount, what to bring. Max 2 marks.
Question 4 · Layout, Typography & DTP Design Quality
4 marks
Explain four features of layout and typography that should be applied when designing the poster to ensure a professional, single-page A4 design.
Show answer & marking scheme

Worked solution

A professional poster uses a large, bold heading or title in a font clearly larger than the body text, so it is instantly readable. No more than two or three complementary fonts and colours should be used consistently throughout, avoiding a cluttered appearance. Effective use of white space and margins prevents the design from feeling cramped, while consistent alignment of text and images (for example, all centred, or all left-aligned) gives the poster a tidy, coherent look. Finally, all of this content must be fitted within a single A4 page without overflowing onto a second page or appearing squeezed.

Marking scheme

1 mark each for any four of: a large, bold heading/title in a font clearly different in size from the body text; a limited/complementary choice of no more than 2–3 fonts and colours used consistently; effective use of white space/margins so the design is uncluttered; consistent alignment of text and image elements throughout; all content fitted onto a single A4 page without overflowing or appearing cramped. Max 4 marks.

Ready to test yourself?

Turn these notes into exam-style practice. Get unlimited AI questions on this topic with instant marking and explanations.

Practise This Topic

Section Unit 1: Task 2 - Spreadsheets & Mail Merge

Open the provided spreadsheet data file. Enter data, insert formulas, apply IF logic, replicate formulas, format values, generate a full-page chart, and execute a mail merge letter to designated recipients.
14 Question · 51 marks
Question 1 · Spreadsheet Editing & Formatting
3 marks
You are provided with the data file MVA_Bookings.xlsx, recording bookings for four kayaking taster sessions at the Family Fun Day, with column headings in row 1: A = Session, B = Time, C = Places Booked, D = Places Available.

Row 2: A, 11:00, 8, 10
Row 3: B, 12:30, 10, 10
Row 4: C, 14:00, 6, 10
Row 5: D, 15:30, 4, 10

A new column, 'Places Remaining', is required in column F. State the cell reference for the column heading, and describe how the column heading should be formatted to match the other headings in row 1.
Show answer & marking scheme

Worked solution

The new heading belongs in row 1, in the next empty column after the existing four headings (A–D), which is cell F1 (column E being reserved for Price per Person). To keep the spreadsheet consistent, this heading should be given the same bold font and centred alignment used for the existing headings.

Marking scheme

1 mark: correct cell reference, F1; 1 mark: bold formatting stated; 1 mark: centred alignment stated (or other consistent formatting matching the existing headers).
Question 2 · Spreadsheet Editing & Formatting
2 marks
State the steps required to insert a new row above row 2 of MVA_Bookings.xlsx, so that a fifth session, Session E, can be added at the top of the list.
Show answer & marking scheme

Worked solution

Right-clicking directly on the row 2 number at the left of the spreadsheet, or first selecting the whole of row 2, and then choosing the Insert (Row) command inserts a new, blank row immediately above the existing row 2, pushing all the existing session rows down by one.

Marking scheme

1 mark: right-click the row 2 header (or select row 2) and choose Insert (Row); 1 mark: correctly notes this inserts a new blank row above the existing row 2, shifting the other rows down.
Question 3 · Spreadsheet Editing & Formatting
3 marks
Column E of MVA_Bookings.xlsx holds the 'Price per Person' for each session, all currently £15. Explain how you would apply currency formatting, to two decimal places with a £ symbol, to this column for rows 2 to 5.
Show answer & marking scheme

Worked solution

The cell range E2:E5 is first selected, then the Format Cells dialogue (or the currency button on the Home ribbon) is used to apply the Currency number format, choosing the £ (GBP) symbol and setting the number of decimal places to 2, so each value displays consistently as, for example, £15.00.

Marking scheme

1 mark: correct cell range selected, E2:E5; 1 mark: Currency format applied via Format Cells (or equivalent toolbar command); 1 mark: £ symbol and 2 decimal places specified.
Question 4 · Spreadsheet Editing & Formatting
2 marks
State how the column headings in row 1 should be formatted so that they remain visible on-screen when a user scrolls down through a long list of bookings.
Show answer & marking scheme

Worked solution

Using the Freeze Panes command (or the specific 'Freeze Top Row' option) fixes row 1 in place at the top of the window, so the column headings remain visible while the user scrolls down through the rest of the booking data below.

Marking scheme

1 mark: use the Freeze Panes/Freeze Top Row command; 1 mark: correctly identifies that this keeps row 1 visible while the rest of the sheet scrolls.
Question 5 · Formulae & Logical Functions (=SUM, =AVERAGE, =IF)
3 marks
Using the session data above, write the formula that should be entered in cell F2 to calculate the number of places remaining for Session A (Places Available minus Places Booked), and state the value this formula would produce.
Show answer & marking scheme

Worked solution

Places Remaining is calculated as Places Available (column D) minus Places Booked (column C), so the formula in F2 is =D2-C2. For Session A, this is 10 − 8 = 2.

Marking scheme

1 mark: correct formula structure using cell references, =D2-C2; 1 mark: correct order (Places Available − Places Booked, not reversed); 1 mark: correct resulting value, 2.
Question 6 · Formulae & Logical Functions (=SUM, =AVERAGE, =IF)
2 marks
State the formula that should be entered in cell C6 to calculate the total number of places booked across all four sessions (cells C2 to C5).
Show answer & marking scheme

Worked solution

The SUM function adds together a range of cells, so entering =SUM(C2:C5) in cell C6 totals the Places Booked values for all four sessions.

Marking scheme

1 mark: correct function used, SUM; 1 mark: correct range specified, (C2:C5).
Question 7 · Formulae & Logical Functions (=SUM, =AVERAGE, =IF)
3 marks
Write a formula for cell G2 using an IF function that displays 'FULL' if Places Remaining (F2) is equal to 0, and displays 'AVAILABLE' otherwise.
Show answer & marking scheme

Worked solution

An IF function tests a logical condition and returns one value if it is true and another if it is false. Here the test is whether F2 equals 0; if true, the formula displays "FULL", and if false, it displays "AVAILABLE": =IF(F2=0,"FULL","AVAILABLE").

Marking scheme

1 mark: correct IF function structure, =IF(...); 1 mark: correct logical test, F2=0; 1 mark: correct true/false text values in the correct order, "FULL" then "AVAILABLE".
Question 8 · Formulae & Logical Functions (=SUM, =AVERAGE, =IF)
2 marks
The formula in cell F2 (=D2-C2) needs to be applied to cells F3, F4 and F5. Describe how this formula can be replicated down the column, and explain why the cell references will automatically update for each row.
Show answer & marking scheme

Worked solution

Selecting cell F2 and dragging the small fill handle at its bottom-right corner down to F5 (or copying F2 and pasting into F3:F5) replicates the formula down the column. Because the cell references in the formula are relative references rather than absolute, they automatically adjust to refer to the corresponding row as the formula is copied, so F3 becomes =D3-C3, F4 becomes =D4-C4, and so on.

Marking scheme

1 mark: correctly describes replicating using the fill handle (drag down) or copy/paste; 1 mark: correctly explains that relative cell references automatically adjust to the corresponding row when copied.
Question 9 · Spreadsheet Page Setup & Print Verification
2 marks
State two page setup settings that should be applied before printing MVA_Bookings.xlsx, to ensure it prints clearly on a single page in landscape orientation.
Show answer & marking scheme

Worked solution

In the Page Setup dialogue, the orientation should be changed from portrait to landscape, and the scaling option should be set to fit the printout to one page wide by one page tall, so all the columns appear together on a single sheet rather than being split across pages.

Marking scheme

1 mark: orientation set to landscape; 1 mark: scaling set to fit the printout to one page (e.g. 'Fit to 1 page').
Question 10 · Spreadsheet Page Setup & Print Verification
2 marks
State the two printouts that should be produced as evidence for this spreadsheet task, and explain the difference between them.
Show answer & marking scheme

Worked solution

The Data View printout shows the spreadsheet as normally seen, displaying the calculated results of all formulas. The Formulae View printout, produced by switching on the 'show formulas' display option (typically with gridlines and row/column headings also switched on for clarity), instead shows the actual formula text entered in each cell, providing evidence of exactly how each value was calculated.

Marking scheme

1 mark: two printouts correctly named — Data View and Formulae View; 1 mark: correctly explains the difference, i.e. Data View shows the calculated results while Formulae View shows the underlying formulas (with gridlines/headings switched on for evidence).
Question 11 · Data Visualisation / Full-Page Charting
7 marks
Using the 'Session' and 'Places Booked' data, describe how you would create a full-page column chart, on a separate sheet, to display the number of places booked for each session. Your answer should refer to: the type of chart used, the data selected, the chart title, the axis labels, and the inclusion of data values on the chart.
Show answer & marking scheme

Worked solution

The Session names (A2:A5) and the corresponding Places Booked values (C2:C5) are selected, and a column (bar) chart is inserted, since this chart type is well suited to comparing values across discrete categories. The chart is then moved to a new chart sheet so that it fills a full page. A clear, descriptive chart title is added, such as 'Family Fun Day: Kayaking Session Bookings', the x-axis is labelled 'Session' and the y-axis is labelled 'Number of Places Booked', and data labels are switched on so the exact number of bookings is displayed above each column.

Marking scheme

1 mark: column (bar) chart correctly identified as the appropriate chart type for comparing discrete categories; 1 mark: correct data selected (Session names and Places Booked values); 1 mark: chart moved to/created on a separate chart sheet so it fills a full page; 1 mark: descriptive, relevant chart title given; 1 mark: x-axis correctly labelled (Session); 1 mark: y-axis correctly labelled (Number of Places Booked); 1 mark: data labels/values switched on so figures are shown on the chart.
Question 12 · Mail Merge Formal Letter Design & Execution
7 marks
A mail merge letter is to be sent to each family confirming their kayaking session booking. The data source MVA_Bookings_Contacts.xlsx contains the fields FirstName, LastName, Session, Time and PlacesBooked.

Write the opening lines of the letter (salutation and first paragraph), showing where each mail merge field should be inserted, using standard formal business letter conventions.
Show answer & marking scheme

Worked solution

A formal mail merge letter opens with a salutation built from the FirstName and LastName merge fields, written in the recognised merge-field notation, for example: 'Dear «FirstName» «LastName»,'. The opening paragraph then confirms the purpose of the letter and incorporates the remaining merge fields naturally into a sentence, for example: 'Thank you for booking onto our Family Fun Day. This letter confirms your place on Kayaking Session «Session», starting at «Time», for «PlacesBooked» participant(s).' This sits below the date and the sender's address block, in standard business letter layout.

Marking scheme

1 mark: correct formal salutation using the FirstName and LastName merge fields («FirstName» «LastName»); 1 mark: merge fields shown in recognised mail merge notation (e.g. «FieldName» or similar chevron/bracket notation); 1 mark: Session field correctly incorporated into the confirmation sentence; 1 mark: Time field correctly incorporated; 1 mark: PlacesBooked field correctly incorporated; 1 mark: content written in a clear, formal register appropriate to a business confirmation letter; 1 mark: correct standard business letter structure evident (date/sender details preceding the salutation, salutation on its own line before the body).
Question 13 · Mail Merge Formal Letter Design & Execution
7 marks
Continue the letter with a closing paragraph and complete sign-off, including an appropriate close, the sender's name and position, and mention of an enclosure (e.g. a site map).
Show answer & marking scheme

Worked solution

The closing paragraph gives the family practical information for the day, such as: 'We look forward to welcoming you to Mourne View Adventures. Please arrive 15 minutes before your session time and wear suitable outdoor clothing. Please find enclosed a map of the site.' The letter then closes with 'Yours sincerely,' (matching a named salutation), followed by the sender's name, 'J. Millar', and job title, 'Events Coordinator, Mourne View Adventures', with an 'Enc.' marker confirming the enclosure.

Marking scheme

1 mark: closing paragraph gives clear practical instructions (e.g. arrival time, what to bring/wear); 1 mark: reference made to an enclosure (e.g. 'enclosed', 'please find enclosed'); 1 mark: correct complementary close matching the salutation used (e.g. 'Yours sincerely' following a named salutation); 1 mark: sender's name given; 1 mark: sender's job title/position given; 1 mark: 'Enc.' or similar enclosure marker included, or the enclosure clearly referenced again at the foot of the letter; 1 mark: overall structure and register consistent with a formal standard business letter.
Question 14 · Mail Merge Formal Letter Design & Execution
6 marks
State the two printouts required as evidence of the mail merge task, and describe one check that should be carried out before printing the final merged letters to ensure the merge has worked correctly for every recipient.
Show answer & marking scheme

Worked solution

The standard letter template, showing the merge fields still in place (e.g. «FirstName»), should be printed as one piece of evidence, along with a printout of at least one, or all, of the individually merged letters, showing the actual customer data in place. Before printing, the merge should be previewed record by record to check that no merge field shows as blank or incorrect and that the data (names, session details) has merged accurately, and this check should be carried out across all records, not just the first.

Marking scheme

1 mark: standard template (with merge fields) identified as one required printout; 1 mark: merged letter(s) identified as the second required printout; 1 mark: describes previewing the merge results before printing; 1 mark: checks that no merge fields appear blank/unmerged; 1 mark: checks that data (e.g. names, session details) has merged correctly/matches the source data; 1 mark: notes that this should be checked across all (or a sample of) records, not just the first.

Section Unit 1: Task 3 - Database Applications

Modify table design, update and delete stock records, create sorted parameter queries, establish table relationships, and produce a professional grouped landscape report.
8 Question · 23 marks
Question 1 · Database Structure & Record Maintenance
2 marks
The database table 'Equipment', used by Mourne View Adventures to record its kayaks, buoyancy aids, wetsuits and helmets, currently stores QuantityInStock as a Text data field. Explain why this should be changed to a Number field, and state one validation rule that could then be applied to this field.
Show answer & marking scheme

Worked solution

A Text field can accept any characters, including letters or symbols, so it cannot be relied upon for numeric sorting or used correctly in calculations such as totals. Changing the field to a Number data type ensures only genuine numeric values can be entered and allows totals and comparisons to be calculated correctly. Once it is a Number field, a validation rule such as 'QuantityInStock >= 0' can be applied to prevent a negative stock value being entered by mistake.

Marking scheme

1 mark: explains that a Text field cannot be reliably used in calculations/numeric sorting and could accept invalid non-numeric entries, so should be Number; 1 mark: a valid validation rule stated, e.g. QuantityInStock ≥ 0 (or a sensible maximum).
Question 2 · Database Structure & Record Maintenance
1 marks
State the field that should be set as the primary key of the Equipment table.
Show answer & marking scheme

Worked solution

EquipmentID uniquely identifies each item of equipment and so is the natural choice of primary key for the table.

Marking scheme

1 mark: EquipmentID.
Question 3 · Database Structure & Record Maintenance
1 marks
A new delivery of six junior buoyancy aids has arrived in stock. State the type of database action that should be used to add this as a new record to the Equipment table.
Show answer & marking scheme

Worked solution

A new record for the six junior buoyancy aids can be added directly by typing it into a new blank row of the Equipment table's datasheet view, or, if importing several new items at once, by running an Append query.

Marking scheme

1 mark: correctly identifies adding a new record (e.g. via the table's datasheet view or an Append query).
Question 4 · Database Structure & Record Maintenance
1 marks
One kayak (EquipmentID K003) has been damaged beyond repair and removed from service. State how this record should be handled in the database, and name the action used to do this.
Show answer & marking scheme

Worked solution

Since the kayak is no longer part of the centre's usable stock, its record should be removed entirely from the Equipment table using the Delete Record command, rather than simply amending its quantity.

Marking scheme

1 mark: correctly states the record should be deleted, using the Delete Record function/command.
Question 5 · Database Query Design with Criteria & Sorting
4 marks
Write the criteria that should be entered under the 'Category' and 'Condition' fields in Query Design view to find all items in the 'Buoyancy Aid' category that are in 'Poor' condition, and state the sort order that should be applied to the results by QuantityInStock (lowest first).
Show answer & marking scheme

Worked solution

In Query Design view, "Buoyancy Aid" is entered on the Criteria row under the Category field, and "Poor" is entered on the same Criteria row under the Condition field, so that only records matching both conditions are returned (AND logic). The Sort row under QuantityInStock is then set to Ascending, so items with the lowest stock appear first.

Marking scheme

1 mark: correct criterion for Category, "Buoyancy Aid"; 1 mark: correct criterion for Condition, "Poor" (entered on the same criteria row, so both conditions must be met — AND logic); 1 mark: QuantityInStock included in the query design grid; 1 mark: sort order correctly set to Ascending (lowest first).
Question 6 · Database Query Design with Criteria & Sorting
4 marks
A second query is required to find all equipment items that are either in the 'Kayak' category OR have a QuantityInStock of less than 3. Explain how the criteria for this query should be entered in Query Design view so that the query returns records meeting either condition.
Show answer & marking scheme

Worked solution

"Kayak" is entered on the Criteria row under Category, and <3 is entered under QuantityInStock, but on a separate row — the 'or' row beneath the main Criteria row. Placing conditions on different rows in Query Design view applies OR logic, so a record is returned if it meets either condition, rather than requiring both, which is what would happen if the criteria were placed on the same row.

Marking scheme

1 mark: correct criterion for Category, "Kayak"; 1 mark: correct criterion for QuantityInStock, <3; 1 mark: correctly explains the two criteria must be placed on separate rows (Criteria and 'or' rows) to apply OR logic rather than AND; 1 mark: correctly explains this returns records meeting either condition, not only records meeting both.
Question 7 · Table Relationship & Printout Verification
3 marks
The database contains two tables, 'Equipment' and 'Bookings', linked by the common field EquipmentID. Explain the type of relationship that should be created between these two tables, and state the printout that should be produced as evidence that the relationship has been correctly established.
Show answer & marking scheme

Worked solution

Since one item of equipment can appear in many different bookings, but each booking record relates to only one item of equipment, a one-to-many relationship should be created between Equipment (the 'one' side) and Bookings (the 'many' side). This is done by opening the Relationships window and dragging a link between the matching EquipmentID field in each table, with referential integrity enforced. A Relationship Report should then be printed as evidence that the link has been correctly established.

Marking scheme

1 mark: correctly identifies a one-to-many relationship (one record in Equipment can relate to many records in Bookings); 1 mark: correctly describes creating the link via the Relationships window/tool, joining the common EquipmentID field; 1 mark: correctly states a Relationship Report should be printed as evidence.
Question 8 · Grouped Database Report Generation
7 marks
Design a report, based on the Equipment table, that groups equipment by Category and is suitable for printing in landscape orientation with the company logo included. Your answer should refer to: the grouping field, the sort order within each group, any summary/count information shown, the page orientation, and the inclusion of the logo.
Show answer & marking scheme

Worked solution

The report is grouped by the Category field, producing a separate section for each equipment category (Kayak, Buoyancy Aid, Wetsuit, Helmet). Within each group, records are sorted alphabetically by ItemName, and a group footer shows a count of the number of items held in that category, with an overall grand total count given at the end of the whole report. Because the report contains several fields across the page, it is set to print in landscape orientation so that everything fits legibly on the page, and the Mourne View Adventures logo is inserted into the report header so it appears once at the top of the printed report.

Marking scheme

1 mark: report correctly grouped by Category; 1 mark: a sensible sort order applied within each group, e.g. by ItemName; 1 mark: a group-level summary included, e.g. a count of items per category; 1 mark: an overall/grand total or summary given for the whole report; 1 mark: page orientation correctly set to landscape; 1 mark: company logo correctly included in the report header; 1 mark: overall layout described as clear and professionally formatted, with appropriate headers/field labels retained.

Section Unit 1: Task 4 - Multimedia Presentations

Open the presentation template, edit master slide graphics, author instructional content across 4 slides with technical examples, and configure navigation action buttons.
7 Question · 14 marks
Question 1 · Master Slide Modification
1 marks
State one graphic element that should be added to the master slide of the water safety presentation so that it appears automatically on every slide.
Show answer & marking scheme

Worked solution

Adding an element such as the company logo, or a consistent background image or colour scheme, to the master slide means it is applied automatically to every slide built from that master, without needing to be added individually to each one.

Marking scheme

1 mark: a valid master-slide graphic element, e.g. company logo, consistent background image/colour scheme, or footer text, added once to the master slide.
Question 2 · Slide Content Authoring with Technical Examples
2 marks
State the content to be included on Slide 1, introducing the topic of water safety for the junior kayaking programme.
Show answer & marking scheme

Worked solution

The opening slide needs a clear, relevant title, such as 'Staying Safe on the Water', paired with a short introductory sentence or two explaining why water safety is important for young kayakers, setting the context for the rest of the presentation.

Marking scheme

1 mark: clear, relevant title given; 1 mark: brief introductory content explaining the topic's relevance/importance.
Question 3 · Slide Content Authoring with Technical Examples
2 marks
Slide 2 should explain the correct use of a buoyancy aid, including one technical example. State the content for this slide.
Show answer & marking scheme

Worked solution

The slide should explain that a buoyancy aid must be correctly sized for the wearer and have all straps and buckles fastened securely to be effective. A specific technical example makes this concrete for pupils: for instance, a properly fitted buoyancy aid should not lift up above the chin when pulled firmly upward at the shoulders.

Marking scheme

1 mark: correct explanation of the general principle (buoyancy aid must be correctly sized/fastened); 1 mark: a specific, technically accurate example given (e.g. the shoulder-lift fit test).
Question 4 · Slide Content Authoring with Technical Examples
2 marks
Slide 3 should explain what to do if a kayak capsizes, including one technical example. State the content for this slide.
Show answer & marking scheme

Worked solution

The slide should explain the key principle of staying with the kayak after a capsize, since the kayak itself floats and provides buoyancy, making the paddler easier to see and rescue. A technical example illustrates the correct procedure, such as performing a controlled 'wet exit' by pulling the spray deck's release handle before sliding out of the cockpit.

Marking scheme

1 mark: correct explanation of the general principle (e.g. stay with the kayak, as it floats and aids visibility/rescue); 1 mark: a specific, technically accurate example given (e.g. correct wet-exit technique using the spray deck release handle).
Question 5 · Slide Content Authoring with Technical Examples
2 marks
Slide 4 should summarise key water safety rules and provide a contact point for further information. State the content for this slide.
Show answer & marking scheme

Worked solution

This closing slide draws the presentation together with a short, bulleted summary of the key rules already covered, such as always wearing a buoyancy aid, staying with a capsized kayak, and listening to instructor guidance, followed by the centre's contact details (phone number and email address) so viewers know how to find out more or book a lesson.

Marking scheme

1 mark: a clear bulleted summary of the key safety points covered in the presentation; 1 mark: contact details/further information provided for follow-up.
Question 6 · Interactive Action Buttons & Handout Layout
3 marks
State the three navigation action buttons that should be added to the slides to allow the user to move through the presentation, and explain what each button does.
Show answer & marking scheme

Worked solution

A Forward (or Next) action button advances the presentation to the following slide, allowing the viewer to move on through the content in sequence. A Backward (or Previous) action button returns to the slide before the current one, letting the viewer review earlier content. A Home action button jumps directly back to the first, title slide from anywhere in the presentation, useful for restarting the loop at the information point.

Marking scheme

1 mark: Forward/Next button correctly described as advancing to the next slide; 1 mark: Backward/Previous button correctly described as returning to the previous slide; 1 mark: Home button correctly described as returning to the first/title slide.
Question 7 · Interactive Action Buttons & Handout Layout
2 marks
State the print/output format that should be used to produce a handout of the presentation suitable for a supervising instructor to hold multiple slides on one printed page, and state a sensible number of slides per page for this handout.
Show answer & marking scheme

Worked solution

Selecting the Handout print/output layout, rather than the full-page Slides layout, allows several slide thumbnails to be arranged on each printed page. A sensible choice for this presentation would be 4 slides per page, giving the instructor a clear, compact reference without the images being too small to read.

Marking scheme

1 mark: Handout (view/layout) correctly identified as the print format; 1 mark: a sensible number of slides per page stated (e.g. 4, or 6).

Section Unit 2: Question 1 - Business Ownership, Communication & Stakeholders

Answer all questions based on the large logistics business scenario in the spaces provided.
9 Question · 27 marks
Question 1 · Factual Recall & Short Identification
1 marks
Foyle Freight Solutions Ltd is a large haulage and logistics company based in Derry~Londonderry, employing 250 staff. The company has 'Ltd' after its name and has issued shares to a small number of family shareholders. State the type of business ownership held by Foyle Freight Solutions Ltd.
Show answer & marking scheme

Worked solution

The use of 'Ltd' together with shares held only by a small, specific group of shareholders (rather than being traded openly on a stock exchange) identifies Foyle Freight Solutions as a private limited company.

Marking scheme

1 mark: private limited company.
Question 2 · Factual Recall & Short Identification
1 marks
State one method of internal written communication that Foyle Freight Solutions could use to inform all depot managers of a new health and safety policy.
Show answer & marking scheme

Worked solution

An internal email sent to all depot managers, or alternatively a memo or a notice posted on the company intranet, would deliver the new policy in writing to everyone who needs it.

Marking scheme

1 mark: any valid internal written communication method, e.g. email, memo, intranet notice.
Question 3 · Factual Recall & Short Identification
2 marks
Name two technologies Foyle Freight Solutions could use to track the real-time location of its delivery vehicles.
Show answer & marking scheme

Worked solution

GPS tracking units fitted to vehicles allow their real-time location to be monitored on a map, while RFID tags attached to vehicles or containers can be read automatically by depot scanners to confirm location and movement through the network.

Marking scheme

1 mark each for GPS and RFID (or a named GPS-based fleet tracking system). Max 2 marks.
Question 4 · Structured Explanations (Ownership, Email, Importance)
4 marks
Explain two advantages to Foyle Freight Solutions of being registered as a private limited company rather than operating as a sole trader.
Show answer & marking scheme

Worked solution

As a private limited company, Foyle Freight Solutions' shareholders have limited liability, meaning they can only lose the amount of money they have invested in the business, protecting their personal assets if the company runs into financial difficulty, unlike a sole trader who has unlimited liability. The company also has its own separate legal identity, giving it continuity: it continues to exist and trade even if a shareholder dies, retires or sells their shares, whereas a sole trader business is legally tied to its single owner.

Marking scheme

1 mark: limited liability identified; 1 mark: explained — shareholders' personal assets/finances are protected beyond their investment if the business fails; 1 mark: continuity/separate legal identity identified; 1 mark: explained — the business continues to exist independently of any one owner, unlike a sole trader.
Question 5 · Structured Explanations (Ownership, Email, Importance)
4 marks
Explain why email is an effective method for Foyle Freight Solutions to communicate urgent delivery schedule changes to drivers, and explain one limitation of using email for this purpose.
Show answer & marking scheme

Worked solution

Email allows an urgent schedule change to be sent instantly to every driver at once, rather than the depot having to phone each driver individually, saving time, and it leaves a written record that can be checked later. However, a limitation is that drivers are often on the road and may not check their email while driving, so a genuinely urgent change might not reach them in time through this method alone, meaning a more immediate channel, such as a phone call or radio, may still be needed.

Marking scheme

1 mark: advantage identified, e.g. speed/instant delivery to multiple recipients; 1 mark: explained, e.g. all drivers receive the same information at once, saving time compared to individual phone calls; 1 mark: limitation identified, e.g. drivers may not check email while driving; 1 mark: explained, e.g. urgent changes may not reach the driver in time, so a more immediate method (e.g. phone/radio) may be needed for genuinely urgent updates.
Question 6 · Structured Explanations (Ownership, Email, Importance)
3 marks
Explain why it is important for Foyle Freight Solutions to communicate effectively with its employees.
Show answer & marking scheme

Worked solution

Clear, effective communication ensures that employees, such as drivers and warehouse staff, correctly understand their instructions and responsibilities, which reduces mistakes and improves both efficiency and safety in day-to-day operations. Effective communication also helps employees feel informed and valued, which improves morale and motivation and can reduce staff turnover.

Marking scheme

1 mark: identifies that effective communication ensures employees understand instructions/expectations correctly; 1 mark: explains this reduces errors/improves efficiency or safety; 1 mark: notes effective communication also improves employee morale/motivation (staff feel informed/valued).
Question 7 · Stakeholder Definition & Conflict Description
4 marks
Define the term 'stakeholder' and, with reference to Foyle Freight Solutions, describe one potential conflict of interest between two different stakeholder groups.
Show answer & marking scheme

Worked solution

A stakeholder is any person or group who has an interest in, or is affected by, the activities of a business. At Foyle Freight Solutions, a conflict could arise between shareholders, who want the company to maximise profits and dividends, for example by keeping wage costs down or setting tighter delivery schedules, and employees such as drivers, who want fair pay and reasonable, safe working hours; these two groups' interests can directly conflict.

Marking scheme

1 mark: correct definition of stakeholder (a person/group with an interest in, or affected by, the business); 1 mark: two relevant stakeholder groups correctly identified for Foyle Freight Solutions, e.g. shareholders and employees; 1 mark: the conflicting interest of the first group described, e.g. shareholders wanting higher profits/lower costs; 1 mark: the conflicting interest of the second group described, e.g. employees wanting fair pay/safe working hours, creating a conflict.
Question 8 · Stakeholder Definition & Conflict Description
4 marks
Local residents living near one of Foyle Freight Solutions' depots are a stakeholder group. Describe why residents might be concerned about the depot's operations, and describe one action the company could take to address these concerns.
Show answer & marking scheme

Worked solution

Residents living close to the depot may be concerned about noise from heavy lorries arriving and departing, particularly early in the morning or late at night, as well as increased traffic congestion and air pollution from vehicle emissions near their homes. To address these concerns, Foyle Freight Solutions could restrict lorry movements to certain hours of the day, invest in quieter or lower-emission vehicles, or hold a community consultation to discuss residents' concerns directly.

Marking scheme

1 mark: a valid concern identified, e.g. noise, traffic congestion or air pollution; 1 mark: the concern explained in the context of the depot (e.g. lorries operating at unsociable hours near homes); 1 mark: a valid company action identified, e.g. restricting operating hours, investing in quieter/electric vehicles, community liaison; 1 mark: the action explained as addressing the specific concern raised.
Question 9 · Digital Technology Explanations (RFID & GPS)
4 marks
Explain how the use of GPS and RFID technology benefits both Foyle Freight Solutions and its customers.
Show answer & marking scheme

Worked solution

GPS technology allows Foyle Freight Solutions to plan efficient delivery routes and monitor vehicle locations in real time, which reduces fuel costs and enables more accurate delivery time estimates. RFID technology allows individual parcels or pallets to be tracked automatically as they move through the supply chain, reducing lost items and manual tracking errors. For customers, these technologies provide accurate, real-time delivery tracking and updates, giving them confidence in when their goods will arrive and improving overall customer satisfaction and trust in the company.

Marking scheme

1 mark: GPS use explained for the business, e.g. route planning/real-time vehicle tracking, reducing fuel costs; 1 mark: RFID use explained for the business, e.g. automated tracking of parcels through the supply chain, reducing errors/lost items; 1 mark: benefit to customers identified, e.g. accurate real-time delivery tracking/updates; 1 mark: benefit explained, e.g. improved reliability/trust and ability to plan for the delivery, improving customer satisfaction.

Section Unit 2: Question 2 - Recruitment, Selection, Training & Digital Trading

Answer all questions based on the retail clothing business scenario in the spaces provided.
6 Question · 25 marks
Question 1 · Short Identification & Preparation
1 marks
Style & Stitch, a retail clothing chain with stores across Belfast, is recruiting a new sales assistant for its expanding city centre store. State one document a candidate would normally submit when applying for this position.
Show answer & marking scheme

Worked solution

Applicants for a sales assistant role would typically submit a CV, or a completed application form, sometimes along with a covering letter, setting out their skills and experience.

Marking scheme

1 mark: CV or application form (or covering letter).
Question 2 · Analysis of Internal Recruitment & Selection Methods
5 marks
Style & Stitch is considering filling its new store manager vacancy through internal recruitment, promoting an existing sales assistant, rather than recruiting externally. Analyse the advantages and disadvantages of this approach for Style & Stitch.
Show answer & marking scheme

Worked solution

Promoting an existing sales assistant has clear advantages: the candidate is already familiar with Style & Stitch's procedures, systems and culture, which reduces the amount of induction and training required compared to an external hire. It can also motivate other existing staff, who see that promotion opportunities genuinely exist within the company, which can improve morale and staff retention. However, internal recruitment also has disadvantages: it limits the pool of candidates considered, meaning the business may miss out on fresh ideas, skills or experience that an external candidate could bring, and it creates a new vacancy at the lower (sales assistant) level that itself still needs to be filled. It may also cause resentment among other staff who applied but were not selected for promotion.

Marking scheme

1 mark: advantage identified, e.g. candidate already familiar with company procedures/culture; 1 mark: advantage developed, e.g. reduces induction/training time and cost; 1 mark: a second advantage, e.g. motivates existing staff by showing promotion opportunities exist, improving morale/retention; 1 mark: disadvantage identified, e.g. limits the pool of candidates and fresh ideas/skills entering the business; 1 mark: disadvantage developed, e.g. creates a new vacancy at the lower level that still needs to be filled, and may cause resentment among unsuccessful internal applicants.
Question 3 · Analysis of Internal Recruitment & Selection Methods
4 marks
Style & Stitch is selecting between two candidates for the store manager role and is considering using an assessment centre, including a group task and a formal interview, rather than a single interview alone. Analyse why using multiple selection methods may lead to a better recruitment decision.
Show answer & marking scheme

Worked solution

Different selection methods reveal different qualities in a candidate: a group task can show teamwork and leadership skills under pressure, which a formal interview alone would not necessarily reveal, while a structured interview allows deeper exploration of a candidate's experience, knowledge and motivation for the role. By using multiple methods together, Style & Stitch reduces its reliance on any single method, which could be biased, unrepresentative on the day, or only assess a narrow set of skills, and instead builds a more complete, balanced picture of each candidate's overall suitability, reducing the risk of making a poor hiring decision.

Marking scheme

1 mark: identifies that different selection methods assess different skills/qualities (e.g. group task shows teamwork, interview shows communication/experience); 1 mark: developed with a specific example relevant to a store manager role; 1 mark: identifies that using multiple methods reduces reliance on any one (potentially biased/unrepresentative) method; 1 mark: developed — gives a more complete, balanced assessment, reducing the risk of a poor recruitment decision.
Question 4 · Explanation of Training Benefits & Digital Trading Definition
4 marks
Explain two benefits to Style & Stitch of providing on-the-job training to a newly promoted store manager.
Show answer & marking scheme

Worked solution

On-the-job training is directly relevant and tailored to Style & Stitch's own procedures and the specific demands of the store manager role, so the new manager learns skills that are immediately applicable to their day-to-day work. It is also relatively low cost compared with sending the manager on an external course, since no outside venue or training provider is needed, and the trainee remains at work and productive while learning, often being trained by an experienced existing manager who can share valuable, business-specific practical knowledge.

Marking scheme

1 mark: benefit identified, e.g. training is directly relevant/tailored to the specific role and company procedures; 1 mark: developed, e.g. the manager learns skills that are immediately applicable to their new job; 1 mark: a second benefit identified, e.g. lower cost than off-the-job training (no external venue/provider needed) and the trainee remains productive; 1 mark: developed, e.g. can be delivered by an experienced colleague, transferring valuable practical knowledge specific to the business.
Question 5 · Explanation of Training Benefits & Digital Trading Definition
3 marks
Define the term 'digital trading' and give one example of how Style & Stitch could use digital trading to increase sales.
Show answer & marking scheme

Worked solution

Digital trading is the buying and selling of goods or services using electronic or digital technology, most commonly via the internet, rather than solely through face-to-face transactions in a physical shop. Style & Stitch could use digital trading by setting up an online store or e-commerce website, allowing customers to browse and purchase clothing online for home delivery or in-store click-and-collect, reaching customers beyond those who visit its physical shops.

Marking scheme

1 mark: digital trading correctly defined as the buying/selling of goods or services using electronic/digital technology; 1 mark: reference made to this typically taking place via the internet/online; 1 mark: a relevant, developed example of digital trading suited to Style & Stitch given, e.g. an online store/e-commerce website with delivery or click-and-collect.
Question 6 · Extended Evaluation of Digital Trading (QWC)
8 marks
In this question you will be assessed on your written communication skills, including the use of specialist business terminology.

Evaluate the advantages and disadvantages to Style & Stitch of expanding into digital trading by launching an online store, in addition to its existing physical shops.

In your answer you should refer to:
• two advantages of digital trading for the business
• two disadvantages/challenges of digital trading for the business
• an overall judgement on whether Style & Stitch should proceed.
Show answer & marking scheme

Worked solution

A strong answer explains that launching an online store would give Style & Stitch a much wider customer reach beyond Belfast, potentially attracting customers nationally, and would allow the business to trade 24 hours a day rather than only during physical shop opening hours, both increasing potential sales. It could also reduce some overheads, since online sales do not require additional shop floor space or as many sales staff, and customer purchase data collected online can make future marketing more targeted and effective. On the other hand, the answer should discuss the significant set-up cost of building a secure website and payment system, along with ongoing costs such as website maintenance and handling deliveries and returns; increased competition from other online retailers, who may undercut Style & Stitch on price; and the risk of cybersecurity and data protection issues around handling customers' personal and payment data, which must comply with data protection law. A well-reasoned overall judgement should weigh these points, for example concluding that the wider reach and extended trading hours likely outweigh the costs and risks, provided the business invests properly in a secure, well-marketed website.

Marking scheme

Level 3 (7–8 marks): thorough, well-balanced, contextualised analysis of both advantages and disadvantages, excellent commercial terminology, high quality of written communication, and a clear, justified overall recommendation. Level 2 (4–6 marks): satisfactory analysis covering some advantages and disadvantages, adequate business terminology, a coherent structure, and an attempted overall judgement. Level 1 (1–3 marks): limited analysis (e.g. only one-sided or undeveloped points), weak specialist vocabulary, basic grammar, little or no overall judgement. Indicative content: wider customer reach beyond the local area; ability to trade 24/7, increasing potential sales; lower overheads/no extra shop floor needed for online sales; easier to target marketing using customer data; set-up and ongoing costs (website, payment system, delivery/returns logistics); increased competition from other online retailers; cybersecurity/data protection risks and legal compliance requirements; possible reduction in footfall to physical stores; a reasoned overall recommendation on whether to proceed.

Section Unit 2: Question 3 - Legislation, Market Research & Marketing Mix

Answer all questions based on the specialist sports shop scenario in the spaces provided.
5 Question · 24 marks
Question 1 · Legislation Identification & Principles Explanation
3 marks
SummitGear Sports, a specialist outdoor and adventure equipment shop in Enniskillen, collects customer names, addresses and email addresses when processing online orders through its website. Identify the UK legislation that governs how this personal data must be handled, and state one principle the shop must follow under this legislation.
Show answer & marking scheme

Worked solution

Personal customer data such as names, addresses and email addresses is protected under the UK General Data Protection Regulation (UK GDPR) and the Data Protection Act 2018. Under this legislation, SummitGear Sports must, for example, keep customer data secure, use it only for the purpose it was originally collected for, keep it accurate and up to date, and not retain it for longer than necessary.

Marking scheme

1 mark: correct legislation named, UK GDPR / Data Protection Act 2018; 1 mark: a correct principle stated, e.g. data must be kept secure, used only for its stated purpose, accurate/kept up to date, or not retained longer than necessary; 1 mark: the principle is correctly linked/applied to SummitGear Sports' handling of customer order data.
Question 2 · Legislation Identification & Principles Explanation
2 marks
State one consequence for SummitGear Sports of failing to comply with data protection legislation when handling customer data.
Show answer & marking scheme

Worked solution

Failing to comply could result in a fine or other enforcement action from the Information Commissioner's Office (ICO), the UK's data protection regulator, and could also cause serious reputational damage, with customers losing trust in the business and taking their custom elsewhere.

Marking scheme

1 mark: any valid consequence, e.g. a fine/penalty from the regulator (ICO); 1 mark: a second valid consequence, e.g. loss of customer trust/reputational damage, or legal action.
Question 3 · Marketing Definition with Example
3 marks
Define the term 'marketing' and give an example of a marketing activity SummitGear Sports could use to promote a new range of hiking boots.
Show answer & marking scheme

Worked solution

Marketing is the process of identifying and anticipating what customers need and want, and then satisfying those needs and wants, at a profit, through an exchange of goods or services for payment. SummitGear Sports could apply this by running a targeted social media advertising campaign showcasing the new hiking boots to local outdoor enthusiasts, or by holding an in-store demonstration event where customers can try the boots on a test trail.

Marking scheme

1 mark: marketing involves identifying/anticipating customer needs and wants; 1 mark: and satisfying them (at a profit/through exchange); 1 mark: a relevant, developed example of a marketing activity for SummitGear Sports given, e.g. social media advertising campaign, in-store demonstration event, influencer partnership.
Question 4 · Market Research Methods Analysis with Examples
8 marks
SummitGear Sports wants to find out whether there is sufficient local demand for a new range of hiking boots before investing in stock. Analyse two methods of market research the shop could use, and the type of information each would provide, in this situation.
Show answer & marking scheme

Worked solution

One method is a customer questionnaire or survey, a form of primary research, which could be distributed to existing customers in-store or online, asking directly about their interest in, and likely purchase of, the new hiking boots and their sensitivity to different price points. This gathers first-hand, up-to-date quantitative and qualitative data on customer interest and preferences specific to SummitGear Sports' own customer base, though it can be time-consuming and costly to design and administer properly. A second method is analysing existing sales data or published market research reports, a form of secondary research, for example reviewing the shop's own sales records for related outdoor footwear, or industry reports on outdoor footwear trends and competitor pricing. This is quicker and cheaper than primary research, since the data already exists, but may not be specific enough to SummitGear Sports' own local customers or the particular new product range being considered.

Marking scheme

1 mark: Method 1 identified, e.g. questionnaire/survey (primary research); 1 mark: described, e.g. distributed to existing customers in-store or online; 1 mark: type of information it provides, e.g. direct quantitative/qualitative data on customer interest, preferences and price sensitivity for the new boots; 1 mark: a strength or limitation identified, e.g. gathers first-hand, up-to-date, relevant data directly from the target market, but can be time-consuming/costly to administer; 1 mark: Method 2 identified, e.g. analysis of existing sales/market data (secondary research); 1 mark: described, e.g. reviewing the shop's own sales records for related products, or published market reports; 1 mark: type of information it provides, e.g. broader trends in outdoor footwear demand/competitor pricing; 1 mark: a strength or limitation identified, e.g. quicker and cheaper than primary research, but may not be specific enough to SummitGear Sports' own customers/local area.
Question 5 · Extended Analysis of Digital Impact on Marketing Mix (QWC)
8 marks
In this question you will be assessed on your written communication skills, including the use of specialist business terminology.

Discuss how digital technology has changed the way SummitGear Sports could apply each of the 4Ps of the marketing mix (Product, Price, Place, Promotion) to market its hiking boots.

In your answer you should refer to at least three of the 4Ps, giving a specific digital example for each.
Show answer & marking scheme

Worked solution

A strong answer explains, for Product, that digital technology allows SummitGear Sports to gather online customer reviews and ratings, informing which boots to stock, while 360-degree product images or videos let customers examine boots in detail online before buying. For Price, digital price comparison websites make it easy for customers to compare SummitGear Sports' prices against competitors instantly, increasing price transparency and competitive pressure, while the shop can also use dynamic online pricing or digital discount codes to respond quickly to demand. For Place, an online store extends 'place' far beyond the physical Enniskillen shop, reaching customers who could never visit in person, while click-and-collect blends the online and physical store together. For Promotion, social media and targeted email marketing allow SummitGear Sports to promote the new boots cheaply to specific customer segments, for example based on past purchase history, and the success of digital promotion can be tracked and measured (e.g. click-through and conversion rates) far more precisely than traditional advertising such as a newspaper advert.

Marking scheme

Level 3 (7–8 marks): thorough, well-balanced, contextualised analysis of at least three of the 4Ps, each with a specific and accurate digital example, excellent commercial terminology, high quality of written communication. Level 2 (4–6 marks): satisfactory analysis of at least two of the 4Ps with reasonable digital examples, adequate business terminology, coherent structure. Level 1 (1–3 marks): limited analysis, only one P addressed in any depth or examples not clearly digital, weak specialist vocabulary, basic grammar. Indicative content: Product — online customer reviews/ratings inform stock decisions; 360°/video product images let customers examine boots in detail online; Price — price comparison websites increase transparency/competition; dynamic online pricing or digital discount codes; Place — online store extends reach beyond the physical shop; click-and-collect blends online and physical; Promotion — social media/email marketing enables low-cost, targeted promotion; digital promotion can be tracked/measured precisely (e.g. click-through/conversion rates).

Wondering how well you actually know this?

thinka is an AI practice app for DSE students: unlimited questions, instant auto-marking, and detailed step-by-step solutions. 100,000+ students use it to confirm they actually know it, not just think they do.

Want more questions like this? Practise unlimited on thinka, instant answers included.

Start Practising Free