teach-ict.com logo

THE education site for computer science and ICT

Attributes and entities

Starters and plenaries

Acting up

A 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)

download file

instructions

download file

character cards

30 seconds

Students 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)

download file

Compare and contrast

A  starter activity
Students are given the names of two items and asked to consider the differences and similarities between them

(subscription only)

download file

Teach me about ..

Lesson starter
Students become the teacher! One student is tasked with preparing a five minute revision starter about this topic for the beginning of the following lesson.

(subscription only)

download file

Draw me a picture

Starter or plenary

Students are given a selection of key terms and are asked to illustrate one of them in a diagram.

(subscription only)

download file

Give me ten

A starter or plenary task
Students work in pairs to come up with ten words related to this project before joining up with another pair to expand their list.

(subscription only)

download file

Just a minute

Starter 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)

download file

Lucky dip questions

Starter 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)

download file

One, two, three

Can 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)

download file

 

Pass the buck

An excellent starter or plenary for involving all students and getting them to identify a large number of facts about the current topic

(subscription only)

download file

Teacher talkabout

Starter or plenary task

The class 'test' the teacher on their knowledge of key words related to this topic

(subscription only)

download file

4-4-2

A plenary activity where students are asked to summarise the lesson and pick out the main key words related to the topic.

(subscription only)

download file

Call My Bluff

A plenary activity based on the popular game show, ‘Call My Bluff’

(subscription only)

download file

Mastermind

A plenary activity which is loosely based on the game show 'Mastermind'

(subscription only)

download file

One Word

A 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)

download file

Word building game

Plenary task

Students work in groups to construct a sentence about today’s lesson

(subscription only)

download file

Corkboard

A great plenary idea both for AFL and for getting feedback from every student

(subscription only)

download file

 

I predict

This task acts as the plenary from one lesson and the starter for the next lesson

(subscription only)

download file

 

Pyramid

A plenary activity.

Students are asked to complete a self assessment sheet to indicate what they have learned during this lesson

(subscription only)

download file

 

Text me

A plenary activity where students are asked to write a text message to explain what they have learned during the lesson

(subscription only)

download file

 

Tweet it

A plenary activity
Students write a ‘Tweet’ message to sum up what they have learned during the lesson

(subscription only)

download file

 

 

Lesson and homework tasks

Theory notes task

Students read the theory notes on the mini website and then answer the questions on the task sheet.

(subscription only)

download file

task

Attributes and entities task

Students 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)

download file

task

download file

answers

 

Entity relationships practical workbook

Goes through one-to-one, one-to-many and many-to-many relationships giving students opportunities to practice creating appropriate ERDs.

(subscription only)

download file

workbook

download file

answers

Resolving relationships

This 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

click here

 

Entity Identity

This activity provides a very gentle introduction to entities and ERD.

Kindly contributed by Julia Stevens

click here

 

100 words

Students have exactly 100 words to summarise the key points about this topic

(subscription only)

download file

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)

download file

task

Key terms

Students are asked to provide a definition and example for key terms related to this topic

(subscription only)

download file

task

Playdough

A wonderfully fun kinaesthetic activity which will help students to think creatively.

Warning: this can be fairly messy

(subscription only)

download file

task

Podcast

Students are given instructions about creating a revision podcast based on this topic

(subscription only)

download file

task

Presentation task

Students 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)

download file

Word cloud

Students 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)

download file

task