ICTGoodies

A fun starter activity that gets students out of their seats. Each student is given a piece of paper with either a word or a definition on it. Students must move around the room to find the person with the asociated word or definiton.

This is a complete scheme about modelling designed for year 8 students. This includes an assessment sheet matched against the national curriculum level descriptors.

After giving students an introduction to spreadsheets and creating charts, you could get them to present this data in the form of a magazine and write an accompanying article that analyses the chart. This is a template / example magazine layout. Let your students change this one or just use it as an example.

A simple random name selector that can be used as part of AfL when questioning the class to ensure the same students don't always answer the questions. Macros will need to be enabled. If a duplicate name pops up, just hit next again.

A fun slide to have on the board while holding a thumb-o-metre session

What is Thum-o-metre?

Using a thumb-o-metre is a great AfL technique. The teacher asks students how they feel about a topic e.g. how confident do you feel using the SUM function in excel. Student indicate with thumbs up, down or level. This gives the teacher a really quick overview of how well the whole class understand the topic.

This is a revision board game designed to help students revise for the GCSE ICT Paper 1 exam. It covers topics including input and output devices, hardware and software, networks, implications of ICT on banking and retail and more.

When I used this game, I got students to make little player pieces or counters out of cardboard. They also used the digital dice at http://www.ictgoodies.com/miscellaneous/digital-dice

I printed the board game and then had it blown up / enlarged to A3 to make it easier to read and play.

Here is the makings of a fun spreadsheet model to learn about conditional formatting and formulas. It needs tailoring to your own requirements but the majority of the work is done.

*Updated* - A guide sheet is now included. This isn't really explicit; instead students should try to figure things out for themselves using the 'Help' feature and Google. Students could try to produce their own stadium working in small groups.

.