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.
Table of Contents
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