Choose exam board for KS4 Computer Science (GCSE)
Choose exam board for KS4 English
Choose exam board for KS4 French
Choose exam board for KS4 Geography
Choose exam board for KS4 German
Choose exam board for KS4 History
Choose tier for KS4 Maths
Choose exam board for KS4 Music
Choose exam board for KS4 Physical education (GCSE)
Choose exam board for KS4 Religious education (GCSE)
Choose exam board for KS4 Spanish

      Making a dinosaur identifier

      Lesson details

      Learning outcome

      I can independently create an identification tool.

      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.

      Teacher tip

      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.

      Equipment

      Pupils will need access to a device with software that can create branching databases. Examples in this lesson use J2E branch https://oak.link/branching-db

      Licence

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

      Lesson video

      Loading...

      Prior knowledge starter quiz

      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


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