Discusses ways in which datalogging equipment can enable titration curves to be measured accurately and how computing power can be used to predict the shape of curves. Highlights include sources of error, use of spreadsheets to generate titration curves, titration of a weak acid with a strong alkali, dibasic acids, weak acid and weak base, and…

Describes two spreadsheets for producing acid-base titration curves, one uses relatively simple cell formulae that can be written into the spreadsheet by inexperienced students and the second uses more complex formulae that are best written by the teacher. (JRH)

Describes a spreadsheet activity for the iodine-clock reaction which follows the concentrations of all reactions and products for 200 seconds and gives the induction period. Explains that, although there are limitations to the spreadsheet, it is nevertheless illuminating. (Author/ASK)

Presents examples that illustrate how spreadsheets can be used to ask and answer all sorts of scientific questions given suitable automation of useful spreadsheet procedures. Examples include data exploration, data analysis, project presentation, simulations, and students writing their own models. (Author/JRH)

Compares phase diagrams relating to the solubilities and melting points of various substances in textbooks with those generated by a spreadsheet using data from the literature. Argues that differences between the diagrams give rise to new chemical insights. (Author/MM)

Discusses reasons for using spreadsheets in science teaching. Presents a list of possible applications together with examples of these from very simple to more complex uses including animation of dynamic systems. Also provides a list of references for materials for beginners and more advanced users. Contains 12 references. (Author/ASK)

Describes when and how to carry out many of the most common statistical tests including mean, standard deviation, confidence limits, correlation, regression, t-test, Chi square test, and ANOVA. Uses Excel to perform these operations. (DDR)

Presents a numerical simulation of a simple food chain together with a set of mathematical rules generalizing the model to a food web of any complexity. Discusses some of the model's interesting features and its use by students. (Author/JRH)

Explored are ways in which spreadsheets can be used in the teaching of chemistry. Some of the limitations of using algebraic modelling tools are highlighted. Several example applications are provided. (CW)

Examined are applications of computer spreadsheets from simple record/observation tables to custom built analysis systems. The advantages and disadvantages depending on the use of these software packages are discussed. Several examples are used to illustrate possible applications. (CW)

Presented are 29 science activities for secondary school science instruction. Topic areas include botany, genetics, biochemistry, anatomy, entomology, molecular structure, spreadsheets, chemistry, mechanics, astronomy, relativity, aeronautics, instrumentation, electrostatics, quantum mechanics, and laboratory interfacing. (CW)

Described is a means of logging data from remote sensors in data files and then transferring the data to a spreadsheet for processing. The presentation of the data in tabular or graphical form is discussed. An example using temperature data from a model house is provided. (Author/CW)