1st Edition

Using Data for Monitoring and Target Setting A Practical Guide for Teachers

By Ian McCallum, Ray Sumner Copyright 1999

    Using Data for Monitoring and Target Setting is a clear and practical guide for teachers and school administrative staff that shows how to use spreadsheets to create orderly records of assessment. These can then be used for the sort of statistical analyses which are now being demanded from schools.
    This guide is photocopiable and includes:
    *lots of practical examples
    *step-by-step instructions on how to obtain the data you want
    *simple advice on how to use EXCEL
    *pictures of the actual screens you will be using.

    Part 1: First Steps with Excel Making Sense of Pupil Performance Figures How Can We Describe Performance? How Can We Investigate the Relationship between Sets of Marks? Confidence in Sample Estimates Creating an Expectancy Table Part 2A: Scales and their Interpretation Part 2B: Handling Test Data Appendices

    Biography

    Ray Sumner has worked in education for many years, both as a teacher and a researcher. He is the author of The Role of Assessment in Schools., Ian McCallum taught mathematics before going on to work at the London Research Centre, where he analysed a wide variety of educational data.