Information and Communication Technology 4IT1 | Paper 2 Mock 01 | Written Paper 2
Question 1 Report
Fig. 1 shows the source artwork for a company that hires solar-powered boats on a city canal. The company is called Sunwake Boats. It needs a logo for a price-list document, an online booking page and waterproof boat stickers. The finished logo should include a sun, a boat and a simple water line, but the small birds shown in the sketch are optional. The booking page has a dark blue banner, while the printed price list has a white background. Create a design that remains clear in both places. The image must be easy to recognise from several metres away on a boat sticker.
(a) Create a logo based on Fig. 1 that includes the company name. [3]
(b) Use shape, size and contrast to make the logo suitable for a boat sticker. [2]
(c) Explain why the birds may be omitted from the completed logo. [1]
(d) Save a version with a transparent background for the booking page. [2]
(a) The logo must include Sunwake Boats, a boat, and both a sun and a water line. These are the essential features specified from the source artwork. [3]
(b) Use bold, simple, recognisable shapes and sufficiently large high-contrast text and features. A boat sticker is viewed from several metres away, so fine detail or weak contrast would not be effective. [2]
(c) The birds may be omitted because they are unnecessary detail that may be unclear at small size and could clutter the logo. [1]
(d) Remove the rectangular background area and save the result in a format that supports transparency, such as PNG. A transparent background allows the logo to sit clearly on the dark-blue booking-page banner without a visible white rectangle. [2]
Answer Details
(a) The logo must include Sunwake Boats, a boat, and both a sun and a water line. These are the essential features specified from the source artwork. [3]
(b) Use bold, simple, recognisable shapes and sufficiently large high-contrast text and features. A boat sticker is viewed from several metres away, so fine detail or weak contrast would not be effective. [2]
(c) The birds may be omitted because they are unnecessary detail that may be unclear at small size and could clutter the logo. [1]
(d) Remove the rectangular background area and save the result in a format that supports transparency, such as PNG. A transparent background allows the logo to sit clearly on the dark-blue booking-page banner without a visible white rectangle. [2]
Question 2 Report
During a coastal bird survey, a field team collects photographs, GPS tracks and a spreadsheet of observations from six beaches. At the end of each day, the team copies information from camera cards and tablets to a laptop. The project leader has found duplicate files with names such as IMG_0045.JPG and new sheet.xlsx. The leader also needs evidence that the data were backed up before the laptop is taken into the field again. The final chart and document will be sent to a conservation charity, but confidential volunteer contact details must not be included.
(a) Create a naming convention for the survey files. Your convention must include a date, beach code, file content and version where needed. Give one example filename for a photograph and one for a spreadsheet. [5]
(b) Create a folder structure that separates raw field information, checked information, volunteer contact details and files ready to send to the charity. [6]
(c) Use an appropriate backup method for the daily survey folder. Describe the steps the team should take and the evidence they should check after copying. [6]
(d) Explain why contact details should not be stored in the same folder as the final information sent to the charity. [4]
(a) Use a consistent pattern such as YYYY-MM-DD_BeachCode_Content_Version.extension [5]. For example: 2026-05-14_BRN_Oystercatcher_001.jpg and 2026-05-14_BRN_Observations_v01.xlsx. The date, beach code and content make files searchable; a version identifier distinguishes revisable files.
(b) A suitable structure is [6]:
Coastal_Bird_Survey/ ├── Raw_Field_Data/ │ ├── Photos/ │ ├── GPS_Tracks/ │ └── Observation_Spreadsheets/ ├── Checked_Data/ ├── Contact_Details_Restricted/ └── Charity_Export_Final_Output/
This separates unverified field records from checked data, confidential contacts and files intended for external sharing.
(c) Back up the complete daily survey folder to a separate external drive or cloud location, using a dated backup name such as 2026-05-14_Backup [6]. Do not delete the laptop originals. Verify the copy by comparing file counts and sizes, or by using a checksum/verification tool; then open a sample image and spreadsheet from the backup. Record the backup date and location as evidence that the backup was completed and checked.
(d) Volunteer contacts are personal and confidential, whereas the charity needs survey data rather than contact information [4]. Keeping them separate reduces accidental sharing and permits restricted access permissions on the contact-details folder.
Answer Details
(a) Use a consistent pattern such as YYYY-MM-DD_BeachCode_Content_Version.extension [5]. For example: 2026-05-14_BRN_Oystercatcher_001.jpg and 2026-05-14_BRN_Observations_v01.xlsx. The date, beach code and content make files searchable; a version identifier distinguishes revisable files.
(b) A suitable structure is [6]:
Coastal_Bird_Survey/ ├── Raw_Field_Data/ │ ├── Photos/ │ ├── GPS_Tracks/ │ └── Observation_Spreadsheets/ ├── Checked_Data/ ├── Contact_Details_Restricted/ └── Charity_Export_Final_Output/
This separates unverified field records from checked data, confidential contacts and files intended for external sharing.
(c) Back up the complete daily survey folder to a separate external drive or cloud location, using a dated backup name such as 2026-05-14_Backup [6]. Do not delete the laptop originals. Verify the copy by comparing file counts and sizes, or by using a checksum/verification tool; then open a sample image and spreadsheet from the backup. Record the backup date and location as evidence that the backup was completed and checked.
(d) Volunteer contacts are personal and confidential, whereas the charity needs survey data rather than contact information [4]. Keeping them separate reduces accidental sharing and permits restricted access permissions on the contact-details folder.
Question 3 Report
Fig. 1 is a sketch for a sailing club that runs beginner lessons on a lake. The club needs a logo for its booking document and for embroidered caps. The words BLUE REED SAILING must be included. The boat and reed should remain easy to identify if the image is printed at 25 mm high. The club secretary asks you to create a version that uses a maximum of three colours and has no rectangular white background. The final logo should be saved separately from the source sketch so that the original is not changed.
(a) Create a logo based on Fig. 1 and the required text. [2]
(b) Use colour and shape choices that make the logo suitable for embroidery. [1]
(c) Save the finished logo without overwriting the supplied sketch. [1]
(a) Create a logo containing recognisable boat and reed imagery from the supplied sketch, and include the exact text BLUE REED SAILING. Both the visual identity and club name are required. [2]
(b) Use bold, simple areas with no more than three colours. Fine lines and excessive colour detail can disappear or be difficult to stitch when the logo is embroidered at only 25 mm high. [1]
(c) Save the finished design under a new file name in an appropriate image format. This preserves the supplied sketch unchanged, so the original remains available. [1]
Answer Details
(a) Create a logo containing recognisable boat and reed imagery from the supplied sketch, and include the exact text BLUE REED SAILING. Both the visual identity and club name are required. [2]
(b) Use bold, simple areas with no more than three colours. Fine lines and excessive colour detail can disappear or be difficult to stitch when the logo is embroidered at only 25 mm high. [1]
(c) Save the finished design under a new file name in an appropriate image format. This preserves the supplied sketch unchanged, so the original remains available. [1]
Question 4 Report
The diagram in Fig. 1 shows a draft invitation created for a school astronomy evening. The event details have been typed, but the text is hard to scan because every line is centred. The organiser has inserted a telescope image at its original size. A reply slip must remain at the bottom of the same sheet so parents can cut it off. The organiser needs to create a clearer invitation while keeping all the factual information, including the date, start time and room number. The completed document should be saved before a copy is printed.
(a) Identify one item of information that should be placed in the reply slip. [1]
(b) Use two improvements to the alignment or spacing of the event details. [2]
(c) Create one change to the telescope image that helps the reply slip remain on the sheet. [1]
(d) Explain why a horizontal line above the reply slip would improve the document. [1]
(a) A reply slip can request a pupil name, parent/carer name, number attending, contact number or signature. Any one of these is suitable because it provides information needed to process the response. [1]
(b) Left-align the detailed event information rather than centring every line, and use consistent spacing between sections. Other valid improvements include a clear heading and subheadings, grouping date, time and room together, or using bullet points for key details. Any two gain credit. [2]
(c) Reduce or resize the telescope image so the reply slip remains on the same sheet. [1]
(d) A horizontal line clearly separates the detachable reply section and shows parents where to cut. [1]
Answer Details
(a) A reply slip can request a pupil name, parent/carer name, number attending, contact number or signature. Any one of these is suitable because it provides information needed to process the response. [1]
(b) Left-align the detailed event information rather than centring every line, and use consistent spacing between sections. Other valid improvements include a clear heading and subheadings, grouping date, time and room together, or using bullet points for key details. Any two gain credit. [2]
(c) Reduce or resize the telescope image so the reply slip remains on the same sheet. [1]
(d) A horizontal line clearly separates the detachable reply section and shows parents where to cut. [1]
Question 5 Report
Read the information below about a college newsletter team. Students create a monthly document containing text, a logo, photographs and a chart from a spreadsheet. The editor receives files through a shared cloud folder. In April, a student deleted the final logo and another student printed an earlier newsletter because both files were called newsletter final. For the May issue, the editor has asked you to set up the file area before task A1 begins. The team must be able to locate approved material, keep drafts separate, save work safely and provide clear evidence of the final version.
(a) Create a main folder structure for the May newsletter. Include folders for received files, working drafts, approved assets, spreadsheet/chart files, final output and archive material. [6]
(b) Create suitable filenames for the following: the first draft of the newsletter document, an approved logo image, the spreadsheet used for the chart, and the PDF ready to print. [6]
(c) Use the shared folder permissions to give the editor, student writers and guest photographer appropriate access. Explain the access given to each user type. [6]
(d) Create a method for the editor to show which newsletter file is the final approved version before it is printed. [4]
(e) Give two checks that should be made before the final PDF is copied to the archive folder and the task is marked complete. [2]
(a) Create this structure [6]:
May_Newsletter/ ├── Received_Files/ ├── Working_Drafts/ ├── Approved_Assets/ ├── Spreadsheet_Charts/ ├── Final_Output/ └── Archive/
Drafts and received material remain separate from approved assets and the final output, preventing an unapproved item being printed.
(b) Suitable filenames are May2026_Newsletter_Draft_v01.docx, May2026_Logo_Approved.png, May2026_ChartData_v01.xlsx and May2026_Newsletter_FINAL.pdf [6]. They contain an issue identifier, communicate status where needed, and use extensions that match the intended file types.
(c) Give the editor edit, manage and delete permissions because they must approve, organise, resave and archive files [6]. Give student writers permission to create and edit working drafts, but not to delete approved/final files or change permissions. Give the guest photographer upload/contribute access to Received_Files, without permission to edit or delete newsletter documents or access unnecessary folders.
(d) Place the approved document in Final_Output with a clear filename such as May2026_Newsletter_FINAL.pdf [4]. The editor checks it against the approved content, then makes it read-only or restricts editing, or records approval in a log. This provides clear evidence of which copy is authorised for printing.
(e) Before archiving, confirm that the correct final version/date has been used and open the PDF to check that text, images and the chart appear correctly [2]. Also confirm that the archived copy was successfully copied and can be opened.
Answer Details
(a) Create this structure [6]:
May_Newsletter/ ├── Received_Files/ ├── Working_Drafts/ ├── Approved_Assets/ ├── Spreadsheet_Charts/ ├── Final_Output/ └── Archive/
Drafts and received material remain separate from approved assets and the final output, preventing an unapproved item being printed.
(b) Suitable filenames are May2026_Newsletter_Draft_v01.docx, May2026_Logo_Approved.png, May2026_ChartData_v01.xlsx and May2026_Newsletter_FINAL.pdf [6]. They contain an issue identifier, communicate status where needed, and use extensions that match the intended file types.
(c) Give the editor edit, manage and delete permissions because they must approve, organise, resave and archive files [6]. Give student writers permission to create and edit working drafts, but not to delete approved/final files or change permissions. Give the guest photographer upload/contribute access to Received_Files, without permission to edit or delete newsletter documents or access unnecessary folders.
(d) Place the approved document in Final_Output with a clear filename such as May2026_Newsletter_FINAL.pdf [4]. The editor checks it against the approved content, then makes it read-only or restricts editing, or records approval in a log. This provides clear evidence of which copy is authorised for printing.
(e) Before archiving, confirm that the correct final version/date has been used and open the PDF to check that text, images and the chart appear correctly [2]. Also confirm that the archived copy was successfully copied and can be opened.
Question 6 Report
A charity repairs donated laptops for students. Its database records DeviceID, DeviceType, FaultDescription, RepairHours, PartsCost and ReadyForCollection. The workshop supervisor needs a query to find laptops that took more than 3.5 hours to repair and are ready for collection. The results will be used to create a report for the collection desk. DeviceID, FaultDescription and PartsCost must be shown, with PartsCost sorted from highest to lowest.
The supervisor has asked an assistant to complete task a2 using the query design view. The assistant must save the query as ReadyLaptopsLongRepair and place a screenshot in the document task. A form is used for entering repairs, but the query must use fields from the stored database table rather than values typed into the report.
(a) Create the criterion for DeviceType. [1]
(b) Create the criterion for RepairHours. [1]
(c) Create the criterion for ReadyForCollection. [1]
(d) Create the sort order for PartsCost. [1]
(e) Give one reason why FaultDescription should be included in the report. [1]
(a) Use Laptop as the DeviceType criterion. [1]
(b) Use >3.5 as the RepairHours criterion. This means more than 3.5 hours, not 3.5 hours exactly. [1]
(c) Use Yes or True as the ReadyForCollection criterion. [1]
(d) Sort PartsCost in descending order to put the highest costs first. [1]
(e) FaultDescription helps collection staff identify the repair or check that the correct device is being collected. [1]
Answer Details
(a) Use Laptop as the DeviceType criterion. [1]
(b) Use >3.5 as the RepairHours criterion. This means more than 3.5 hours, not 3.5 hours exactly. [1]
(c) Use Yes or True as the ReadyForCollection criterion. [1]
(d) Sort PartsCost in descending order to put the highest costs first. [1]
(e) FaultDescription helps collection staff identify the repair or check that the correct device is being collected. [1]
Question 7 Report
Fig. 1 shows a worksheet layout for a student-run refill shop. The shop sells products by weight. Column C holds the mass purchased in grams, D holds the price per 100 g, E calculates product cost, F adds a fixed container deposit held in J1, and G displays the final cost. The team needs formulas that can be copied down, checks for orders below 100 g, and a clear chart for a presentation. They will save the completed spreadsheet before printing a customer summary.
(a) Create a formula in E2 to calculate the product cost. [3]
(b) Create a formula in F2 that uses the container deposit in J1. [2]
(c) Create a formula in G2 to calculate the final cost. [2]
(d) Use conditional formatting to identify orders below 100 g. [2]
(e) Create a suitable chart type to compare final costs by product. [2]
(f) Explain why the price in D2 should not be formatted as a percentage. [2]
(g) Give a suitable filename before the worksheet is saved. [1]
(h) Identify the absolute reference needed for the container deposit. [2]
(a) Enter =C2/100*D2 in E2 [3]. Since D2 is the price per 100 g, divide the mass by 100 before multiplying by that price. For 250 g at £0.38 per 100 g, the product cost is \(250/100 \times 0.38 = £0.95\).
(b) Enter =$J$1 in F2 [2]. This returns the fixed deposit and keeps its reference fixed when copied down.
(c) Enter =E2+F2 in G2 [2] to add product cost and deposit.
(d) Select the mass cells and apply conditional formatting for values less than 100 [2].
(e) A bar chart or column chart is suitable for comparing final costs by product [2].
(f) D2 is a monetary price, not a proportion [2]. Percentage formatting would misrepresent £0.38 as 38%, rather than showing a price of £0.38.
(g) A suitable filename is Refill_shop_orders.xlsx [1].
(h) The required absolute reference is $J$1 [2]. It locks both column J and row 1 during copying.
Answer Details
(a) Enter =C2/100*D2 in E2 [3]. Since D2 is the price per 100 g, divide the mass by 100 before multiplying by that price. For 250 g at £0.38 per 100 g, the product cost is \(250/100 \times 0.38 = £0.95\).
(b) Enter =$J$1 in F2 [2]. This returns the fixed deposit and keeps its reference fixed when copied down.
(c) Enter =E2+F2 in G2 [2] to add product cost and deposit.
(d) Select the mass cells and apply conditional formatting for values less than 100 [2].
(e) A bar chart or column chart is suitable for comparing final costs by product [2].
(f) D2 is a monetary price, not a proportion [2]. Percentage formatting would misrepresent £0.38 as 38%, rather than showing a price of £0.38.
(g) A suitable filename is Refill_shop_orders.xlsx [1].
(h) The required absolute reference is $J$1 [2]. It locks both column J and row 1 during copying.
Question 8 Report
A maker-space is moving its workshop booking information from several old documents into one website. The manager has supplied text, a logo, photographs and a list of safety rules. Some filenames contain spaces, one photograph is 5000 pixels wide, and two pages use different spellings of the same workshop name. Visitors need to find sessions, view safety information and send a booking request. The author must create a consistent site before uploading it. The manager also wants evidence that the finished pages work correctly in more than one browser and on a phone.
(a) Create a folder and file plan for this website. Include suitable names for a home page, a stylesheet, an images folder, a booking page and a safety page. [4]
(b) Explain five actions the author should take to prepare the supplied image files for use on the web. [5]
(c) Create HTML for a logo that links to the home page. The logo file is images/makerspace-logo.png, the home page is index.html, and the alternative text must be meaningful. [4]
(d) Give four tests that should be recorded as evidence before the author submits task A1. [4]
(a) A suitable plan includes index.html as the home page, styles.css as the stylesheet, an images folder, booking.html, and safety.html. Use clear lowercase names with no spaces, which reduces broken links and makes files easier to manage. Any four required items gain credit. [4]
(b) Resize the 5000-pixel-wide photograph to suitable display dimensions, compress it to reduce file size, and use an appropriate format such as JPEG or WebP for a photograph. Rename files clearly with no spaces, check copyright or permission, crop unnecessary areas, plan meaningful alternative text, and keep originals separately. Any five actions prepare images for fast, lawful and accessible web use. [5]
(c) Correctly nest the logo image inside an anchor:
<a href="index.html">
<img src="images/makerspace-logo.png" alt="Riverside Maker-space home">
</a>The anchor returns visitors to the home page, the source gives the correct relative image path, and the alternative text explains the logo’s function as a home link. [4]
(d) Record tests of every hyperlink, booking-form validation, the site in more than one browser, and the responsive layout on a phone. Other valid tests include image loading and alternative text, spelling and consistent workshop naming, HTML/CSS validation, and keyboard navigation. Any four recorded checks provide evidence that the pages work correctly. [4]
Answer Details
(a) A suitable plan includes index.html as the home page, styles.css as the stylesheet, an images folder, booking.html, and safety.html. Use clear lowercase names with no spaces, which reduces broken links and makes files easier to manage. Any four required items gain credit. [4]
(b) Resize the 5000-pixel-wide photograph to suitable display dimensions, compress it to reduce file size, and use an appropriate format such as JPEG or WebP for a photograph. Rename files clearly with no spaces, check copyright or permission, crop unnecessary areas, plan meaningful alternative text, and keep originals separately. Any five actions prepare images for fast, lawful and accessible web use. [5]
(c) Correctly nest the logo image inside an anchor:
<a href="index.html">
<img src="images/makerspace-logo.png" alt="Riverside Maker-space home">
</a>The anchor returns visitors to the home page, the source gives the correct relative image path, and the alternative text explains the logo’s function as a home link. [4]
(d) Record tests of every hyperlink, booking-form validation, the site in more than one browser, and the responsive layout on a phone. Other valid tests include image loading and alternative text, spelling and consistent workshop naming, HTML/CSS validation, and keyboard navigation. Any four recorded checks provide evidence that the pages work correctly. [4]
