iGCSE ICT Spreadsheets: Plant Nursery

Pearson Edexcel iGCSE ICT (4IT1) Paper 2-style spreadsheet practice assessment: LOOKUP, IF, PRODUCT, absolute references, filters, pie chart, mark scheme.

Give your iGCSE ICT pupils realistic practice for the spreadsheet tasks in Paper 2 (Practical). This complete, ready-to-use practice assessment covers specification topic 6.3 Spreadsheets and is set in a plant nursery, Desert Bloom Plant Nursery.

What’s included

• Question paper (PDF, 3 pages)
• Teacher mark scheme (PDF, 4 pages) and an editable DOCX version
• Completed model answer spreadsheet (XLSX)
• Data files zip: NURSERY (workbook with STOCK, PRICING and SUMMARY worksheets) and an EVIDENCE document for screenshots and written answers

Assessment format

45 marks, 1 hour 15 minutes.

Section A – Practical (32 marks)

• Task 1 – Formatting (4 marks): fonts, shading, row height, text wrap and alignment of field headings.
• Task 2 – Calculations (15 marks): a LOOKUP for the markup, a sell price formula, the PRODUCT function, a SUM total, a percentage using an absolute cell reference, an IF that returns Reorder or a blank, replication and percentage formats.
• Task 3 – Functions (4 marks): MAX, MIN and COUNTIF.
• Task 4 – Currency (1 mark): currency format with two decimal places.
• Task 5 – Filtering (3 marks): filtering on two criteria and hiding columns, with screenshot evidence.
• Task 6 – Chart (3 marks): a pie chart with title, percentage data labels and legend.
• Task 7 – Printing (2 marks): portrait, fit to one page wide, footer with name and automated file name, print to PDF.

Section B – Short answer (13 marks): PRODUCT, absolute references, COUNT and COUNTA, choosing a pie chart, hidden columns, lookup tables, testing a formula and using multiple worksheets.

Mark scheme

Point-by-point marking grids with “award the mark for” and “check / do not accept” guidance, expected values for checking pupils’ work quickly (for example the first plant’s sell price, income and percentage, the total income and the number of plants to reorder), and every mark mapped to a learning objective and to the 4IT1 specification references (6.3.1–6.3.8, 5.4).

Ideal for

End-of-unit practice, mock preparation, timed lab practice, homework or cover lessons.

Notes

Designed for Microsoft Excel. Currency is shown in pounds (£). The scenario and all data are fictional. A second spreadsheet practice paper, Oasis Bike Hire, is also available.