| In recent years,professional certification has received more attention in college education,and the requirements for the information management of professional certification work are becoming more and more stronger.According to the professional certification standard of Engineering Education(2018),analyzed the data management requirements and graduation requirements involved in the professional certification to reach the evaluation process,the management system of engineering major graduation requirements to achieve adds and optimizes functions to achieve upgrades.The main work is as follows:First,analysis of teaching information management standard,the system establishes the teaching information management standard with curriculum outline,test paper,teaching class and achievement as a whole.The system have finished some corresponding function modules.Second,analyzed the evaluation mechanism of graduation requirements and practiced concept about ‘course as the core’,the system have developed an evaluation mechanism based on graduation requirements.The system have finished some corresponding function modules.Third,data characteristics were included by analyzing and classify system data.The system have used principal component analysis to analyze course score data,because data characteristics and comparison of multivariate statistical analysis methods.The feasibility of the system is verified by an example.Design and implement data warehouse of course score statistics and analysis in the system.The system have finished some corresponding function modules.Fourth,the problems of system database are a large number of data tables,complex relationship and large amount of some tables data.A plan to optimize data display is proposed.The system have designed the data warehouse,which was used to optimize data display and analyze course score data.The system have verified the feasibility of the scheme by developing the functions of professional score query and teaching score. |