New listings

This article describes how John Chamberlain of St Dominics Sixth Form College used Excel spreadsheets to model all six different examples relating to equilibria in A level Chemistry.

This Excel spreadsheet has been built as an example of how random numbers can be generated using Macros. The spreadsheet also enables the users to explore how the spreadsheet has been written.

Debi Hand from Peter Symonds College focuses on the use of Excel worksheets to aid the learning process in AS Decision and Discrete Mathematics. In some cases this means a simple use of a sheet to highlight characteristics of sorting algorithms; in other cases this would be to use a spreadsheet to help speed up the process of learning - in particular in the case of simulations.

When generating random numbers in Excel, the values are changed every time return is pressed. This article explains how to use Macros in Excel to produce the random numbers and then use them, without them continually changing.

This interactive resource has been created in Excel as a simulation tool to assist students answering sample exam questions in Decision and Discrete Mathematics.

The article describes the use of spreadsheets as a management tool to record and monitor progress, outcomes and added value for students on Advanced Level programmes. GCSE qualifications are used, within Durham University’s A Level Information System (ALIS) to predict potential outcomes and progress is regularly reviewed against targets.

The downloadable Excel sheet is part of an article which describes the use of spreadsheets as a management tool to record and monitor progress, outcomes and added value for students on Advanced Level programmes. GCSE qualifications are used, within Durham University’s A Level Information System (ALIS) to predict potential outcomes and progress is regularly reviewed against targets.

This how to contains both an example of the use of multiple choice questions in Microsoft Excel and step-by-step instructions for creating the example.

This lesson plan demonstrates how Excel forms can produce interactive exercises to be used as teaching resources.

Aimed to help students interpret graphical representations in a dynamic way, this chemistry lesson plan, containing downloadable Excel spreadsheet, reinforces and integrates the concepts encountered in equilibrium.