That Blue Square Thing

Circuit board imageFunctional ICT - Help Sheets and Exercises

To pass Functional Skills IT you'll need to be able to word process, produce posters, design effective presentations and use spreadsheets with confidence, including to produce graphs.

Some of those core skills might need a spot of practice or you might have forgotten how to do something important. Here, hopefully, is where this section comes in!

As well as the guides and exercises in this section there's also the Heart Tough Exercises, which will take you through an entire exam paper at both Level 1 and Level 2. You'll probably also find a whole load of other useful resources on your school system.

Word Processing Skills :

Remember, the key is getting your document Fit for Purpose. Make sure it's laid out clearly, uses clear fonts, avoids Word Art unless it's actually needed and works as a printed document.

pdf iconBasic word processing skills - takes you through the basics

pdf iconUsing Tables - a guide to the bit that's most likely to cause problems

pdf iconLetter layout guide - a basic guide to how to lay a half decent letter out

For help writing letters (and laying out other documents) you might want to take a look at this page on laying out a formal letterwiki link or this letter writing guidewiki link which has lots of different options.

pdf iconWork experience letter task - a practice task writing a letter

pdf iconMemo Guide - how to create a memo using a template

pdf iconObidos Travel memo task - a practice exercise using a memo

And how to produce an e-mail in an exam:

PDF iconE-mail screenshots in exams

Presentation Skills

Remember that presentations need to work on screen. Don't put too many words on each slide and make sure the font is big enough. The key is getting it Fit for Purpose.

pdf iconBasic presentation skills - takes you through the basics.

pdf iconSunnycoombe holiday park presentation task - producing a basic presentation

This task requires:

Txt iconInfo for presentation.txt - this is the text you can use for the presentation

Image iconSunnycoombe map.jpg

Image iconSunnycoombe logo.jpg

Spreadsheet Skills

It really is all about the formulae. Use them properly, use SUM and remember to use the funky star wars button to show formulae (don't know what the funky star wars button is? Read the More complex spreadsheet skills sheet then!)

pdf iconBasic spreadsheet skills - takes you through the basics

pdf iconMore complex spreadsheet skills - shows you how to show formulae and all the more difficult things

pdf iconIF statements - the really quite complex bit that's needed for Level 2

Roar Haircutters

pdf iconRoar Haircutters spreadsheet task - a full spreadsheet task to work through

pdf iconHelp sheet for more complex areas of the Roar task

excel iconCompleted Roar haircutters spreadsheet - to let you check you're doing it about right

Graph Drawing

Note that these files deal with graph drawing in Office 2003. At some point I might get around to updating them to Office 2007 versions.

pdf iconBar chart task

pdf iconPie chart task

pdf iconComparative bar chart task

pdf iconDivided bar chart task

excel iconThese tasks all require the Fish Graphs.xls spreadsheet file

Desk Top Publishing Skills

DTP skills are all about cool layout. Don't forget that munchkin looking Word Art doesn't make a document cool and funky and really isn't Fit for Purpose. Think style!

pdf iconPoster design ideas - posters and other DTP tasks are where word art actually comes in useful

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