High School Teaching Assessment And The Design And Accomplishment Of Information Query System

In the current secondary education, no great progress is made in the evaluation of teaching effect based on initial average score, passing rate and not passing rate. The evaluation methods tend to be more and more modern, and the operation of evaluation still mostly depends on EXCEL form which is operated by human. It is obvious that such evaluation is ineffective and unreasonable. Thus, this phenomenon has decided that only the school and partial teachers can thoroughly learn about teaching effect; however, as the subject of the whole teaching process, many parents cannot know clearly about the learning conditions of their children.This thesis focuses on the present issue about making students’scores become more reasonable through Gaussian Distribution of the results. SQL and Server are used as the Students’ Score Management System to make it effective and automatic. Meanwhile, the weighed average number and regression equation of data statistics are provided to realize more reliable students’ performance prediction. Data warehouse, On-Line Analytical Processing and Data Mining are used to predict the kinds of senior schools that students will be admitted into through the application of NET so as to make each subject participate in teaching process conveniently, and the allocation of different roles of users ensures the security of data. Finally, the teaching evaluation of senior schools and Information Query System are designed and realized with the help of the technique currently owned by the school.This information system involves Microsoft, SQL, Server and 2008+Web. Server is used as solutions in Visual Studio 2010 environment, while SQL Server is used during the implementation process.On-Line Analytical Processing and Reporting Services provided by 2008 provide users with query information. The system emphasizes the design and creation of the Data Base and explores the structural design and creation of Data Warehouse as well as the preparation of the data source, the extraction, transformation and loading of the data, In the process of system implementation, On-Line Analytical Processing and C4.5 decision tree algorithm specialized of Data Mining are mainly studied.This system realizes the evaluation of teaching effects and the assessment of learning effect in high school teaching management and helps to predict students’ scores and universities that students will be admitted into. Meanwhile, it enables the school and parents to clearly know about learning condition on the Internet.