Research And Implementation Of Office2007Examination Paper Automatic Rating System

For a long time, due to the strong subjective operability of the operating title of the Office (Word, Excel, and PowerPoint), its more accurate automatic scoring has been a problem. Although so far have a lot of the automatic scoring system in this regard available in the study of a large number of literature and examines the characteristics of the existing system, it was found that the existing system is mainly built on Office2000or Office2003on the basis VBA macro language combined with the OLE technology to write object-oriented programming to achieve the automatic scoring of Office Operation, the proposed solution has many inadequacies.Abandoned Office2003documents automatically marking the ideas and methods to use VBA and OLE technology, proposed a new solution. The solution is based on the Office2007software. According to the Office2007document using the Office Open XML file format, the corresponding XML files extracted from the standard answer to Office2007document and the students’ answers to the Office2007document and the information processing of the extracted XML file, by the method for comparing two documents information to the automatic scoring of the Office2007document.Taking into account the basic course of computer applications used Office software to the2003version. The article added to the module of the Office2003 document for Office2007documents in order to achieve the system is compatible Office2003documents.The paper focuses on the automatic scoring algorithm based on string similarity model in comparison document. The algorithm model is introduced in calculating the string similarity edit distance algorithm. The rating of the algorithm in line with the linear rule, the score and the number of errors is score file a linear relationship.Automatic scoring test of about5700copies of Office2003documents, the actual test data show that the algorithm in the text of the score in line with the linear rule, Word2003document, Excel2003document and PowerPoint2003documents automatically score the scoring error rates were2.45%,2.05%and1.49%. In the environment of the ordinary PC, the system marking the number of documents from about200to achieve a single document marking rate maximum.