Hero image

93Uploads

397k+Views

235k+Downloads

stuff for ICT and Computing
WJEC A2 videos from youtube
djphillips1408djphillips1408

WJEC A2 videos from youtube

(2)
I had a bad throat so decided to ask my students to do a trawl of youtube to find various videos that mirrored the contents of the specification. We have dropped them into file format so you can easily embed them in your VLEs. Hope they are of use
FREE android app to teach scratch
djphillips1408djphillips1408

FREE android app to teach scratch

(1)
"Scratch Kids" brings you a whole bunch of video tutorials to get you going making your 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 you will be set tasks to do in scratch and hopefully you will be able to complete them on your own. However don't worry the next video in each project will show you how to complete the task!! These videos are really targeted at primary 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. This is a big app of just under 300Mb, because there is so much material in it. You will need to be hooked into your WiFi connection!! https://play.google.com/store/apps/details?id=com.kid.scratch
Mail merge and spreadsheet test
djphillips1408djphillips1408

Mail merge and spreadsheet test

(3)
I use these files as an end of year test for our year 8s. Combines some basic graphic work, with a few formula in a spreadsheet to create a graph that is then used in a mail merge task. It's a bit 'leftfield' in content and would need a few changes to the word docs to make it specific to your school, however it is a lot of fun, assesses useful skills and the kids enjoy doing it.
OCR Nationals French trip scenario resources
djphillips1408djphillips1408

OCR Nationals French trip scenario resources

(3)
A bunch of films, screencasts and weblinks that you could use to help support the delivery of the French trip model assignment. Some of it is geared to my school, for example we use open source email rather than outlook, but the principles of all the resources can be used by anyone. Please find the second part of this resource in the resource bank to finish off the database videos
Fish and shark game using scratch
djphillips1408djphillips1408

Fish and shark game using scratch

(19)
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.
Mail on Sunday DTP exercise
djphillips1408djphillips1408

Mail on Sunday DTP exercise

(4)
A series of videos that show students how to create a DTP version of the Mail on Sunday. Your best students should be able to create something that would be hard to tell from the real thing!! The 2 graphics are an example front cover and the masthead of the paper. Sorry about the lack of controls on the films, but can't re-render.
AS spreadsheet examplar for WJEC IT1
djphillips1408djphillips1408

AS spreadsheet examplar for WJEC IT1

(9)
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...
Video store database
djphillips1408djphillips1408

Video store database

(4)
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!!
Web design using Dreamweaver part 2
djphillips1408djphillips1408

Web design using Dreamweaver part 2

(6)
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
simple visual basic routines for Access databases
djphillips1408djphillips1408

simple visual basic routines for Access databases

(3)
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!!
Comics using comic life and drawplus
djphillips1408djphillips1408

Comics using comic life and drawplus

(4)
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...
Art in the style of Julian Opie with Flash
djphillips1408djphillips1408

Art in the style of Julian Opie with Flash

(1)
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....
Car racing game made in Scratch
djphillips1408djphillips1408

Car racing game made in Scratch

(1)
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!!