# Excel Student Grades Practice — File, Tasks & Answers

Version: 2026-10-08.1

https://formulasmith.com/en/sample-data/student-grades/

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.

## 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.

## 1. Confirm the data shape

Identify the score, subject and attendance columns; count the records.

## 2. Calculate the overall mean

Average the score records and display two decimal places.

## 3. Summarize each subject

List each subject in an empty area and calculate its record count and mean.

## 4. Apply grade bands

Add Grade in G using the stated exercise thresholds.

## 5. Rank records with ties

Add descending Rank in H and keep the score range fixed.

## 6. Convert attendance correctly

Add Attendance fraction in I and apply Percentage format.

## 7. Flag the practice pass rule

Add Result in J using the exercise pass threshold.

## 8. Reconcile band counts

Count the records in each grade band and compare with the answer sheet.

## Teaching and reuse
Free for practice, teaching, demos and commercial use. No registration. Attribution is welcome, not required. These records are synthetic. Share the source page so learners can obtain the matching file version.