Pupils explore Boolean logic through the familiar world of recommendation systems, learning how apps and game stores decide what to suggest next. They work with a games dataset, test clear true or false conditions and build recommendation rules that can be applied consistently and fairly.

Across three lessons, pupils learn AND, OR and NOT logic gates, combine them into logic circuits then translate circuits into plain English rules. They then apply those rules to real data, using spreadsheet filters to narrow a list and IF statements to build a simple recommendation system that outputs a clear yes or no for each game. Along the way they practise careful reasoning, checking results against the data and debugging when a rule does not behave as expected.

Everything is fully planned and ready to teach. Includes fully editable PowerPoints, lesson plans and worksheets.

LESSONS INCLUDED

1. Recommendation rules: What recommendation systems are, why platforms use them, writing clear conditions and testing rules against a games table using AND, OR and NOT.
2. Design logic circuits: Translating requirements into logic, filtering a spreadsheet to find matches and drawing circuits that reflect a set of recommendation requirements.
3. Build a recommendation system: Writing IF statements using AND, OR and NOT in spreadsheet logic, using AutoFill to scale calculations and creating a working recommendation rule that flags which games meet the criteria.
   .
   **WHO IS THIS FOR? **
   Ideal for KS3 computing classes and great for teachers who want a practical, modern way to teach Boolean logic without abstract worksheets. Perfect if you want pupils to see how logic connects to real systems, real data and real decisions.

Buy now to give pupils a confident first step into Boolean logic and a set of spreadsheet skills they will use again and again.