The Student's Achievement Administrative System Based On B/S Structure

As the rapid development of information technology and network technology, the school's day-to-day management of teaching is also subject to the affect of the information acquisition, processing and the ability of the communication. The student achievement management as one of the day-to-day management of teaching management's important parts, its content is very crucial for the managers. A good student achievement management system should be able to provide adequate information for management and decision-making. In this paper, the student achievement management system is suitable for the public. It has good compatibility. the system has certain scalability, maintainability , standardization and automation which are the goals of the system's development.The traditional student achievement management system has relatively shortcomings in low efficiency and poor confidentiality. Its update and maintenance have brought a lot of difficulties. The system uses ASP + SQL Server2000 technology, achieving the WEB-based management system of student achievement management system. It uses SQL Server2000 to complete the data query and analysis functions in this system. And it apply ASP (Active Server Pages) scripting language to achieve the server side functions. Users can access the system through the browser. ASP, a server-side scripting environment which is developed by the Microsoft, is a very good tool to create dynamic pages. Since the role of a programming language, you can use it to compile the dynamically generated HTML code. Therefore, as long as users visit the Web site and request an ASP page, the Web server can handle the corresponding ASP code, generating HTML code. And then it will be delivered to the user's browser and show the page. ASP procedures do not have to compile. It is easy to write and in direct implementation of server-side. It can use ADO components easily to access to the database. As long as use the executable code HTML browser, the clients can visit the web content which ASP designed. ASP has the compatibility with any ActiveX scripting language. It's technology processing has a fairly rapid pace, and their safety is also very high. ASP has its own seven objects.SQL Server2000 is an upgrading production is expanded in the basis of SQL Server7.0. SQL Server2000 inherited the database software design and the engine's advantage have become a new generation of network applications and one of the database analysis of the best solution. It provides full supports to the XML and HTTP and separate loading time. And ensure that the characteristics of the full use of the Windows 2000 features, including supports for Actives Directory (Active Directory) and supports up to 32 processors and 64 GB of memory. SQL Server2000 has a greater stability and reliability. SQL provides orders for many task which are the public relational database languages. All the public relational database languages are wrote in SQL can be replanted.This system includes student achievement enquiry system, initialization information system, achievement report forms printing and information search system. Implementations of the system are students query results online, student achievement recording and on this basis the corresponding statistical data and finally realize statements output. The system requires that every teacher can only record the achievements of their own course. It can realize individuals responsibility system. It can set system initialization, including schools, colleges, professional, courses, teachers, and other information. And the system can be backup and recovered. According to the conditions of users, teachers or students information can be searched. In addition, from the economic and technical point of view the system is also feasible.The system uses a structured analysis (Structured Analysis, referred to SA method), top-down, and gradually decomposition. It abstracts the system to data flow diagram. As processing the gradual decomposition, data will also be decomposed step by step, forming a certain level of data flow diagram. Data dictionary is the system described in various types of data collection, including items of data, data structure, data flow, data storage and processing of five sections. This paper shows the important data and its description.The system consists of the prospects and the background. The prospects include the modules for student achievement querying (for results and related support functions). The backgrounds include some modules on the system initialization settings, and the results recorded statements of print module, information searching modules, database backup and recovery, and the system helps. The prospects designing require the students should be entering their own account numbers and passwords to query the results. The failure will have different tips. The background designing require that in the use of the process, according to the different teachers with different permissions it will do the corresponding operations. Based on this, the system includes modules for individual student achievement, setting system module, and the results recorded statements of print module, searching module of four modules. As a whole of the four modules, the interface is clear and simple and it can be expanded, improved the data importing and exporting, maintenance, self-inspection of high-performance, user errors, lose all the wrong tips, fault-tolerant high-performance.The overall structure of the system transfer a menu form, using a form to manage the information, data processing, information requiring, system maintenance work. In the student achievement query module, the students can sign their account numbers and passwords in the window of the students enter on the home page. When students enter the user query results page, you can query the results of each course. You can also be conducted for all the achievements, and may carry out all the achievements statistics courses, including credit performance of the points. When they query the results of each course, they can not only view the results of the courses, but also can have a further understanding of their information, including the school curriculum, credits and other information. In the system settings modules, it is divided into nine parts, such as schools, colleges, professions, courses, classes, students, teachers and information database system were all set up. In the results entry module and print statements, the statements have three printing methods, namely: credit statements printing, print results statements, rehabilitation statements printing. The users can print them depending on the need for different functions. The three printings all have classes printing. In addition, in the rehabilitation of the courses, print statements also have increased the classified name printing function. On top of that the system also has a function to change the web page form into the Excel in the informational searching module. In the searching information module, it will be divided into two parts. One is conducting a search of the students and teachers'basic information. In terms of the indiscriminate entering the students'names, accounting numbers of students, teachers'names, accounting numbers and the courses of teachers and other options. To meet the conditions for the students or teachers, adding a revised function. Another one is the searching results of the students. Managers can choose the corresponding courses scores conditions, and find all the conditions which meet the scores of all students records. The function is to facilitate the teachers to make the best understanding of student achievements in an effective way. When using it, we can select multiple conditions enquiries.The concept of structural design is the key to the entire database designing which is the common basis of the data models. It is more independent of the machines, more abstract and thus more stable than the data model. In this paper, the system's overall plans and information subsystem ER map are given. It will be converted to ER plans and choice of DBMS products supported by the data model in line with the logic of the structure, and then to support this model of data DBMS to compare and select the SQL Server 2000 database server as a background. On this basis, determine the physical structure of the database, and an evaluation of the physical structure of the system is designed to ensure that the database of various services running on a shorter response time, storage space utilization, through put Affairs, is Optimization of a comparison of the database structure.This system of rights management is very necessary, we will system is divided into four categories of users: senior manager, responsible for setting the basic information, teachers, students of information management (including search), recording and reporting of the results output The management of the system's basic maintenance (backup and recovery); manager, responsible for monitoring the performance of this sector input, the completion of this sector all statements of print; ordinary teachers, responsible for the achievements recorded, print statements; ordinary users, that means the ordinary users Students, students in the Home users can only log in the entrance of students, and the results of their inquiries.The implementation of this system is connecting to the database and increase, amend, delete, query, and other operations to the database. In addition, the use of the CSS style can landscaping pages. And the use of JavaScript scripting language can deal with some of the pages for special effects. The system will link the database to create a separate document to enhance the readability.It also gives the system of testing and analysis of results, the conducted unit testing and integration testing. And Black Box Testing and White Box Testing excluded some possible errors.It has a good fault tolerance. The basic system availability achieved the expected goals. Finally, the text has a full summary, and puts forward what the system should be done in the next step.