ludus

Letter Grades

ld-0014 · 2 › ██░░░░░░░░ · lookup

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

  1. Make a copy of the template — it becomes your private sheet.
  2. Solve it however you like — helper columns and extra tabs are fair game. The one rule: the grader swaps INPUT for other datasets, so never put your own content inside INPUT.
  3. Check yourself against the expected sample output shown in your copy (and below).
  4. 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 ScoreGradeScore
0F84
60D59
70C90
80B72.5
90A100
66

Expected output (Answer!B3:B23)

Grade
B
F
A
C
A
D