You will need to download the resources from the exercise http://www.tes.co.uk/teaching-resource/Mafia-Zoo-spreadsheet-exercises-and-videos-6070807/ first if you want this to make complete sense. However if you just want to teach kids to mail merge from web based generated data then it could work as a standlalone lesson. Anyway one set of instructions and some videos to show how to generate data and mail merge it. Great exercise for KS3 kids and a very useful skill

Nice little lesson to show you how to use a photo merge to make some id cards and it fits in nicely with my other exercises on here with Mafia Zoo in the title. Anyway you will need Serif PagePlus, some photos and a spreadsheet data source.....

Set of 4 videos to cover creating and reusing movie clips, tweening, easing, opacity and the use of actions on buttons. Ideal for unit 20 of the Nationals but let's be honest most of your year 7s could handle this. Not a criticism of Nationals as I like the course, but it's just fun, a decent standard and kids will want to do it of any age.....

This is a really cool task to get kids moving with graphics software. I use fireworks but I guess it's easy enough to adapt for say photoshop. Anyway take two animals, rip the head off one, add it to the other and use rubber stamps, opacity, magic wand, hue/saturation to make it look like a 'cloned&' or &';morphed' animal. you might be surprised by what kids can create!!

Very useful for Cam Nats R002 as kids can count it as 'item of publicity' in task 2 of this unit. After all everyone loves a PowerPoint but this one shows you how to do it properly!!

Further to a request on the ICT forum about how to make a custom toolbar in Word 2010, the video below shows you how to do it. It is part of a series of videos available via teach-ict.com shop to cover the entire WJEC AS coursework project

A series of mind maps suitable for the A level course by WJEC and based around the Doyle text. These could of course be used by students doing other specs where there is some overlap. Lots more to follow

3 videos and some images that will enable your students to take their first steps with Serif Pageplus and realsie that creating something like the front cover of a national newspaper is not beyond them

after a thread appeared on the forums I knocked this up to explain a very simple relational database for keeping recipes and ingredients. It's not a full dbase build but it illustrates the use of joining tables and sub forms pretty well. Certainly a very good first lesson to introduce the principle a seperate tables and looking things up

In this video you can show students how to make a set of business cards that mail merge in both images and text. Using spreadsheets and publisher they end up with a set of individual business cards for a group of individuals at their organisation. This is a logical progression step if you have used the Mafia Zoo (gangsta zoo on teach-ict) scenario.

Series of tutorials using Impress (sorry for wrongly labelling this as Powerpoint previously) to create a quiz that uses triggered animations and sounds recorded by students. Ideal exercise for combining ICT with Languages. I must apologise to any French teachers in advance for me poor attempts at speaking the language!!

Podcast covering ergonomic issues that are traditionally covered on GCSE or AS level ICT papers

In these videos we show you how to make a quiz using triggered animations and Open Office Impress rather than Powerpoint. In this example, we create a quiz for a French class and this sort of work is a good cross curricular exercise between ICT and languages.

We use this exam with our year 7's as their end of year exam. The mark scheme is a simple tick sheet exercise that enables you to grade the work created very quickly. Sorry about all the separate photos but you can't use a zip file here.

A series of video tutorials that go throught the various techniques that need to be covered to gain a distinction grade on the OCR Nationals unit 2 web design course. The videos can be used with KS3 students as well. If you want to test the kids on these tutorials then there is a link at the end to another set of resources in here that is what I use as an end of year 7 exam, it really is very good and the kids really enjoy doing it.

First of all the javascript menu files is a zip and not a doc, you wil need to download it, rename and the extract. The videos have no controls as they are swf files. Does not sound like a good start does it!! Trust me you will have kids making very fancy drop down menus with this and it's a nailed on distinction for unit 21 of Nationals if you follow that course.

A short series of videos to show kids how to get to grips with the basics of dance ejay 5. Quality of vid2 is a little sub par due to recording issues but is easily still fine to use. Only funky fresh partaaay people need download and av'it large!!

Podcast covering teleworking issues fro teh employee's perspective that are traditionally covered on GCSE or AS level ICT papers

Further to a request on the forum, here's a quick video of how to create a running total of sales on a spreadsheet without having to keep a record of all the actual sales data too. It's very useful for those of you doing the WJEC AS spreadsheet section!!!

Yes that is an odd title. Anyway I use this as an end of year 8 exam to test simple spreadsheet techniques, mail merging and a bit of graphics. Guess you would have to customise the instructions as they are geared to my school but it won't take much editing. Still kids enjoyed it last year and it was an exam!!