Pearson Edexcel International GCSE

13–17 November 2023

Time: 3 hours
Paper
reference 4IT1/02
Information and Communication
 

Technology (ICT)
PAPER 2: Practical Paper

You must have:

Data files: EVIDENCE, FITNESS, WEB PAGES, PAYMENTS, LEAFLET CONTENT and
IMAGES Folder

Instructions
•• Answer all questions.
You must not use the internet during the examination.
• Save your work into your examination folder.
Information
•• There are two sections in this paper, with a total of 100 marks.
The marks for each task are shown in brackets
– use this as a guide as to how much time to spend on each task.

Advice
•• Read through the instructions on page 2.
Attempt ALL tasks.

Turn over

P74653A
©2023 Pearson Education Ltd.
Z:1/1/1/1/1/1/1/
*P74653A*
Instructions to candidates
This paper consists of two sections. Each section contains several tasks.
Work through the tasks in order.
This table shows the major software used, the marks available and the data files needed
for each section.

Section Software Marks Data files needed

Graphics, database, EVIDENCE, FITNESS, WEB PAGES,

A 50
web authoring IMAGES Folder
Spreadsheet, word EVIDENCE, PAYMENTS,
B 50
processing LEAFLET CONTENT, IMAGES Folder

Total marks 100

For each task, you may also need to use other software.

2 P74653A

Scenario
Clara owns Evolving with Fitness. The company offers online fitness classes and personal
training opportunities.
These are the company’s contact details.
Address:
Upper Avenue
Lower Town
EF19 6PT
Telephone: 07700 901999
Email: clara@ewf.service
Website: www.ewf.service

P74653A 3
 Turn over
 SECTION A
Task A1
Clara needs a logo to be used on some of the company documents.
Task A1a
Create the logo.
The logo must be a simple drawing that is fit for purpose and:
• combines lines and coloured shapes
• represents fitness
• includes EWF on the logo.
(4)

SAVE the logo as EWF LOGO

Task A1b

OPEN the document EVIDENCE

Answer these questions in the document EVIDENCE

(i) Give two benefits of using a vector image for a company logo.
(2)
(ii) Give one drawback of using a vector image for a company logo.
(1)

RESAVE EVIDENCE

(Total for Task A1 = 7 marks)

4 P74653A

 BLANK PAGE

P74653A 5
 Turn over
Task A2
Clara has collected information about the company’s fitness classes.
She has saved the information in the database FITNESS
The database has three tables.
The CLASSES table includes information about the classes available.
The CLIENTS table includes information about the clients who have booked the classes.
The BOOKING table includes information about the classes and the clients who have
booked the classes.
The structure of the CLASSES table is:

Field name Data type Description

CLASS ID Text Code to identify the class

TITLE Text The name of the class

TYPE Text Type of class

DAY Text The day the class is held

DURATION Number How long the class lasts

COST Currency How much the class costs

INSTRUCTOR Text The name of the instructor

The structure of the CLIENTS table is:

Field name Data type Description

CLIENT ID Text Code to identify the client

CLIENT NAME Text Surname of the client

INITIAL Text Client’s initial

LOCATION Text Where the client lives

PAYMENT METHOD Text How the client pays for the classes

YEAR STARTED Number The year the client attended their first class

6 P74653A

The structure of the BOOKING table is:

Field name Data type Description

BOOKING ID Text Code to identify the booking

CLIENT ID Text Code to identify the client

CLASS ID Text Code to identify the class

Clara wants to use a form to add bookings to the BOOKING table.

OPEN the FITNESS database.

Task A2a
Create a form for the BOOKING table.
The form must:
• include the logo you created in Task A1a in the top left of the header
• include the title ‘Class Booking Form’ that has a:
• serif font
• dark background and white text
• be customised so the width of the field headings is 3cm
• include an instruction on the form ‘Please check data before saving’.
(6)

SAVE the form as BOOKING_FORM

TAKE a screenshot of your form in design view that shows you have set the width
of the field headings to 3cm.

PASTE the screenshot into document EVIDENCE

RESAVE EVIDENCE

P74653A 7
 Turn over
Task A2b
Another booking has been made.
Use the BOOKING_FORM you created in Task A2a to add a new booking on the
BOOKING table:
BOOKING ID – BK66, CLIENT ID – MAD0996, CLASS ID – MOPIL
(2)

TAKE a screenshot of the completed form.

RESAVE the table.

PASTE the screenshot into document EVIDENCE

RESAVE EVIDENCE

8 P74653A

Task A2c
Clara wants a list of clients who:
• are not located in the UK or Europe
• pay monthly for classes
• started classes in 2022 or 2023
Create a query on the CLIENTS table to produce the list.
(2)

SAVE the query as CLIENTS_QUERY

TAKE a screenshot of the query design.

PASTE the screenshot into document EVIDENCE

RESAVE EVIDENCE

The list must:

• show only these fields in this order CLIENT ID, INITIAL, CLIENT NAME,
YEAR STARTED
• be sorted in descending order of CLIENT ID
(3)

DISPLAY the ordered and sorted results of the query.

TAKE a screenshot of the results.

PASTE the screenshot into document EVIDENCE

RESAVE EVIDENCE

P74653A 9
 Turn over
Task A2d
Clara wants a list of classes.
The list must:
• include the classes where she is the instructor and that cost £6.00
• show only these fields in this order CLASS ID, DAY, TITLE and TYPE
• sort the results into ascending order of CLASS ID
Create a query on the CLASSES table to find the information.

SAVE the query as CLASSES_QUERY

Clara wants a database report based on the results from the CLASSES_QUERY
Create a database report to display the results.
The database report must:
• have a suitable title
• group the report based on the field DAY
• include an automated date in short date format in the header
• show only the required fields
• show the records sorted as required
• be formatted so the DAY field name and the DAY field values stand out
• include the page number in the report header.
(8)

SAVE the report as CLASSES REPORT

TAKE a screenshot in design view showing you have included an automated date
in short date format in the header.

PASTE the screenshot into document EVIDENCE

TAKE a screenshot of the report in print view making sure you show the
page number.

PASTE the screenshot into document EVIDENCE

RESAVE EVIDENCE

10 P74653A

Task A2e
Create the relationships between the three tables.
(1)

RESAVE the database.

TAKE a screenshot showing the relationships.

PASTE the screenshot into document EVIDENCE

RESAVE EVIDENCE

Task A2f
Answer these questions in the document EVIDENCE
(i) State one field that is used as a primary key in the FITNESS database.
(1)
(ii) Give one reason why a primary key is used in a database.
(1)
(iii) Explain one reason why a lookup list has been used on the INSTRUCTOR field in
the CLASSES table.
(2)

RESAVE EVIDENCE

(Total for Task A2 = 26 marks)

P74653A 11
 Turn over
Task A3
Clara wants you to create two web pages to promote the company.
Content for the web pages is stored in the file WEB PAGES
She wants you to create these linked pages:
• HOME
• CLASSES
Both web pages must be saved as .html
Task A3a
(i) Create the HOME page based on this design:

Logo and Company Name

Link to Link to
Home page Classes page
Text

Image Image Image

250px × 250px 250px × 250px 250px × 250px

For more information email us at (email address)

Use these HTML elements:

Company name – <h1>
Text – paragraph <p>
Use this colour scheme:
Background colour – #D7BDE2 (RGB 215, 189, 226)
Text colour – #5B2C6F (RGB 91, 44, 111)
Include three appropriate images from the IMAGES folder and position them as shown
in the design.
(9)

SAVE the web page as HOME

12 P74653A

 (ii) Create the CLASSES page based on this design:

Logo and Company Name

Link to Link to
Home page Classes page
Table

For more information email us at (email address)

Use the same HTML elements as the HOME page

(4)

SAVE the web page as CLASSES

Task A3b
Answer these questions in the document EVIDENCE
(i) Explain one benefit of using a template to create the web pages.
(2)
(ii) Explain one improvement you would make to the web pages.
(2)

RESAVE EVIDENCE

(Total for Task A3 = 17 marks)

TOTAL FOR SECTION A = 50 MARKS

P74653A 13
 Turn over
 SECTION B
Task B1
Evolving with Fitness offers online fitness classes.
The spreadsheet PAYMENTS contains information on payments made by one client
for January.
It has two worksheets called INVOICE and INFORMATION. Some functions require you
to use more than one worksheet.

OPEN the spreadsheet PAYMENTS

Task B1a
(i) Format the INVOICE worksheet to:
• merge and centre cells A1 to E1 and merge and centre cells B2 to E2
• use dark shading for the heading with white text
• right align cells B4, B6 and B8
• include an automated date in the header.
(4)
(ii) Format the INFORMATION worksheet to include a named range for cells A1 to
E28 named ‘ClassInformation’.
(1)

14 P74653A

Task B1b
Clara wants you to use spreadsheet tools to analyse the data for the information
included for P Bellamy.
(i) Use spreadsheet functions to display the:
• Duration (mins) of the Sunday Bootcamp class
• Cost of class for the Sunday Bootcamp class.
(4)
(ii) Replicate the functions for Duration (mins) and Cost of class for the other classes.
(1)
(iii) Use spreadsheet formulae to calculate the:
• Total cost for the week
• Total cost for the month
(3)
(iv) Use one spreadsheet function, to display the Discount message ‘5% discount next
month’ if the Total cost for the month is £100.00 or more. If the message is not
displayed, the cell must remain blank.
(3)
(v) On the INFORMATION worksheet, enter a formula to display the Total number
of classes
(2)

SAVE the spreadsheet as PAYMENTS formula

Task B1c
Format the INVOICE worksheet so that:
• currency values show £ with two decimal places
(1)
• row headings Duration (mins) and Cost of class use text wrap
(1)
• row and column headings are displayed when the spreadsheet is printed
(1)
• all cells that contain a heading have a border displayed.
(1)

SAVE the spreadsheet as PAYMENTS values

(Total for Task B1 = 22 marks)

P74653A 15
 Turn over
Task B2

SAVE the spreadsheet as FILTER

Clara wants some information.

(i) Filter the INFORMATION worksheet to show the 45 minute classes instructed
by Sol.
(2)
(ii) Display only the Class ID, Cost and Instructor
(1)
(iii) Hide all other information on the worksheet so only the filtered data is visible.
(1)

RESAVE FILTER

(TOTAL FOR TASK B2 = 4 MARKS)

16 P74653A

Task B3
Answer these questions in the document EVIDENCE
(i) Give one reason why it is useful to have linked worksheets in a spreadsheet.
(1)
(ii) Explain one benefit of replicating formulas in a spreadsheet.
(2)
(iii) Give one benefit of using a header in a spreadsheet.
(1)
(iv) The INFORMATION worksheet has the text Muscle Factory in the cell B3
Give the name of the function you would use to determine the number of
characters in the cell B3
(1)

RESAVE EVIDENCE

(Total for Task B3 = 5 marks)

P74653A 17
 Turn over
Task B4
Clara wants to send a leaflet to potential clients to promote the fitness classes.
She wants you to create the leaflet using the:
• column structure
• instructions
• content from the LEAFLET CONTENT document.
Column structure:
Side 1

1 2 3

Side 2

4 5 6

18 P74653A

Instructions:
The leaflet must:
• be set to landscape orientation
• be two sides of A4 with 3 columns on each side of A4
• use the colour scheme purple, black and white
• include Evolving with Fitness as a footer.
Add a suitable heading to column 1 and format it with an appropriate font size and style.
Add an appropriate image to column 1 and include appropriate alt text.
Add some text and images to column 3 and make appropriate use of grouping and
layering to make sure the text is in front of the images.
Add a table to column 5 that includes the table information. Format the table by making
appropriate use of borders and shading.
Add the 4 icons and relevant text to column 4.
Add appropriate text and images to columns 2 and 6.
Make appropriate use of bullet points.
Ensure the leaflet includes appropriate use of white space.
Use formatting features to ensure the leaflet is fit for purpose and could be sent to
potential clients.

P74653A 19
 Turn over
TASK B4a
Create the leaflet.
(16)

SAVE the document as LEAFLET

TASK B4b
Answer these questions in the document EVIDENCE
(i) Give one reason why it is important to save work regularly.
(1)
(ii) Explain one reason why colour choice is important when designing a leaflet.
(2)

RESAVE EVIDENCE

(Total for Task B4 = 19 marks)

TOTAL FOR SECTION B = 50 MARKS

TOTAL FOR PAPER = 100 MARKS

20 P74653A
