At the end of the semester, however, I was called to do the graduate information form. Among the graduates of 2018, classes such as Chinese history can be said to be a large population. The information of dozens of people is very complicated, and I am really tired of going back and forth to the head teacher's office and my dormitory. The lengthy information dazzled people. The head teacher got the secret of the student status department and screened it to patrol more quickly. However, I was extremely lazy after all. So, through a series of convenient tools, I let myself lie in the dormitory to review, and helped the teacher finish the information sorting work of the graduate student on the way—— It's easy.
First of all, there is the problem of information synchronization. A form must be able to be edited and synchronized to the teacher's computer in real time after editing. Some people will say that QQ is used, but the transmission of QQ leads to countless redundancies. In the end, I'm afraid I can't tell which version. Those who can support such work in China, Nut cloud Is one of them.
I set the desk file of the head teacher as a shared directory, synchronized it to the Nuts ECS and granted my account a management permission, so I can edit the document on my computer. After editing, it will be synchronized to the teacher's computer about 30s later, perfect. Nut Cloud supports LAN acceleration. The world's first LAN is here, so the transmission speed is high.
Then, the problem is that I need to occasionally use the teacher's QQ to send some messages, and I need to be able to control the teacher's desktop. However, QQ's remote assistance function was not flattered, so I silently used what was once packed for me by Mu Ruoxi AnyDesk Connect to the remote desktop. It looks like it is finally configured.
I said that there are too many data. Unfortunately, Excel supports many functions. One of the graduate information is“ *Registered permanent residence ”The "dictionary" given by a superior leader has tens of thousands of lines. How can I find it one by one, or go to Ctrl+F? It's totally impossible, but fortunately, there is one match Function can be matched directly. If it does not exist #N/A In this way, you can instantly detect the problems of which classes and which students. If there are problems, the monitor, you have worked hard! (Yes, it's hard.)
In addition to this, there are also ID numbers and student numbers. Some students are one less len Function, you can directly calculate the number of words, and then select the one with different number of words through filtering. Don't you know whose information is wrong immediately? If you are wrong, the monitor, you have worked hard! (Yes, it's hard.)
As a result, it seems that the things that need more than N people to do carefully can be solved smoothly through several functions and two tools. It can only be said that technology is a necessary toy for lazy people.
Next, continue to preview.
Jiang Chen
2017.06.22
