Hero image

93Uploads

398k+Views

236k+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
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
Making id cards with photos and merging
djphillips1408djphillips1408

Making id cards with photos and merging

(1)
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.....
Elephant rugby mail merge exam
djphillips1408djphillips1408

Elephant rugby mail merge exam

(0)
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!!
Animation with Drawplus ideal for OCR Nat unit 20
djphillips1408djphillips1408

Animation with Drawplus ideal for OCR Nat unit 20

(4)
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.....
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!!
Getting funky with Dance Ejay 5
djphillips1408djphillips1408

Getting funky with Dance Ejay 5

(2)
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!!
WJEC A2 mind maps for revision
djphillips1408djphillips1408

WJEC A2 mind maps for revision

(3)
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
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.
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...
Mafia zoo revisited with a mail merge
djphillips1408djphillips1408

Mafia zoo revisited with a mail merge

(1)
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
WJEC AS mind maps
djphillips1408djphillips1408

WJEC AS mind maps

(4)
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
Simple relational database
djphillips1408djphillips1408

Simple relational database

(4)
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
AS video lectures
djphillips1408djphillips1408

AS video lectures

(1)
This is a sample chalkboard that I created for use with my AS level students on the WJEC course. You can find more of these on Teach-ICT, but they are not free. They are however my best work to date.
Mafia Zoo spreadsheet exercises and videos
djphillips1408djphillips1408

Mafia Zoo spreadsheet exercises and videos

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