Computing · Year 3

Active learning ideas

Introduction to Branching Databases

Active learning works for branching databases because Year 3 pupils grasp abstract data structures best through physical and digital creation. Sorting real objects and testing yes/no questions makes the logic visible and memorable, turning a technical concept into a tangible skill.

• National Curriculum Attainment Targets
• KS2: Computing - Data and Information
• KS2: Computing - Information Technology

• 20–45 min
• Pairs → Whole Class
• 4 activities

Activity 01

• Placemat Activity
• 30 min · Pairs

Paired Paper Prototyping: Animal Branching Tree

Pairs brainstorm yes/no questions for 8-10 common animals and draw a branching tree on large paper. They test it by hiding animal cards and guiding each other through choices. Pairs swap trees with another pair for feedback and refine paths.

Explain how a series of yes/no questions can identify a specific item.

Facilitation Tip

During Paired Paper Prototyping, circulate to ask pairs how their first question splits the animals and whether it leads to quick identification.

What to look for

Present students with a simple branching database diagram for identifying fruits. Ask: 'If an item is red and round, which question do you ask next?' or 'What happens if you are looking for a banana?'

• Understand
• Analyze
• Evaluate
• Self-Awareness
• Relationship Skills

Activity 02

• Placemat Activity
• 45 min · Small Groups

Small Groups Digital Creation: 2Investigate Software

Groups log into free branching database software like 2Investigate or Purple Mash. They input animals, add yes/no questions, and build the tree structure. Groups test their database on classmates and note any mismatches for improvements.

Design a simple branching database to identify common animals.

Facilitation Tip

In Small Groups Digital Creation, model how to drag questions into the correct order before testing paths with the included objects.

What to look for

Give each student a card with an animal (e.g., a dolphin). Ask them to write two yes/no questions that would help identify it in a branching database and state the final record name.

• Understand
• Analyze
• Evaluate
• Self-Awareness
• Relationship Skills

Activity 03

• Placemat Activity
• 25 min · Whole Class

Whole Class Mystery Challenge: Object Prediction

Display animal images one by one. Class votes on yes/no answers to teacher questions, predicting the path on a shared interactive whiteboard. Discuss what happens if an animal does not fit and vote on new questions.

Predict what happens if an object does not fit any defined categories in a database.

Facilitation Tip

For the Whole Class Mystery Challenge, provide a mix of familiar and unfamiliar objects so students recognize the need for inclusive categories.

What to look for

Pose the question: 'What might happen if we created a branching database for pets, but forgot to include a question about whether the pet can swim?' Facilitate a class discussion on the limitations and potential errors.

• Understand
• Analyze
• Evaluate
• Self-Awareness
• Relationship Skills

Activity 04

• Placemat Activity
• 20 min · Individual

Individual Debugging: Faulty Database Fix

Provide printed or digital buggy branching trees. Pupils trace paths for given animals, identify breaks, and suggest fixes. They recreate corrected versions and test with 3 animals.

Explain how a series of yes/no questions can identify a specific item.

Facilitation Tip

During Individual Debugging, ask students to explain the error message before fixing it to reinforce debugging as a reflective process.

What to look for

Present students with a simple branching database diagram for identifying fruits. Ask: 'If an item is red and round, which question do you ask next?' or 'What happens if you are looking for a banana?'

• Understand
• Analyze
• Evaluate
• Self-Awareness
• Relationship Skills

A few notes on teaching this unit

Teachers should start with concrete examples before moving to abstract questions, using physical objects to model the branching process. Avoid rushing to digital tools; paper prototyping builds confidence and reveals misconceptions early. Research shows that students learn more when they experience dead ends and revise, so design tasks with intentional gaps or errors for debugging practice.

Successful learning looks like students designing clear yes/no questions, testing their database paths without dead ends, and confidently predicting outcomes. They should explain why certain questions work better than others and adjust their designs based on feedback.

---

Watch Out for These Misconceptions

• During Paired Paper Prototyping, watch for students treating branching databases as guessing games rather than organized tools.

  Guide pairs to discuss why their first question should split the animals in half, such as asking about fur versus no fur, and have them test if their design leads to quick identification.

• During Whole Class Mystery Challenge, watch for students assuming every object fits neatly without planning inclusive questions.

  After revealing the mystery object, ask the class to identify which categories excluded it and redesign one question to include it.

• During Small Groups Digital Creation, watch for students using open-ended questions like 'What colour is it?' instead of yes/no questions.

  Have groups revise their questions by testing them with the software; if a path leads to multiple possible answers, prompt them to rephrase the question as yes/no.

---

Methods used in this brief

• Placemat Activity