table of Contents
Abstract ............................................................................. 2
Introduction ............................................................. 2
First, the problem is proposed ................................................................... 2
Second, feasibility analysis .................................................................... 3
Third, demand analysis .....................................................................
Fourth, overall design ................................................................... 5
V. Detailed design ................................................................... 7
Sixth, conclusions ...........................................................................................
Seven, thank you .............................................................................................
Reference ...........................................................................................
Public class score management subsystem
Li Wei
School of Computer and Information Science, Southwest Normal University, Chongqing 400715, China
Summary: Computer public lesson management system is based on network, using the .NET platform, SQL Server 2000 database, support ASP.NET IIS server to construct a management system for multiple users, combined with other subsystems in MyCollege. From these subsystems, the basic information of the student is acquired, combined with the local database, build a digital space on the basis of traditional campus teaching plan management and student performance management, implement teaching plan, courses, teacher information, student results It is convenient for query and management to improve the purpose of improving education management level and efficiency.
Keywords: computer public lesson management system ASP.NET SQL Server 2000
Abstract: On the basis of network, Computer Public Course Management System (CPCMS) combines with the other child systems of MyCollege.Net using the .net platform, SQL Server 2000 data base and IIS server which surppot ASPsp.net, .CPCMS gets departments information and basic students information from these child systems to connect with local data base. Foundation as traditional teaching plan management and score management, CPCMS build a digital space to achieve convenient search and manage for the teaching plans, courses, teachers, scores .Having it , We can IMPROVE Management Efficiency.
introduction
In the development of MyCollege.net system, I mainly participate in the design and implementation of the application subsystem - computer public class score management subsystem. I am responsible for the overall design and logical layer of the system in the development of this sub-system. Used .NET tools and B-S structures, have a more profound understanding and experience of these two important technologies. The data access layer (DataAccess) and business appearance layer (BusinessFacade) are used. There is a part of learning and application for the .NET DAB technology.
One, question
All along, the public computer department of our school is manually operation, and the teacher registers the results of the students, and pays to the teaching secretary, and then integrates these achievements, and finally send it. Each class. This is wasting manpower, material, and it is easy to make mistakes and is not easy to save, and the highly developed automation is severely detached. As a result, we consider writing a public class grade management system to manage it. Second, feasibility analysis
(1) Technology feasibility
The public class score management system is mainly used in the Ministry of Education, the Ministry of Education of the Ministry of Education on Teaching Plan, Curriculum, Teacher Information, Results. By using the Visualstudio.NET tools provided by Microsoft, you can implement online query and management of teaching programs, courses, etc. related to public lessons.
(2) Economic feasibility
Since this system is just as our graduation design, it is not too much economic feasibility.
consider. But it is very suitable for public class management in colleges, because the system implements the management and query network.
Chemist, teachers, students.
(3) operation feasibility
The interface design of this system is simple and intuitive, easy to understand. It is used by the controls that are common or common, and it is easy to get started. In addition, the system is published on the network, and the user can access this anytime, anywhere. You can use this system without special training and explanations.
Three, demand analysis
(1) Function Description
1. Teaching Management Function (Use of public computer education) includes:
1 Entry and query of the courses open in the new semester: For example, the course will be opened at the 2004: C language and VFOR.
Explanation: All course scores consist of three parts: usual grades, machine scores, written test results. The specific gravitys accounted for: 10%, 10%, 80%, in which the three parts and specific gravity therefor are fixed.
2 Entry and inquiries for the course arrangements of each laminate, the course arrangement is the semester for each department
Electoral course, members of teachers, and class time and class locations.
Note: All the courses selected in each of each department are the same. But the students in the same department do not have to have the same teacher to teach.
2. The function of the performance management (the teacher is used) is as follows:
1 Enter a score: You can also enter a single entry can also be incorporated in batches, where batch entry is in units of transcripts, and each time you call a transcript from the system, and submit it once after editing.
Transcripts: transcripts include semester, department, professional, course, teacher, student achievement.
2 Query results: single query (students can be used), query about all the students' results of all courses of the student according to the student's school number or name.
Batch query is in units of transcripts, each querying a transcript.
3 Print scores: You can print a transcript once, or print it as required.
4 Statistics Adjustment: Statistics on the scores in the transcript, pointing out the distribution of the number of people in each score. Because sometimes the students' grades are overall, they need to be adjusted, and the system can adjust the scores in the transcript according to the rules set by the user.
Results Adjustment Rules: Adjusts the total score of the total score in a certain segment to another score. For example, 50 to 60 points are all adjusted to 60 to 65. In order to make the adjustment process as reasonable as possible, it is also possible to restrict the student scores of the adjustment score segment, such as setting its written test scores must be more than 50 points, and usual grades can be properly relaxed.
5 The examination of each semester is not as follows.
3. Permission Description: 1 Administrator can use the function: Teacher Information Management, Department Display, Curriculum Management, Teaching Plan Management, Student Results;
2 Teachers can use the performance management of the performance: add, delete, modify, query, analyze, and adjust, and adjust the students.
3 Students can use the function: Query all the results of individual students.
4. System data update features:
Get basic information about students, department, professional, and update the local database, and the data saved by the local database is updated under MyCollege .NET.
(2) top-level data flow map
1. Administrator Operational Management Top Data Flow Diagram:
2. Grade management top data flow map:
Fourth, the overall design
The overall function module of the system is as follows:
1. Press functional division module to use the B-S structure, use the .NET platform, SQLServer database, IIS server (support ASP.NET) as a development tool.
2, use three-layer architecture: data access layer (dataAccess), business appearance layer (businessfacade), representation
3. Data Access Layer (DataAccess) is responsible for the processing of the database, which only adds deletion modifications to data in the database, usually on the ADO.NET layer on the .NET platform, can be flexible to the database, But in order to simplify the development of the system, a set of tools provided by Microsoft Data Application Block (DAB) provided in this system.
4, according to the object division module, the system includes: teacher information management module for teacher information, teaching plan management module for the teaching plan, for the course management module, targeting the department's department information query module, the performance management Module. The following functions as a functional function in the module. Among them, the performance management will be set together, and the individual student results queries are adjusted together, and this can be found in the object division module and the difference between the functional division module.
5. According to the object division module, it is more clear according to the functional division module: the idea is clearer, consistent with the user interface design ideas, easy to think and future function expansion, and better achieve low coupling and high cohesive, easy to maintain and modify.
6. There is no control coupled between each function function, and the independence is better. There is a common environmental coupling. Focus on the processing of the database, the database processing technology is high.
7. Complete the authentication and permission assignment of the user with myCollege.net's UIA (unified authentication subsystem).
8. The system data update feature in the functional description can be implemented (see the access policy of public data resources in MyCollege.net):
Synchronous Access Policy: This system does not set a dedicated database to save the required public data resources. WEBSERVICEs are obtained through WebService from the network whenever this system requires a public data resource (student, department information). (CRESOURCE subsystem is saved is the latest data under mycl Dege.NET system). The advantage is that the system can get the latest data, and the disadvantage is that the performance and reliability requirements of the network are relatively high.
Asynchronous Access Policy: Setting up student locally, the basic information stored in the department, and access it directly from the local database when needed. The advantage is that the implementation is simple, the response time is short; the disadvantage is that the administrator can only update the local database periodically, so the information saved in the local database may not be real-time information.
Cache Policy: Local also sets students, the basic information stores in the department The cache policy caches the data to the local database to support high-speed access to the data. The advantage is that the response time and data is more compromised, and the disadvantage is to achieve more complicated. In this system, second programs will be adopted, since only read operations from CResource, the public data resources are not modified, and the synchronization of data is easy to maintain. It also reduces the requirements for network reliability and speed.
V. Detailed design
(1) Permission certification
When the user enters the system, the system is logged in, the system makes permission detection, and there is different functions for different roles.
1. Students can only query personal achievements without having to log in in this system.
2. After the teacher is logged in, you can get the functional operation rights of the performance process.
3. Once the administrator logins, you can get all the operations other than the score adjustment.
(2) Summary of various functions used by administrators
1. Teacher information processing
2. System
3. Course processing
4. Teaching plan
5. Performance
Each processing is refined as follows:
1. Teacher information processing
Function Description: For administrators to add, delete, display because the system only uses other information such as teachers and does not save other information such as teachers, so there is no modification of teachers in this module.
Data flow graph:
Data Dictionary:
Storage Name: Teacher Information Store
Property: Database
Description: Store basic information for teacher information, delete, display processing access
Content (see database design): teacher name, teacher ID
Location: Database
deal with
1 words: Teacher Information Add
Function Description: Receive teachers to add information, access the "Teacher Information Store" table in the database, add to teacher information
Enter data stream: Teacher Add Information (Teacher Name)
Output data stream: Add information (teacher name, teacher ID (automatically generate ID number))
2 name: Teacher Information Delete
Function Description: Accept the delete command information, access the "Teacher Information Store" table in the Database, delete the corresponding teacher information
Enter data stream: Delete selection
Output data stream: Teacher ID
3 words: display teacher information
Function Description: Accept the display command, access the "Teacher Information Store" table in the database, return to the teacher information
Enter data stream: display command
Output data stream: Teacher Information (All Teacher Information: Teacher Number, Teacher Name)
2, departmental processing
Function Description: For administrators inquire information, inquiry
Data flow graph:
Data Dictionary:
Store 1 name: Department storage
Property: Database
Description: Store all the information of all schools, providing data sources for "2.1 display all hospital"
Content (see Database Design): Academy ID, Style
Location: Database
Store 2 Name: Department (MAJOR) storage
Property: Database
Description: Store the all-school department of the whole school, providing data sources for processing "2.2 display hospital"
Content: (For details, see Database Design): Department ID, Type, School ID Location: Database
Process 1 name: 2.1 Show all hospital
Function Description: Accept the Call Command, Access Storage "Department Storage", Show all hospital names
Enter data stream: The hospital query command, the hospital information data flow (the name)
Output data stream: The hospital query command information
Processing 2 words: 2.2 All lines in the show
Function Description: Accept display command information, access storage "system storage", display all the names in the hospital
Enter data stream: Department query information (optional), information data stream (all the names in the hospital)
Output data stream: Academy ID
3, lesson processing
Function Description: For administrators to increase, delete, display all courses across all schools.
Data flow graph:
Data Dictionary: (similar to teacher information, slightly)
4, teaching plan processing:
Function Description: For administrators to configure various institutional courses to achieve the addition, deletion, display of the teaching plan.
Data flow graph:
Data Dictionary: (similar to teacher information, slightly)
5, achievement
See grade processing module
(3) Teacher use function (mainly for performance management)
1. Basic processing of students
2. Student results adjustment processing
Functional refinement is as follows:
1, basic processing of grades
Function Description: Single student single-door score (usually achieved, delete, editing, editing), delete, editing; (available for teachers, administrators)
The results of all students (usual results, transformation results, written test results, total results) query display; (available for teachers, administrators)
Single student's query display (available for students, teachers, administrators).
Data flow graph:
Brief data dictionary:
storage
Name: Score storage
Content: Student ID, Teaching Plan ID, Meeting Performance, Plot Grade, written test results, total results, adjustment logo
Description: Store students' achievement information, the ID and teaching plan ID can identify a single-door grade,
It is the data source for all relevant grades. There is a adjustment logo, which is convenient for the feasible check of the recovery operation. (For details, see Database Design)
data flow
Add information: Learning number, the teaching plan ID, usual results, achievement, written test results
Delete information: Learn, the teaching plan ID
Update information: Learn, the teaching plan ID, usual grade, machine grade, written test results
2, achievement adjustment processing
Function Description: Analysis: Returns the number of people in each score;
Adjustment: Define the score (usually grades, high performance, written test results, total score), adjustment within the scope of this score
Recovery: Does all student results in a certain class of a teacher have been adjusted, and the adjusted results are restored to the original grade. (According to the usual scores in the database, the machine is achieved, the written test results will be restored to the original grade)
Data flow graph:
Data Dictionary:
data flow
Adjustment information: The scores of all results (usage grades, machine achievements, written test results, total scores), lower limit and adjustment amplitude
Recovery calculation: According to the usual grade, the machine is achieved, the specific gravity of the written test results recalculates each of the total scores in the database. The calculation formula is: total points = usual score × 0.1 machine score × 0.1 written test scores × 0.8 According to function, design various and functions as follows:
(1) Teacher Information Management PUBLIC CLASS TEACHERS
1. Teacher Information Add Function Public Int Addteacher (String Teachername)
Function: Add teacher information (teacher name) to data table TTEACHERS
2, teacher information delete function public int Removetecher (int teacherid)
Function: Delete the corresponding teacher information line according to the parameter teacherid
3. Teacher Information Display Function Public Dataset ListallTeachers ()
Function: Display Data Table Tteachers All Teacher Information
(2) Departmental processing class public class deptmajors
1, the hospital information query function public dataset listallDepts ()
Function: Display data sheet TDEPTS in all hospital information
2, system information query public DataSet Listallmajorsindept (int deptid)
Function: Display all deptid = @ deptid in the TMAJORS table according to the DEPTID query
(3) Curriculum Class PUBLIC CLASS COURSES
1. Courses Add Functions Public Int AddCours (String CourseName)
Function: Add course information (course name) to data table TCOURSES
2, lesson delete function public int RemoveCourse (int courseid)
Function: Remove the corresponding course item from the data table Tcourses according to CourseId
3, curriculum display function public Dataset ListAllcourses ()
Function: Display all course information in TCOURSES
(4) Teaching program management PUBLIC CLASS TEACHINGPLANSTEM
1, Teaching Plan Add Function Public Bool AddteachingPlan (int DEPTID, STRING TERM, INT Grade, Int Courseid, Int Teacherid)
Function: Add a teaching plan to the data sheet TTEACHINGPLANS
2. Teaching Plan Delete Function Public Bool RemoveteachingPlan (int TeachingPlanid)
Function: Delete the corresponding data line from the data table TTEACHINGPLANS according to TEACHINGPLANID
3, teaching plan display function public dataset listteachingPlans ()
Function: Show teaching plan information from view vTeachingPlans
(5) Schedule management
1. Single Classic All Students' Results Display Functions Public Dataset Listscores (int TeachingPlanid)
Function: According to the TEACHingPlanid from the view vscores, all of its student results are listed
2, single-class single student results Add functions public Bool AddScore (String Snumber, Int TeachingPlanid, Float Daily, Float Practise, Float Written)
Function: Add student scores to data table Tscores, each data item value is shown
3, single-agent single student grade delete function Public Bool RemoveScore (String Snumber, int TeachingPlanid) Function: Remove the corresponding data line from Data Sheet Tscores in accordance with SNUMBE and TeachingPlanid
4, single-class single student grade update function public bool updatescore (String Snumber, int teachingplanid, float daily, float phactise, float written)
Function: Modify the Daily, Practise of the corresponding data line according to SNUMBE and TeachingPlanid, modify each Written value
5, a single student all the results query function public dataset getscores (String snumber)
Function: Inquiry the corresponding data line from the view vscores from the student Snumber, return all of its courses
6, grade analysis function public int analysis, float low, float high)
Function: Query from the TSCORE table Returns the number of students in the TEACHINGPLANID in Low and HIGH
7, grade adjustment function public int adjutscores (int TeachingPlanid, Float D1, Float D2, Float P1, Float P2, Float W1, Float W2, Float T1, Float T2, Float T1New, Float T2NEW)
Representative of each parameter: FLOAT D1 usual minority limit, Float D2 usually the upper limit, FLOAT P1 is lower, the upper limit of FLOAT P2 is upper limit, the lower limit of the Float W1 written test results, the Float W2 written test result is the upper limit, Float T2 The total number of grades, the lower limit of the total division between FLOAT T1NEW, FLOAT T2NEW changes the upper limit of the total division of the total division
Function: Modify the score based on the range and adjustment of each parameter, and modify the modified system Adjusted
8, grade recovery function public void recoverscores (int TeachingPlanid)
Function: Check each line to modify the identity item Adjusted, if you modified, return it to the original data
(For details, please refer to the system code)
Data Access Layer (DataAccess) is responsible for the processing of the database, built on the Microsoft Data Application Block layer, directly calls the DAB provided, and completes the call from ADO.NET by the DAB function.
Sixth, conclusions
By designing and implementing this system, I have a certain understanding of .NET, with an object-oriented and N layer structure have a use of practical experience, exercise the mutual coordination skills of the group development, and feel the mutual development between the group members. The importance of discussing and helping, learned a lot of practical development experience from the team leader, and for software engineering has a more specific and in-depth application than before.
Seven, thank you
This graduation design can be successfully completed inseparable from our guidance.
Zou Xiangchun
Teacher guidance and help,
Lu Xinhong
teacher,
Chen Wu
teacher,
Smell
teacher,
Li Yun Gang
Teacher also gave great help in this process, expressing their sincere gratitude to their help. There is also a team of all members to support me, thank you for their heartfelt thanks!
references:
[1] Shao Weizhong, Yang Fuqing. Object-oriented system design. Tsinghua University Press
[2] Wu Yizhen. Object-oriented analysis design and programming. Tsinghua University Press.
[3] Guo Sheng.C # .NET program design. Tsinghua University Press.
