Excel → Custom 4-Point Grade Converter
Upload an Excel file where the first column is your roster, and the columns after it are different assessments (quizzes, tests, etc.). Each assessment can be on any points scale (5-point, 10-point, 100-point, or even 0–1 percents).
This tool adds a new *_4pt column for each assessment based on your custom 4-point scale.
2. Define your 4-point scale (percent-based)
Scores are converted to percents first, then mapped to 1–4 based on these cutoffs. If you leave the 4.0 cutoff blank, the tool will never auto-assign a 4.
Anything below the minimum for 2 becomes a 1.