Cambridge IGCSE ICT 0417/03 October/November 2025 (Paper 3 Spreadsheets and Website Authoring): Task-by-Task Guide
Cambridge IGCSE ICT 0417/03 is the October/November 2025 Paper 3 (Spreadsheets and Website Authoring). 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 seven source files, set for Tawara Construction, a builder that needs to work out the length and cost of the timber rafters in a roof. The spreadsheet carried 40 marks, file management 1 and the web page 29. 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 the equivalent May/June 2026 paper, see 0417 Paper 32 May/June 2026: questions and mark scheme.
For an overview of all three 0417 papers from this series, see IGCSE ICT 0417 Oct/Nov 2025 Papers: Tasks & Mark Scheme.
0417/03 at a glance
Paper codes: the code printed on the cover is 0417/03/O/N/25, the question paper file is 0417_w25_qp_03, the mark scheme file is 0417_w25_ms_3 and the source files are in 0417_w25_sf_03.
| Task | Steps | What you produce | Marks |
|---|---|---|---|
| 1 Evidence document | – | A new document for your screenshots | 0 |
| 2 Spreadsheet | 1 to 11 | A rafter calculator, printed as formulae, values and a model | 40 |
| 3 File management | 12 | A TC folder holding only the five files you need | 1 |
| 4 Web page | 13 to 21 | A new stylesheet and an edited web page | 29 |
| 5 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 n2503evidence_ followed by your centre and candidate numbers. The screenshots it holds carry marks in Steps 6, 12, 13 and 21, and the copy of your HTML source is where most Task 4 marks are checked.
Task 2: the rafter spreadsheet (40 marks)
The sheet takes the overhang in millimetres, the roof width and the roof height, works out the rafter length, finds the shortest standard length of timber that will do, and looks up its cost for the timber size chosen. The standard lengths run from 2.4 to 6 metres.
- Step 1, header (1 mark): your name, centre number and candidate number right-aligned in the header.
- Step 2, adding the stock data (2 marks): the contents of n25stock.csv added unchanged (1), in cells A20 to E36 (1).
- Step 3, overhang in metres in B6 (1 mark): =B5/1000.
- Step 4, rafter length in B9 (8 marks): the scheme’s answer is =B6+SQRT((B7/2)^2+B8^2). One mark each for:
- =B6+
- SQRT(
- the brackets around everything else inside the square root
- B7/2
- B7/2 in its own brackets
- ^2 on that bracket
- the + between the two squared terms
- B8^2
- Step 5, minimum standard length in B10 (6 marks): =XLOOKUP(B9,A24:A36,A24:A36,,1,1), with one mark each for XLOOKUP, B9, the first A24:A36, the second A24:A36, the “,,1” and the final “,1”. The match mode of 1 returns an exact match or the next larger length, so the rafter is cut from the shortest piece that is long enough.
- Step 6, validation in B11 (3 marks): a List rule (1) using the range B21:E21, the timber sizes in row 21 (1), with the in-cell drop-down selected (1). A screenshot of the rule goes in the evidence document.
- Step 7, cost in B12 (9 marks): =VLOOKUP(B10,A24:E36,HLOOKUP(B11,B21:E22,2,0)+1,0). One mark each for VLOOKUP, B10, A24:E36, HLOOKUP, B11, B21:E22, “,2,0”, “+1” and the final “,0”. The HLOOKUP looks up the size chosen in B11 and returns the number below it in row 22; adding 1 skips the length column so the VLOOKUP reads the right price column. Both lookups use an exact match.
- Step 8, formatting rows 1 to 4 (4 marks): A1:B1 and A3:B3 merged (1), rows 1 and 3 centre-aligned (1), A1 with a black background and a white 18 pt sans-serif font (1), and rows 2 and 4 about half the height of row 5 (1).
- Step 9, formulae printout (2 marks): every cell fully visible (1), and landscape with row and column headings (1).
- Step 10, values printout (1 mark): portrait, one page, fully visible, no row and column headings.
- Step 11, modelling (3 marks): the new data entered correctly as 300, 3.5 and 1.75 (1), the 175 × 50 timber selected in B11 (1), and a values printout of A1 to B12 only, portrait, on one page with no row and column headings (1). With these values the rafter is 0.3 + √(1.75² + 1.75²), about 2.77 m, so B10 should show the next standard length up.
Task 3: file management (1 mark)
You create a folder called TC and copy in only the two PNG images, the HTML file, the JPG and n25tc1.css, leaving out the two CSV files. The one mark is for a screenshot showing the folder name, file names, extensions, file sizes and image dimensions. Add the dimensions column to the folder view before you take it.
Task 4: the stylesheet and web page (29 marks)
All colour codes had to be hexadecimal, and the stylesheet could not contain HTML or scripting.
- Step 13, the new stylesheet (13 marks): one mark each for:
- a screenshot of the stylesheet, together with body background-color: #d8ddff (blue ff, red d8, green dd, written in red-green-blue order)
- background-position: left top
- background-repeat: no-repeat
- background-image: url(“n25badge.png”)
- table border-spacing: 20px
- table border-collapse: separate
- table margin-left: auto
- table margin-right: 0 (these two right-align the table)
- td padding: 20px
- a class with the exact name .centre
- text-align: center inside it
- correct CSS syntax throughout
- a comment with your details at the end of the stylesheet
- Step 14, table structure (2 marks): rowspan=“4” on the right cell of row 1, which holds the logo (1), and rowspan=“2” on the left cell of row 5 (1).
- Step 15, attaching stylesheets (2 marks): n25tc1.css attached in the head section (1), and your new stylesheet attached after it so it has higher priority (1).
- Step 16, page title (1 mark): Tawara Construction in title tags in the head section.
- Step 17, email link (3 marks): an anchor around “Contact us” (1), href=“mailto:tawaraconstruction@cambridge.org (1), and ?subject=Quote requested (1).
- Step 18, the lower right cell (3 marks): A Candidate replaced with your name, centre number and candidate number (1), the paragraph split into two lines before your details (1), and the class centre applied to the h3 text in both lines (1).
- Step 19, default target (1 mark):
<base target="_self">in the head section. - Step 20, author meta tag (3 marks): a meta tag in the head section (1), name=“author” (1), and content set to your name (1).
- Step 21, browser screenshot (1 mark): the page shown in a browser with the address bar visible. You also paste your HTML source into the evidence document.
Where the marks are on 0417/03
- Spreadsheet formulas carried 24 marks: B6 (1), B9 (8), B10 (6) and B12 (9). That is over a third of the paper.
- The rest of the spreadsheet carried 16 marks: header and data (3), validation (3), formatting (4), the two printouts (3) and modelling (3).
- Writing CSS carried 13 marks in Step 13 alone, more than any other step on the paper.
- The HTML edits carried 16 marks: table structure (2), attaching stylesheets (2), title (1), email link (3), the candidate cell (3), base target (1), meta tag (3) and the browser screenshot (1).
- File management carried 1 mark.
- Lookup functions carried 15 marks across B10 and B12. Nested lookups that use a second lookup to choose the column are worth practising.
How to self-mark 0417/03 with the mark scheme
- Mark formulas part by part from your formulae printout. Tick each component of B9, B10 and B12 separately. A formula with one wrong argument still scores its other parts.
- Check the brackets in B9. Three of its eight marks are about where the brackets go: around the whole expression inside SQRT, around B7/2, and the ^2 applied to that bracket.
- Test the model values. With 300, 3.5 and 1.75, B9 should be about 2.77, and B10 should be the next standard length up, not the one below.
- Mark the stylesheet line by line. Each property is its own mark, and the colour code must be in red, green, blue order even though the paper lists blue first.
- Mark the HTML from your source copy, tag by tag. Check that the title, base and meta tags are inside the head section, and that the new stylesheet’s link comes after n25tc1.css.
- Check the email link character by character. The address and the subject line must both be in the href.
Sit 0417/03 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 | 40 | 75 minutes |
| Task 3 File management | 1 | 4 minutes |
| Task 4 Stylesheet and web page | 29 | 45 minutes |
| Task 5 Print the evidence document | 0 | 3 minutes |
| Check printouts and screenshots against the steps | – | 5 minutes |
Within the spreadsheet, leave time for B12: it is worth 9 marks on its own. Sit the paper with no internet or email, as on exam day.
0417/03 in other series
Both this paper and the May/June 2026 Paper 32 priced an item with a VLOOKUP whose column number came from a second lookup (HLOOKUP here, XLOOKUP in 2026), and both had rowspans in the web page table and a mailto link with a subject line. The shape changed: here a 13-mark stylesheet was written from scratch, while the 2026 paper only attached a stylesheet and moved those marks to a video, images and a separate image-editing task.
Other October/November 2025 0417 papers
Practise and download
- Download 0417/03 and its mark scheme on the Learning Portal →
- All 0417 October/November 2025 papers: overview and marking patterns
- 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 03 October/November 2025? +
Five tasks for Tawara Construction: set up an evidence document, build a spreadsheet that calculates the length and cost of a timber roof rafter (40 marks), organise files into a TC folder (1 mark), create a stylesheet and edit a web page (29 marks), and print the evidence document.
How many marks is 0417/03 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 from seven source files. The spreadsheet carries 40 marks, and the biggest single steps are the 13-mark stylesheet and the 9-mark cost lookup in cell B12.
What was the rafter formula in 0417/03 Oct/Nov 2025? +
The mark scheme answer for cell B9 is =B6+SQRT((B7/2)^2+B8^2): the overhang in metres plus the square root of half the roof width squared plus the roof height squared. It was worth 8 marks, one for each part of the formula.
What was the cost lookup formula in cell B12 on 0417/03? +
The scheme gives =VLOOKUP(B10,A24:E36,HLOOKUP(B11,B21:E22,2,0)+1,0), worth 9 marks. The HLOOKUP finds the timber size chosen in B11 and returns its number from row 22, and adding 1 moves the VLOOKUP past the length column to the right price column.
What colour code was the 0417/03 web page background? +
The page background had to be #d8ddff: red d8, green dd and blue ff, written in hexadecimal. The stylesheet also placed n25badge.png once in the top left corner, with no-repeat and a background position of left top.
Where can I download 0417/03 October/November 2025 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. You also need the source files to sit it.
What is 0417_w25_qp_03? +
0417_w25_qp_03 is the file name of the question paper for Cambridge IGCSE ICT 0417 Paper 03 (Paper 3 Spreadsheets and Website Authoring), October/November 2025. Its mark scheme is 0417_w25_ms_3, and the code printed on the cover is 0417/03/O/N/25. The source files for it are in 0417_w25_sf_03. In these file names, w25 means the October/November 2025 series, qp means question paper and ms means mark scheme.
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 TrialWritten by
Mahira Kitchil
Connect on LinkedIn →Project Head, Tutopiya
Mahira Kitchil is a Project Head at Tutopiya, where she works with Cambridge IGCSE and Edexcel A-Level teachers in more than 20 countries on how exams are set and marked. She writes practical guides that help students find the right past papers and use the mark scheme the way examiners do, so every practice paper counts.
Related Articles
A Level Biology 9700 Oct/Nov 2025 Papers & Mark Schemes
Free 9700 Oct/Nov 2025 Paper 1 and Paper 3 with mark schemes: the topics tested, the practical tasks and how examiners awarded marks on each.
A Level Computer Science 9618 Oct/Nov 2025 Papers & Marking
Free 9618 Oct/Nov 2025 papers and mark schemes, plus a paper-by-paper breakdown of Papers 1 to 4 and how examiners gave marks for code and theory.
A Level Geography 9696 Oct/Nov 2025 Papers: Topics & Mark Scheme
Free 9696 Oct/Nov 2025 papers, inserts and mark schemes, plus a paper-by-paper breakdown of the data questions, options and essays and how they were levelled.
