Teaching Ideas
Visit Teaching News and enter our competition to win DK books!

More Teaching Ideas Literacy Ideas and Resources Numeracy Ideas and Resources Science Ideas and Resources Information and Communication Technology Ideas and Resources Design and Technology Ideas and Resources Geography Ideas and Resources History Ideas and Resources Art Ideas and Resources Music Ideas and Resources Physical Education Ideas and Resources Religious Education Ideas and Resources Early Years Ideas and Resources Foreign Languages Ideas and Resources More Teaching Ideas
Branching Database Ideas
Subject: I.C.T.
Age Range: 7 to 11

Branching databases can be tricky concept to teach, so try some of these ideas to help your children's understanding.

1) Play Guess Who - Ask all of the children in the class to stand. The teacher should choose one of the pupils in the class without saying who he / she has chosen. One of the pupils must ask the teacher a 'Yes / No' questions about the person who has been chosen (e.g. do they have blonde hair? are they a boy?). Children who don't match the description should sit down (i.e. if a child asks "Are they a boy?" and the teacher replies "Yes", the girls don't match the description and so should sit down). As more questions are asked, the pupils should be able to identify which pupil has been chosen. This is an enjoyable starting activity which encourages children to phrase their questions carefully. Who can identify the chosen person in the lowest number of guesses? You could also get the children to play the real game if you have one available - AMAZON LINK???

2) Drawing on the playground - Organise the children into small groups (max 6-8). They should stand on the playground as one group together. Ask the children to think of a question which can be used to split them into two smaller groups (e.g. are they a girl?). Write this question on the playground using large chalks and draw two arrows with YES next to one and NO next to the other. The children should travel along the arrows which match their description (e.g. girls go along the 'Yes' arrow and boys go along the 'No' arrow). Each group should then split themselves again by asking a new question (e.g. Are they wearing glasses?), writing the question, drawing arrows and having the children travel along the new arrows. Continue until there is only one child at the end of each arrow. By doing this, the children will have made their own branching tree which could be copied / photographed as evidence!

3) Sorting sweets - When teaching children about branching databases, try starting with something that they are familiar with. I usually use sweets as they have a range of different properties which can be used when sorting (e.g. packet colour / packet size / flavours / shapes). The children are usually familiar with them too, so they can think of questions really easily! Once they are comfortable sorting objects like these, try sorting more difficult items.

Have you taught a good lesson about branching databases? If you have any good ideas, try posting them in the comments area below, or email them to mark@teachingideas.com and I will add them to this page!


Teaching Ideas - Providing free lesson ideas, resources and activities since 1998.
All Content © Mark Warner / Teaching Ideas 1998-2009
Graphics by ThistleGirl Designs
Home Home Contact Contact FAQ FAQ
Site Map Site Map Contribute Contribute Terms Terms
RSS Feed RSS Feed Twitter Twitter Privacy Privacy
Join the Mailing List
Enter your email address to receive
updates via email.

Teaching Ideas is kindly hosted by
RM