The Students’ Comprehensive Ability Evaluation And Analysis System Based On ISchool Database

With the quality of life and national improving, more and more attention has been paid tothe education industry in recent years. Education is the basic way to improve the nationalquality. Along with the introduction and usage of various kinds of education system, the studyinformation of students is explosively growing. It is becoming a hot topic about how to usethe information to analyze the learning ability of students objectively in order to improve theirlearning effect. In this paper, we build a system named students comprehensive abilityevaluation and analysis system based on the iSchool data. We have implemented the systemaccording to user requirements, and described the specific process of system in details.This paper focuses on the students’ comprehensive ability based on the system, mainlyimplemented the following several aspects work:(1) Perfect the system requirements, define the system boundary, establish case diagramfor different users from the perspective of different users and roles.(2) The paper not only has been given integrated design of the system, but also identifiedthe software architecture and the database design. The system is divided into three subsystemsfor teachers, school administrators and system administrator respectively. The function ofsubsystems is relatively concentrated, so that the coupling between subsystems is reduced.Besides, we have designed the structure optimization of database conceptual model andlogical model, according to the software requirements and practical applications.(3) Design the system architecture. The three-tier architecture: Business Logic Layer,Data Access Layer and Presentation Layer. The Presentation Layer is used in the interactionwith the user, to check for user input data, give the corresponding prompt information orprocessing results, and send request to the Business Logic Layer. The Business Logic Layerrealizes the business logic or algorithms, send data operation request to the Data Access Layer,provides results for the Presentation Layer. The Data Access Layer finishes the function ofdata read and store. In consequence it reduces the coupling between layer and layer. Besides,the design of code turns out to be clear structure and perfect function. In order to make users get a good experience, front-end of the system uses the jQueryand Ajax technology, which can enrich the man-machine interaction experience. CSSframework, which uses the Twitter Bootstrap, can solve the problem of the compatibilitybetween different browsers. Even if the system is used in mobile phones, tablets and othermobile client, users will not feel the difference. The system uses the Apache Shiro securityFramework, which gives different user role authorization and guarantees the security ofsystem, for preventing the data from theft or tampering.(4) The implemented of main functions: information management, information queryand data statistics. The data statistics can be shown visually to users by using the visualizationtechnology.(5) The student ability analysis algorithm based on decision tree. The system gets thelearning ability of students by take advantage of the iSchool database. Thus we can helpstudents to improve learning effectively.