That Blue Square Thing

Functional ICT

The Wonderful Ruby and Fantastic Jasmine have been preparing small revision skills guides for Excel for themselves. They said I could share them here with other people. I'll include Ruby's and Jasmine's each time - you might prefer the way one of them explains things to the other one...

PDF iconJasmine's guide to formatting cells

PDF iconJasmine's guide to borders and percentages

PDF iconJasmine's guide to Formulas and Functions

PDF iconRuby's guide to formatting cells

PDF iconRuby's guide to using formulas

PDF iconRuby's guide to using functions

PDF iconRuby's guide to using IF statements

Neither of them got around to showing how to Show Formulas in Excel, so I wrote a guide to that...

PDF iconMy guide to showing formulas in Excel

And one on how to deal with e-mail in an exam:

PDF iconMy guide to producing an e-mail screenshot in an exam

Functional ICT is all about using ICT skills in a flexible way to produce documents which are "Fit for Purpose". It's what people outside of school expect you to be able to do with ICT.

The course is assessed through a single exam. You sue a computer to produce a series of pieces of work which are printed. Only printed work is marked in this course.

In the exam you might have to:

You need to make sure that you can do all these things without any problems, especially using formulae in spreadsheets.

Key Reminders:

The exam is available at 2 levels:

If you're an engineer or working on any other diploma, then you need to pass ICT Functional Skills at the same level as your diploma (or at Level 2 if you're working at Level 3 engineering).

For both levels it is crucial that you make sure that you type your name, candidate number and centre number (you'll be told the numbers; we hope you know the name by now...) at the bottom of each sheet you hand in. You can't hand write it - and if it's not there the marker will ignore the work!

How to do IT :

The Help Sheets and Exercises page has a number of basic help sheets designed to guide you through most of the basic things you should need to be able to do. You should find you can already do most of these.

There are also a number of basic exercises for you to practice with. Some of these come from past exam papers.

Then there's the Heart Touch Exercises. These are an entire exam paper - at both Level 1 and Level 2

Then the School Trip Activities take you through a set of three entirely typical functional activities. Well worth a look.

If you have a major problem in the run up to your exam, don't forget that you can Contact Us using e-mail or ask any of your tutors for help.