Research on the Application of Computer Technology in Data Processing of University Chemical Experiment

University chemistry is a subject based on experimental verification, which is inseparable from instruments and data analysis. However, with the increasing complexity of university chemistry experiments, we need to use modern instruments for analysis, which can record experimental data more accurately. However, there are clear requirements for the processing of experimental data. With the different purposes of the experiment, we need different graphics and data analysis, which needs the help of computer technology. Through the computer technology, we can realize the automation of chemical experiment instrument operation, which can also automatically collect and transmit test data. Therefore, computer technology not only promotes the development of modern chemical instrument technology, but also improves the processing of university chemical experiment data. First of all, this paper analyzes the main application software technology. Then, this paper puts forward some examples for MATLAB and origin respectively.


Introduction
With the change of the requirements of university chemistry experiment, the university chemistry basic education curriculum of college students will be reformed, which will pay more attention to the exploration of learning process [1]. The correct recording, processing, induction and analysis of experimental data is the basis of forming experimental report, which is the basic requirement of chemical experiment teaching [2][3][4]. The traditional experimental data processing method is still manual processing, which will have many problems. However, the data processing process of university chemistry experiment is often ignored, which is difficult to accurately complete the experimental data mining [5]. Through computer technology, we can better mine the principles hidden in the experimental data. Through computer software, we can avoid the tedious data processing process, which will improve the accuracy of data [6]. We can find that computer software has been used in chemical experiment data processing, which has abandoned the traditional manual drawing method. Through computer technology, we can reduce the burden of students' experimental data processing, which will more quickly complete the complex mathematical problems of experimental data [7].

Computer technology applied in data processing of university chemistry experiment
The data processing of university chemistry experiment can be carried out through a variety of computer technologies. This paper mainly introduces the following common experimental data processing software, as shown in Figure 1.

Matlab software
Matlab is a commercial mathematical software developed by MathWorks in 1984. Matlab is based on advanced matrix language to process experimental data. Matlab can realize many functions, such as matrix operation, drawing function and data, realizing algorithm, creating user interface, connecting programming language program, etc., which can be applied in many fields, such as image processing, signal processing and communication, engineering calculation, financial modeling, University and so on. Matlab can write its own program, which can achieve data processing. The numerical calculation and drawing analysis of MATLAB are all realized by program language, which makes it easy to operate and the program is not complicated. The written program can be stored in the software and called repeatedly, which can directly call the original program to obtain data processing results. Matlab contains more than 600 kinds of functions, which can draw a variety of graphics, such as stereogram, three-dimensional rendering, animation and so on.

Origin Software
Origin is a professional drawing and data analysis software released by Originlab in 1992. It is easy to use and intuitive. Origin does not need to write program code, which can directly call the function for data analysis and drawing. Compared with the experimental results calculated by programming, origin can display more parameters in nonlinear fitting, which will make the fitting results more accurate. Origin's data analysis includes a variety of perfect mathematical analysis functions, such as data statistics, drawing graphics, curve fitting, signal processing and peak analysis. Origin's drawing function is based on the original template, which includes a large number of 2D and 3D drawing templates. Origin provides a variety of interfaces, which can easily connect with various databases.

Excel software
Excel has powerful function calculation function. Excel contains more than 300 functions, including text function, logic function, trigonometric function, logarithmic function, statistical function, search function, etc. We can process and analyze the data in most fields through various operations, such as data statistical summary, sorting and filtering, calculation and analysis, and searching at any time. Through the macro and visual basic custom function, we can meet the special requirements of customers. Excel software supports the call, edit, copy and paste of formula, which can perform advanced operation on the recorded data. Through mixed operation, Excel software improves the efficiency and accuracy of manual calculation. Although excel has powerful data analysis function, it can be used as the basic unit of data processing. By making the basic unit into an electronic template, we can call out the corresponding template to complete the parameters of the experimental drawing.

Data processing method
Through Excel, we can make the data processing template for the corrosion experiment of steel bars in concrete determined by the tow electrode method. In the corresponding position of the template, we can enter the original data of the first line. By activating the corresponding cells, we can get the original data spreadsheet, as shown in Table 1.

Data processing results of origin experiment
To open origin, we can select Open excel in the file menu, which can open the table in the way of origin worksheet. At the same time, we can choose time t and self corrosion potential E to plot. By selecting layer contents, we can synthesize all the data, which will be drawn on the same graph, as shown in Figure 2.

Figure 2.
The average potential of the wire is negative. Through the powerful data analysis and tabulation function of Excel, we can make chemical experiment data processing template. Then, we can directly import the data needed for mapping into origin mapping, which is a simple, fast and accurate process. Through origin mapping, we can draw detailed and beautiful graphics. The processing of experimental data by origin not only stimulates students' enthusiasm for learning physical chemistry experiments, but also saves a lot of time. Through origin, we can cultivate students' ability to learn chemical experiments by means of modern technology.

Data processing method
In the potentiometric titration analysis of analytical chemistry, we need an accurate method to get the titration end point. Several groups of (E, V) data measured in the experiment are used to draw E-V curve, which requires the first derivative (Δ E / Δ V) value and second derivative (Δ 2E / Δ V2) value of e to V of each group to draw curve. Through the curve, we can better determine the titration end point. In traditional calculation, the inflection point of titration jump can be calculated by interpolation method, which will increase the corresponding volume of titrant. Traditional calculation requires manual drawing on coordinate paper with calculator, which generally takes 2-3 hours, which will lead to the accuracy of reading titration end point. Through the function "diff" of MATLAB software, we can get the differential of E and V, as shown in Table 2. Then, we can get the first derivative and the second derivative.

Matlab experimental data processing results
Through this program, we can draw three kinds of potentiometric titration curves, as shown in Figure  3. According to the line ratio, we can calculate the titration end point (VEP = 24.34ml) by interpolation.

Data processing method
A group of experimental data is obtained through the demonstration experiment, and the experimental data is entered into the excel table, as shown in Table 3.

Nonlinear fitting
According to the experimental data, the fitting result of power function is the best, as shown in Figure  4.

Conclusion
Through computer technology, we can reduce the burden of students' experimental data processing, which will more quickly complete the complex mathematical problems of experimental data. Computer technology has greatly improved the efficiency of laboratory work, which provides a strong support for the development of chemistry.