Exam System maintenance-overall & amp; details, Exam System Maintenance overall

Test System maintenance-overall & details, test system maintenance overall

The preliminary work for exam system maintenance has been completed successfully! What makes people feel most successful is that there is no problem in the entire examination process, and I feel very proud! This directly proves that the children's hard work is worthwhile. However, nothing is worthwhile. In the end, the most popular problem still emerges, however, what is different from the previous one is that we have no tension with those problems, and there are solutions and ideas to solve the problems afterwards. Of course, these are all from the hard work of a teacher mi.

Two important problems have emerged throughout the process:

Question 1: Network interruptions during the exam

Question 2: The test is over and the English teacher scores

As far as problem 1 is concerned, this problem is not actually caused by humans. However, after this incident occurs, the rest of the problem is really delayed due to insufficient preparation! After the network ping fails, we decided to change the server to allow the students to continue the test. However, it is a pity that we did not have enough preparation for the 251, and the thought we want to express is: when everything is ready, everything is calm. If you don't get it, wait. The storm will come after all ......

According to the normal steps, we should make the same preparations on the 1949th and the 1949th, but we have not encountered any problems due to our previous tests, so when we really need backup, everyone is relaxed! In the end, there is no way to restart the 207 server, so that all students can answer questions again and the exam time will be extended by one hour! After the problem is solved, let's review the details. What we need to reflect on is that, as we have already started, all the difficulties of this customer service have been solved, why don't I give up when I finally want to succeed? When repetitive things need to be completed, it depends on everyone's care and persistence! Although it was very difficult at the beginning, it was very slow, but since we have already experienced it, when we do it repeatedly, it is so easy. Sticking to the end is a waste of time. In fact, the payment is the same, but the harvest is far from the difference, it is worth reflecting on.

Concluding remarks:

It is best not to make mistakes. When you want to make mistakes, you must look back ...... (Just a joke) Be careful when you get caught!

Question 2: The determination is really a painstaking effort by everyone. There are also all kinds of errors and troubles of beautiful teachers. In fact, there is a really unbearable time in the whole process, but when I saw the battle between teacher Mi and the beauty teacher, I realized why I had to complicate things every time. I had the opportunity to grow myself one by one, I almost missed it again ...... If this group of beautiful teachers are not talking about our progress and growth. Of course, these experiences were learned later. Before that, I always felt that if the teachers did not interrupt, we may have solved these problems early. However, if we had no teachers talking about it, we would not be under pressure, will we solve these problems in a short time? The problem will certainly be solved, but I think the time is definitely not so well controlled! So I want to learn from Mr. Mi. Thank you to the beautiful teachers!

Major problems:

1. When I imported the question library, I accidentally poured an answer! The error score with N decimal points is displayed.

Solution: directly update the score of corresponding student questions in the database, and use the most direct SQL statement update method.

System Optimization: This solution directly targets instructors and saves some trouble. It makes full use of others' strengths and supplements their weaknesses.

2. Check that the test data is incomplete. As a result, the student's test score contains the test data on the 16th.

Solution: Back up the complete database, restore one copy, and delete the test data according to the test time.

Situation explanation: because the information in the entire system is directly associated with the merged table, because all the answer records were not merged during the previous test, only a small part of the test was performed, so when students merge again after the exam, some dynamic information before the database is merged! Therefore, the test information is displayed.

3. Why does the database Virtual table contain information? After verification, I confirmed that the information was the student of the test, not the virtual number. Why did it go to the virtual table?

Cause analysis: the data dictionary is used in the examination system, but the abbreviation of the College is directly imported into the examination system, which is not considerate when the student information is imported, as a result, when the schools are looking for data, they ignore the abbreviations of your students in the school. They mistakenly entered the virtual table. Fortunately, the data was not lost.

Solution: update the information of the wrong school to meet the dictionary requirements, and then solve the problem.

......

There are a lot of errors and a lot of GAINS. However, there is still a big problem behind it: lack of overall view! Be careless and not serious! How can we solve these two problems?

After the experience, the student will grow up. After the students finish the examination, they will happily go home, and the teacher's score will barely pass! The rest is to solve the problem. Come on!

Step by step, step by step; step by step, step by step

------ Personal experience