Study on the Design of Campus Network-based Personalized English Teaching Platform

College English teaching is in urgent need of a platform which may improve students' initiative in English learning, raise learning interest and enhance English teaching management, in order to improve students' English level and facilitate the teacher's English teaching management. The popularity of campus network facilities in various universities provides hardware support for the establishment of a personalized English teaching platform based on campus network. The study is aimed at designing a personalized English teaching platform based on campus network, which takes VBSCRIPT as programming language and SQL Server as database software of the platform, completing the interactive processing of the data based on the data structure of client computer/server (B/S). First, the paper introduces the relevant teaching and education theories, laying theoretical and technical basis for the design of personalized English teaching platform in combination with the computer technology used in the design of the platform. The combination of questionnaire and analytic study is used in the design of the system from various aspects, and makes the design of the platform come true. At last, the testing of the system verifies that the system meets the relevant functional requirement. The platform would provide an open environment for English learning and stimulating the guidance of teachers and is of great significance to improve the level of college English teaching. Keywords—campus network; personalized teaching platform; VBSCRIPT; SQL server; B/S framework


Introduction
English, as the most widely used international language, has its self-evident importance. The foreign language proficiency of college students has a direct impact on their employment after graduation and study abroad. In recent years, college English learning has been weakened by lack of effective motivation and English learning environment, so that college English education and learning have been stagnant in ordinary colleges and universities [1]. Examination-oriented education and coping learning are becoming more and more serious in college English teaching. The study and design of a personalized English teaching platform based on campus network is the effective way to address the issue and the platform may not only stimulate stu-dents' initiative and interest in English learning but also improve the management level of English teaching [2].
With the rapid popularization of computer networks, the construction of campus networks in universities has begun to take shape. Most colleges and universities have their own independent campus networks with a set of independent campus network management system [3]. At the same time, the application effect of network teaching and computer aided teaching has been verified. Therefore, it is worthwhile to use the campus networks to provide students with an English learning platform and thus help college English teaching. The paper first introduces theories of the personalized learning and constructivist learning, with a focus on the major role of leaners and guiding role of teachers in learning [4]; then uses VBSCRIPT as the programming language of the platform, on which the data interaction is realized between Web browser side, WEB server and background SQL data based on the data architecture of B/S, and adopts SQL database technology, which may facilitate the diversity of English teaching contents, teachers and students' visits and the overall management of English teaching. In addition, the paper analyzes the requirements of teaching platform, system framework and system database, and improve the functional requirements of the system with questionnaire and research analyses [5]. Finally, a personalized English teaching platform based on campus network is designed: students can learn and master their own learning dynamics and English scores according to their English proficiency; teachers get a full understanding of the students' learning status and play a guiding role. The design of the platform would promote the development and application of college English network teaching, and provide a teaching platform, which meets the needs of both teachers and students in college English learning.

2
Introduction to Education and Teaching Theories and Computer Technology

Education and teaching theories
Personalized learning. Related scholars believe that personalized learning is mainly divided into such five perspectives as users, system, process, output and strategies. Personalized learning refers to that students choose their own learning content and learning path based on their own characteristics and needs. Personalized learning is not an isolated self-learning, but also includes the improvement of the personality development through cooperative learning [6]. The system for personalized learning should have the learning materials in the form of information customization, with which learners can customize the learning contents according to their own needs; if the system lacks relevant content, learners can search the relevant resources through the Internet and customize the required contents in the personal learning system, creating an open and independent personalized learning environment [7].
Constructivist learning theory. Constructivist learning theory stresses the learner-centered and believes that learning is the process of learners' active construction of their knowledge and the process of cognition and reconstruction of the original knowledge base. Learning involves not only passive teaching, but also active knowledge acquisition. Of course, constructivist learning theory does not ignore the guiding role of teachers [8]. In constructivist learning theory, the requirements for students and teachers are as follows: Students should: (1) learn to use exploration and discovery; (2) actively collect and analyze data and information, make higher assumptions about learning contents and try to verify them; (3) build the relationship between "connection" and thinking, and improve the efficiency and quality in the learning process.
Teachers should play the role of facilitator and facilitator from the following aspects: (1) stimulate learning interest and form learning motivation; (2) create a learning situation, give relevant hints for learning, and help learners understand the meaning of the knowledge; (3) organize group discussion and exchange, and guide the process of collaborative learning.

2.2
Computer technologies VBSCRIPT programing language. VBSCRIPT, abbreviated as VBS, is a scripting language developed by Microsoft and a simple version of Visual Basic [9]. VBS is Microsoft's lightweight interpretation language and also a default language for dynamic Asp web programming, and together with Asp and ADO objects, users can master Asp dynamic web development technology.
VB Script is usually applied in following three practical aspects: 1. Windows operation, mainly used to perform automated, completed and repetitive operating system tasks; 2. Web browser, the client's web browser is directed by the web VBS to realize dynamic HTML; 3. Web server, the program code for VBS is directly embedded into the HTML page with ASP as the end. The program in the ASP page transforms the execution structure into the HTML to be used by the users in the web browser [10]. In this way, the server puts the corresponding results into the HTML web page. VBS does not pose a major burden on server load and is easier to control. Used in most Windows operators, it is a transfer to conveniently implement other programs, including office programs. SQL Server database. In this paper, SQL server database is used to conduct data management of personalized English grammar test and diagnosis database data, and is a database of distribution. Structured Query Language -Structured Query Language, or SQL Language, is a database query and programming language for accessing queries, updating, and managing relational database systems [11].
Four parts of SQL and their functions are as shown in Table 1. Application regulations Specifies that the SQL statement is used in the program of the host language B/S framework. B/S framework (Browser/Server model) is a pattern of network architecture after the emergence of the WEB, which is the most important application of the clients. The model unifies the clients, centralizes the core of the system function to the server, and simplify the development, maintenance and use of the system [12]. With just a browser stalled on the client such as Netscape Navigator or Internet Explorer, such databases as SQL Server, Oracle, MYSQL and ACCESS are installed on the server. The browser interacts with the database through the Web Server with the data structure framework as shown in Figure 1:

3
System Requirement Analysis 3.1

Questionnaire of system requirements
The personalized English teaching platform, aimed at improving students' autonomous learning ability, is a reform of the English teaching process. The needs of students and teachers should be the primary goal of system. The system should grasp the students' interest in English, purposes and main ways of learning; and subdivide the requirements for teachers in various aspects [13]. In this study, a questionnaire survey is conducted to master the system requirements of students and teachers on the personalized English teaching platform.
Designing the questionnaire. Due to the differences in requirements between teachers and students, the questionnaire is divided into two categories: teacher questionnaire and student questionnaire. The questionnaire involves with the aspects of platform openness, functional interface design and practice test design, which corre-spond to modules such as teaching strategy, function module, question setting and interface setting.
Sampling. The subjects of this paper are mainly non-English majors, as well as relevant English teachers. 300 questionnaires are distributed to college students with 29 valid questionnaires collected; 20 questionnaires are distributed to teachers with 20 valid questionnaires collected.
Results of questionnaires.
Investigation on system openness. 78% of the students surveyed said they had no access to online English teaching platforms. For the Question "Why choose the English teaching platform", 26% of the students for consolidating the content learned in the classroom, 23% of the students for preview before class, 22% of the students for expanding knowledge and 29% of the students for evaluating learning effect. In 20 questionnaires for teachers, 90% of the teachers think that the traditional classroom cannot be replaced by the online English teaching model. 96% of teachers are satisfied with the open mode of online learning platform and express that they don't want to intervene the learning progress of students in the online English learning [14]. Therefore, students and teachers expect to have an open network environment to provide them with an autonomous learning platform.
Realization of functional interface design. The modules such as unit test, score statistics, textbook knowledge development and English grammar explanation reflect the students' learning process at the same time. And practice and practice management are the functional interface that the teachers are more concerned about [15].
Practice and test reminders. From the evaluation statistics on the setting of questions by students as shown in Table 3, the multiple choice question is the most popular question of the students surveyed, and questions to be manually filled in the blank is the most unpopular type.  Non-functional requirements of the platform. Non-functional requirements include reliability, security, easy to use, interoperability, maintainability and extensibility.
1. Platform performance. For the personalized English teaching platform, the performance indexes mainly include system response time and system load. This design meets the online learning of at least 200 English students at the same time. 2. Security and reliability of the platform. The system has the login module, and the unauthorized users cannot access the system question bank. The features of the campus network may also prevent malicious attacks from outside networks. 3. Maintainability of the platform. The maintenance can be conducted directly on the server side, directly changing the defects of the module on the server side. 4. Environment requirements for platform development: Operating system: window XP, Window 7, 8, 10 Server; Database: SQ Server, 2003; Development tools: Edit plus; Development language: VBSCRIPT; Web server: IIS 6.0. B/S model: Win7+IIS+SQL Server, Client: IE6.0 and above browser.

Framework requirements of system functional modules
From the overall functional framework of personalized English teaching platform based on campus network as shown in Figure 2, the platform focuses on meeting the needs of students, giving consideration of meeting the needs of teachers and administrators, to meet personalized learning and constructivism learning theory. There are different types of sub-function modules under the system's main function module. There are learning records, wrong records, personal management and other sub-modules under file management modules; the student management module includes approve students, inquire students, cancel students, edit students, and review students; test management module has three sub-modules such as add questions, delete questions, and edit questions.

Analysis of database requirements
Autonomous learning is the core of the platform, and the database design is related to system performance and data integrity. The data table design for database is the basic unit of SQL sever data storage, and data tables are used to record and save data, which are independent but related to each other in the system. The basic information of teachers, students and administrators is stored in the form of data tables as shown in Table 4 for teachers. Not only the types of users, but also different types of questions such as multiple choice questions, structural questions, translation questions and basic exercises have their different types of data storage models.

Detailed explanation of the function of student learning modules
In order to further explain the detailed functions of English learning on the system platform, the student's English learning business process is illustrated in detail in Figure 3.

Realization of Personalized English Teaching Platform Based on Campus Network
According to the design idea required by the system, the programming is completed by using SQL language and VBSCRIPT language, and the system interface is tested accordingly.

System interface
Firstly, the system login interface is designed mainly to meet functions of the user system login, password recovery, and new user registration. The login interface of the computer learning system for personalized detection and diagnosis of college English grammar is shown in Figure 4. Figure 5 shows the main page of student learning, whose interface function is consistent with system requirement analysis. The screenshot interface is the page that students check the definition and examples of English apposition in the labyrinth module.
The interface of the system also includes an administrator interface and a teacher interface, which is no longer described here. After the design of each interface of the system, the function of the system needs to be tested.

System test of personalized English teaching platform
The test mainly observes whether the system achieves the design goal, including whether the functional requirements are realized, whether the business process is correct, whether the operating environment of the system is stable, and whether the system bug is controllable.
The main contents of the system test include functional test, performance test, and safety test. Functional test may try all interface operations as much as possible, and complete the function proofreading; the performance test mainly observes the impact of the system on CPU share and disk space occupancy. At the same time, the test ensures that the system cannot break down when the 200 users log in and read the data at the same time, with normal reaction speed. The system security mainly verifies the protection of user passwords and the guarantee of the system openness by the system, and also determines that the data can be saved effectively when the user exits the system. According to the above requirements, the system tests are carried out one by one, and the test results should show that the system has reached the requirements for function, performance and safety, and complete the design of the personalized English teaching platform based on campus network.