| Name | Category | Score | Max | Weight % | Adj % | Percent | Extra? | Drop? | Actions |
|---|---|---|---|---|---|---|---|---|---|
|
Extra rows increase points only.
Fill blank weights fairly.
|
|||||||||
Example Data
Click "Load Sample" to populate the table with these items.
| Name | Category | Score | Max | Weight % | Adj % | Extra? |
|---|---|---|---|---|---|---|
| Quiz 1 | Quizzes | 9 | 10 | 5 | 0 | No |
| Quiz 2 | Quizzes | 8 | 10 | 5 | 0 | No |
| Midterm | Exams | 78 | 100 | 30 | 0 | No |
| Project | Projects | 45 | 50 | 20 | 0 | No |
| Final | Exams | 180 | 200 | 40 | 0 | No |
| Bonus Quiz | Quizzes | 2 | 2 | 0 | 0 | Yes |
Formula Used
Per-item percentage: \( p_i = \frac{\text{score}_i}{\text{max}_i} \times 100 + \text{adj}_i \).
Weighted average (weighted basis): \( \bar{P} = \frac{\sum\_{i \in I} w_i p_i}{\sum\_{i \in I} w_i} \), with optional normalization and category/top-N rules applied.
Points average (points basis): \( \bar{P} = \frac{\sum\_{i \in I} \text{score}_i}{\sum\_{i \in I} \text{max}_i} \times 100 \).
Points + Extra Credit: Extra items contribute to numerator only: \( \bar{P} = \frac{\sum \text{score}_\text{regular} + \sum \text{score}_\text{extra}}{\sum \text{max}_\text{regular}} \times 100 \).
Minimum required on remaining weight: Let current average be \(C\), remaining weight fraction \(r\), target \(T\). Needed on remaining \(x = \frac{T - (1-r)C}{r}\), clamped to [0,100].
How to Use This Calculator
- Add rows for each exam component: quizzes, projects, midterms, final.
- Enter achieved points, maximum points, optional weight, and any adjustments.
- Choose basis: weighted percent, points, or points with extra credit.
- Use drop and top-N rules globally or by category.
- Set grade thresholds, rounding, and optional curve parameters.
- Optionally require a minimum percent in a specific category.
- Set a target and remaining weight to see needed performance.
- Export CSV or PDF, or share a stateful link for collaboration.
What Is an Exam Average?
An exam average summarizes performance across multiple graded items. It can be computed by percentage of points or by weighted percentages when components carry different importance.
- Points basis: total earned points divided by total possible points.
- Weighted basis: per‑item percentages combined by their assigned weights.
- Extras: this tool optionally supports adjustments, extra credit, and drop‑lowest rules.
Weighted vs Points Basis — Worked Example
Suppose two items:
- Exam A: 40/50 (80%) with weight 30%.
- Exam B: 90/100 (90%) with weight 70%.
Weighted basis: (0.3 × 80) + (0.7 × 90) = 24 + 63 = 87%.
Points basis: (40 + 90) / (50 + 100) = 130/150 = 86.67%.
Different methods yield close, but not identical, results. Choose the one matching your syllabus.
Drop‑Lowest Effect — Numeric Illustration
Three quizzes weighted equally within a category:
- Quiz 1: 6/10 = 60%
- Quiz 2: 8/10 = 80%
- Quiz 3: 9/10 = 90%
Without dropping: (60 + 80 + 90) / 3 = 76.67%.
Drop lowest one: (80 + 90) / 2 = 85%.
Dropping the lowest score can materially increase the category average, depending on policy.