Suitable spreadsheet techniques and build for the WJEC AS course, but could equally be used by anyone wanting to learn how to create a spreadsheet with a few macros,Multiple IF, VLOOKUP, 3D referencing etc...

It's a series of camtasia tutorials (vid files) and video footage taken with a camcorder (film files) that explain how to construct a database suitable for a video store. Tables, forms, reports and queries are all covered and some 'advanced' features like combo boxes and report calculations. Please check the document 'order of videos' to get everything in the right way!!

Podcast covering health and safety issues that are traditionally covered on GCSE or AS level ICT papers

A series of video tutorials to show students how to build a website from scratch using Dreamweaver. PLEASE NOTE 8 MORE VIDEOS IN THIS SERIES IN 'Web design using Dreamweaver part 1' WHICH YOU SHOULD WATCH BEFORE THESE

A series of chalkboard style videos that cover numerous aspects of the WJEC AS syllabus in line with the first few chapters in the Doyle textbook. I have since created superior resources for this course available on www.teach-ict.com

I don't claim to be a programmer, but these videos do let kids get a handle on some simple programming techniques to bring databases to life a little. Will turn into a series of tutorials once I get the kids at my school to explain to me how the hell it all works. Ideal for those students doing the WJEC course to chase down the few marks available, vid2 is the key one for that as it shows how to VB a login routine!!

Simple, yet stylish, flash animation to show the baseic concept of data logging.

Cracking little sets of videos that shows how to construct comics in comic life but also working with drawplus to rip characters from one cartoon and embedding them in the other. All neatly wrapped up in a cyber bullying theme for a token nod to e-safety. This task kills a flock of birds with one stone and your kids will love it. This exercise sees Homer Simpson being bullied by Bender from Futurama...

A selection of short videos that are relevant to the WJEC AS level specification

Simple tutorial but highly effective and engaging for students of all ages. Using just 2 layers in Flash and a few tools you can create a piece of art work in the style of Julian Opie. You will be surprised at just how good your students will get with this one, we have some amazing work on the walls at school that Mr Opie himself would have been proud of....

Sorry about the lack of controls on the videos but I can't find the original recordings to rerender. Anyway nice set of tutorials to show kids how to make a two player racing game in scratch. Have to admit there are a few mistakes later on, but kids will be able to work out how to amend!!

Lovely interactive crossword on network theory taken form the now defunct www.ictgcse.com site. You might want to press F11 on your keyboard to make it more visible in your browser.

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