Computing · Year 4

Active learning ideas

Creating a Knowledge Base

Active learning helps Year 4 students grasp branching databases because hands-on creation and testing make abstract decision trees visible and concrete. When pupils work in pairs, small groups, and whole-class settings, they experience how logical splits and user feedback shape a functional knowledge base, reinforcing both computing skills and collaboration.

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

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

Activity 01

• Project-Based Learning
• 25 min · Pairs

Pairs Brainstorm: Branching Questions

Pairs select a topic like woodland animals and list 10 yes/no questions that could split the set. They sort questions by how evenly they divide items, then pick the best six. Share top questions with the class for voting.

Design a complete branching database for a chosen topic.

Facilitation Tip

During Pairs Brainstorm: Branching Questions, circulate and ask each pair to explain why their first question splits the dataset evenly, not just which question they chose.

What to look for

Provide students with a list of 5 fictional creatures and a partially completed branching database. Ask them to write one additional yes/no question that would best split the remaining creatures and explain why.

• Apply
• Analyze
• Evaluate
• Create
• Self-Management
• Relationship Skills
• Decision-Making

Activity 02

• Project-Based Learning
• 45 min · Small Groups

Small Groups: Database Construction

Groups draw branching trees on large paper using their questions and dataset images. They test paths with sample users from the group, noting dead ends. Adjust branches based on tests before digitising in simple software.

Justify the questions chosen for each branch of the database.

Facilitation Tip

When Small Groups construct their databases, remind them to number each branch and label paths so users can follow the logic without confusion.

What to look for

Students exchange their completed branching databases. Each student tests their partner's database by trying to find 3 specific items. They then provide feedback on which questions were confusing or ineffective and suggest one improvement.

• Apply
• Analyze
• Evaluate
• Create
• Self-Management
• Relationship Skills
• Decision-Making

Activity 03

• Project-Based Learning
• 30 min · Whole Class

Whole Class: Usability Testing

Display completed databases around the room. Pupils rotate, using each one to identify items and rate user-friendliness on speed and clarity. Class discusses patterns in feedback for improvements.

Evaluate the user-friendliness of a created database.

Facilitation Tip

During Whole Class Usability Testing, assign specific roles (tester, recorder, reporter) so every student contributes and observes how others interact with their work.

What to look for

Students are given a single, simple item (e.g., a 'dog'). Ask them to write down the final question their branching database would ask to identify this item and the answer that leads to it.

• Apply
• Analyze
• Evaluate
• Create
• Self-Management
• Relationship Skills
• Decision-Making

Activity 04

• Project-Based Learning
• 20 min · Individual

Individual: Justification Reflection

Each pupil writes why their questions split data well and how tests improved the database. Include one example path with user feedback. Share in a class gallery walk.

Design a complete branching database for a chosen topic.

What to look for

Provide students with a list of 5 fictional creatures and a partially completed branching database. Ask them to write one additional yes/no question that would best split the remaining creatures and explain why.

• Apply
• Analyze
• Evaluate
• Create
• Self-Management
• Relationship Skills
• Decision-Making

A few notes on teaching this unit

Teachers should model the process of drafting, testing, and revising questions in front of the class to demystify iteration. Avoid giving perfect examples too soon, as the power of this topic lies in pupils experiencing how real-world databases evolve through user feedback. Research suggests young learners benefit from immediate, low-stakes feedback loops, so plan for quick testing cycles rather than long development phases.

Successful learning looks like students designing balanced yes/no questions that halve datasets at each branch, constructing a clear and testable database, and justifying their choices with evidence from peer evaluations. You will see evidence of logical thinking, attention to user experience, and iterative improvement throughout the activities.

---

Watch Out for These Misconceptions

• During Pairs Brainstorm: Branching Questions, students may believe any yes/no question works for branching, even if it eliminates only one item.

  During Pairs Brainstorm: Branching Questions, provide each pair with a shuffled dataset and ask them to draft two questions: one that splits items evenly and one that doesn’t. Then have them test both by physically sorting cards to see which question halves the set more effectively.

• During Small Groups: Database Construction, students may think databases need perfect questions from the start with no changes.

  During Small Groups: Database Construction, give each group a red pen and require them to mark up their first draft with at least two changes based on peer feedback before finalizing.

• During Whole Class: Usability Testing, students may believe user-friendliness means just pretty pictures, not question clarity.

  During Whole Class: Usability Testing, provide a simple script for testers to follow: ‘Read each question aloud exactly as written and record where you pause or hesitate.’ Use these moments to highlight how wording affects understanding.

---

Methods used in this brief

• Project-Based Learning