Chrisblogga

GCE ICT Advanced Level Practical – High-Frequency Tasks 2019–2024 Analysis After analysing the last 6 years of ICT Paper 3, these tasks appear with alarming regularity: Database Section Almost Guaranteed 1. Create a relational database with 3–4 tables and proper primary/foreign keys Students, Subjects, Scores, Teachers patterns. 2. Query using criteria — especially date ranges, "LIKE" with wildcards, and calculated fields. 3. Create a report with grouping and sorting e.g. results by class then by subject. 4. Parameter query — the one that asks the user for input at runtime. Most repeated query type: "List all students who scored above 15 in at least two subjects in the 2023/2024 academic year." Spreadsheet Section - VLOOKUP or XLOOKUP with approximate match for grading - Pivot tables still coming despite being "old" - Conditional formatting + data validation - Charts with secondary axis very common in 2022–2024 Mail Merge The 2024 paper had a classic "send personalised admission letters to successful candidates" mail merge. This has appeared in 4 of the last 6 years. I have attached in comments the exact structure of the most common database schema that has been used in three different years. Who else is writing ICT this year? Let's share resources.