Cambridge IGCSE ICT 0417/32 is the May/June 2026 Paper 3 (Spreadsheets and Website Authoring), variant 2. It lasts 2 hours 15 minutes, is worth 70 marks and is sat by every 0417 candidate. It is a practical paper done on a computer from six source files, set for a company called Pat’s Pocket Doors that sells sliding doors fitted into the wall. The spreadsheet task carried 41 marks and the web page 27. This guide goes through the paper step by step and shows what the official mark scheme gave marks for. The paper and its mark scheme are free on the Tutopiya Learning Portal.

For an overview of all three 0417 papers from this series, see IGCSE ICT 0417 May/June 2026 past papers: what came up and how it was marked.

0417/32 at a glance

Task	Steps	What you produce	Marks
1 Evidence document	–	A new document for your screenshots	0
2 Spreadsheet	1 to 12	A door sizing and pricing sheet, printed as formulae and values	41
3 File management	13	A folder holding only the files you need	1
4 Images	14	A rotated door image saved as a JPG	1
5 Web page	15 to 22	pocketdoor.htm, built in one table	27
6 Print the evidence document	–	A printout of all your screenshots	0
		Total	70

Task-by-task walkthrough

Task 1: evidence document (no marks)

You create a word-processed document with your name, centre number and candidate number on every page, and save it as ppdevidence_ followed by your centre and candidate numbers. The screenshots it holds carry marks in Steps 4, 9, 10, 13 and 22.

Task 2: the pocket door spreadsheet (41 marks)

The user types the available wall space in C3 and the door type in C4. The sheet then finds the largest door that fits, its width, the type and the cost.

• Step 1, setting up (1 mark): the text “Details by” followed by a space and your name and numbers, with the sheet saved as doors_ plus your centre and candidate numbers.
• Step 2, formatting to match the layout (10 marks): one mark each for:
  • A1:C1, A6:C6, A12:B12 and A17:E17 merged and centred
  • those four titles in large white text on a grey background
  • A3:B3, A4:B4 and C18:E18 merged
  • A18:A19 and B18:B19 merged
  • those two headings wrapped as shown
  • A3:B4 and A7:A10 right-aligned
  • A3:B4, A18:B19 and C18:E18 bold
  • C7:C8 left-aligned
  • every other cell centred vertically and horizontally
  • all currency values in $ to 2 decimal places
• Step 3, sorting (2 marks): only the numeric rows of the doors table sorted on Wall space (1), ascending with each row kept together (1).
• Step 4, named range (2 marks): a range called door (1) covering only A20:E29, the numeric cells (1).
• Step 5, wall space in B7 (5 marks): =VLOOKUP(C3,door,1,1). The marks are for VLOOKUP, C3, the range door, column 1 and the final 1 for an approximate match, which returns the largest wall space in the table that fits the user’s entry.
• Step 6, door width in B8 (1 mark): =VLOOKUP(B7,door,2,0), an exact match on the wall space you found.
• Step 7, door type in B9 (1 mark): =C4.
• Step 8, cost in B10 (9 marks): the scheme builds it as =VLOOKUP(C3,door,2+XLOOKUP(C4,B13:B15,A13:A15),1), with one mark each for VLOOKUP, C3, door, the “2+”, XLOOKUP, C4, B13:B15, A13:A15 and the final 1. The XLOOKUP finds the door type in the Door type table and returns its number (Glass 1, Pine 2, Oak 3). Adding 2 skips the wall space and width columns, so the VLOOKUP reads from the Glass, Pine or Oak price column.
• Step 9, validation on C3 (4 marks): a rule applied to C3 (1), allowing decimal values between two limits (1), with the minimum (1) and the maximum (1) each worth a mark. Set both limits exactly as the step gives them.
• Step 10, validation on C4 (3 marks): a rule on C4 (1) of type List (1), with its source as the door types in B13:B15 (the Glass, Pine and Oak headings in C19:E19 were also accepted) (1).
• Step 11, formulae printout (2 marks): every cell fully visible (1), and landscape with row and column headings (1).
• Step 12, values printout (1 mark): portrait, fully visible, one page, no row and column headings.

Task 3: file management (1 mark)

You create a folder called door and copy in only the stylesheet, the three images and the video, leaving out the CSV. The one mark is for a screenshot showing the folder name, file names, extensions and sizes, the video’s frame height and width, and the images’ dimensions. Add those columns to the folder view before you take it.

Task 4: rotating an image (1 mark)

The glass-door image rotated 180 degrees and saved in the door folder as a JPG named image_ plus your centre and candidate numbers.

Task 5: the pocketdoor.htm web page (27 marks)

The page is one table, three columns wide. Cells A and B each fill the whole height of the left two columns, and cells C to F are stacked down the third column.

• Step 15, table structure (6 marks): width 90% (1), a single table (1), visible borders (1), no cell letters on the page (1), and rowspan=“4” on the first column (1) and the second column (1).
• Step 16, page title (1 mark): Pat’s Pocket Doors in the head section.
• Step 17, images and video (10 marks): the banner image in cell A (1); then for cell B, the video with visible controls (1), a video tag (1), autoplay (1), loop (1), a source tag with src=“j2632video.mp4” (1), type=“video/mp4” (1), a height of 640 px with the aspect ratio kept (1), and a text error message between the opening and closing video tags (1). The rotated glass-door image in D and the oak image in E share the final mark (1). Setting only the height keeps the aspect ratio.
• Step 18, cell C text (3 marks): “Web page created by” (1), then your name and numbers on a new line (1), all in h2 (1).
• Step 19, cell F text (2 marks): “Contact us” (1) in h1 (1).
• Step 20, email link (3 marks): an anchor around “Contact us” (1), a mailto link to ppd@cambridge.org (1), and ?subject= with the subject line I want a pocket door! (1).
• Step 21, stylesheet (1 mark): j2632.css attached with a link in the head section.
• Step 22, browser screenshot (1 mark): the whole page visible and readable in a browser with the address bar showing. You also paste your HTML source into the evidence document, which is where most Task 5 marks are checked.

The scheme’s general rules for web pages also apply: only tags inside the head section are marked as head content, a different tag from the one the step names scores nothing, and h1 or h2 marks are lost if the tag carries attributes that change the text’s style.

Where the marks are on 0417/32

• Spreadsheet formulas carried 16 marks: B7 (5), B8 (1), B9 (1) and B10 (9).
• Spreadsheet setup and formatting carried 11 marks: Step 1 (1) and the Step 2 layout (10).
• Validation carried 7 marks: C3 (4) and C4 (3).
• Data handling and printouts carried 7 marks: sorting (2), the named range (2) and the two printouts (3).
• The web page’s video and images carried 10 marks, the table structure and title 7, the cell text and styles 5, the email link 3, and the stylesheet and browser screenshot 1 each.
• File management and image editing carried 1 mark each.

How to self-mark 0417/32 with the mark scheme

1. Read the over-riding rules first. The scheme gives no marks for unnecessary functions, for formulas in the wrong cells, or for formatting if extra cells are formatted too. The formulae printout marks need at least one formula displayed.
2. Mark formulas part by part from your formulae printout. Tick each component in Steps 5 and 8 separately. A formula with one wrong argument still scores the other parts.
3. Check your named range screenshot shows A20:E29 exactly, with no heading rows included.
4. Test your sheet with the sample entry. Enter the values the paper gives and check that every formula returns a sensible result before you print.
5. Mark the web page from your HTML source, tag by tag. Look for each attribute in Step 17 separately: controls, autoplay, loop, the source tag’s src and type, and the height.
6. Check the email link character by character. The address and the subject line must both be in the href.

Sit 0417/32 as a timed mock

The paper allows 135 minutes for 70 marks, just under two minutes per mark. A workable plan:

Block	Marks	Time
Task 1 Evidence document	0	3 minutes
Task 2 Spreadsheet	41	75 minutes
Tasks 3 and 4 File management and image	2	7 minutes
Task 5 Web page	27	42 minutes
Task 6 Print the evidence document	0	3 minutes
Check printouts and screenshots against the steps	–	5 minutes

Within the spreadsheet, leave time for Step 8: it is worth 9 marks on its own. Sit the paper with no internet or email, as on exam day.

Other May/June 2026 0417 papers

• 0417 Paper 12 (Theory)
• 0417 Paper 22 (Document Production, Databases and Presentations)

Practise and download

• Download 0417/32 and its mark scheme on the Learning Portal →
• All 0417 May/June 2026 papers: overview and marking patterns
• Try a free IGCSE ICT quiz

Need help with a 0417 topic? Book a free trial lesson with an IGCSE ICT tutor →

Frequently asked questions

What tasks were on 0417 Paper 32 May/June 2026? +

Six tasks: an evidence document, a 41-mark spreadsheet that works out the size and cost of a sliding pocket door, a 1-mark file management task, a 1-mark image rotation, a 27-mark web page built in a single table, and printing the evidence document.

How many marks is 0417/32 and how long is it? +

It is out of 70 marks and lasts 2 hours 15 minutes. It is a practical paper done on a computer, and the spreadsheet task alone is worth 41 marks.

What was the 9-mark formula on 0417/32? +

The cost formula in cell B10. The mark scheme builds it as =VLOOKUP(C3,door,2+XLOOKUP(C4,B13:B15,A13:A15),1): the XLOOKUP turns the door type into its number, and adding 2 gives the right price column. Each part of the formula earned its own mark.

What was the named range on 0417/32? +

A range called door covering only the numeric cells of the doors table, A20:E29. It earned 2 marks, one for creating the name and one for the exact range, and both lookup formulas in B7 and B10 used it.

What did the 0417/32 video need? +

A video tag with visible controls, autoplay and a continuous loop, a source tag naming j2632video.mp4 with type video/mp4, a height of 640 pixels with the aspect ratio kept, and a text error message between the video tags. Each was a separate mark.

Where can I download 0417/32 May/June 2026 and its mark scheme? +

Both are free to download and print on the Tutopiya Learning Portal, on the Cambridge IGCSE ICT 0417 past papers page.

Ready to Excel in Your Studies?

Get personalised help from Tutopiya's expert tutors. Whether it's IGCSE, IB, A-Levels, or any other curriculum — we match you with the perfect tutor and your first session is free.

Book Your Free Trial