Hero image

93Uploads

398k+Views

236k+Downloads

stuff for ICT and Computing
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!!!
Scratch top down racer version 2
djphillips1408djphillips1408

Scratch top down racer version 2

(3)
If you have ever used my previous top down racer videos then I would suggest you move on to these ones as they are superior. Loads of skills to create a 2 player racing game like micro machines, lap counters, oil slicks, speed ups, and showing how to stop any cheats. Will keep kids busy for about 2-3 hours in general.
Serif WebPlus exam
djphillips1408djphillips1408

Serif WebPlus exam

(3)
We use this exam with our year 7's as their end of year exam. The mark scheme is a simple tick sheet exercise that enables you to grade the work created very quickly. Sorry about all the separate photos but you can't use a zip file here.
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
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
Triggered animations in Open Office Impress
djphillips1408djphillips1408

Triggered animations in Open Office Impress

(2)
Series of tutorials using Impress (sorry for wrongly labelling this as Powerpoint previously) to create a quiz that uses triggered animations and sounds recorded by students. Ideal exercise for combining ICT with Languages. I must apologise to any French teachers in advance for me poor attempts at speaking the language!!
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!!
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!!
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
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.....
Languages quiz using Open Office Impress
djphillips1408djphillips1408

Languages quiz using Open Office Impress

(1)
In these videos we show you how to make a quiz using triggered animations and Open Office Impress rather than Powerpoint. In this example, we create a quiz for a French class and this sort of work is a good cross curricular exercise between ICT and languages.
macro and offset to keep a running total of sales
djphillips1408djphillips1408

macro and offset to keep a running total of sales

(1)
Further to a request on the forum, here's a quick video of how to create a running total of sales on a spreadsheet without having to keep a record of all the actual sales data too. It's very useful for those of you doing the WJEC AS spreadsheet section!!!
Banner advert in Flash
djphillips1408djphillips1408

Banner advert in Flash

(1)
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.
Mail merging a picture using Publisher and Access
djphillips1408djphillips1408

Mail merging a picture using Publisher and Access

(1)
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.
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...
Mario and Sonic relational database
djphillips1408djphillips1408

Mario and Sonic relational database

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