(1) Students can be ranked by grade on the report cards of each class in the same grade, or ranked within the class in which the student is located. That is, rankings can be made for a single subject, or for multiple subjects and total scores at one time.
(2) Class score analysis means that the scores of each class are summarized into an independent table. The content includes: the number of people who took the exam, the number of people who actually took the exam, the average score, the average score of the top students in the class, and the scores of the top students in each class. Distribution etc.
2. Student placement and class adjustment: According to the different standards for class placement for each school and grade, two class placement methods are provided for selection:
(1) Classification based on total score ranking: Students can be ranked in a one-stop manner based on their total score (or a certain subject score) with reference to factors such as grades, gender, special students, etc., and students can be evenly organized into several teaching classes. The divided teaching classes can achieve the following indicators:
(a) The number of students in each class is basically equal.
(b) The number of male and female students in each class is basically equal.
(c) The number of students in each ranking group is basically equal in each class.
(d) The average scores of all classes are basically the same.
(d) In order to meet the requirements of different users, this software can not consider the ratio of male to female students, but only assign classes according to grades. It can also not consider the gender of the first few students and only consider the gender of several subsequent students. It can also not consider the gender of the first few students. Randomly assign classes.
(e) The software labels the class placement results as “accurate” in order to distinguish them from the official serial numbers.
(f) This software has intelligent reminder, inspection and repair functions. Guide you to enter various reasonable data; automatically correct the spaces that are mistakenly entered before and after the text when entering gender and special birth columns for you.
(2) Classes will be divided according to each subject test: those with "pre-selected classes" requirements will be satisfied first. Then mainly consider the small gap in the average scores of each subject, and also consider the gender matching. When the above conditions are met, consider the matching of special students (two columns are provided for special students, and you can fill in outstanding students, class cadres, problem students, boarding students, etc. ). Several indicators achieved by the separated teaching classes are the same as (1).
The design ideas of the two class division methods are: the former first classifies and ranks students, and then allocates them to each class in a "one-stop" manner, so the number of students in an integer multiple of the class number only differs by 1-2 students in each class; the latter classifies students according to their respective categories. Subject scores, gender and other conditions are used to determine which class the student is assigned to, so the final average score of each subject and the overall average score of each class are only within half a point.
The editor strongly recommends that you do not have more than two special requests, and do not consider too many class formation factors, otherwise it will be at the expense of "balance". The more factors are considered, the greater the gap between the number of students in each grade and their average scores.
(3) Class adjustment: Class adjustment requires that students have a small difference in test scores and that male and female students must match. The primary student cannot be transferred out again... Therefore, manual class adjustment is quite laborious. This software is designed to adjust the class according to the exam number. Functions such as size and name sequence automatic search, shift mark color and remarks make shift adjustment easy. After adjusting the class, you can tap the button to track the number of boys and girls in each class, the number of special students, the average score of the top students, the distribution of the top students in each class, etc.
3. Mass-send student scores to the mailbox: After the statistics of student scores in each grade and class are completed, the overall situation should be sent to the leader's mailbox; the scores of each class should be sent to the class teacher's mailbox; the individual students' scores with comments should be sent to the students and their Parent email. This software can easily solve these problems.
4. Unified examination arrangement: As long as the grade name, examination room name, number of students in the examination room, student class, and score information are given, the software can quickly generate an examination room schedule and candidates' examination rooms and examination numbers, so that students with equal rankings in each class can be assigned to the same examination room in one go. requirements, the software also has a random field editing function to meet the different requirements of users.
5. Proofreading and reading aloud: This software provides a novel "text-to-speech" Chinese installation data package source and speech library. You can use a clear and smooth female voice to read the contents of the identification column starting from the selected cell plus any N columns ( N≥0). In order to save proofreading time, only numbers are read when reading, and units such as tens, hundreds, thousands, and ten thousand are not read; in order to proofread English words, a function of splitting words into letters and reading aloud is added; when reading the full text, each independent cell will not be lost. The reading function of Excel itself has been greatly improved and optimized.
6. Quickly write comments: This software has a student comment library. You can conveniently select comments from the comment library to fill in the student transcripts (based on the second column, the number of students is measured). With the personal information group sending function, it can be quickly sent to Student (or parent) personal email address. There are a lot of comments in the comment database, and you can add and modify them at will.
7. Current page and double-sided printing: The software can complete double-sided printing of Excel documents at one time, and can also select the starting and ending pages for alternate page printing to achieve more flexible double-sided printing; the software can also print only the current page. It fills the gap that Excel does not have current page printing and double-sided printing functions, and is even more powerful than the printing function in Word.
8. Change the cell format (data type) after data has been entered: This command solves the problem of being unable to redefine the cell data type after using [Format]-[Cell]-[Number] after entering data into the cell. The data type can be freely converted between text type, numeric type, and date type.
9. Convenient uninstall function: allows you to easily uninstall the software you want, so you can try it with confidence.
it works
it works
it works