Functional 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.
Basic word processing skills - takes you through the basics
Using Tables - a guide to the bit that's most likely to cause problems
Letter 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 letter
or this letter writing guide which has lots of different options.
Work experience letter task - a practice task writing a letter
Memo Guide - how to create a memo using a template
Obidos Travel memo task - a practice exercise using a memo
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.
Basic presentation skills - takes you through the basics.
Sunnycoombe holiday park presentation task - producing a basic presentation
This task requires:
Info for presentation.txt - this is the text you can use for the presentation
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!)
Basic spreadsheet skills - takes you through the basics
More complex spreadsheet skills - shows you how to show formulae and all the more difficult things
IF statements - the really quite complex bit that's needed for Level 2
Roar Haircutters
Roar Haircutters spreadsheet task - a full spreadsheet task to work through
Help sheet for more complex areas of the Roar task
Completed Roar haircutters spreadsheet - to let you check you're doing it about right
Graph Drawing
These 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 Fit for Purpose. Think style!
Poster 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 Us using e-mail or ask any of your tutors for help.