Letter Grades
Your client teaches a course and needs scores turned into grades. The grading scheme is a boundary table: each row gives the minimum score for a grade, sorted from lowest to highest. A score earns the grade on the last row whose minimum is less than or equal to it. The lowest minimum is always low enough to catch every score.
Produce the grade for each score, one row per score, aligned with the input. The grader swaps in different schemes and score lists — different cutoffs, different labels, different lengths — so read both tables and cover the whole OUTPUT range: empty score rows must produce empty output rows.
Work on it
- Make a copy of the template — it becomes your private sheet.
- Solve it however you like — helper columns and extra tabs are fair game. The one rule:
the grader swaps
INPUTfor other datasets, so never put your own content insideINPUT. - Check yourself against the expected sample output shown in your copy (and below).
- Submit below — Share → "anyone with the link, Viewer", paste the link. Your sheet is graded against 2 hidden datasets, so hardcoded answers won't survive.
Sample
Input (Input!B2:E23)
| Min Score | Grade | Score | |
| 0 | F | 84 | |
| 60 | D | 59 | |
| 70 | C | 90 | |
| 80 | B | 72.5 | |
| 90 | A | 100 | |
| 66 |
Expected output (Answer!B3:B23)
| Grade |
|---|
| B |
| F |
| A |
| C |
| A |
| D |