Sample Student Grades
A long-format student grades table with one score per row, subject and term columns, and attendance values. Download as CSV, Excel or JSON.
Start the 8-task practice package — files and complete answers
Try the subject-summary practice workbook
Separate from the raw downloads: summarize 180 independent synthetic score records by subject at a score threshold of 70. Start with 36 blank responses, then compare the visible answer key.
Download subject-summary workbook (.xlsx)What is in the file
6 columns, 180 data rows by default, plus a header row. These are the first ten rows of the default file.
| 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 |
Download 180 rows
6 columns · header included · no signup
Direct files work without JavaScript. Choose another size below.
Get the matching tasks and answer filesBuilt in your browser when you click. Nothing is uploaded, no signup, free for commercial use.
About this dataset
Each generated row is an independent score record with a unique Student ID, a name, one of five subjects, a term, a score and attendance. The table is long format: subjects are values in one column, not five score columns. It does not track the same student across every subject or term. Practise subject-level summaries, score ranking and grade-band lookups on synthetic records.
File layout and import notes
- Columns: Student ID, Student, Subject, Term, Score and Attendance. One score record occupies one row.
- Scores range from 31 to 100. Attendance is stored as a whole percentage from 62 to 100, so 85 means 85%, not an Excel fraction of 0.85.
- Names can repeat, but each Student ID is unique. These rows are not a complete gradebook with five subjects for each student.
Free practice package · 180 source rows
Tasks, complete answers and a file to keep
Use a long-format table of independent score records to practise summaries, illustrative grade bands and ranking. Compare every derived value and each subject summary with the answer file.
Version 2026-10-08.1. These answers match the default 180-row source file, not the other sizes in the download control.
1. Start with the source file
Keep an unchanged copy. Work through the tasks before opening the answers.
Tasks only (.md) — no answers2. Compare with complete answers
The workbook contains the original data, every reference row and expected checks. The CSV contains the full reference table.
All files download directly without signup or JavaScript. Markdown (.md) handouts are plain-text files you can open in a text editor. The answer sheets contain fixed reference values; formula sheets, where included, recalculate in your spreadsheet application.
The printable HTML files open in a browser. Choose Print or Save as PDF. The tasks sheet has writing space and no hidden answers; the worked-answer sheet includes formulas and expected tables.
Before you start
- Answers match the default 180-row file. Repeated names do not identify the same student; do not calculate a multi-subject student average from these rows.
- Practice-only rules: A at 90, B at 80, C at 70, D at 60, otherwise F. Pass means score at least 60. These are exercise assumptions, not a school policy.
- Attendance is a whole percentage: divide by 100 before applying Percentage format. Ranking is descending competition ranking: ties share a rank and later ranks are skipped.
- Formulas use English function names and commas. Localized Excel may use different names and separators.
8 tasks to work through
Confirm the data shape
Identify the score, subject and attendance columns; count the records.
Show answer and method for task 1
=COUNT(E2:E181)180 score records. E contains Score, C contains Subject, and F contains whole-percentage Attendance. Each Student ID identifies a record.
Calculate the overall mean
Average the score records and display two decimal places.
Show answer and method for task 2
=AVERAGE(E2:E181)65.81. Every record has equal weight; this is not a weighted student grade.
Summarize each subject
List each subject in an empty area and calculate its record count and mean.
Show answer and method for task 3
=AVERAGEIF($C$2:$C$181,"Mathematics",$E$2:$E$181)Repeat for each subject. COUNTIF gives record counts; the Subject answers sheet provides all expected counts and rounded means.
Apply grade bands
Add Grade in G using the stated exercise thresholds.
Show answer and method for task 4
=IF(E2>=90,"A",IF(E2>=80,"B",IF(E2>=70,"C",IF(E2>=60,"D","F"))))Fill down. Boundary scores 90, 80, 70 and 60 enter A, B, C and D respectively. The formula workbook keeps these thresholds on the Rules sheet.
Rank records with ties
Add descending Rank in H and keep the score range fixed.
Show answer and method for task 5
=COUNTIF($E$2:$E$181,">"&E2)+1The first record ranks 59. Equal scores receive equal ranks; the next rank skips the number of tied records.
Convert attendance correctly
Add Attendance fraction in I and apply Percentage format.
Show answer and method for task 6
=F2/100A stored value of 85 becomes 0.85, displayed as 85%. Formatting the original 85 directly would display 8500%.
Flag the practice pass rule
Add Result in J using the exercise pass threshold.
Show answer and method for task 7
=IF(E2>=60,"Pass","Review")105 records are Pass. A score exactly equal to 60 passes.
Reconcile band counts
Count the records in each grade band and compare with the answer sheet.
Show answer and method for task 8
=COUNTIF(G2:G181,"A")Repeat for A, B, C, D and F. Counts must sum to 180. Compare derived columns G:J record by record, not only the totals.
Check your results before opening the answers
Enter the values you calculated from the unchanged 180-row file. This checks a few totals and counts, not your whole workbook.
Use a decimal point, no thousands separators and at most two decimal places: 1234.56. Round averages to two decimals. Leave checks you have not tried blank.
Your entries are checked only in this page. They are not uploaded, saved or included in analytics. Use Clear values to remove them.
Need the worked solution? Go to the expected checks and summary tables below.
Show expected checks and summary tables
Check your work
| Check | Expected |
|---|---|
| Score records | 180 |
| Mean score (2 decimals) | 65.81 |
| Minimum score | 31 |
| Maximum score | 100 |
| First record rank | 59 |
| Pass records (score >= 60) | 105 |
Subject answers
| Subject | Records | Average score (2 decimals) |
|---|---|---|
| Biology | 36 | 66.83 |
| Economics | 35 | 61.86 |
| History | 37 | 67.86 |
| Mathematics | 36 | 66.53 |
| Physics | 36 | 65.81 |
Grade-band answers
| Band | Records |
|---|---|
| A | 30 |
| B | 29 |
| C | 23 |
| D | 23 |
| F | 75 |
Preview the first three reference rows
| Student ID | Student | Subject | Term | Score | Attendance | Grade | Rank | Attendance fraction | Result |
|---|---|---|---|---|---|---|---|---|---|
| STU-1000 | Lucas | History | Autumn | 80 | 97 | B | 59 | 0.97 | Pass |
| STU-1001 | Lena | Economics | Autumn | 66 | 89 | D | 92 | 0.89 | Pass |
| STU-1002 | Ethan | Physics | Autumn | 51 | 81 | F | 126 | 0.81 | Review |
Use this in a lesson or tutorial
Share the source file and tasks-only handout first, then release the answers. Use the checks to discuss different approaches; matching one total does not prove every row is correct.
Free for practice, teaching, demos and commercial use. Attribution is welcome, not required. These are generated records, not real customer or student data. Link to this page so learners can get matching files.
Download starts and successful formula copies may be counted without sending your spreadsheet contents or a visitor identifier. The site respects Do Not Track and Global Privacy Control for these counts. Downloads are not proof of task completion.
Calculate score summaries from this download
In the raw download, scores are in E and subjects in C: place the first three formulas outside A:F. The separate fixed 180-record project preserves Data!A1:F181 and starts Tasks!B7:F12 and B16:B21 blank. Enter the project formulas in their named Tasks cells; display means with two decimal places and shares as 0.00%.
Download subject-summary workbook (.xlsx) — Optional fixed 180-record XLSX with Tasks, Data and Answer key sheets. Thirty-six responses start blank. The visible key supplies literal answers and 36 text formula examples; it does not calculate or score your attempt.
Average of all score records
=AVERAGE(E2:E181)Average for Mathematics
=AVERAGEIF(C2:C181,"Mathematics",E2:E181)Rank the first score from highest to lowest
=RANK.EQ(E2,$E$2:$E$181,0)Project: record count in Tasks!B7
=COUNTIFS('Data'!$C$2:$C$181,$A7)Project: score total in Tasks!C7
=SUMIFS('Data'!$E$2:$E$181,'Data'!$C$2:$C$181,$A7)Project: mean score in Tasks!D7
=AVERAGEIFS('Data'!$E$2:$E$181,'Data'!$C$2:$C$181,$A7)Project: count at or above 70 in Tasks!E7
=COUNTIFS('Data'!$C$2:$C$181,$A7,'Data'!$E$2:$E$181,">="&$B$3)Project: qualifying share in Tasks!F7
=E7/B7Project: record-weighted mean in Tasks!B21
=SUMPRODUCT(B7:B11,D7:D11)/SUM(B7:B11)| Check | Expected |
|---|---|
| Score records | 180 |
| Average score, displayed to 2 decimals | 65.81 |
| Mathematics records | 36 |
| Mathematics average, displayed to 2 decimals | 66.53 |
| First score (E2) | 80 |
| Rank of E2, descending | 59 |
If columns are cut off, scroll the table sideways.
| Subject | Records | Score total | Mean score | Score >=70 | Share >=70 |
|---|---|---|---|---|---|
| Mathematics | 36 | 2395 | 66.53 | 18 | 50.00% |
| Physics | 36 | 2369 | 65.81 | 15 | 41.67% |
| History | 37 | 2511 | 67.86 | 19 | 51.35% |
| Biology | 36 | 2406 | 66.83 | 19 | 52.78% |
| Economics | 35 | 2165 | 61.86 | 11 | 31.43% |
| All records | 180 | 11846 | 65.81 | 82 | 45.56% |
If columns are cut off, scroll the table sideways.
- These are independent score records, not repeated observations for a complete student gradebook. Repeated names do not identify the same student.
- A subject average weights each record equally. It does not calculate one overall grade per student or apply subject weights.
- In Tasks, the five subject labels are already in A7:A11 and B3 is 70. Enter the five project formulas in B7:F7, then fill down to row 11. Score >=70 includes exactly 70; this is a chosen practice rule, not a school pass standard.
- For the All records row, enter =SUM(B7:B11) in B12, =SUM(C7:C11) in C12 and =SUM(E7:E11) in E12. Use =C12/B12 in D12 and =E12/B12 in F12: the checks are 180 records, 11846 score points and 82 qualifying records.
- The overall mean is 11846/180, displayed as 65.81, and the qualifying share is 82/180, displayed as 45.56%. Weight unrounded subject means by their record counts; simply averaging the five subject means gives 65.78. Use number formatting rather than ROUND in the mean helpers.
- The optional workbook has 36 blank responses and 36 text formula examples in its visible Answer key. Enter those examples in the stated Tasks cells to calculate your own results; the file has no evaluated formulas or automatic scoring.
- The project and its literal answers are fixed to 180 records at threshold 70. They do not change with the raw download row-count control. If you edit the data or threshold, recalculate your answers; the supplied key no longer applies.
- RANK.EQ assigns the same rank to equal scores and skips subsequent ranks. Keep the reference range locked when filling down.
- If you choose another row count, extend every range and compute new expected results. The answers here describe only the default file.
- Attendance in F is a whole percentage: 85 means 85%. To display it with Excel’s Percentage format, use =F2/100 in a helper column.
- The examples use English function names and comma separators. Localized spreadsheets may need translated names or semicolons.
Documentation reviewed .
Microsoft: AVERAGEIFMicrosoft: RANK.EQMicrosoft: COUNTIFSMicrosoft: SUMIFSMicrosoft: AVERAGEIFSMicrosoft: SUMPRODUCT
What you can practise with it
- Average, median and standard deviation across scores or by subject
- Convert a score to a letter grade with a lookup table
- Rank independent score records and inspect ties; repeated names do not identify one student
- Summarize subjects at the chosen score threshold of 70 with the optional fixed 180-record practice workbook
- Highlight the top and bottom decile with conditional formatting
Try a related exercise
- Turn a score into a band without nesting IFs — Four thresholds, one readable formula. The nested-IF version is where bracket-counting errors come from.
- Find the third-largest value without sorting — Top-n answers that do not disturb the sheet — and do not break when two values tie.
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. Direct links download the default-size files without JavaScript. The row-count control builds other supported sizes in your browser. Your spreadsheet contents are not uploaded and no account is involved.
Which formats can I download?
The raw dataset downloads are Excel (.xlsx), CSV and JSON with the same original rows. The separate optional subject-summary project is one fixed 180-record XLSX with Tasks, Data and Answer key sheets; it does not come in CSV or JSON or change with the row-count control.
Can I choose how many rows I get?
Yes. The browser control offers 25, 100, 180, 500 data rows, plus a header. Direct source links contain 180 data rows; the preview shows the first ten of those rows.
Does this file include tasks and complete answers?
Yes. The practice package has 8 tasks, a separate tasks-only handout, a full walkthrough and a workbook with every reference row and expected checks. Answers apply only to the default 180-row source file. The workbook is a reference and formula solution, not a native Excel execution certificate or a prebuilt interactive PivotTable.