Sample Student Grades
Scores across five subjects per student — for AVERAGE, RANK, VLOOKUP grade bands and statistical practice.
What is in the file
6 columns, 180 rows by default. The first ten rows are shown below — the download contains exactly this data.
| Student ID | Student | Subject | Term | Score | Attendance |
|---|---|---|---|---|---|
| STU-1000 | Lucas | History | Autumn | 80 | 97 |
| STU-1001 | Lena | Economics | Autumn | 66 | 89 |
| STU-1002 | Ethan | Physics | Autumn | 51 | 81 |
| STU-1003 | Nora | Biology | Autumn | 37 | 74 |
| STU-1004 | Noah | Physics | Spring | 68 | 91 |
| STU-1005 | Maya | Biology | Autumn | 54 | 83 |
| STU-1006 | Ava | Mathematics | Spring | 39 | 75 |
| STU-1007 | Chloe | History | Spring | 94 | 67 |
| STU-1008 | Adam | Economics | Spring | 35 | 72 |
| STU-1009 | Emma | History | Spring | 89 | 64 |
Built in your browser when you click. Nothing is uploaded, no signup, free for commercial use.
About this dataset
A grade book is the shortest path to practising the statistical function family on data you can sanity-check by eye: averages, medians, standard deviation, ranking, and a lookup table that turns a score into a letter grade. Scores are spread widely enough that a bell-curve chart and a RANK column both look like the real thing.
What you can practise with it
- Average, median and standard deviation per student and per subject
- Convert a score to a letter grade with a lookup table
- RANK students and break ties
- Highlight the top and bottom decile with conditional formatting
Tools that work on this data
Free to use, share and republish — including commercially. Attribution isn't required, but it's what keeps these free to make, and there's one ready to paste below.
Questions
Is this sample student grades free to use?
Yes — for practice, teaching, demos and commercial work alike. The rows are generated, so there is no personal data in the file. Attribution is not required; if you would like to credit it, there is a ready-made line at the bottom of this page.
Do I have to sign up or give an email address?
No. The file is built in your browser when you click download; nothing is uploaded and no account is involved.
Which formats can I download?
Excel (.xlsx), CSV and JSON. All three contain the same rows, so you can use the CSV for an import exercise and the .xlsx for a formula exercise.
Can I choose how many rows I get?
Yes. Pick a row count before downloading — the default is 180 rows, which is what the preview on this page is drawn from.