BTEC Tech Awards DIT Component 2 Help Sheets

This collection of help sheets provides a comprehensive toolkit to guide students through the BTEC DIT Component 2 coursework, using the January 2024 “Fitness Company” PSA as a scenario example.

• Data Investigation (Task 1): Guides students in evaluating data collection methods, reliability, and security.

• Practical Skills (Task 2a-c): Provides step-by-step instructions for spreadsheet setup, complex formulas (VLOOKUP, IF, SUMIF), and dynamic dashboard creation using Pivot Tables and charts/graphs.

• Evaluation (Task 3a-b): Supports students in analysing data for trends and patterns, while critiquing their own presentation to ensure it remains unbiased and professional.

Each sheet features direct textbook page references, encouraging independent learning and ensuring students provide the specific evidence required for the highest marks.