Progress Judgements

Your Excel Sheet

Your sheet as loaded. Cells with a red corner had a mistake: point at one, or read the notes below. The Fixed tab shows it corrected.

Drop your Excel sheet here

Use the usual layout: a Grade column, the number of students, how many made expected or better progress, and how many did better than expected. Phase labels and Total rows are optional.

Paste From Excel

Copy the table in Excel, header row included, and paste it here. Or paste plain rows in this order: Grade, Phase, Students, Expected or better, Better than expected.

Simulated Sheets

Pretend versions only. These are not actual results and should not be reported as findings.

Each tab is your sheet with the fewest changes that bring Weak down to the limit. Blue cells are the pretend numbers. Point at one to see the real value.

Load a sheet above and the simulated versions appear here.

Simulated options

What Changes

Criteria

How each result is decided, from “Criteria For Attainment & Progress”. Change a number and everything updates.

Weak

Fewer students than this make expected or better progress.

Acceptable

The line above is reached, but fewer than the Good line did better than expected.

75%

Good

At least this many did better than expected.

Very Good

At least this many did better than expected.

Outstanding

At least this many did better than expected.

Most Weak allowed%

Most Outstanding allowed%

Which judgements count

Grades and phase totals 0 Grades only 0 Phase totals only 0

Build Your Own

Change the numbers here and the sheets above follow.

Edit Your Data

Edit any number and the whole page updates straight away. Rows with no numbers are left out.

Phase	Grade	Students	Made expected or better	Did better than expected	Remove

Current Results

The real numbers from the loaded sheet, after fixing any adding-up mistakes. Nothing is pretend in this section.

Load a sheet at the top of the page to see results here.

The Big Picture

Grade by Grade

Each row is one grade. The bar fills up with the students who made expected progress. If it reaches the black line, the grade is not Weak. The last column says how many more students it would take.

Mistakes Fixed in the File

Before and After

Build Simulations

What-if versions only. These are not actual results and should not be reported as findings.

The idea. A grade stops being Weak when at least 75 out of every 100 students make expected progress. Each option pretends a few more students did, in as few grades as possible, until there are few enough Weak results.

Example. A grade has 80 students and 52 made expected progress (65%). To reach 75% it needs 60, so it is 8 short. If 8 more students had made it, the grade would be Acceptable instead of Weak.

Phase results. A phase is all its grades added up, like a team score. Nobody changes it directly. It goes up by itself when its grades go up.

Load a sheet at the top of the page to build simulations.

Simulated