How to quickly import student information in the light speed cloud online examination system?

Using the online examination system to import student information is mainly because it is difficult to apply for student accounts here. In an organization, it is necessary to ensure that all student accounts are different, so when creating student accounts, we must figure out how to solve the problem.

Because importing students needs to allocate account information, it mainly involves the processing of Excel tool tables. As long as this is solved, you can quickly import student information.

First log in to the management background, select "Excel Import" in member management, and then download the Excel template.

Open the downloaded Excel template and fill in the student account in the first account cell, as shown below. The first account cell is A3, and we fill in the student account 2020 100 1.

Enter "=A3+ 1" in the next student account, and then press Enter.

Next, you will find that the cell "=A3+ 1" automatically adds 1 on the basis of 20201and becomes 2020 1002.

Move the mouse to the lower right corner of A4 cell, and you will find that the cursor becomes a cross.

Hold down the left mouse button and drag down.

The selected area forms a arithmetic progression with a tolerance of 1, thus ensuring that each account is different.

Finally, save this Excel form and import it directly. As the password part is left blank, the initial password of each student is 123456, which can be modified by students themselves after logging in.