How to calculate the three rates of student achievement, how to calculate the excellent rate of stud

The three rates refer to the excellent rate, the passing rate, the low score rate, and in fact, there is a high score rate. Here's how it works:

Count the number of candidates who get the value of the candidate's score higher than (the low score rate is lower) and multiply the full score of a certain classification (such as the total score, or a certain subject) by the corresponding proportion (90% for the high score rate, 80% for the excellent rate, 60% for the pass rate, and 40% for the low score rate), and then count the total number of people, divide the number of statistics by the total number of people, and convert it into a percentage to get the three rates.

High score >=90;For example, calculate the language excellence rate = contif(a2:a60,">=80")/cont(a2:a60)；Pass rate >=60;Low score <=40.

Excellent rate:Divide the number of outstanding students by the total class size and multiply by 100%.

For example: 30 excellent class size 50 = 60%.

Pass Rate:Divide the number of passes by the total class size and multiply by 100%.

For example: 30 total class size 50 = 60%.

Consolidation rate:Divide the number of graduates by the number of students enrolled and multiply by 100%.

For example: Graduation 48 Total enrollment 50 = 96%.

Poor birth rate:Divide the number of poor students by the total class size and multiply by 100%.

For example, the number of poor students is 5 and the total class size is 50=10%.

Standard cut-off.

Excellent grades should be greater than or equal to 85 points. The number of students with a score of 85 or more divided by the total number of students. This is the rate of excellence in the grades.

The pass rate should be greater than or equal to 60 points. The number of students with a score of 60 or more divided by the total number of students. This is the passing rate of the grade.

The above premise is that the total score is 100 points.

The total score is calculated on a 100-point basis. The passing rate is the number of people with a score of 60 to 79 divided by the number of people who took the test. The good rate is the number of people with a score of 80 to 89 divided by the number of people who took the test.

The merit rate is the number of people who score between 90 and 100 points divided by the number of people who take the exam. Good and excellent are not included in the calculation of the pass rate.

Excellent grades should be greater than or equal to 85 points. The number of students with a score of 85 or more divided by the total number of students. This is the rate of excellence in the grades.

The pass rate should be greater than or equal to 60 points. The number of students with a score of 60 or more divided by the total number of students. This is the passing rate of the grade.

The above premise is that the total score is 100 points.

How to calculate the rate of student achievement.

The pass rate algorithm is the number of students with a score of 60 or more divided by the total number of students. This is the passing rate of the grade. (provided that the total score is 100 points).

The formula for calculating the pass rate of the exam: the number of people who pass the exam The total number of people who take the exam 100% = the pass rate. For example, if there are 10 people who take the exam and the number of people who pass is 5, then the pass rate is: 5 10 100% = 50%.

1) If the result is divisible, then follow the calculated result.

2) If the result is not divisible, the rounding method is used, and 2 decimal places are kept by default.

Excellent grades should be greater than or equal to 85 points. The number of students with a score of 85 or more divided by the total number of students. This is the rate of excellence in the grades.

The pass rate should be greater than or equal to 60 points. The number of students with a score of 60 or more divided by the total number of students. This is the passing rate of the grade.

The above premise is that the total score is 100 points.

Enter the score (the first line is empty data text);

a column of selected grades;

Menus, Data, Filtering, Auto-Filtering;

Data column arrow, custom, condition = greater than or equal to 60;

It will appear in the status bar of the window, for example: 24 out of 30 records are found, which means that the pass rate is ......

How to calculate the rate of student achievement.

Calculate the pass rate: Take the calculation of the math pass rate in the following ** as an example, and take WPS 2019 as an example.

1. Click the passing rate cell and enter =countif(c2:c11,">=60")/count(c2:c11)

2. Pull the cross in the lower right corner of the box to the right, and the physical pass rate result is also displayed.

Excellent grades should be greater than or equal to 85 points. The number of students with a score of 85 or more divided by the total number of students. This is the rate of excellence in the grades.

The pass rate should be greater than or equal to 60 points. The number of students with a score of 60 or more divided by the total number of students. That is, the search rate of the results and the broad box.

The above premise is that the total score is 100 points.

Formula for calculating the excellent rate and pass rate of a student's grades:

Excellent rate Number of excellent people Total number of people tested x 100% Pass rate Number of people who passed (sum of total number of passing, good, and excellent people) Total number of people tested x 100%.

Elementary school. The standard of excellent Chinese and mathematics scores in grades 1 and 2 (100-point scale): 90 points and above in primary school.

Passing standards for Chinese and mathematics scores (100-point scale) for grades 1 and 2: 60 points for grades 3 - 6 grades of primary school Chinese and mathematics (100-point scale) Excellent standards:

85 points and above.

Primary 3 - Grade 6 Chinese and Mathematics (100-point scale) Passing standard: 60 pointsSecondary school subjects (excluding physical education) Achievement (100-point scale) Excellent standard: 85 points and above Secondary school subjects (excluding physical education) Passing standard (100-point scale):

60 points of excellent physical education standard: 90 points and above.

Passing standard for physical education: 60 points.

Excellent grades should be greater than or equal to 85 points. The number of students with a score of 85 or more divided by the total number of students. This is the rate of excellence in the grades.

The pass rate should be greater than or equal to 60 points. The number of students with a score of 60 or more divided by the total number of students. This is the passing rate of the grade.

The above premise is that the total score is 100 points.

How to calculate the rate of student achievement.

The total score is calculated on a 100-point basis.

The passing rate is the number of people with a score of 60 to 79 divided by the number of people who took the test.

The good rate is the number of people with a score of 80 to 89 divided by the number of people who took the test.

The merit rate is the number of people who score between 90 and 100 points divided by the number of people who take the exam.

Good and excellent are not included in the calculation of the pass rate.