training

Training

There will be many things that you need to do for this project that you already know how to do but others that you don't. This section of the website provides you with Training Materials that allow you to find out how to do something at your own pace.

The Training Materials are organised according to the Assessment Objectives that require the skills, or under the General Heading for skills that apply to more than one.

You can use the list below to take you right to the section you're working on right now, or just scroll on down and browse around

General Skills

There's a few things that you're going to need to think about every time you start a new piece of work, check out the stuff below for a reminder of what these things are!

MaterialInformation
Taking & Editing ScreenshotsSome of the work you produce will need screenshots to show how you did things.

top

AO1 - Standard Ways of Working

You need to show that you can organise your work. The information below will help you to do this

MaterialInformation
Creating & organising files & foldersA quick refresher on the basics!
Spreadsheet PasswordHow to protect your excel data from prying eyes
Shortcuts - the lowdownWhat are they? How do you make them? Why would you want to?

top

AO2 - Using the Internet

MaterialInformation
Google Search BasicsGoogle provides help on how to optimise your internet search.

top

AO3 - Presenting Your Skills

You probably reckon that you've pretty much done Powerpoint to death now, afterall, you've been using it since Primary School!

Well that's great, and you've probably already picked up most of the skills for producing Powerpoint Presentations that you'll need. Remember that for AO3 you must create a professional presentation? Well what does this mean exactly? That's where you need some training, there's always something left to learn!

We've created a set of training materials for AO3. Check 'em out!

MaterialInformation
Getting Started in PowerpointSure, we've all done Powerpoint, but we've also done loads of stuff since then! Time for a quick refresher!

top

AO4 - Business Documents

You will have already produced a number of different business documents, using a variety of software. You're going to put those skills to use now, but just in case you're not sure where you start, have a look at the materials below.

MaterialInformation
The Anatomy of a LetterHere's how to lay out a letter properly.
Flyer ExamplesTake a look at this page for some examples of Flyers.

top

AO5 - Spreadsheets

Spreadsheets are pretty simple once you get to grips with the basics - it's just a Giant Calculator really!

MaterialInformation
Getting Data InSpreadsheets don't work without some numbers, here's how to get started.
Basic FormulaeNow We've got some numbers, we can add them up and stuff, neat!
Functions? Oh, cool!Functions are a bit like Formulae, but they do a bit more, let's take a look at them here.
Calculating VATThe only certain things in life are Death and Taxes, here's how to sort one of them...

top

AO6 - Databases

You'll have done some database work before, but it's the sort of thing that you probably only use in ICT. Below you'll find a short refresher course in Microsoft Access.

MaterialInformation
Database Refresher CourseYou should complete this short course before you complete the work for Mungo.

top