How to make student record registration form

How to make student record registration form

Teacher in charge of a friend of the semester must be made to produce student registration form, like the following this excle table how to make it?

1, the first is to enter the corresponding column headings, student names, students ranked in rank, because the current ranking is sensitive topic, is to prohibit, you can also be replaced by other names. You can also hide this column.

2, the student's serial number naturally does not need one one to enter, in the Excle table you just enter the first, second student ordinal number: 1, 2, then drag in the lower-right corner of the 2 box (this is the autofill); In the WPS table you just type in the first one and then automatically populate it.

3. Calculate total score In this case, you simply enter or select "=sum (d2:e2)" (without quotes) in the F2, and then drag in the lower-right corner of the box in the F2 pane.

4, calculate the rank: In this example, please enter "=rank (F2, $F $: $F $53)" (without quotes) in G2.

A brief explanation: =rank (F2, $F $: $F $53) refers to F2 in this score from F2 to F53 of these scores in the rankings, the reason to be in the right range f2:f53 plus $, is the absolute reference, tell the computer not to think smart to Lenovo, extrapolate, the following ranking to understand as a g3= RANK (f3,f3:f53), G4=rank (f4,f4:f53) ... And F2 does not add $, is to let the computer extrapolate.

5, calculate the average, this is common sense. Please enter or select =average (d2:d53) in the D54.

6, the calculation of performance zoning. Please enter =countif (d2:d53, ">89.9") in the D55 to let the computer count the number of good scores over 89.9.

In D57, enter =countif (d2:d53, ">79.9")-countif (d2:d53, ">89.9"), Let the computer count a number of better than 79.9 of the results minus 89.9 good results, that is, we say the test of more than 80 points of the number of students.

The rest of the analogy.

7. Calculate the percentage of the score partition. Entering "=d55/$A $53%" In the D66 indicates that the number of students with more than 90 points in D55 is divided by the number of students in the A55, and that is also to avoid computer extrapolate. Others can be analogy.

8, if you feel trouble, please download the template, with the largest number of second-year worksheets, the class of students in the name of the grade entered, and the extra line can be deleted.