Workbook - CLAiT 2006 - Level 1 (Item Codes WB2 & EWB2)

Unit 2: Creating Spreadsheets and Graphs

(Using Excel 2003)

Key features

  • Supplied on CD-ROM for unlimited self-printing
  • Available in PDF format (£19.95) and editable Word format (£39.90)
  • All data files supplied

List of Contents

Section
Covers
Download sample
1
Introduction
 
2
What is a spreadsheet?
 
3
Creating and saving a spreadsheet
 
4
Printing a spreadsheet
5
Recalling and editing a spreadsheet
 
6
Inserting and deleting rows and columns
 
7
Aligning & emphasising text and numbers
 
8
Formatting numbers
9
Applying borders and shading
 
10
Printing row and column headings
 
11
Inserting headers and footers
 
12
Using (and printing) formulae
 
13
Using functions
 
14
Creating pie charts
 
15
Creating column charts
 
16
Creating line charts
 
17
Making changes to charts
 

 

This workbook has been carefully designed to cover all the skills required for the OCR New Clait Level 1 (Clait 2006) qualification (Unit 2).

It is designed for learners to work through at their own pace, and at the end of every section there are practice tasks to re-inforce learning. (Also available separately, product code PT2)

Although not designed as such, the workbook can also be used as the basis for lesson plans for tutor-led training.

The workbook is supplied on CD-ROM in PDF format for easy, unlimited printing, or in Word format (XP/2000/2003/2007 compatible) for centres who wish to customise it to suit.

You are allowed to print and photocopy the workbook as much as you like for use at the same OCR training centre, and you can place the workbook on an Intranet if required.

-->