Grade Analyzer

About this tool

At the end of a term you copy a class list out of a spreadsheet and need the mean, pass rate and who is struggling. Tapping numbers into a calculator one at a time loses entries. Paste the whole block here and the count, median, standard deviation, band distribution and ranked list come out together.

Eight students at 88, 92, 75, 64, 95, 53, 81 and 70 with a maximum of 100 and a 60% pass line give a mean of 77.25, a median of 78, a pass rate of 87.5%, an excellence rate of 25%, a standard deviation near 13.2, a high of 95 and a low of 53. Raise the pass line to 70% and the pass rate drops to 62.5%.

What it does

• EntryName and score on one line Every number shown here maps to a field on the form, so changing one value recomputes the rest. The units are printed next to each input, which saves most of the usual mistakes.
• DistributionFive automatic score bands The main figures sit at the top of the result panel and the breakdown sits below it, so you can read the conclusion first and audit the steps afterwards. Nothing you type leaves the browser.
• ThresholdsCustom pass and excellence cut-offs All arithmetic runs locally in the page. There is no request to a server, no account, and no saved history once the tab is closed. Use the example button if you want a set of values that is known to work.
• DivisorPopulation standard deviation Intermediate quantities are kept in the detail table. When a total looks wrong, tracing back through those rows is much quicker than staring at the headline number alone.
• RankingRanked list sorted by score The formula is written out in the notes rather than hidden behind a label, so you can check it against a spreadsheet or a textbook. Values are rounded only for display.
• ToleranceBad lines skipped and counted Inputs are validated before any calculation starts. Empty or impossible values produce a short explanation instead of a zero, a NaN, or a made-up answer.

How to use it

1. Start by filling inpaste a name and score per line The main figures sit at the top of the result panel and the breakdown sits below it, so you can read the conclusion first and audit the steps afterwards. Nothing you type leaves the browser.
2. Next, setset the maximum mark All arithmetic runs locally in the page. There is no request to a server, no account, and no saved history once the tab is closed. Use the example button if you want a set of values that is known to work.
3. Then pressset the pass percentage Intermediate quantities are kept in the detail table. When a total looks wrong, tracing back through those rows is much quicker than staring at the headline number alone.
4. Read thepress Calculate The formula is written out in the notes rather than hidden behind a label, so you can check it against a spreadsheet or a textbook. Values are rounded only for display.
5. Finally, useread the bands, then the ranking Inputs are validated before any calculation starts. Empty or impossible values produce a short explanation instead of a zero, a NaN, or a made-up answer.

Things to keep in mind

• Countat least two valid grades All arithmetic runs locally in the page. There is no request to a server, no account, and no saved history once the tab is closed. Use the example button if you want a set of values that is known to work.
• Rangea score cannot exceed the maximum Intermediate quantities are kept in the detail table. When a total looks wrong, tracing back through those rows is much quicker than staring at the headline number alone.
• Excellence lineexcellence is fixed at 90% of full marks The formula is written out in the notes rather than hidden behind a label, so you can check it against a spreadsheet or a textbook. Values are rounded only for display.
• Duplicatesduplicate names are not merged Inputs are validated before any calculation starts. Empty or impossible values produce a short explanation instead of a zero, a NaN, or a made-up answer.
• Display capthe ranked list shows 10 entries Every number shown here maps to a field on the form, so changing one value recomputes the rest. The units are printed next to each input, which saves most of the usual mistakes.