Branching Databases — Year 3 Lesson Plan
National Curriculum: Computing KS2 — select, use and combine a variety of software on a range of digital devices to design and create a range of programs, systems and content that accomplish given goals, including collecting, analysing, evaluating and presenting data and information
Overview
Pupils learn to collect, organise, and query data using branching databases. They begin by sorting physical objects using yes/no questions, then translate this into a branching database structure. Using database software, they create their own branching databases to identify everyday objects, animals, or plants, and evaluate whether their questions are clear and unambiguous.
Learning Objectives
- Explain what a database is and why databases are useful for storing information.
- Sort objects using yes/no questions to create a branching structure.
- Create a branching database using database software.
- Query a branching database to find a specific record.
Key Vocabulary
Suggested Lesson Structure
Animal guessing game: one pupil thinks of an animal, others ask only yes/no questions to identify it in ten questions or fewer. After two rounds, discuss: which questions were most useful? Questions that split the remaining animals into two roughly equal groups are most efficient. Introduce the idea that this is exactly how a branching database works.
Show a simple branching database for fruit: Does it have a skin you peel? Yes → Does it grow in bunches? No → Is it citrus? Walk through how you arrive at 'orange' by answering yes/no questions. Explain: databases help us store and find information quickly. A branching database narrows down the answer step by step. Introduce vocabulary: records, fields, attributes. Demonstrate the software pupils will use (e.g. 2Investigate or J2Data), showing how to add questions and answers to build the tree.
Pupils create a paper branching database for a set of eight animals on cards. They must identify attributes (e.g. has wings, lives in water, is a mammal) and write yes/no questions that correctly sort every animal into a unique endpoint. Teacher checks: does each question have a clear yes or no answer? Does every branch lead to exactly one animal?
Pupils enter their branching database into the software. They test it by querying it for each animal and checking they reach the correct endpoint. Then they swap with a partner and query each other's database for a mystery animal.
Discuss: what made a good question? What happened if a question was ambiguous? How is a branching database similar to a dichotomous key in science? Connect to real-world databases: where might a doctor, a librarian, or a shopkeeper use a database to find records quickly?
Common Misconceptions
- Pupils sometimes write ambiguous questions ('Is it nice?', 'Is it big?') — questions must have a definitive yes or no answer for every item in the database.
- Thinking databases are only on computers — a branching key in a biology textbook or a library catalogue card system are both databases.
Prior Knowledge
Pupils should already be able to:
- Experience sorting objects by one or more criteria in maths.
- Familiarity with yes/no questions and logical reasoning.
- Basic use of classroom software and typing skills.
Want a personalised version of this lesson?
Use Staffroom to generate a complete lesson plan tailored to your class — add context about ability, recent learning, or specific pupils and get a plan ready to teach. Free trial, no card required.