Excel 2003: General spreadsheet tasks

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

Resource

KS3

KS4

KS5

Click Here

Workbook 1

Skills covered:

  • Basic formulae
  • Basic functions
  • Displaying formulae
 
tick
tick

download filedownload file

Task

Discos Task

Skills covered:

  • Basic formatting
  • Word wrap
  • Renaming a tab
  • Deleting a worksheet
  • Inserting a worksheet
  • Basic formulae
  • Basic functions
  • Using the help menu
  • Inserting rows
  • Deleting a column
  • Merging cells
  • Footers
  • Adding an image
  • Absolute cell reference
  • Entering and formatting the date
  • Format painter
  • Making a copy of the sheet
  • Sorting data in a table
  • Aligning text
  • Text orientation
  • Borders
  • IF formula
  • Charts
  • Setting the print area

 

tick
tick
download filedownload file

Task

absolute cell reference video tutorial

discos.xls

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 filedownload file

Task

Burgers Task

Skills covered:

  • Suitable column widths
  • Renaming tabs
  • Basic formatting
  • Basic formulae
  • Basic functions
  • Sorting data
  • Find tool
  • Charts
  • Absolute cell reference
  • IF formula
  • Setting print area
tick
tick
download filedownload 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 filedownload 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 filedownload 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 filedownload file

Task (2003)

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 (2003)

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