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

#### KS5

##### 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

##### Teddy Tots Greetings Cards Task

Skills covered:

• Create a structure and layout within a spreadsheet application
• Enter a list of prices into a spreadsheet
• Write simple formula with a single operator
• Write a SUM function using a cell range
• Format data to currency
• Use appropriate number of decimal places
• Write a formula to calculate a percentage
• Ensure work fits on one A4 sheet
• Set gridlines to show on printing
• Set row and column headers to show on printing
• Show formulas

(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