New
New
Year 3

Making a dinosaur identifier

I can independently create an identification tool.

New
New
Year 3

Making a dinosaur identifier

I can independently create an identification tool.

These resources will be removed by end of Summer Term 2025.

Switch to our new teaching resources now - designed by teachers and leading subject experts, and tested in classrooms.

These resources were created for remote use during the pandemic and are not designed for classroom teaching.

Lesson details

Key learning points

  1. You can create your own identification tool.
  2. Branching databases can be created based on a plan.
  3. Branching databases are used in real-world situations.

Keywords

  • Identification - the process of identifying something

  • Real world - something that happens in real life

Common misconception

Branching databases can only be used to identify objects.

In the real world, branching databases can be used for many reasons such as finding faults and diagnosing illnesses.


To help you plan your year 3 computing lesson on: Making a dinosaur identifier, download all teaching resources for free and adapt to suit your pupils' needs...

Find a practical example of a branching database that pupils can use. Having hands-on experience will allow pupils to appreciate the links between what they are doing in the lesson and applications in the real world.
Teacher tip

Equipment

Software is required to create branching databases on a computer. This lesson uses oak.link/branching-db but activities can be completed using any alternative.

Licence

This content is © Oak National Academy Limited (2025), licensed on Open Government Licence version 3.0 except where otherwise stated. See Oak's terms & conditions (Collection 2).

Lesson video

Loading...

6 Questions

Q1.
What is the purpose of a branching database?
to store objects
to draw objects
Correct answer: to identify objects using questions
to test objects
Q2.
What does plan mean in the context of a database?
Correct answer: a design for the future
a random arrangement
a way to delete data
a list of objects
Q3.
Why is it important to use attributes in a branching database?
to delete objects
to make it look colourful
to add more objects
Correct answer: to group objects logically
Q4.
What does compare mean in the context of a database?
to group objects randomly
Correct answer: to identify similarities and differences
to plan the database
to test the database
Q5.
What makes a good question for a branching database?
It is random.
It has more than two answers.
It uses long sentences.
Correct answer: It splits the data evenly.
Q6.
Put these steps in order for creating a branching database.
1 - Select objects.
2 - Create questions.
3 - Test the database.
4 - Use the database.

6 Questions

Q1.
Match the tasks to their purposes.
Correct Answer:selecting objects,choosing what to include in the database

choosing what to include in the database

Correct Answer:creating questions,grouping objects logically

grouping objects logically

Correct Answer:testing,checking if the database works

checking if the database works

Correct Answer:planning,designing the database structure

designing the database structure

Q2.
Why is planning important when creating a branching database?
to make it look colourful
to delete data
to add more questions
Correct answer: to ensure it works effectively
Q3.
Order these tasks for testing a database.
1 - Check questions.
2 - Test grouping.
3 - Fix errors.
4 - Final test.
Q4.
Which statement is true about branching databases?
They are only used to identify objects.
Correct answer: They can be used for lots of reasons like finding faults.
They are only used in schools.
They cannot be used in the real world.
Q5.
How can branching databases be used beyond identifying objects?
Correct answer: diagnosing illnesses
deleting data
storing pictures
writing stories
Q6.
Match the terms to their definitions.
Correct Answer:identification,the process of identifying something

the process of identifying something

Correct Answer:real world,something that happens in real life

something that happens in real life

Correct Answer:attributes,characteristics used to group objects

characteristics used to group objects

Correct Answer:testing,ensuring the database works correctly

ensuring the database works correctly

Additional material

Download additional material