Conditional Formatting
 
 

 

Home
Project resources
 

 

The resources in this project have been programmed in Excel and used extensively during the main parts of Mathematics lessons. The author introduces topics using mini-whiteboards and then allows students to practise on laptop computers and increase their confidence as they get the answers right!

The project has been particularly successful for motivating lower ability students during afternoon sessions!

Most files comprise several spreadsheets and so a variety of topics are covered, including simple arithmetic questions allowing weaker secondary pupils to practise basic skills either in school or at home.

Full instructions on how to achieve conditional formatting using Excel are included in the project resources.


A Teachnet UK 2005 Project submitted by
John Coats [Notre Dame High School, Sheffield]