Cambridge IGCSE ICT 0417/02 October/November 2025 (Paper 2 Document Production, Databases and Presentations): Task-by-Task Guide
Past Papers

Cambridge IGCSE ICT 0417/02 October/November 2025 (Paper 2 Document Production, Databases and Presentations): Task-by-Task Guide

Mahira Kitchil Project Head, Tutopiya
• 9 min read
Updated

Cambridge IGCSE ICT 0417/02 is the October/November 2025 Paper 2 (Document Production, Databases and Presentations). 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 eight source files, with marks given for printouts and for screenshots in an evidence document. The database task carried 26 marks, the document 25 and the presentation 19. 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 22 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/02 at a glance

Paper codes: the code printed on the cover is 0417/02/O/N/25, the question paper file is 0417_w25_qp_02, the mark scheme file is 0417_w25_ms_2 and the source files are in 0417_w25_sf_02.

TaskStepsWhat you produceMarks
1 Evidence document–Open and save the evidence document template0
2 Document1 to 14An edited running festival document, TM_Festival25
3 Database15 to 22Three imported tables, an edited record and two reports26
4 Presentation23 to 33Seven slides with a master slide, pie chart, notes and a link19
5 Print the evidence document34A printout of all your screenshots0
Total70

Task-by-task walkthrough

Task 1: evidence document (no marks)

You open n2502evidence.rtf, make sure your name, centre number and candidate number appear on every page, and save it as EVIDENCE followed by your candidate number. It earns nothing itself, but the screenshots you paste into it carry marks in Steps 1, 6, 9, 15 to 20, 25 and 32.

Task 2: the TM_Festival document (25 marks)

The document arrives as A4 portrait with 2 cm margins and three styles already set up. You must not change any of them.

  • Step 1, saving (1 mark): saved as TM_Festival in the format of your own software, with a screenshot that shows the file type.
  • Step 2, header and footer (2 marks): automated page numbers right-aligned in the header (1), and your name, centre number and candidate number right-aligned in the footer (1).
  • Step 3, sorting the list (1 mark): the list from “accurate chip timing” to “special commemorative medal” sorted into alphabetical order.
  • Step 4, bullets (3 marks): consistent bullets on the right text (1), indented 1.5 cm from the left margin (1), and single line spacing with 0 pt before and after (1).
  • Step 5, two columns (2 marks): a section break around the right text, from the Race Entry subheading to the paragraph ending “be polite to them” (1), and two columns with a 1.5 cm gap (1).
  • Step 6, creating the TMF-subhead style (2 marks): one mark for creating it, naming it correctly and basing it on the default or normal style; one for all the settings: serif, 16 pt, centred, bold, all capitals, single line spacing, 0 pt before and 6 pt after.
  • Step 7, applying TMF-subhead (1 mark): to all five subheadings, matching the style you defined.
  • Step 8, deleting a row (1 mark): the Elite runners row and its contents removed, with the rest of the table intact.
  • Step 9, row height (1 mark): the last row set to 1.5 cm, shown by a screenshot.
  • Step 10, the last row (3 marks): its three cells merged into one (1), the contents centred vertically and horizontally (1), and a light grey 20 to 30% fill (1).
  • Step 11, table formatting (2 marks): consistent 1 pt internal and external gridlines that print (1), and one combined mark for text on one line in every row, borders and data within the column width and the space after the table kept (1).
  • Step 12, the track image (2 marks): n2502track.jpg placed in the paragraph starting “The race starts” (1) and rotated 180 degrees (1).
  • Step 13, cropping and placing the image (3 marks): cropped to remove the blue sky above the clouds, with the clouds still fully visible (1); resized to 3.5 cm wide with no distortion (1); and aligned to the top of its paragraph and the right margin, with text wrapping (1).
  • Step 14, proofread and print (1 mark): one mark for the whole layout: paragraphs intact, the list and table not split, no widows or orphans, no blank pages, the original styles kept and consistent spacing.

Task 3: the race results database (26 marks)

  • Step 15, the race table (2 marks): the primary key set on Entry_no with no added ID field (1), and all 12 field names and data types as given (1). Entry_no, YOB, Age, Gender_result and Race_result are integers, Record_time and Race_time are times shown as hh:mm:ss, and Pace_KM/h is a decimal number.
  • Step 16, changing a data type (1 mark): Pace_KM/h changed to display as time in the format hh:mm:ss.
  • Step 17, the club table (1 mark): four text fields with Club_code as the primary key and no ID field.
  • Step 18, the age group table (1 mark): four text fields with Group_code as the primary key and no ID field.
  • Step 19, relationships (1 mark): both one-to-many links, Club_code to Club_no and Group_code to Age_cat, for a single mark.
  • Step 20, finding and editing a record (2 marks): evidence of an automated search function used to locate Entry_no 1498 (1), and the record amended to Age_cat FSE39, YOB 1992, Age 33 and Gender_result 137 (1).
  • Step 21, the Young Scottish Finishers report (7 marks): one mark each for:
    • the title Young Scottish Finishers, 100% accurate and fully visible
    • selecting Area containing the text Scot
    • selecting Age of 30 or less (the scheme gives 34 records for the two conditions together)
    • sorting by ascending Area, then descending Age
    • the six fields in the set order, with headings that match the data
    • all fields present with nothing truncated
    • a portrait tabular report on a single page
  • Step 22, the Senior Female Club Competitors report (11 marks): one mark each for:
    • the title Senior Female Club Competitors, 100% accurate and fully visible
    • the calculated field heading Age_graded, 100% accurate
    • correct Age_graded values, calculated at run time as Record_time ÷ Race_time
    • Age_graded shown as a percentage
    • Age_graded to 1 decimal place
    • selecting Age_cat FSE29 or FSE39 (the scheme gives 43 records in all)
    • excluding Club_name values that contain Independent
    • sorting by descending Gender_result
    • the eight base fields in the set order, with headings that match the data
    • landscape, tabular, a single page wide, with every field in full
    • your details in the page footer on every page

Task 4: the nutrition presentation (19 marks)

  • Step 23, seven slides (1 mark): all imported from n2502guide.rtf, each with a title and bulleted list, no blank slides and no text changed.
  • Step 24, the master slide (4 marks): your details top left in the same position on every slide, with no extra items and nothing overlapping (1); a horizontal and a vertical line at the top and right, running the full width and height of the slide (1); lines 3 to 4 pt wide and about 2 cm from the top and right edges (1); and automated slide numbers top right, inside the box where the lines cross (1).
  • Step 25, hiding a slide (1 mark): a screenshot showing slide 6, Good sources of carbohydrates, hidden.
  • Step 26, the pie chart (1 mark): built from the macronutrients for endurance training only.
  • Step 27, chart title (1 mark): Macronutrient ratio for endurance training, 100% accurate.
  • Step 28, sector labels (2 marks): only the macronutrient names and percentages (1), all outside the sectors with no legend (1).
  • Step 29, emphasis (1 mark): only the largest sector pulled away from the chart.
  • Step 30, placement (2 marks): on the Optimise your diet slide, left of the bullets (1), with all data and labels visible, no split words and no overlap (1).
  • Step 31, presenter notes (2 marks): the sentence about endurance runners needing more carbohydrates entered as notes on the right slide, 100% accurate (1), and only that slide (slide 4) printed as notes pages in portrait (1).
  • Step 32, the hyperlink (2 marks): the text “critical fuel source” made into the link (1), and the link going to slide 6, Good sources of carbohydrates (1).
  • Step 33, printing handouts (2 marks): portrait handouts, two slides to a page, each filling half the page (1), and the printing controlled so that slides 1 to 5 and 7 print and the hidden slide 6 does not (1).

Task 5: printing the evidence document (no marks)

You check that your details are on every page, then save and print the evidence document. The marks for its screenshots sit in the steps that asked for them.

Where the marks are on 0417/02

  • Database work carried 26 marks: importing and setting up the three tables (5), relationships (1), the search and record edit (2) and the two reports (18). The reports alone are a quarter of the paper.
  • Document editing carried 25 marks: saving, header and footer (3), the sorted bulleted list (4), columns (2), the style (3), the table (7), the image (5) and the final proofread (1).
  • The presentation carried 19 marks, 7 of them on the pie chart (Steps 26 to 30) and 4 on the master slide.
  • Five marks need text typed exactly: the two report titles, the Age_graded heading, the chart title and the presenter notes.
  • Screenshots carry marks in Steps 1, 6, 9, 15 to 20, 25 and 32. A step done correctly with no screenshot can still lose its mark.

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

  1. Lay out your printouts and evidence document side by side with the scheme. Each line in the scheme is one mark.
  2. Check typed text letter by letter. A 100% accurate mark is lost to one wrong character, a capital letter in the wrong place or a missing underscore.
  3. Check every setting in a combined mark. Step 6’s settings mark, Step 11’s second mark and Step 14’s single mark each list several settings, and one miss loses the whole mark.
  4. Count your report rows. Step 21 should show 34 records and Step 22 should show 43. A different count points to a wrong selection, usually the “includes Scot” or “does not include Independent” condition.
  5. Recalculate a few Age_graded values by dividing Record_time by Race_time, and check that they show as a percentage to 1 decimal place.
  6. Check the handouts for slides 1, 2, 3, 4, 5 and 7, two to a portrait page, with no Good sources of carbohydrates slide.

Sit 0417/02 as a timed mock

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

BlockMarksTime
Task 1 Evidence document03 minutes
Task 2 Document2545 minutes
Task 3 Database2650 minutes
Task 4 Presentation1930 minutes
Task 5 Print the evidence document04 minutes
Check printouts against the steps–3 minutes

Sit it with no internet or email, as on exam day, and use the eight source files listed on page 2 of the paper.

0417/02 in other series

The May/June 2026 Paper 22 kept the same three-part shape: a document with a new style based on the normal style, two columns and a cropped, resized and wrapped image, then a three-table database, then a presentation with a pie chart that needed a title, labels outside the sectors, no legend and the largest sector pulled out. The split moved from 25, 26 and 19 marks here to 25, 30 and 15 in 2026, where the second report was replaced by labels and the master slide lines, hidden slide, presenter notes and hyperlink did not appear.

Other October/November 2025 0417 papers

Practise and download

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 02 October/November 2025? +

Five tasks: set up an evidence document, edit a running festival document called TM_Festival (25 marks), build a three-table race results database with two reports (26 marks), create a seven-slide presentation on nutrition for runners with a pie chart (19 marks), and print the evidence document.

How many marks is 0417/02 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 eight source files. The database task is the biggest at 26 marks, and the single biggest step is the 11-mark Senior Female Club Competitors report in Step 22.

What were the settings for the TMF-subhead style on 0417/02? +

A style based on the default or normal paragraph style: serif font, 16 points, centred, bold and all capitals, single line spacing, 0 points before and 6 points after. One mark was for creating, naming and basing it correctly, and one for all the settings. Applying it to the five subheadings was a third mark.

How was the Age_graded field calculated on 0417/02? +

It was a run-time calculated field equal to Record_time divided by Race_time, displayed as a percentage to one decimal place. The heading, the values, the percentage format and the one decimal place each earned a separate mark.

How many records should the 0417/02 Oct/Nov 2025 reports show? +

The mark scheme says the Young Scottish Finishers report in Step 21 selects 34 records, and the Senior Female Club Competitors report in Step 22 selects 43 records.

Where can I download 0417/02 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_02? +

0417_w25_qp_02 is the file name of the question paper for Cambridge IGCSE ICT 0417 Paper 02 (Paper 2 Document Production, Databases and Presentations), October/November 2025. Its mark scheme is 0417_w25_ms_2, and the code printed on the cover is 0417/02/O/N/25. The source files for it are in 0417_w25_sf_02. 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 Trial
M

Written 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.

Mahira Kitchil on LinkedIn

Get Started

Courses

Company

Subjects & Curriculums

Resources

Book a Tutor

Struggling with this topic?

Practise IGCSE ICT with free topic quizzes