Information and Communication Technology 0417/32 May/June 2025: question paper and mark scheme
Cambridge IGCSE Information and Communication Technology (0417), Paper 3 Spreadsheets and Website Authoring, May/June 2025. Read both free below, or download them. Done the paper? Get it marked by AI against this mark scheme.
Open and examine the file j25fuelmix.csv
Place in the header the text Tests performed on: followed by a space, the automated date, a space then the text at followed by a space then the automated time.
Place left-aligned in the footer the text Tests by: followed by a space then your name, centre number and candidate number.
Save this as a spreadsheet with the file name FuelData_ followed by your centre number_candidate number, for example FuelData_ZZ999_9999
[3]
Mark scheme
Text Tests performed on: with space then with automated date in header … 1
… with space, the text at another space and the automated time 1
Text Tests by: with space then name, centre and candidate number left 1
aligned in footer
Task Answer Marks
For Task 2 see below for example of spreadsheet values.
Merge cells A1 to F1.
Format this merged cell with a black 40-point serif font on a yellow background.
Merge cells A3 to B3 and A11 to B11.
Format these merged cells with a light grey background.
Format rows 1 to 18 of the spreadsheet to look like this:
A B C D E F
Test data for fuel mixes
1 on the straight track
2
3 All tests
4 Fastest test time
5 Slowest test time
6 Average test time
7 Average test time for Mix 1
8 Average test time for Mix 2
9 Average test time for Mix 3
10
11 Wind adjusted tests
12 Average test time for Mix 1
13 Average test time for Mix 2
14 Average test time for Mix 3
15 Best Mix
16
Test number Wind
Mix number Fuel mix % Test time adjustment Wind
17 acceptable
18 1 1 3.2 17.1022 4.1 No
Make sure rows 19 to 77 are formatted the same as row 18.
[8]
Mark scheme
Cells A1:F1, A3:B3 and A11:B11 merged 1
Merged cell A1 black 40-point serif font 1
Merged cell A1 wrapped as shown 1
Borders as shown 1
Rows 1, 3, 11 and 17 to 77 centre aligned horizontally 1
Row 17 centre aligned vertically 1
Row 17 wrapped as shown 1
Column A rows 4–9 and 12–15 right aligned 1
Task Answer Marks
For Task 3 see below for example of Evidence Document.
Place in cell B9 a formula, using the named range created in Step 3, to display the average test time for mix number 3 [1]
Tests are only acceptable if there is little or no following wind.
Mark scheme
Cell B9 1
=AVERAGEIF(B18:B77,3,TTime)
PUBLISHED
Task Answer Marks
For Task 10 see below for example of spreadsheet formulae.
Place in cell F18 a replicable formula to check the wind adjustment for this test. If this value is below +2, display the word Yes, if not, display the word No
Replicate this formula for all tests.
[4]
For the calculations for wind adjusted tests, the results will only count if the wind levels are acceptable.
Mark scheme
Cell F18 1
=IF( … )
… E18<2 … 1
… ,"Yes" … 1
… ,"No” … 1
Task Answer Marks
For Task 11 see below for example of spreadsheet formulae.
Place in cell B15 a formula to display the Fuel mix % for the fuel mix that gave the fastest wind-adjusted average test time. Format this cell to display as a percentage. [6]
Mark scheme
Cell B15 1
=IF(MIN(B12:B14)=B12
… ,3.2%, … 1
… IF(MIN(B12:B14)=B13… 1
… ,3.4%, … 1
… 3.6%)) 1
Formatted as % value 1
Task Answer Marks
For Task 15 see below for example of spreadsheet formulae and values.
Print your spreadsheet showing the formulae. Make sure that the:
• printout is in landscape orientation
• row and column headings are displayed
• contents of all cells are fully visible.
[1]
Mark scheme
Formulae printout – Landscape orientation, fully visible with row and column 1
headings
Task Answer Marks
For Task 17 see below for example of values spreadsheet and selection method.
Print your spreadsheet showing the values. Make sure that the:
• printout fits on a single page
• printout is in portrait orientation
• row and column headings are not displayed
• contents of all cells are fully visible.
[1]
[Total: 40]
Task 3 – File management
Mark scheme
Values printout – Portrait, single page, fully visible, no row and column 1
headings
Task Answer Marks
For Task 18 see below for example of Evidence Document.
Create a new folder called TR
Locate only the following files and store them in your TR folder.
j25banner.jpg j25racing.css j25racing.mp4 j25tech.htm j25text.txt
Display the contents of your TR folder, showing the folder name and all file names, file extensions, file sizes, frame heights, frame widths and image dimensions.
Take a screenshot of this folder, making sure that the required information is clearly visible. Place this screenshot in your Evidence Document. [1]
[Total: 1]
Task 4 – Web Page
Mark scheme
Screenshot includes folder name, image dimensions, file names, sizes, 1
extensions, frame height and frame width.
PUBLISHED
Task Answer Marks
For Task 19 see below for example of HTML and browser view.
Create in your TR folder a web page called j25racing.htm
This web page must be created using a single table and work in all browsers. The table must be centre-aligned and fit 85% of the browser window. The table must have a structure as shown in this diagram:
A
B C
D E
F G
Each table cell is identified with a letter which must not appear on your final web page.
Table borders must not appear on the final web page.
[5]
Mark scheme
table style="width:85%" 1
Single table used 1
No borders visible 1
No letters visible 1
Row 1 – colspan="2" 1
Task Answer Marks
For Task 20 see below for example of HTML.
Place inline style attributes into the HTML to set both the width and height of cell C to 480 pixels.
[2]
Mark scheme
Row 2 right cell style=”width:480” 1
Row 2 right cell style=”height:480” 1
Task Answer Marks
For Task 21 see below for example of HTML and browser view.
Place in:
• cell A the image j25banner.jpg
• cell C video and source tags to display j25racing.mp4
Make sure that the controls are visible and the video loops when played.
Display an automated text-based error message if the browser does not support this video type.
[7]
Mark scheme
Top row – j25banner.png 1
Row 2 right – Video visible in browser 1
video <…> tag used with … 1
… loop attribute 1
source<…> tag used with src="j25racing.mp4" … 1
… type="video/mp4" 1
Appropriate error message between <video> and </video> 1
Task Answer Marks
For Task 22 see below for example of browser view.
Enter in cell B the text from the file j25text.txt
Set this text in style h3.
[2]
Mark scheme
Row 2 left – text from source file 100% accurate … 1
… set in style h3 1
PUBLISHED
Task Answer Marks
For Task 23 see below for example of HTML and browser view.
Enter in:
• cell D the text New technologies
• cell E the text Contact us
• cell F the text Designed by:
• cell G your name, centre number and candidate number.
Set all the text in these cells in style h2.
[4]
Mark scheme
Row 3 left – New technologies 1
Row 3 right – Contact us 1
Row 4 left – Designed by: 1
right – name and numbers
Rows 3 and 4 – all set in style h2 1
Task Answer Marks
For Task 24 see below for example of HTML.
Make the text New technologies a link to open the web page j25tech.htm
Make the text Contact us a link to an email editor to prepare an email to
Tawara.Racing@cambridge.org with the subject line Tell me more!
[5]
Mark scheme
Anchor set around New technologies 1
<a href="j25tech.htm" … 1
Anchor set around Contact us 1
… ?subject=Tell me more!"> 1
Task Answer Marks
For Task 25 see below for example of html and browser view.
Attach the stylesheet j25racing.css to your web page.
Edit this stylesheet so that the table is centre-aligned in the browser window.
Save this stylesheet.
[2]
Mark scheme
j25racing.css attached in head section 1
Table centre aligned in browser 1
Task Answer Marks
For Task 26 see below for example of HTML and browser view.
Save your web page.
Take a copy of your HTML source and place this in your Evidence Document.
Display your web page in a browser. If necessary, resize it so that:
• all the page can be seen
• all text can be easily read
• the address bar is visible.
Take screenshot evidence showing your web page in the browser. Place this in your Evidence
Document.
[1]
[Total: 29]
Task 5 – Printing the Evidence Document
Save and print your Evidence Document. Make sure your name, centre number and candidate number appear on every page of your Evidence Document.
Mark scheme
In web browser with address visible 1
Checked your answers against these? Let AI mark the whole paper, on your own working.
Examiners follow the generic marking principles at the front of the scheme, then each question's points: method (M), accuracy (A) and independent (B) marks, error carried forward where the scheme allows it, and positive marking, so you're credited for what you got right.
Check your answers against it
Done this paper? Upload your script and CIE Buddy's AI marker marks it question by question against this exact scheme, puts the ticks on your own working and says what each lost mark needed.
Where can I find the 0417/32 May/June 2025 mark scheme?+
On this page, free: the mark scheme for IGCSE Information and Communication Technology 0417/32, May/June 2025 (0417_s25_ms_32), and the question paper (0417_s25_qp_32), to read or download, with each question's marking points written out underneath.
How many marks is 0417/32 out of?+
Information and Communication Technology 0417/32 for May/June 2025 is out of 70 marks, with 2 hours 15 minutes to answer it, across 3 questions.
Can I get my 0417/32 answers marked?+
Yes. Upload your answers to 0417/32/M/J/25 as a PDF or photos, and CIE Buddy marks every question against this paper's official mark scheme, using Cambridge's marking rules. You get your score, each lost mark explained on your own script, and the topics to revise. It's a guide, not an official Cambridge grade.