Attributes and entities
Starters and plenaries
Acting upA fun starter activity. Students are given a character card. They then have to explain a term related to this topic whilst staying in character. (subscription only) |
instructions character cards |
30 secondsStudents are shown a number of terms for exactly 30 seconds. They need to memorise as many as possible. After 30 seconds, the terms are hidden and they need to write down as many terms as they can remember along with at least one fact about that term. (subscription only) |
|
Compare and contrastA starter activity (subscription only) |
|
Teach me about ..Lesson starter (subscription only) |
|
Draw me a pictureStarter or plenary Students are given a selection of key terms and are asked to illustrate one of them in a diagram. (subscription only) |
|
Give me tenA starter or plenary task (subscription only) |
|
Just a minuteStarter or plenary task Students are asked to talk to a partner about this topic for 60 seconds whilst abiding by a set of rules (subscription only) |
|
Lucky dip questionsStarter or plenary task Every student is given a number at the start of the activity. This is used to help pick who will ask and answer questions about what has been learned during the lesson. (subscription only) |
|
One, two, threeCan be used either as a starter or a plenary task. Students are given a sheet to complete firstly on their own, then with a partner and then joining up with another pair (subscription only) |
|
Pass the buckAn excellent starter or plenary for involving all students and getting them to identify a large number of facts about the current topic (subscription only) |
|
Teacher talkaboutStarter or plenary task The class 'test' the teacher on their knowledge of key words related to this topic (subscription only) |
|
4-4-2A plenary activity where students are asked to summarise the lesson and pick out the main key words related to the topic. (subscription only) |
|
Call My BluffA plenary activity based on the popular game show, ‘Call My Bluff’ (subscription only) |
|
MastermindA plenary activity which is loosely based on the game show 'Mastermind' (subscription only) |
|
One WordA plenary task. Students have to sum up today's lesson in just one sentence. They must include a given word within that sentence. (subscription only) |
|
Word building gamePlenary task Students work in groups to construct a sentence about today’s lesson (subscription only) |
|
CorkboardA great plenary idea both for AFL and for getting feedback from every student (subscription only) |
|
I predictThis task acts as the plenary from one lesson and the starter for the next lesson (subscription only) |
|
PyramidA plenary activity. Students are asked to complete a self assessment sheet to indicate what they have learned during this lesson (subscription only) |
|
Text meA plenary activity where students are asked to write a text message to explain what they have learned during the lesson (subscription only) |
|
Tweet itA plenary activity (subscription only) |
|
Lesson and homework tasks
Theory notes taskStudents read the theory notes on the mini website and then answer the questions on the task sheet. (subscription only) |
task |
Attributes and entities taskStudents are given a number of different entities for various scenarios. They have to identify the appropriate attributes that would be related to those entities. (subscription only) |
task answers
|
Entity relationships practical workbookGoes through one-to-one, one-to-many and many-to-many relationships giving students opportunities to practice creating appropriate ERDs. (subscription only) |
workbook answers |
Resolving relationshipsThis activity provides students with a set of example relationships which are set up as 'many to many'. Their task is to try to resolve the relationships correctly and in so doing, gain a better understanding of this skill. Kindly contributed by Julia Stevens |
|
Entity IdentityThis activity provides a very gentle introduction to entities and ERD. Kindly contributed by Julia Stevens |
|
100 wordsStudents have exactly 100 words to summarise the key points about this topic (subscription only) |
task |
In the style of ...A fantastic kinaesthetic activity which is bound to produce some amusing results whilst at the same time reinforcing the main concepts of this topic. (subscription only) |
task |
Key termsStudents are asked to provide a definition and example for key terms related to this topic (subscription only) |
task |
PlaydoughA wonderfully fun kinaesthetic activity which will help students to think creatively. Warning: this can be fairly messy (subscription only) |
task |
PodcastStudents are given instructions about creating a revision podcast based on this topic (subscription only) |
task |
Presentation taskStudents can take forever to set up a presentation often wasting valuable lesson time choosing their background colours and font styles. This resource provides students with a template for this topic with the aim on them spending time on the content rather than the 'pretty stuff'. (subscription only) |
|
Word cloudStudents write a set of notes about this topic and then use them as the basis to create a word cloud. Their work can be used to create a classroom display. (subscription only) |
task |