1. Spreadsheet Modelling—functions (IF, COUNTIF, MIN, MAX, ROUND), formula replication, discount calculations, absolute referencing, data sorting, formatting (currency, date/time, cell styles)

2. Database Queries—criteria filters (e.g. more than 100 guests), sorting results, field selection, foreign key usage, data validation (range, presence), form creation with formatted inputs

3. Word Processing—layout editing (headers, footers, tables), inserting screenshots, PDF export, document formatting for clarity and accessibility, page organization

4. Website Creation—HTML page structure, image insertion and resizing, navigation links, internal linking, consistent template use, text styling (color, font)

5. Logo and Graphics—bitmap properties, image editing (resizing, cropping), inserting graphics in documents and web pages, creating fit-for-purpose branding assets

6. ICT Theory—data vs information, advantages of validation, reasons for using mail merge, function purposes in spreadsheets, differences in referencing styles