ÌÇÐÄ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

9 November 2026

docx, 38.27 KB
docx, 38.27 KB
pptx, 131.93 KB
pptx, 131.93 KB
docx, 37.65 KB
docx, 37.65 KB

Data warehouses lesson for IB Diploma Computer Science (first assessment 2027), with editable PowerPoint slides, a student worksheet and full answers. A data warehouse collects data from many sources into one store designed for analysis and reporting rather than everyday transactions.

Written for the 2027 IB Computer Science guide, unit A3 Databases (HL only). Everything is editable, so you can adapt it to your class.

What’s included
  • PowerPoint lesson (10 slides) with speaker notes on every slide
  • Student worksheet (Word), ready to print or edit
  • Answer sheet (Word) with model answers for every question
A3.4.2 Data warehouses

By the end of the lesson students can:

  • Explain the purpose of a data warehouse in business intelligence
  • Describe six features of data warehouse data
  • Compare a data warehouse with an everyday database

Worksheet sections: A. Features; B. Integrate the data; C. Append-only; D. Business intelligence

Every lesson includes
  • Learning goals and a starter question
  • Clear explanations with worked examples (Python where code is needed)
  • A quick check and a “your turnâ€� task linked to the worksheet
  • An exit ticket
Format
  • PowerPoint (.pptx) and Word (.docx), fully editable
  • Works in PowerPoint and Google Slides
  • Calm pastel design, consistent across the whole IB course

These are independent resources written for the IB Diploma Programme Computer Science guide (first assessment 2027). They are not produced or endorsed by the International Baccalaureate Organization.

More lessons in this series

Last updated: November 2026.

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

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

Bundle

Databases – IB Computer Science (18 lessons)

18 ready-to-teach lessons for IB Diploma Computer Science (first assessment 2027): Databases. Every lesson has editable PowerPoint slides, a student worksheet and full answers, and the bundle costs less than buying the lessons one by one. A complete, ready-to-teach bundle for IB Computer Science (first assessment 2027): Databases, in 18 bespoke lessons written for the new syllabus. Every lesson comes with: - **Editable PowerPoint slides** – goals, starter, explanations, worked examples, a task and an exit ticket, with teacher notes - **Student worksheet (Word)** – structured questions that build from recall to exam-style application - **Answer sheet (Word)** – full model answers for quick marking or self-assessment Worth £89.82 if bought lesson by lesson. ## What's inside **A3.1 Database fundamentals** - A3.1.1 Relational databases **A3.2 Database design** - A3.2.1 Database schemas - A3.2.2 Entity relationship diagrams - A3.2.3 Datatypes - A3.2.4 Constructing tables - A3.2.5 Normal forms: 1NF, 2NF and 3NF - A3.2.6 Normalising a scenario to 3NF - A3.2.7 Denormalising databases **A3.3 Database programming** - A3.3.1 Data language types: DDL and DML - A3.3.2 Constructing queries in SQL - A3.3.3 Updating data with SQL - A3.3.4 SQL aggregate functions *(HL)* - A3.3.5 Database views *(HL)* - A3.3.6 Database transactions *(HL)* **A3.4 Alternative databases and data warehouses** *(HL only)* - A3.4.1 Different types of database - A3.4.2 Data warehouses - A3.4.3 OLAP and data mining - A3.4.4 Distributed databases ## Why teachers use it - Mapped code by code to the 2027 IB CS guide, so coverage is easy to track - SL and HL content clearly labelled - Fully editable – adapt to your class, timings and school template - Works for teaching, revision, cover lessons and homework Last updated: November 2026.

£44.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.