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

Selection of videos my students found one lesson that relate to the WJEC AS level specification. Hope you find them useful to drop into your VLEs.

OK FIRST OF ALL THESE ARE NOT MP3 FILES THEY ARE MP4 FILES, YOU MUST RENAME THEM ONCE DOWNLOADED TO MAKE THEM WORK. Lots of videos to get you going with serif webplus and certainly enough to deal with the likes of the Cambridge Nationals R005 unit. However, the software and the videos are easy enough for KS3 students to follow to make some rather fancy websites

Thought I would create a series of mind maps to help my own students revise for this course. I have tried to embed key terms that seem to appear on the mark schemes from the board. Hopefully they may help a few of your students too!! I am going to add lots of these over the next couple of weeks, we find they work very well in moodle within a lightbox gallery

These videos show you how you can genuinely use a Nintendo Wii combined with a copy of Mario and Sonic at the Olympic Games in the classroom to inject a bit of fun into a relational database build.

Useful for unit 20 of the OCR Nationals course. A set of short videos about how to create a simple banner advert in Flash. If you don't like cartoon violence then a penguin being hit by a car may not be for you. Once again sorry about the lack of controls but I have lost the original screencasts.

The following videos explain how you can integrate monkeyjam, audacity and a graphics program of your choice (I use fireworks) to create something a little more advanced than the standard 'lego youtube' efforts that we have all seen.

https://itunes.apple.com/gb/app/appinventor2-free/id958514716?mt=8 Want to give your students loads of activities to do with MIT's appinventor 2? Then here's the solution for you. Now first of all whilst these are screencasts, they are not the standard sort of activity that you would find on the likes of YouTube. What happens is that there is a screencast that gives the students a task to work out and if they are unable to solve the problem then there is a solution video to accompany the task set. This way your students have to think about how to solve the problem, rather than simply following a 'how to' style tutorial. So what's in the set of tutorials? Well there are 5 app builds, the first 2 are simple little ones to get your students familiar with the interface and show them how to make a 'soundboard' and a variation of the magic 8 ball. The other 3 app builds have far more detail.

This is a 2 video sample of the 31 video paid for version that you can find. I didn't pick the best 2 and the rest are worse, that would involve wading through them all and I haven't got time for that. It's just a random sample. Please don't put these videos into the public domain, on a VLE or shared area at school is fine though. https://www.tes.com/teaching-resource/cambridge-nationals-r001-complete-video-tutorial-set-for-all-theory-11363773

A few videos to get you going with drawplus, nothing fancy but enough techniques to keep most KS3 kids busy for a few hours.

Lots of Flash tutorials to show how to make a fabulous animated banner that links to a website. Motion tweening, shape tweening, movie clips and actionscript all included. Suitable for the OCR unit 20, if perhaps a little more advanced than strictly necessary.

6 videos and 3 worksheets that I use with my year 8 students to introduce them to some basic spreadsheet techniques. Hope the file names above make sense for you to work out how to run with it. Not a rip form Teach-ICT, it was my idea that I let them use!!!

Set of tutorials that guide students through how to create a set of top trumps based on teachers at their school. Tables, forms, reports and queries all covered and you actually have a database exercise that kids will enjoy. Make sure the kids simply save each of the avatars as they go along.

Dataset and question paper very suitable for level 3 BTEC Unit 2 ICT controlled assessement. Not complex one at all and gentle introduction to the sorts of questions that you will see in the real exam.

Series of videos to show students how to make a game in scratch. Learn how to make parrots move randomly, create a crosshair target to follow your mouse, show and hide objects, keep scores and play against a timer. No idea what happened with cut outs in video 4 and 5 but I no longer have the originals to amend, however you can also use this tutorial on the teach-ict site by following the alternative link at the bottom

Yes it's a fab set of videos to show kids how to make the very first video game Pong. Once they are happy with it I would personally set them the task to make the game 'breakout'.

I had a request from a student doing a GCSE database project that involved wanted to make a form that listed only the models of a specific make of car on the form. So I made this video and throught someone else might find it useful.

A series of video tutorials to show students how to build a website from scratch using Dreamweaver. Very suitable for OCR National students who want to access distinction grades. Certainly useful for AS level students too and there is no reason why the more able KS3 student could not use this material too. Also covers some basic work with Fireworks and Flash too. PLEASE NOTE 2 MORE VIDEOS IN THIS SERIES IN PART 2

Series of multiple choice questions used in the ECDL exam. Files are to be used in conjunction with Promethenan activote systems

We have had a few posts on the ICT forum in the past about how to mail merge a picture. Seem to get lots of long winded answers so I thoguht I would create this video to show you how it is done. I have used this video with my own AS level students who are doing the WJEC course.