International GCSE in Information & Communication Technology (ICT) (4IT1).NOTES FOR
CENTERS ICT IGCSE 2024
These notes are to be read in conjunction with the relevant sections of the Instructions for the
Conduct of Examination (ICE) for May 2024 (available from the Pearson website).
These notes are provided to enable Centre staff to re-create the data files for use in the
International GCSE in Information & Communication Technology (ICT) (4IT1).
NOTES:
The contents of this document or the data files must NOT be discussed with
candidates before the end of the examination window.
If it is necessary to reconstruct files using these notes, a printout of the files produced
MUST be included with the scripts for the examiner.
Centres should check in the OFFICE 2010, OFFICE 2003 and NON-OFFICE folders for file
formats which are consistent with the Centre system.
LIST OF FILES:
A copy of each of the following data files must be stored in each candidate’s secure examination
user area before the examination:
IMAGES folder Folder containing EIGHT JPG image files named EDIT, IMAGE 1,
IMAGE 2, IMAGE 3, IMAGE 4, IMAGE 5, IMAGE 6, IMAGE 7
CAR HIRE Database file
HIRE COSTS Spreadsheet file
EVIDENCE, INFORMATION Word processed files
SHEET, PRESENTATION
The following details are provided to recreate the database, spreadsheet, presentation and
word-processed files if Microsoft Office 2003 or later products are not available for candidates.
The IMAGES folder will need to be copied along with the relevant OFFICE or NON-OFFICE folder.
If the files have to be recreated for software versions other than Microsoft Office 2003 or 2010
then the Centre must submit a printout of the data files used by the candidates.
, DATABASE FILE:
Database filename: CAR HIRE
File formats available: ACCDB, MDB and CSV files
Database tables: BOOKINGS, CARS and CLIENTS
BOOKINGS table structure:
FIELD NAME DATA TYPE DESCRIPTION COMMENTS
BOOKINGID AutoNumber Code to identify the booking Set as primary key
CAR ID Short Text Code to identify the car Field size 10
CLIENT ID Short Text Code to identify the client Field size 10
BOOKING METHOD Short Text Methods available to book Field size 10
Lookup list to include
Online, Telephone
The content of the table is stored in the NON-OFFICE folder, DATABASE FILES folder as a comma
separated variable file called BOOKINGS.CSV
CARS table structure:
FIELD NAME DATA TYPE DESCRIPTION COMMENTS
CAR ID Short Text Code to identify the car Set as primary key
Field size 10
CAR TYPE Short Text Type of car hired Field size 10
Lookup list to include
Standard, Premium,
Small SUV, Large SUV
TRANSMISSION Short Text Type of transmission File size 10
Lookup list to include
Automatic, Manual
FUEL TYPE Short Text Type of fuel Field size 10
Look up list to include
Electric, Hybrid,
Petrol
The content of the table is stored in the NON-OFFICE folder, DATABASE FILES folder as a comma
separated variable file called CARS.CSV
CLIENTS table structure:
FIELD NAME DATA TYPE DESCRIPTION COMMENTS
CLIENT ID Short Text Code to identify the client Set as primary key
Field size 10
CLIENT NAME Short Text Name of the client Field size 50
INSURANCE Yes/No Has the client taken out Yes/No
insurance
DEPOSIT PAID Currency How much deposit has the client Currency
paid Auto decimal places
The content of the table is stored in the NON-OFFICE folder, DATABASE FILES folder as a comma
separated variable file called CLIENTS.CSV
The tables MUST be linked as shown in this image:
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller papersbybree. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.99. You're not tied to anything after your purchase.
