Use WPS form to divide class

In the new semester, the division is a school routine work. Traditional methods are divided into classes in a certain order, which is assumed to be divided into 4 classes by grade, in the first round, 1, 2, 3 and 4 were divided into 1, 2, 3 and 4, and the second round, 5, 6, 7 and 8 were divided into 4, 3, 2, 1, and so on. In this way, Class 1 and Class 4 have the best and the worst students every two rounds. Take Class 1 As an example, divided into 1, 8, 9, 16, 17, 24 and other places, the gap between the two adjacent positions two times in the 7 is too big, another 1, too small, this will lead to a head teacher also has a small point of view.

Methods of improvement: the assumption is divided into 4 classes, the first round, 1, 2, 3, 4 are divided into 1, 2, 3, 4 classes; In the second round, 5, 6, 7 and 8 were divided into 2, 3, 4 and 1 respectively, and the third round, 9, 10, 11 and 12 were divided into 3, 4, 1 and 2 respectively; the fourth round, 13, 14, 15 , 16 to 4, 1, 2, 3 classes respectively, and so on. Analysis: From the above class process, because the next round of the best ranking to the next class, this ensures that each class in four rounds can be divided into the best, the worst and the middle of the ranking, the same 1 classes as an example, can be divided into 1, 8, 11, 14, 17, 24 and other places, adjacent to the gap between the two, four times only once for 7 , the remaining three times for 3, too small gap also eliminated, you can compare the other classes to the ranking situation, compared to the order of the class is much better.

The following steps are implemented:

The first step: input good student's relevant information, and arrange the order according to the result. As pictured.

　　

Now, it is in the class, starting with A2, to form such a sequence: 1, 2, 3, 4, 2, 3, 4, 1, 3, 4, 1, 2, 4, 1, 2, 3, and so on until the final student figure.

There are two ways to use this:

1, you can use the copy and paste method, that is, enter the above data, that is 1, 2, 3, 4, 2, 3, 4, 1, 3, 4, 1, 2, 4, 1, 2, 3 and then paste into all the data until the end. This method is relatively simple and easy to understand.

2, the use of function method: Add a column: number, respectively, enter the data below: 0, 1, 2, 3 ... Until the last student, then enter the formula in A2: =mod (int (E2/4) +mod (e2,4), 4) +1, drag the fill handle until the last student. The same sequence 1, 2, 3, 4, 2, 3, 4, 1, 3, 4, 1, 2, 4, 1, 2, 3 ... Until finally, as pictured.
　　

Then select all the data, and perform the data → filter → auto filter

Open the inverted triangle symbol at the back of the class, choose 1, you can get 1 classes of the student roster as shown,
　　

According to the required sorting, printing, complete the task.