The ticks indicate the suitability of resources for each Key Stage.

#### KS5

Skills covered:

• Entering data
• Widen columns
• Basic formatting
• Autosum
• Insert row
• Delete row
• Show gridlines

Kindly contributed by Jo Wallace from City of Bath College

Skills covered:

• Entering data
• Widen columns
• Format to 2dp
• Autosum
• Insert row

Kindly contributed by Jo Wallace from City of Bath College

This workbook provides a clear step-by-step series of tasks to both show students and enable them to practice many of the common formatting and printing techniques.

##### Disco Task (2012 new version*)

Skills covered:

• enter data
• widen columns
• text formatting
• wrap text
• merge cells
• rename tabs
• delete worksheets
• insert worksheet
• copy worksheet
• multiplication formula
• SUM formula
• format as currency
• insert rows
• absolute cell reference
• insert footer
• borders
• cell alignment
• format date
• find and replace
• Undo
• format painter
• sort data

* this is NOT the same as the 2003 version of the disco task

##### Burgers Task (2012 brand new version*)

Skills covered:

• rename tabs
• delete worksheet
• column widths
• text formatting
• SUM, AVERAGE, MIN, MAX formula
• replicate formula
• cell formatting - colours, borders, underline
• insert rows
• merge and centre
• decimal places
• column chart
• change chart style
• change chart colour
• move, resize chart
• undo, redo

* this is NOT the same as the 2003 version of the burgers task. It is a completely new task.

burgers.xls

Skills covered:

• Setting up a basic spreadsheet
• Basic formulae
• Basic functions
• Basic formatting
• Format painter
• Formatting currency
• Merging cells
• Freezing panes
• Hiding a column
• Creating a copy of the workbook
• Switching between windows
• Saving as a template
• IF formula
• Column chart
• Chart formatting
• Setting printing options
• Find and replace tool
• Sorting data in a table

ringtones.xls

##### Teddy Tots Greetings Cards

Skills covered:

• Basic formulae
• Fitting to one page
• Printing gridlines
• Showing row and column headers
• Displaying formulae

(subscription only)

Skills covered:

• Basic formula and functions
• Inserting rows
• Borders
• Printing options
• Sorting data
• Hiding a column

skiing.xls

Skills covered:

• Basic formula and functions
• Resizing columns
• Footers

##### Groovy Music

Skills covered:

• merge cells
• wrap text
• align titles
• basic formulae
• basic functions
• formatting cells
• borders
• gridlines
• sort data
• auto filter
• footers
• hiding cells
• freeze pane
• print area
• show formulas
• IF formula
• VLOOKUP
• charts
• absolute cell reference

##### Online auctions

This spreadsheet exercise provides students with an opportunity to practise:

• basic formatting and cell alignment
• inserting new columns and rows
• MIN, MAX and AVERAGE formulae

Contributed by Jon Bridgeman of Finham Park School

auctions.xls

A test which should take most of an ICT lesson.

A good way to check the level of your students' skills

test instructions

test marksheet