Y3 Branching Databases
Lesson Focus
Learners will start to explore questions with yes/no answers, and how these can be used to identify and compare objects.
Investigate questions with yes/no answers.
Will be able to make up a yes/no question about a collection of objects.
Children can select an attribute to separate objects into groups.
Children will learn how to arrange objects into a tree structure and think about which attributes the questions are related to.
Learners will create their own questions with yes/no answers to help sort objects.
They will learn how to arrange objects into a tree structure.
Children will test a predefined branching database and understand how objects have been described and sorted.
Learners will start to create a simple branching database.
Learners will use attributes to create questions with yes/no answers, and will apply these to given objects.
Learners will show that their branching database works through testing.
Children will further test their database with a partner to see if it works.
Children will be able to explain why questions need to be in a specific order.
Learners will independently plan a branching database.
Children create questions that will enable objects to be uniquely identified.
Children will suggest real-world uses for branching databases.
Digital Skills & Computing Focus
Log into a computer and their Google Account.
Access Google Classroom.
Able to identify the set assignment and follow instructions.
Open the assigned links.
Open the set worksheets when asked.
Complete the different sections.
Use keyboard shortcuts. If required.
Understand left and right mouse clicks.
Open and complete the “Drag “n” Drop” activity if required.
Select the correct links in Google Classroom and open online branching database software.
Select and add content to the database.
Create a number of questions relating to the chosen objects.
Understand the flow of the database and make corrections if required.
Able to select and add different content and change the structure.
Take screenshots and copy to the worksheet.
Key vocabulary
Attribute, value, questions, table, objects, Branching database, database, attribute, value, questions, objects, equal, even, separate, compare, order, organise
Learners will develop their understanding of what a branching database is and how to create one. They will use yes/no questions to gain an understanding of what attributes are and how to use them to sort groups of objects. Learners will create on-screen branching databases.
Children will create questions with yes/no answers and test yes/no questions about a collection of objects. By simply answering yes/no they will create two groups of objects separated by one attribute
Learners will identify the attributes needed to collect data about an object. They will select an attribute to separate objects into groups and arrange objects into a tree structure. Children will be able to explain that questions need to be ordered carefully to split objects into similarly sized groups and sub-groups.
To conclude the unit, they will create an identification tool using a branching database, which they will test with a partner. They will also consider real-world applications for branching databases.
📸photographic summary 📸
📋Sorting Questions📋
Year 3 start to explore questions with yes/no answers, and how these can be used to identify and compare objects. They will create their own yes/no questions, before using these to split a collection of objects into groups.
Children investigate questions with yes/no answers and was able to create a collection of objects based on their answers - either a YES or NO
Children spent time thinking about questions relating to different items and how to identify them with simple questions.
👩👩👦Creating a Group👩👩👦
Children develop their understanding of using questions with yes/no answers to group objects more than once. They now learn how to arrange objects into a tree structure and will continue to think about which attributes the questions are related to.
They learn to use an attribute to separate objects into groups and arrange objects into a tree structure. It's during this lesson, learners will be introduced to branching databases, what a branching database looks like and how they work.
📈Creating a Branching Database📉
Children develop their understanding of ordering objects/images in a branching database structure. They will learn how to use an online database tool to arrange objects into a branching database, and will create their own questions with yes/no answers.
Children work with a partner to test their database and correct any mistakes.
Learning objectives
To create a branching database
I can select objects to arrange in a branching database
I can group objects using my own yes/no questions
I can test my branching database to see if it works
📈going it alone📉
Children were finally confident to start to create their own branching database. They worked in pairs to create the structure and add the various questions that will enable anyone to find the item via it's attribute .
Learners then demonstrated their knowledge and understanding by creating and finishing a "space" branching database on the touch screen at the front of the class. Children took turns in completing a section of the database then we tested it together.
James, even built a branching database at home - well done James.