ÌÇÐÄVlog

Please consent to cookies to view content.

' ); iframeDoc.close(); } } } } } const observer = new MutationObserver(switchSrc); observer.observe(document.documentElement, { childList: true, subtree: true, }); })();

ÌÇÐÄVlog

Last updated

18 November 2026

pptx, 379.76 KB
pptx, 379.76 KB
png, 237.12 KB
png, 237.12 KB
png, 281.2 KB
png, 281.2 KB
png, 263.32 KB
png, 263.32 KB

BTEC Tech Award Digital Information Technology – Component 2: Collecting, Presenting and Interpreting Data | Complete 87-Slide Teaching Deck

Teach all of Component 2 with one fully editable PowerPoint deck, written for the Pearson BTEC Level 1/Level 2 Tech Award in Digital Information Technology (603/7050/6). It covers Learning Aims A, B and C, from collecting data to building and evaluating a dashboard.

WHAT’S INCLUDED

87 slides in 10 sections, with speaker notes on every slide
15 learning-objective slides, so each lesson starts with clear goals
A clear I DO → WE DO → YOU DO → CHECK → REFLECT sequence throughout
8 spreadsheet views with a working formula bar and highlighted cells, showing exactly what students type and where
A dashboard mock-up made with native, editable PowerPoint charts, with KPIs, a bar chart and a pie chart
18 teaching tables, 11 concept-card slides, 6 case-study slides and 2 bar charts
7 YOU DO tasks for independent practice
4 retrieval quizzes (24 questions in total), with answers in the notes
A card-sort activity and a model-response slide that shows what a strong written evaluation looks like

ONE DATASET, START TO FINISH
Students work with one fictional business, Riverside Café, for the whole component. A week of sales across six products builds up step by step: SUM, AVERAGE, MAX, MIN, COUNTIF, SUMIF, IF, lookups, absolute and relative referencing, what-if analysis, goal seek, filters, subtotals, conditional formatting and macros. Every figure on every slide was checked by calculation, so the totals, averages and percentages students work out will match the slides.

COVERAGE
A: The ways data is used, what makes data good quality, the factors affecting how it is collected, and presenting it accurately.
B: Spreadsheet skills to process and analyse data, then building a dashboard.
C: Drawing conclusions, making recommendations and evaluating how well a dashboard meets a client’s needs.
Final section: assignment-style skills, such as planning written evaluations, using evidence and avoiding common pitfalls.

PRACTICAL NOTES FOR TEACHERS

The notes explain where Excel and Google Sheets differ
What-if analysis is taught as a set of tools (scenarios, goal seek, data tables), not as a single function
The notes remind students that macro workbooks must be saved as .xlsm
The spreadsheet views are illustrations on slides. Students should rebuild them in real software, using the figures shown.

Ready to teach and fully editable. Ideal for non-specialists, cover and revision.

Independent resource from Lesson & Co. Not endorsed by or affiliated with Pearson. All organisations, people and data are fictional. Always check the current specification and assessment guidance on the Pearson website.

Get this resource as part of a bundle and save up to 36%

A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.

Bundle

Pearson BTEC Tech Award Digital Information Technology | Components 1–3 Bundle | 298 Editable Slides | DIT Revision

## SEO Title Pearson BTEC Tech Award Digital Information Technology | Components 1–3 Bundle | 298 Editable Slides | DIT Revision ## Description A comprehensive **3-resource teaching and assessment bundle** for **Pearson BTEC Level 1/Level 2 Tech Award in Digital Information Technology (603/7050/6)**. Featuring **298 fully editable PowerPoint slides**, this collection covers **Components 1, 2 and 3**, supporting Years 10–11 teaching, NEA preparation and examination revision. **Component 1 – User Interface Design (91 Slides)** - Types of user interfaces and devices - User needs, accessibility and personas - Layout, navigation, colours and fonts - Design principles and wireframes - Project planning and Gantt charts - Prototyping, testing and evaluation - 18 lessons covering 36 GLH **Component 2 – Collecting, Presenting and Interpreting Data (87 Slides)** - Data collection and quality - Spreadsheet formulas and functions - SUM, IF, COUNTIF, SUMIF and lookups - Absolute and relative referencing - What-if analysis and goal seek - Data dashboards, charts and KPIs - Evaluating dashboards and recommendations - Original Riverside Café case study **Component 3 – Effective Digital Working Practices (120 Slides)** - Cloud computing and modern teams - Digital accessibility and inclusion - Cybersecurity, malware and phishing - Encryption, backups and disaster recovery - Data protection and ethical issues - Environmental impacts of technology - Flowcharts and data flow diagrams - Exam-style questions and evaluation skills - 24-lesson course map covering 48 GLH **Teaching and Assessment** - I Do / We Do / You Do / Check / Reflect - Original fictional business scenarios - Editable diagrams and interface mock-ups - Worked calculations and spreadsheet examples - Retrieval quizzes and model answers - NEA skills and examination techniques **What's Included** - 3 complete editable PowerPoints - **298 fully editable slides** - Detailed teacher speaker notes - 13 Component 1 interface mock-ups - Spreadsheet and dashboard illustrations - Cybersecurity and system diagrams - Original practice tasks and case studies - Component 3 practice examination - Revision quizzes, answers and glossaries **Visual Preview and Format** **All visuals shown in the ÌÇÐÄVlog previews are included in the relevant resources.** Buyers can review examples of the actual slides, diagrams and interface designs before purchasing. All three presentations are editable PPTX files. Interface and spreadsheet examples are illustrative, not functioning software. **Important:** Independent assessment preparation. No live Pearson-set assignments or official examination papers are included. Ideal for **BTEC Tech Award Digital Information Technology**, KS4 lessons, revision and assessment preparation. ## SEO Keywords Pearson BTEC Digital Information Technology, BTEC Tech Award DIT, Components 1 2 3, user interface design, UI design, project planning, Gantt charts, spreadsheets, data dashboards, Excel formulas, cybersecurity, cloud computing, digital working practices, data protection, NEA preparation, BTEC DIT revision, editable PowerPoint ## Copyright © 2026 Lesson & Co. All rights reserved. Independent educational resource supporting Pearson BTEC Tech Award in Digital Information Technology. Not produced, approved or endorsed by Pearson. Qualification names identify curriculum relevance only. Original explanations, activities, diagrams and designs remain the intellectual property of Lesson & Co. Third-party materials retain their respective rights. **Short Footer:** © 2026 Lesson & Co. Independent BTEC Digital IT resource. Not affiliated with Pearson.

£22.99

Reviews

Something went wrong, please try again later.

This resource hasn't been reviewed yet

To ensure quality for our reviews, only customers who have purchased this resource can review it

to let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.