Hero image

93Uploads

398k+Views

236k+Downloads

stuff for ICT and Computing
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!!!
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.
Serif Webplus videos suitable for all levels
djphillips1408djphillips1408

Serif Webplus videos suitable for all levels

(1)
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
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.
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!!
Making a drop down javascript menu
djphillips1408djphillips1408

Making a drop down javascript menu

(0)
First of all the javascript menu files is a zip and not a doc, you wil need to download it, rename and the extract. The videos have no controls as they are swf files. Does not sound like a good start does it!! Trust me you will have kids making very fancy drop down menus with this and it's a nailed on distinction for unit 21 of Nationals if you follow that course.
Art in the style of Leslie de Rose using Photopea
djphillips1408djphillips1408

Art in the style of Leslie de Rose using Photopea

(0)
Honestly absolute piece of cake to do this and you get some really fabulous work for your classroom walls. The image attached was created in about 2 minutes. Google Leslie’s artwork and you will see what it looks like and how your students can get so very close to recreating it so easily.
FREE appinventor 2 tutorial app
djphillips1408djphillips1408

FREE appinventor 2 tutorial app

(0)
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.
Cloning animals using Fireworks
djphillips1408djphillips1408

Cloning animals using Fireworks

(0)
This is a really cool task to get kids moving with graphics software. I use fireworks but I guess it's easy enough to adapt for say photoshop. Anyway take two animals, rip the head off one, add it to the other and use rubber stamps, opacity, magic wand, hue/saturation to make it look like a 'cloned&' or &';morphed' animal. you might be surprised by what kids can create!!