An important new course for contaminated land professionals. The programme has been developed to equip delegates with the understanding of how to develop strategies to manage data and to use the tools necessary to store, analyse and report on environmental data.

The key contents of the course include:

• Data management basics
• Data management policy and strategy
• Designing and utilising data management systems
• Producing queries and reporting on data
• Introduction to statistics for contaminated land
• Utilising Mean and Maximum value tests
• Spatial distribution, contouring algorithms and geo-statistics
• Uncertainty relating to precision and bias and probabilistic assessment

The contents of the course include:

• Data management basics
  This lecture presents the fundamentals of data management and the use of databases, spreadsheets and GIS. The lecture includes information about data file transfer types, reference values, certification, normalisation and referential integrity.
• Data management policy and strategy
  This lecture looks at producing company strategies for data management. It deals with the issues required for project initiation and how to work with laboratories to get electronic data with standardised naming conventions.
  
• Designing and utilising data management systems
  A lecture and practical for designing spreadsheets and databases for contaminated land. Using MS Excel it deals with sorting, filtering, validation and pivot tables. It uses MS Access to design simple databases and importing data.
  
• Producing queries and reporting on data
  A lecture and practical to learn how to produce MS Access queries including aggregation and cross-tab queries. Outputting this data to Excel and graphing.
  
• Introduction to statistics for contaminated land
  A lecture to introduce the statistics required for contaminated land.
  
• Utilising Mean and Maximum value tests
  A lecture and practical to learn how to use spatial tools to integrate data and perform the Mean and Maxium Value test as specified by the Environment Agency of England and Wales CLEA 2002 methodology - Contaminated Land Report 7.
  
• Spatial distribution, contouring algorithms and geo-statistics
  A lecture and practical to learn about techniques used to determine spatial distributions of samples. An introduction into contouring algorithms and the use of geo-statistics for contaminated land.
  
• Uncertainty relating to precision and bias and probabilistic assessment
  A lecture and practical to enable assessment and quantification of uncertainty and how to assign a proportion of this uncertainty to analytical and sampling error. Also how probabilistic assessment can aid in further understanding uncertainty.

To book a place on a course, please click here.