Spreadsheet tasks

Teddy Tots Greetings Cards

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)

download file

Task (2007)

download file

Task (2003)

Car Sales - comparison and percentages

Skills covered:

  • Write a SUM formula
  • Write a formula to calculate percentages
  • Format cells as a percentage
  • Format cells to 1 decimal place
  • Write and use an absolute cell reference
  • Replicate formulae
  • Write a formula to calculate the differences between to different percentages
  • Ensure work fits on one A4 sheet
  • Add name to footer
  • Set gridlines to show on printing
  • Set row and column headers to show on printing
  • Show formulas

(subscription only)

download file

Task

click here

car sales.xls

click here

car sales answers.xls

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

download file

2003

download file

2007

 

Spreadsheet validation task

A comprehensive task which teaches students how to set up different types of validation in spreadsheets.

(subscription only)

download file

Task

click here

validation.xls

Spreadsheet test

A test which should take most of an ICT lesson.

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

download file

test instructions

download file

test marksheet

download file

completed spreadsheet

 

 

 

 

Copyright © www.teach-ict.com