Overview

Excel Modelling Best Practice is designed to ensure that teachers are aware of industry best practice in Excel spreadsheet development so that they can inform and assess their students appropriately. It covers workbook design, modelling principles and key Excel functions, formulae and functionality to enable teachers to enhance pupils’ use of Excel in modelling.

  • Excel modelling within the KS2/3/4 curriculum
  • Developing model logic
  • Systems design principles applied to Excel
  • Workbook structure best practice
  • Data structure best practice
  • Managing parameters
  • Tools for best practice, including functions, range names, validation
  • Approaches to scenario modelling
  • Techniques to build-in flexibility
  • Testing assumptions
  • User guidance, help and documentation

Who should attend?

Teachers from KS2 to KS4 who wish to understand current industry best practice in creating Excel spreadsheet models, to improve their teaching and assessment, as well as to prepare student better for the working environment.

Duration

1 day

Price

Price: £100+VAT

Host schools: up to 3 free places, provided there are a minimum of 3 paying delegates on the course

Delivered by

Neil Rabbitts, IT professional of 25 years, volunteer for ICT lessons with year 6 for 10 years, governor at Willow Brook Primary School for 10 years

I have used spreadsheets for 25 years and deliver commercial training courses. Having developed many complex Excel models, there are a number of techniques and design principles which make a good spreadsheet model stand out. I will be delighted to assist teachers in spreading this knowledge more widely.
Neil Rabbitts, Governor, Willow Brook Primary School