Pearson Edexcel International Advanced Level
Friday 16 June 2023
Afternoon (Time: 3 hours)
Paper
reference WIT14/01
Information Technology
International Advanced Level
UNIT 4
You must have:
The files Staff.accdb, Staff extract.txt, Candidate evidence template.docx
Instructions
•• Answer all questions using the template provided.
Paste your screen prints into the appropriate places in the template.
• Type your responses to Question 1(e) and Question 5 in the appropriate places in
the template.
Information
•• The total mark for this paper is 80.
The marks for each question are shown in brackets
– use this as a guide as to how much time to spend on each question.
Advice
•• Read each question carefully before you start to answer it.
Try to answer every question.
• Check your answers if you have time at the end.
Turn over
P72606A
©2023 Pearson Education Ltd.
N:1/1/1
*P72606A*
, Instructions
A template for your evidence is provided in your examination area.
Open the template and type in your centre name, centre number, candidate name and
candidate number in the boxes provided.
You must save the template using a filename in this format:
Centre number_candidate number_surname_first letter of first name
For example, 12345_9212_Smith_J
The screen prints you produce must be copied into the appropriate places in your
template.
After you add a screen print to your template check that all the text can be read and
enlarge the image, if necessary.
Remember to save your template regularly.
Responses to Question 1(e) and Question 5 must be typed in the appropriate places in
your template.
2 P72606A
, Scenario
Lucian owns a company that employs staff to work in school kitchens.
Each member of staff has one job, e.g. Head Cook.
Once a year each member of staff meets with Lucian to discuss their performance
throughout the year.
A performance grade (1–3) is agreed at the meeting.
Grade 1 is the best grade.
Lucian keeps a list of staff members in a single table within the database Staff.
He has provided the staff extract text file, which includes records of staff performance.
Lucian is finding it difficult to keep track of:
• the performance grades of each member of staff
• the schools that staff are employed in
• the job each member of staff is employed to do.
He wants a solution that will allow him to manage staff records more effectively.
P72606A 3
Turn over
Friday 16 June 2023
Afternoon (Time: 3 hours)
Paper
reference WIT14/01
Information Technology
International Advanced Level
UNIT 4
You must have:
The files Staff.accdb, Staff extract.txt, Candidate evidence template.docx
Instructions
•• Answer all questions using the template provided.
Paste your screen prints into the appropriate places in the template.
• Type your responses to Question 1(e) and Question 5 in the appropriate places in
the template.
Information
•• The total mark for this paper is 80.
The marks for each question are shown in brackets
– use this as a guide as to how much time to spend on each question.
Advice
•• Read each question carefully before you start to answer it.
Try to answer every question.
• Check your answers if you have time at the end.
Turn over
P72606A
©2023 Pearson Education Ltd.
N:1/1/1
*P72606A*
, Instructions
A template for your evidence is provided in your examination area.
Open the template and type in your centre name, centre number, candidate name and
candidate number in the boxes provided.
You must save the template using a filename in this format:
Centre number_candidate number_surname_first letter of first name
For example, 12345_9212_Smith_J
The screen prints you produce must be copied into the appropriate places in your
template.
After you add a screen print to your template check that all the text can be read and
enlarge the image, if necessary.
Remember to save your template regularly.
Responses to Question 1(e) and Question 5 must be typed in the appropriate places in
your template.
2 P72606A
, Scenario
Lucian owns a company that employs staff to work in school kitchens.
Each member of staff has one job, e.g. Head Cook.
Once a year each member of staff meets with Lucian to discuss their performance
throughout the year.
A performance grade (1–3) is agreed at the meeting.
Grade 1 is the best grade.
Lucian keeps a list of staff members in a single table within the database Staff.
He has provided the staff extract text file, which includes records of staff performance.
Lucian is finding it difficult to keep track of:
• the performance grades of each member of staff
• the schools that staff are employed in
• the job each member of staff is employed to do.
He wants a solution that will allow him to manage staff records more effectively.
P72606A 3
Turn over
