Excel 2007: General spreadsheet tasks

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

Resource

KS3

KS4

KS5

Click Here

Introduction to spreadsheets

Skills covered:

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

Kindly contributed by Jo Wallace from City of Bath College

tick tick  

absolute cell reference video tutorial

Task

Basic formatting task

Skills covered:

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

Kindly contributed by Jo Wallace from City of Bath College

tick tick  

absolute cell reference video tutorial

Task

Formatting task

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.

 
 
tick
tick

download file

Task

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

tick tick tick

download file

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
  • select non adjacent columns
  • column chart
  • change chart style
  • change chart colour
  • add titles, axis labels
  • move, resize chart
  • undo, redo

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

tick
tick
tick
download file

Task

absolute cell reference video tutorial

burgers.xls

Ringtones Task

Skills covered:

  • Setting up a basic spreadsheet
  • Basic formulae
  • Basic functions
  • Basic formatting
  • Format painter
  • Formatting currency
  • Merging cells
  • Adding and removing toolbars
  • 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
tick
tick
download file

Task

absolute cell reference video tutorial

ringtones.xls

Teddy Tots Greetings Cards

Skills covered:

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

(subscription only)

  tick tick

download file

Task

 

Skiing Task

Skills covered:

  • Setting up a spreadsheet
  • Basic formula and functions
  • Formatting a spreadsheet
  • Inserting rows
  • Borders
  • Headers and footers
  • Printing options
  • Sorting data
  • Hiding a column
tick
tick
download file

Task

absolute cell reference video tutorial

skiing.xls

Supermarket Comparisons Task

Skills covered:

  • Setting up a spreadsheet
  • Basic formula and functions
  • Formatting a spreadsheet
  • Resizing columns
  • Footers

 

tick
tick

download file

Task

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

 

tick
tick

download file

Task

Online auctions

This spreadsheet exercise provides students with an opportunity to practise:

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

Extension tasks are provided

Contributed by Jon Bridgeman of Finham Park School

tick tick tick
absolute cell reference video tutorial

auctions.xls

Spreadsheet test

A test which should take most of an ICT lesson.

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

 

tick
tick

download file

test instructions

download file

test marksheet

download file

completed spreadsheet

 

 

 

 

 

 

 

 

Copyright © www.teach-ict.com