Course Completion Summary: Criteria Explained

This calculator works out a course completion summary by applying your chosen criteria to a list of completion rates or scores. You enter the individual completion values and set the threshold (e.g., 80%), and it returns the number and percentage of items that meet that threshold, plus the average completion. The result helps you quickly see how many courses, tasks, or modules passed your standard.

Formula

The calculator uses two simple formulas:

• Passed count: number of values in the list that are greater than or equal to the threshold.
• Pass rate: (Passed count ÷ Total count) × 100

Where:

• Completion rates – the list of percentages you enter (e.g., 85, 70, 92). Each represents a course or task completion.
• Threshold – the minimum percentage required to count as “passedâ€� (e.g., 80%).
• Passed – the number of entries meeting or exceeding the threshold.
• Pass rate – the percentage of entries that passed.
• Average completion – the mean of all entered values.

Worked Example

Using the default values from the calculator:

List: 85, 70, 92, 60, 78, 88, 95, 50
Threshold: 80

1. Count how many are ≥ 80: 85, 92, 88, 95 → 4 passed.
2. Total count = 8.
3. Pass rate = 4 ÷ 8 × 100 = 50.0%.
4. Average = (85+70+92+60+78+88+95+50) ÷ 8 = 618 ÷ 8 = 77.25%.

The calculator shows: Passed = 4, Pass rate = 50.0%, Average = 77.3%.

When to Use a Course Completion Summary

A course completion summary is useful in several contexts:

• Training managers – to see how many employees finished mandatory courses.
• Educators – to track assignment submission rates across a class.
• Online course creators – to evaluate how many students complete the whole course.
• Quality assurance – to check if a certain percentage of modules meet a completion standard.

You can also use it for any list of percentages, like survey response rates or task completion in a project.

How to Read the Results

The Passed number tells you how many items met your threshold. The Pass rate gives that as a percentage of the total – this is the headline metric for most summaries. A pass rate of 50% means half of the courses met the threshold. The Average completion is a separate measure: it shows the typical completion across all items, regardless of the threshold. If the average is below the threshold, it indicates that most items are below the standard, even if a few high scores pull the average up.

For example, if the average is 77% but the threshold is 80%, the typical course is not passing, even though some courses scored 95%.

Common Mistakes and Misconceptions

• Mixing up average and pass rate – The average is the mean of all values; the pass rate is the percentage that met the threshold. They can be very different. A list with values 100, 0, 100, 0 has an average of 50% but a pass rate of 50% as well (if threshold is 50), but with threshold 80, pass rate is 50% while average is 50% – coincidence. Always check which one you need.
• Using the wrong threshold – Some thresholds are “greater thanâ€� vs. “greater than or equal to.â€� This calculator uses ≥ (greater than or equal to). If your criteria are strictly “more than 80%â€�, you may need to adjust.
• Entering values as fractions instead of percentages – If you enter 0.85 instead of 85, the threshold of 80 would never be met. Keep all values in the same unit (percent).
• Ignoring missing data – The calculator only uses the numbers you enter. If some courses have no completion data, they are not counted. Decide whether to include them as 0% or exclude them.

Limitations of the Formula

This summary gives a simple pass/fail view. It does not show:

• Partial credit – A course at 79% is treated the same as one at 0%.
• Trends over time – It only shows a snapshot, not whether completion is improving.
• Weighted importance – All courses count equally, even if some are more critical.

For a deeper analysis, you might want to look at the distribution of scores, the median, or the range.

Frequently Asked Questions

What is a good course completion rate?

A “good� rate depends on your context. For mandatory compliance training, 90% or higher is often expected. For voluntary online courses, 10–20% is common. The threshold you set should reflect what is realistic and important for your situation.

Should I include courses that were not started as 0%?

It depends on what you are measuring. If you want to know the completion rate of all assigned courses, include them as 0%. If you only care about those that were actually started, exclude them. Be consistent and state your method.

How do I handle a threshold like “at least 80% but not 100%�?

This calculator only works with a single lower bound. If you need an upper bound as well, you would have to filter your list manually before entering it. For example, to count only courses between 80% and 99%, remove any 100% values from the list.

Can I use this for non-course data?

Yes. The calculator works with any list of numbers and a threshold. For example, you could use it to see how many sales reps met a quota (percentage of target) or how many days had on-time delivery (if you convert to a percentage).

What if my list has missing values?

The calculator ignores blank entries, but if you enter a blank cell, it is not counted. If you want to treat missing as 0%, you must type 0. The average and pass rate will change accordingly.

Related

• Tech Jobs: Language Access vs. Ability
• AI Agent Autonomy: Are Safeguards Keeping Pace?
• Wood Grain Back Cover for Moto X: Coming to Moto Maker?

in list | Completion rates (%) | 85, 70, 92, 60, 78, 88, 95, 50 | 0
in t | Threshold (%) | 80 | 0
out count_pass | Passed | count | 0 | 0
out pct_pass | Pass rate (%) | count_pass / count * 100 | 1
out avg | Average completion (%) | mean | 1