(1) Mass email function:
1. Make salary slips (grade strips) and salary books (grade books): An employee salary table (student grade table) is composed of several records that coexist under the header of the same single row or multiple rows in the same worksheet. If you want to send a single person's salary (score) to yourself, you can use this software to easily separate each record, and add a header above each record to clarify the meaning of each item, and add a header below. Blank lines for cropping after printing. This software can also save the salary slip (score slip) into an independent workbook file.
2. Mass-sending salary slips (score slips) to mailboxes: The software sends salary slips directly to everyone's mailbox in bulk, which is convenient and fast, truly realizing paperless and efficient office work.
3. Mass-send salary slips (score strips) to mobile phones: Separate personal wages from the salary table in Excel worksheets and send them to mobile phones for free, achieving fast, convenient and safe purposes.
4. Send salary slips (score slips) in bulk to personal folders: Nowadays, personal information of many units is stored in the server and can be viewed by employees through FTP. This software can save each row of records (salary slips) in the same worksheet as in a personal folder with the same name and rename them uniformly. For example: the two files named Zhang San and Li Si saved in the [Independent] folder can be correspondingly transferred to the two folders Zhang San and Li Si respectively, and the two files can be renamed [ September salary].
5. Classify worksheet contents and send them to emails and mobile phones: The software first saves worksheet records into categories as workbook files, and then sends these files as attachments to the email address of the designated person in charge of the category. For example, the grade report table consists of the scores of students in each class. The software first saves this table as a workbook for each class, and then sends the workbook of each class to the corresponding class teacher.
6. Mass-send emails with the same attachments: Mass-send common emails with the same title, same content, and same attachments to multiple mailboxes and mobile phones. Different from mass mailboxes, you can send them "one by one". There is no limit on the number of group messages and they will not be viewed by the other party. to multiple addresses and will not be filtered as spam.
7. Automatically enter NetEase mailbox: any 126, 163, yeah mailbox can be entered with one click.
(2) School data processing:
1. 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 in each class are basically equal; (d) in order to meet the requirements of different users, this software does not consider the ratio of male and female students. Classes can be divided into classes only based on grades, or the gender of the first few students may not be considered, and only the gender of the following students may be considered, or classes may be randomly assigned without grades; (e) The software labels the class formation results as "accurate" in order to distinguish them from the official serial numbers; (f) The 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.
2. Student ranking/class performance analysis: (1) Students can be ranked by grade on the report card of each class in the same grade, or ranked within the class where the student is located, that is, single-subject ranking, or ranking can be done Multi-disciplinary, total score one-time ranking. (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.
3. Quickly write comments: This software comes with a student comment library. Users 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 quickly Send it to the student's (or parent's) personal email address. There are a lot of comments in the comment database, and you can add and modify them at will.
Note: Using the function of mass sending salary slips (scores), you can split the uniformly registered school and grade test scoresheets into each class’s scoresheet (saved in an independent workbook under the [Classification File] folder). ), sent to the email addresses of each class teacher in bulk, and then the class teacher adds a comment column to the score record row of the students in this class, and finally sent to the email addresses of the students (parents) in bulk.
4. Filter the top N names in each class: filter the row data of the top N outstanding personnel (scores) in each unit (class) in the same table, and delete the row data of the remaining personnel.
5. Classification of English words and explanations: English words in primary and secondary schools can be classified according to how many consecutive letters they have in common. For example, words containing 4 consecutive identical letters can be divided into one category (marked with the same serial number); The explanations of English words in primary and secondary schools are classified according to whether one or two Chinese characters are the same (marked with the same serial number). It is very helpful for memorizing English words.
(3) Common financial data processing:
1. Add and delete the subtotal, total and total of this page: You can easily add "Subtotal of this page" and "Total of this page" to each page of the account, and add "Subtotal of this page" and "Total of this page" to the last page. Page Accumulation" and "Total" are also applicable to pages after classification and filtering. These additional items can be easily removed by pressing the "Delete" key.
2. Conversion of commonly used data such as RMB uppercase and lowercase: can convert RMB lowercase to uppercase, can round off, round off fractions, extract fractions, calculate salary tax, convert fractions or rankings to grades, convert Chinese characters to pinyin, English Convert the first letter of a word to uppercase, etc. Since the method of entering formulas in cells is adopted, it is convenient for users to fill in areas and modify formulas.
it works
it works
it works