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 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.

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.

.