Here you go, 5 easy to follow video solutions for the Rockhill task set for the January 2020 exam paper. Every task is solved and you will get your head around every table, query, report and form required. I have even included the 2 accdb files of the solutions for you to play with.

Some basic graphics work to get kids to make fabulous artwork to adorn your classroom walls with. All using the free browser based graphics editor called Pixlr so everyone can access this lesson. Jolly good fun that will keep the kids busy for a couple of hours at least. First video is aimed at kids from a school in China, where I am teaching, and they would not have known the British people in the picture, doesn’t make any difference to the skills being taught though.

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.

Complete solution videos, 2 completed databases for you to play with. Videos are easy to follow and you will have your students understanding how to solve all of this within a couple of lessons.

I can't draw, dropped art in year 9 when I was at school, but drawing cartoon animals with serif drawplus is a doodle. This video will show you how you can turn your KS3 kids into fine computer based artists

Fabulous deal or no deal game to test GCSE ICT students on theory. Taken from the old www.ictgcse.com website and made in conjunction with our friends at content generator.

Lovely interactive crossword on hardware 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.

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

Of all my scratch tutorials this is my favourite. Lots of skills and commands used in scratch and the kids end up with a game that they will genuinely play. Loads of extension possibilities are easily identifiable too.

Fabulous penalty shootout game to test GCSE ICT students on theory. Taken from the old www.ictgcse.com website and made in conjunction with our friends at content generator.

Simple revision aid to help GCSE and possibly AS level students to discuss to the pros and cons of email

Fabulous hangman game to test GCSE ICT students on theory. Taken from the old www.ictgcse.com website.

Lovely interactive crossword on Internet 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.

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.

Just Basic is probably the easiest "in" to programming that I have come across. The videos below are about 3 hours worth of screencasts to get you going with the software and will keep your students busy for many lessons. There are lots and lots of different little exercises and challenges to do, it's not just one great big build. Before you wade into the actual screencasts you will need to ensure you download the zip file that has 4 .bas files in it, these will be needed for the little challenges that I set throughout the videos.

These videos bring you a whole bunch of tutorials to get your kids going making their own games in the new version of Scratch 2.0. This are not the sort of standard tutorials that you find on the web. During the videos kids will be set tasks to do in scratch and hopefully they will be able to complete them on their own. However don't worry the next video in each project will show them how to complete the task!! Each of the 9 zip files attached here contain numerous video tutorials within them. These videos are really targeted at KS2 and KS3 students although the content will go on to stretch and challenge even the most able of them with variables, cloning, broadcasting and many other features of Scratch. You can just sit back and relax without having to plan anything. Oh and there is enough material to keep your students busy for around many hours, even if they don't manage to have a go at the extension tasks that are identified for all 5 games!! If you want to try the videos before buying this resource then there are already app versions of it. It free on Android and just 79p on Apple. The App versions have hit the top ten in educational downloads in over 50 countries and have made number 1 in 14 already with those numbers going up monthly. I am 100% confident you won't be disappointed. Apple - https://itunes.apple.com/gb/app/scratch-kids/id955314895?mt=8 Android - https://play.google.com/store/apps/details?id=training.computing.scratchkids Please understand that purchasing these videos give you the right to use them on an internal VLE or shared drive in school, they can not be placed in the public domain so they can be accessed outside of school (unless on a secure VLE).

A fabulous set of tutorials to get you going using Python. These are not ordinary 'watch and repeat' tutorials that you traditionally find on the internet. Each video will set a task for the learner to complete and if the learner needs a little support to complete the task then there is always a solution video on hand too. No prior knowledge of python required. There are 6 distinct python tasks to make. A simple calculator program, a hi lo game, a magic 8 ball, a random name picker, the fizz buzz game and a Pythagoras calculator. These would keep new programmers busy in class for a fair few hours and this app is an ideal tool to help cover the requirements of the new computing curriculum. Users will need to download Python and we will be using the IDLE IDE to get going. If you want to check out the content of these videos for free before downloading then they are available as a free app on iOS and Android. https://play.google.com/store/apps/details?id=training.computing.learnpython https://itunes.apple.com/gb/app/python-for-beginners/id1082132961?mt=8 If you do purchase the videos then you are granted a licence to place them on a shared area within your school or on a VLE that requires a user ID and password to access (no guest access). Basically as long as the general public can't get to them then that fine...

OK this is a series of 28 videos that show kids how to build breakout, however they don't simply watch and repeat. There are many short little videos that break down the build into little tasks, your students simply watch a task video and try to solve that little chunk themselves. Don't worry if they get stuck then there is also a solution video. This method of teaching actually gets the kids to think rather than simply copying the standard type of tutorial videos that you find on YouTube. If you want to check out all of the videos before purchasing then you can do so with the free android app below, or for a few pennies the Apple version too. I guarantee that your students will be extended beyond what most currently do with scratch and it really is not that tough. Downloading this resource gives you licence to drop it on your VLE or shared resource drive for kids to access from in school or at home, it does not allow you to place it on a website in the public domain. Apple - https://itunes.apple.com/gb/app/scratch-2-games/id661122186?mt=8 Android - https://play.google.com/store/apps/details?id=training.computing.scratchlite

A set of 31 videos that cover the entire theoretical content of the R001 Cambridge Nationals in ICT course. They can be used as snippets in lessons, flipped classrooms or just dropped on a VLE for revision purposes. You can check out a couple of sample videos below https://www.tes.com/teaching-resource/cambridge-nationals-r001-screencasts-a-sample-11478359 Please don't put these videos into the public domain, on a VLE or shared area at school is fine though.

First of all £20 - that’s a bargain, you will save so much time and the websites you get will be so much better than you have had in the past, honestly I should be charging £200 I never understand why you would want to build a website from the ground up with CSS and HTML - it’s daft, no-one in the real world does this, they use the likes of WordPress, SquareSpace, Wix or Shopify. Now if you go down the WordPress route, you can get free hosting, your students have access to build their sites 24/7 from anywhere they can access the net, and they will build something that actually looks professional. WordPress is not template driven like Wix. I have had many students go through this unit at Distinction level using Wordpress and these videos show you how to do it all. Themes, pages, media, plugins, CSS, Javascript and even some SEO to tie in with unit 3. I promise you your students will build cracking websites really quickly and you won’t go back to HTML or the likes of Dreamweaver or WYSWIG editors, it’s not 2005 you know, the world has moved on. Oh one thing if you watch the preview video on YouTube please understand the real videos are much better quality and easier to see what’s going on.