Analyze student test scores with philosophy specific problem specific analysis principles Rankings.

If you have encountered such a problem before, you should not be frightened by the words "specific analysis principle" of specific problems, to put it bluntly, it is to analyze your results as usual. For example, your overall view of the grades, specifically analyze the situation of your papers, the learning situation, this can be done very simply, and today's teachers often ask students to do these useless work, you can just write and deal with it.

To give a simple example, for example: I am relatively satisfied with this result, the usual review is relatively in place, the test score basically reached the expected score, the undesirable is that the performance is not good, I forgot a few formulas, and so on.

It's the same about rankings, you can even go and scold, for example, I'm not satisfied with the rankings, I'm very satisfied with my grades, the rankings don't reflect my true level, in fact, I'm improving compared to myself, the rankings can't say anything except that I'm a little slower than others, and it has had a serious impact on my mental health, so I recommend that the school stop ranking, otherwise all psychological problems will be borne by the school in the future (hehe, to put it bluntly, it's to make up the number of words, Don't write as I say, I'm just scolding the teacher for being a brute, and he's like a deaf man).

As long as you can insist on reviewing, mathematics is not a problem in professional courses Not to mention, the exams are all basic things, very simple, many schools also have tutorial classes for professional courses, and it is not a problem to study hard in the end.

Learning is your own business, and what kind of height you can learn is a matter of talent.

Is it funny to always put that pitiful pride and vanity on the teachers and the school!

Yes, fairness should be guaranteed and the child's self-esteem should be maintained. The evaluation system for students should be diversified and avoid monolithic. Students should be encouraged and appreciated, and students should not be hit too hard.

For example, if the first test is a score, for example, the first test is a score B, there are 3 columns, and if you enter "=A-B" in the first column A, the second column B, and the third column, the difference between the two scores will be automatically calculated.

Use the vlookup function to put the second grade after the student's name.

You can use subtraction to go up and down twice, the first score - the second score, the positive score decreases, and the negative score increases.

Minus, use counif in the difference column to count more than 0 is less than 0, and you will know the rise and fall.

In order to reflect the fairness and fairness of the test results of information technology courses, better serve the teaching, and improve the enthusiasm of teachers and the pertinence of teaching, we need to carefully analyze the test scores of students, according to the regular data statistics, according to the average score, the score of each class analysis and evaluation, such quality analysis can not be the specific analysis of the problems existing in the teaching of information technology, can only superficially evaluate which class is good or bad, can not play a real role in the analysis of teaching quality. Therefore, it is necessary to take random sampling of the test scores of some students in each class, and use excel to carry out corresponding statistical analysis, especially to analyze those knowledge points that are well mastered, those knowledge points should continue to be strengthened, and how to teach in the future, so that students can understand and grasp firmly, and accordingly improve students' academic performance.

Comparison of scores in each subject – reflects whether the student is biased towards the subject and whether the student has hobbies.

Comparison of previous grade changes – reflects the progress and decline of students' grades, as well as the degree of mastery of learning content.

The distribution of grades in the class to understand the degree to which the environment affects the individual. Wait a minute.

A statistical ledger of student performance can be established to facilitate intuitive analysis, identify gaps and causes, and be targeted.