Jucai's academic affairs and performance management system is based on Excel+VBA. The comprehensive version of Jucai Academic Affairs and Grade Management System contains more than 20 sub-softwares listed below, most of which are free gifts.
Jicai Academic Affairs and Grade Management System Software Description
In the score statistics software, the standard score lines for qualified, excellent, and low scores can be specified in advance, or the user can specify the percentage of the total number of students as the basis. The computer will automatically calculate the score lines as required and conduct statistics.
In the examination room seating arrangement software, there are two ways to ensure that people in the same unit are not adjacent (Sichuan-shaped), and there are also two types of software to ensure that people in the same unit are not adjacent to each other (cross-shaped).
The class placement software has added grades-free class placement and the function of pre-designating a student's class.
When the invigilation arrangement software used to check someone’s invigilation arrangements, you no longer had to enter the name and just clicked.
The admission ticket production software has added the function of printing 4 admission tickets on one A4 paper.
The score notification (general family letter) production software has added notifications for two and three exams. In order to make it easier for parents to understand and analyze their children's academic performance, reference data has been added: class average scores and grade average scores for each subject (including total scores), especially personal class rankings and grade rankings for each subject. In the single notification, a large page production function has also been added.
Features of Gucai Academic Affairs and Grade Management System Software
① Carry out in-depth development of Excel, use VBA language to write programs, set up custom functions, custom functions, custom menus and buttons;
②The system contains more than twenty sub-software;
③ Set up relevant functions according to the actual needs of the school, and be a powerful assistant to the education management department, school leaders, academic staff, head teachers, and teachers;
④As long as you import the original data, perform button operations that require no memory, and rely on the thoughtful human-machine dialogue function, you can automatically obtain various results without the need for special training;
⑤ Compared with similar software, the advantages lie in the completeness of the project, ease of operation, practicality of functions, and low price (most of the more than 20 sub-software are free software).
Features of the Jucai Academic Affairs and Score Management System
1. Automatically divide classes. Three methods of class classification: ①Double-condition automatic class classification, according to an even combination of gender and grades. Target classes can be preset for specific students; ② Multi-condition automatic class classification, comprehensive analysis of eleven conditions during class classification: gender, total score, two custom characteristics, and seven subject scores, and the computer will allocate these students to each class evenly; ③ Automatic class classification without grades, according to the principle of even matching based on gender, household registration, and other conditions (such as source school, boarding students, benchmark students, loan students, boarding students, arts and sports students, league members, backbone students, problem students, etc.), and can preset target classes for specific students.
2. Examination room seating arrangement. Under the condition of random ordering between units and between candidates within units, candidates from the same unit in the same examination room are not adjacent to each other (Sichuan shape), nor are they adjacent to left or right (Cross shape). Candidates with large performance gaps are also not adjacent to each other. It can automatically generate the test number of each candidate and generate the distribution statistics table of the number of candidates in each examination room in each unit. It can be used not only for large-scale unified examinations (on a school basis), but also for on-campus examinations (on a class basis, allowing students in each class at the same level to take the exam, or students in different grades to take the exam at the same time).
3. Make the examination room seating chart. It is used to make examination room seating charts and table stickers for candidates, and can easily print out the arrangements by unit (class). Especially when the number of people in each examination room is different and the seating arrangement is different, this software is of great use.
4. Invigilation and arrangement. ①Multi-class arrangement: If the proctoring of each exam is arranged at one time, the exam room for each proctor is not fixed, and the pairing is not fixed, then this software is suitable. ②Single-class arrangement: It is suitable for invigilation arrangements that arrange invigilators before each exam (or the invigilators remain the same for each exam), and are also suitable for invigilation arrangements that draw lots before the college entrance examination, high school entrance examination, etc. (it can effectively avoid the time-consuming, labor-intensive and pick-and-choose invigilation arrangements). There are three arrangement methods: one is random arrangement while giving priority to the same unit to avoid as much as possible; the second is random arrangement while giving priority to male and female matching; the third is unconditional random arrangement.
5. Student performance statistics. The subject capacity is 15 subjects, and there is no limit on the number of classes and students. Many statistical items are set by users and are suitable for statistical analysis and comparison of student performance in the same grade in all types of schools. Automatic statistical output items: the number of students in each class and all students in each subject test, total score, average score, highest and lowest scores, number of passing (custom passing standards), passing rate, number of high scores, high score rate, number of low scores, low score rate, total score distribution of the number of students in each score segment (customized), and distribution of the number of students in each ranking segment (customized). The standards for high scores and low scores can be specified in advance, or the percentage of the total number of people can be specified, and the computer will make statistics according to the regulations. The honor list (scores and rankings) of the top n students in each subject and total score (self-determined), and the top n students in each class are equally divided. Ranking of each student in each subject and overall score. The distribution of the number of students in each class in each subject and total score, each score band (customized), and each ranking band (customized). The number of people who passed the first n subjects (self-determined) and all subjects in each class and the passing rate. In particular, the system can also count the scores of all teachers!
6. Multi-school joint examination score management. Many statistical items are set by users and are suitable for statistical analysis and comparison of student performance in the same grade in all types of schools. Automatic statistical output items: the number of students in each school and all students taking exams in each subject, the total score, the average score, the highest and lowest scores, the number of people who passed (customized passing standards), the passing rate, the number of high scores, the high score rate, the number of low scores, the low score rate, the total score distribution of the number of people in each score section (customized), and the number of people in each ranking section (customized). The standards for high scores and low scores can be specified in advance, or the percentage of the total number of people can be specified, and the computer will make statistics according to the regulations. Ranking of each student in each subject and overall score. The top n (self-determined) honor list (scores and rankings) of each subject and the top n students of each school will be equally divided. The number of people who passed the first n subjects (self-determined) in each school and the pass rate. In particular, the system can also count the performance of all teachers.
7. Production of score notice (family letter). Suitable for batch printing and production of student transcripts (general letters). Execute the "Continuous Print" command and follow the prompts to enter the class for which transcripts are to be printed, and the computer will automatically print the transcripts for all students in the class at once. Print one or two transcripts per A4 paper. There are three production types: single exam, two exams, and three exams. In addition to outputting the student's original grades, the student's class ranking and grade ranking in each subject will also be automatically output. At the same time, the class average score, class highest score, grade average score, and grade top score for each subject (including total score) will be output for reference by students and their parents. This system is most suitable for use by class teachers, grade groups, academic affairs offices, and political education offices.
8. Statistical analysis of paper scores. Main statistical items: the total score and ranking of each student; the average score of each question in each class and the whole level, the highest score and its number, the lowest score and its number, the most frequent score and its number; the distribution of the total score in each class, the distribution of the number of top students in each class, the honor list, etc. The average score, passing rate, excellence rate, etc. of each teacher will also be calculated.
9. Tracking and analysis of individual subject scores. The results of 12 examinations in a single subject were tracked and analyzed before and after, so that the progress and decline of each student can be seen at a glance.
10. Statistical analysis of student performance standard scores. Automatically complete the project: ① The ranking of each student's subject and total score and various rankings; ② The standard score of each student's score in each subject; ③ The average score, standard deviation, passing number/rate, highest and lowest score of each subject in the class; ④ The number of students in each section and total score.
11. Teachers score points. The computer can be used to register for a single subject by searching the student number (or examination number), or the computer can be used to register for multiple subjects in the order of the student number and examination number. Supports fuzzy search of names. In order to avoid typing errors, a reading and coordination function is also added.
12. Score query. With the student number (or examination number) and name, you can check the detailed results of 12 individual exams.
13. Production of admission ticket. Suitable for batch printing and production of admission tickets. Print 2 admission tickets for each A4 paper with stubs, print 8 or 4 admission tickets for each A4 paper without stubs, and support photo printing.
14. Production of certificates. Suitable for batch printing and production of honorary certificates.
15. Summary of results. Suitable for quickly bringing together multiple different score sheets. For example, after the marking groups of each subject submit their respective electronic registration books, the scores of each student's subjects will be merged together.
16. Judges’ scoring statistics. You can remove one of the highest and lowest scores each, or you can remove the two highest and lowest scores each.
17. Address book. Administrators can enter, modify, and delete single records in the front desk, or enter the backend to enter, modify, and delete records in batches.
18. Democratic assessment and counting of votes. When counting votes, just click the mouse and the computer will automatically count the votes. It can be used for students’ evaluation of teachers’ teaching status, democratic evaluation of faculty and staff’s year-end assessment, democratic evaluation of merit-based evaluation, etc.
19. File encryption and decryption. File encryption/decryption software is extremely reliable and will encrypt important or private files (including photos).
20. Print in categories and columns. For example, the results of freshmen's class placement, examination room arrangement results, etc. need to be classified by class (or school) and printed out in two or three columns.
21. Segmented statistics. Set the statistical score range by yourself, automatically complete the statistics of the number of people in each score range of each subject, and also calculate the total score, average score, highest and lowest scores, number of people, etc. for each subject.
Jucai Academic Affairs and Grade Management System Update Log
1. The details are more outstanding!
2.BUG gone without a trace
Huajun editor recommends:
Jucai's academic administration and performance management system software feels really good! The editor specially tested it for this purpose, and it is really great to use. Bertso Cloud Academy Student Terminal, Easy Copybook, Batch Butler, etc. are all very good software tested by the editor. Come and choose the one that suits you!
