Scribd
Upload
76 views

Notes For Centres 1906

The document provides instructions and files for centers administering the International GCSE ICT exam in June 2019. It includes details on 15 image files, a database with tables on destinations and clients, a spreadsheet with costs and details worksheets, and word processed files for a presentation and webpage. The contents must not be discussed with candidates before the exam and centers must submit printouts if recreating the files.

Uploaded by

desh15
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
76 views

Notes For Centres 1906

The document provides instructions and files for centers administering the International GCSE ICT exam in June 2019. It includes details on 15 image files, a database with tables on destinations and clients, a spreadsheet with costs and details worksheets, and word processed files for a presentation and webpage. The contents must not be discussed with candidates before the exam and centers must submit printouts if recreating the files.

Uploaded by

desh15
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 8

Notice for Centres

International GCSE Information and


Communication Technology (4IT1)

June 2019
These notes are to be read in conjunction with the relevant sections of the Instructions
for the Conduct of Examination (ICE) for June 2019 (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 Examination 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 2007, 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 containing FIFTEEN JPG image files named


folder Image1, Image2, Image3, Image4, Image5, Image6, Image7, Image8,
Image9, Image10, Image11, Image12, Image13, Image14, scuba diver

HOLIDAYS Database file


COURSES Spreadsheet file
PRESENTATION Word processed file
WEBPAGE Word processed file

The following details are provided to recreate the database, spreadsheet and word-
processed files if Microsoft Office 2007 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
2007 then the Centre must submit a printout of the data files used by the candidates.

Notes for Centres 4IT1 Paper 2 Summer 2019 2


DATABASE FILE:
Database filename: HOLIDAYS
File formats available: ACCDB, MDB and CSV files
Database Tables: DESTINATION, CLIENTS

DESTINATION table structure:

FIELD NAME DATA TYPE DESCRIPTION COMMENTS


Unique code for each holiday –
two letters to identify the Field size 5
HOLIDAY_ID Short Text country and one digit to Set as primary
represent the number of the key
holiday
COUNTRY Short Text Name of the country Field size 20
REGION Short Text Region within the country Field size 255
DIVEBOAT
Short Text Name of the dive boat company Field size 255
COMPANY
NUMBER OF Number of days the holiday is
Number Long integer
DAYS booked for
Field size 12
LIVEABOARD Whether the holiday is on a
Lookup list to
OR DAY Short Text liveaboard boat or has use of a boat
include Liveaboard
BOAT for a day
and Day boat

The content of the table is stored in the NON-OFFICE folder as a comma separated
variable file called DESTINALTIONS.CSV

CLIENTS table structure:

FIELD NAME DATA TYPE COMMENTS


Primary key
CLIENT_ID Short Text
Field size 6
HOLIDAY_ID Short Text Field size 5
CLIENT NAME Short Text Field size 255
CLIENT DATE OF
Date/Time dd/mm/yyyy
BIRTH
CONTACT EMAIL Short Text Field size 255
MEDICAL FORM Yes/No Yes/No

The content of the table is stored in the NON-OFFICE folder as a comma separated
variable file called CLIENTS.CSV

Notes for Centres 4IT1 Paper 2 Summer 2019 3


The tables should be linked as shown in this image:

Notes for Centres 4IT1 Paper 2 Summer 2019 4


SPREADSHEET FILES

Spreadsheet filename: COURSES


File formats available: XLSX, XLS and CSV files

The spreadsheet contains two worksheets named COSTS and DETAILS

COSTS worksheet

Worksheet format:
• Page setup:
o landscape orientation and fit to 1 page wide by 1 page tall
o display row & column headings and gridlines
• All rows set to 15 (20 pixels) high
• Column A set to 30 (225 pixels) wide
• All remaining columns set to 16 (120 pixels) wide
• Font: default font set to Calibri (a sans serif font) size 11
• Rows 1 and 2 set to bold
• Cells A17:A19 set to bold
• All other cells set to general format.

When opened by candidates the worksheet should look like this image:

The contents of the worksheets are stored in the COSTS.CSV file.

Notes for Centres 4IT1 Paper 2 Summer 2019 5


DETAILS worksheet

Worksheet format:
• Page setup:
o landscape orientation and fit to 1 page wide by 1 page tall
o display row & column headings and gridlines
• All rows set to 15 (20 pixels) high
• Column A set to 32 (240 pixels) wide
• All remaining columns set to 8 (60 pixels) wide
• Font: default font set to Calibri (a sans serif font) size 11
• Row 1 set to bold
• Column B set to currency with 2 decimals
• C2:C7 set as a percentage
• C12 and D10 set to currency with 2 decimals
• All other cells set to general format.

When opened by candidates the worksheet should look like this image:

The contents of the worksheets are stored in the DETAILS.CSV file.

Notes for Centres 4IT1 Paper 2 Summer 2019 6


WORD PROCESSING FILES

Word processed filename: PRESENTATION


File formats available: DOCX, DOC and TXT files

Format of document:

Margins: All 2.54 cm


Font: Calibri (any sans serif font is acceptable) size 11, Regular Text
aligned left
Single line spaced

When opened by the candidate, the document should look like this image:

Notes for Centres 4IT1 Paper 2 Summer 2019 7


Word processed filename: WEBPAGE
File formats available: DOCX, DOC and TXT files

Format of document Margins: All 2.54cm

Font: Calibri (any sans serif font is acceptable) size 11, regular
Text aligned left
Single line spaced
The heading Courses and the sub headings are set to bold

When opened by the candidate, the document should look like this image:

Notes for Centres 4IT1 Paper 2 Summer 2019 8

You might also like