What subjects do stupid ... doors refer to, such as mathematics, physics and so on. The second time refers to the number of make-up exams. You said this is a course that only passed two make-up exams.
B. What is the meaning of "home" in Lianyungang dialect?
Stupid.
It can be translated into: "Oh, what a fool I am!"
C. What do you mean by the number and frequency of elective courses?
The number of hours in this course is the number of times you need to take this course;
The number of classes is the last. How many classes does this course need?
For example, twice a week. That is, you have to take this course twice a week, and you need to take two classes at a time, which is two classes.
If you are satisfied ~ please "choose the satisfactory answer" ~ Thank you for your support ~
I'm glad I can help you ~ if you don't understand, you can ask ~
D. What does it mean to be admitted to a university?
I. Distribution conditions
1, which meets the graduation requirements;
2. The number of remedial classes during school study is ≤ 5 times;
3. The highest score in CET-3 and CET-4 is ≥54.5 (the new standard is 387) or the score in the foreign language proficiency test organized by the school is ≥54.5;
4. Those who have not received a "serious warning" or above in their studies, and those who have not received a "demerit" or above in their lives;
Second, the calculation method of make-up exam
5. Calculation of college foreign language courses and make-up exams in physical education class: If non-foreign language majors make-up exams for many times and non-physical education majors make-up exams for many times, they will be calculated once according to the granted courses.
6. Courses such as situation and policy, military theory, employment guidance, Putonghua (public * * *), music (public * * * *), calligraphy (public * * * *) and public * * * elective courses are not award-winning courses.
7. Elective courses, such as taking the number of courses specified in the teaching plan and obtaining credits, over-selected courses, such as make-up, are not included in the make-up exam of the award-winning courses.
8. ① A score of 60 or above in CET-3 and CET-4 (new standard 425) can be used to make up the foreign language test in the first four semesters;
② In the fourth semester, a score of 49.5 (new standard 352) ≤ Grade 4 (Grade 3) < 60 (new standard 425) is considered as a pass.
9. Make-up exams for public * * * courses (except 5 and 6) are calculated according to the number of courses.
Third, others.
1 10. Persons who do not meet the conditions for granting posts, if they have special expertise or other outstanding academic performance, may apply for granting special posts (for specific requirements, see the Measures for Special Granting of Full-time Undergraduate Students in China West Normal University).
1 1 1, courses retaken before graduation, courses that failed to retake, and courses that failed in the final exam of last semester will be retaken within the first week after the graduates leave school, and those who meet the conditions for granting places will be awarded bachelor's degrees.
1 12. The measures for granting places to students in off-campus joint education shall be implemented with reference to the above provisions.
E. How to use Excel as a general course for all students to evaluate their scores?
. A major (even a college) has several students, a student has several courses, and different courses have several weights. In the past, when measuring students' comprehensive evaluation results, it was used in homework calculation, and the workload was huge. The author uses Excel spreadsheet, function, VBA programming and other functions [1. ] To realize the efficient and programmed comprehensive evaluation of students' grades.
(II) Workbook Structure The structure of this Excel workbook mainly includes three worksheets, namely, parameter setting worksheet, examination result worksheet and performance evaluation worksheet. Among them, the parameter setting worksheet is used to set parameters such as course name, course nature and weight. The test score worksheet is used to store the basic information of students' test scores. Including student number, class number, grade, name, course name, course category, examination period, examination result, make-up examination result, deferred examination result, retake examination result, demotion and other fields. The contents of the two fields will be automatically filled in according to the set parameters. The performance evaluation worksheet is used to output the overall evaluation results, performance rankings and other related information of students. Including student number, class number, grade, name, total score, number of retakes, number of retakes, grade ranking, CET-4 and CET-6. The contents of this table are automatically output according to the parameter setting worksheet and the test score worksheet.
(3) The program function mainly includes calculating the total evaluation scores, total courses, grades and courses of all students; The ranking of the comprehensive evaluation results of all students; Inquire about the total evaluation scores, total courses, various grades, various courses and specific course scores of any one or some students.
(4) Programming mainly combines Excel spreadsheets, uses VBA to write program codes, and uses macros and menus to complete program functions. Firstly, six macros are written in VBA language: KCFL, ZSCJ, TCXM, JSCJ, CJPX and QKJL. Secondly, write the program code in these two books, add a new drop-down menu item "Statistics (S)" on the Excel menu bar, and integrate six macros in the menu. The program code is as follows: 6 When the test score worksheet is activated, add macros KCFL, ZSCJ and QKJL to the menu.
Add to menu
PrivateSubWorksheetActivateO
DimitemsAsVariant
Menuindex II application. Commandbars ( 1)。
Control (low). index
Set the white definition menu 2 application. Command bar
(1).Controls.Add (type: msoControlPopup, be.
Fore: two menuindex, temporary: two True)
Customize the menu. Title II "Statistics (&; s)"
Setitem 1 2 application. commandbars ( 1)。
Control ("Statistics (&; S)").Controls.Add。
Iteml。 Heading II "refresh record (l-2) (&; Answer) "
Iteml。 Operation ii "refresh record"
Setitem 1 2 application. commandbars ( 1)。
Control ("Statistics (&; S)").Controls.Add。
Iteml。 Title II "1 Course Classification"
Iteml。 About Action 2 "KCFL"
Setitem 1 2 application. Command bar s( 1).
Control ("Statistics (&; S)").Controls.Add。
Iteml。 Tuesday's CAPTIO "2 conversion result"
Iteml。 on action ii“ZSCJ”
Setitem 1 2 application. commandbars ( 1)。
Control ("Statistics (&; S)").Controls.Add。
Iteml。 Captio "cleared the original record" on Tuesday.
Iteml。 on action ii“QKJL”
End joint
6. Delete the menu when the test score worksheet is deactivated.
OnErrorResumeNext
Apply. Command bar s( 1). Control ("system.
I am ten (&; s)”)。 delete
End joint
Similarly, when the exam evaluation worksheet is activated, the macro TCXM will
(1 no duplicate name), JSCJ(2 calculation results), CJPX
O comprehensive evaluation results ranking) and QKJL (sorting record) are added to the dishes.
Single. Delete the menu when the exam evaluation worksheet is deactivated.
6 Delete the menu before closing the workbook
This workbook
PrivateSubWorkbookBeforeClose (Cancel
AsBoolean)
. nErrorResumeNext
Apply. Command bar s( 1). Control ("system.
t ten(&； s)”)。 delete
End joint
6 Delete the menu when the workbook is deactivated
PrivateSubWorkbookDeactivateO
OnErrorResumeNext
Apply. Commandbars ( 1)。 Control is called "on"
t ten(&； s)”)。 delete
End joint
The menu added after programming is shown in Figure 2:
Second, the score evaluation takes the comprehensive score ranking of graduate students recommended by undergraduate courses as an example: 80% of students' professional compulsory courses and 20% of public compulsory courses, and calculates students' comprehensive test scores and rankings.
(1) Set the evaluation parameters as shown in Figure 3. In the Parameter Settings worksheet, first enter one or more course categories (such as required major, required major, others, etc.). ) and its corresponding weight in the corresponding position in column A (for example, the required major is O.80 and the required major is 0.20); Secondly, in the corresponding position of column E, enter the names of the courses the students are taking (such as advanced mathematics, general chemistry, ideological and moral cultivation, etc.). ) and its course category (mouse (3) to evaluate students' grades is shown in Figure 5. In the Exam Evaluation worksheet, click; Menu, first of all, the columns of "student number", "class number", "grade" and "name" will be automatically filled in, and there will be no duplication between student numbers; Secondly, click the corresponding cells of Total Score, Number of Make-up Exams, Number of Restaurants, Band 4, Band 6 of English, Average of Professional Compulsory, Average of Public Compulsory and Public * * * *, and a drop-down list will appear. The content of this drop-down list is a set course. Fig. 3 Setting up the evaluation parameter diagram (2) Import the basic data as shown in Figure 4. Import the basic data in the worksheet of "Test Results", and then classify the courses and convert the results. Just click the menu (Figure 4) and automatically fill in the course category corresponding to each course name (column F in Figure 4) according to the preset corresponding relationship between course names and course categories (Figure Section); At the same time, according to the corresponding relationship between the preset course category and the weight (figure section), the test scores (L column in Figure 4) are automatically converted. You can also click,<2 transformation result > menu to fill in the corresponding Yu Duan records respectively. Fields such as "Required Gate" will be filled in automatically; Finally, automatically according to the "total evaluation results" sort. Of course, you can also click & lt2 calculation result ><3 overall evaluation result ranking > and fill in the above three aspects respectively. If you don't need to know all the students' comprehensive scores, classified scores and single subject scores, but just want to query (calculate) the performance evaluation of a certain student or some students, you can do it as follows: First, enter the student number and name in the corresponding cell; Secondly, modify the "CET-4 and CET-6" field to the name of the course to be searched; Finally, click the corresponding menu to achieve it.
The comprehensive evaluation program compiled by Excel has been applied in the graduate promotion of the School of Horticulture and Landscape Architecture of Southwest University, which has significantly improved the work efficiency. A major has 120 students, each with more than 40 courses. Professional compulsory courses and public compulsory courses have different weights. After importing the basic data of test scores, it only takes 3 ~ 5 minutes to get detailed information such as students' comprehensive evaluation scores and rankings. The program is fast, simple and practical. At the same time, it has the following advantages: First, when the percentile and non-percentile scores are mixed, the comprehensive evaluation of the scores can still be realized by using the "weight percentile conversion" in the parameter setting worksheet. Second, when the course weight and course category change with different goals, you only need to reset the corresponding parameters in the worksheet every time, without changing the program statements. Thirdly, the number of course categories is not limited to the three (public compulsory, professional compulsory and others) given in this example, and can be extended to any number.
Fourthly, when there are special requirements for the investigation of a certain course, this program can display the students' rankings and the results of this special course at the same time. Fifth, this scheme can be applied not only to the comprehensive evaluation of students' grades, but also to other aspects. For example, if the field names in each worksheet are slightly changed, they can also be used to calculate work performance, work allowance, etc. It is necessary to popularize this program in the future comprehensive evaluation of grades in order to improve its function.
F. Self-taught exam: What do you mean by "there are two or four opportunities to apply for the exam a year, and at most four at a time"? .
In other words, the local provincial education department organizes self-study exams two or four times a year, but each time you take an internal exam, you can't take more than four subjects. Depending on the province, some provinces arrange it twice, and some arrange it four times. You should pay more attention to the self-taught information on the online entrance examination of local provinces.
G. what do you mean by graduation?
This is called graduation. When you finish your studies and pass all the exams. There are other requirements for graduation. Eight subjects are eight subjects, and the second is the number of retakes.
H. What do you mean by make-up exam (inclusive)?
If you don't take the exam more than once, you won't be awarded a degree, that is to say, if you take the exam more than once, you will be awarded a degree.
But including it means including it once.
1. What do you mean by the total class hours for make-up exams?
Column A is the student's name, and columns B to I are the scores of seven courses respectively. Column J is the total score: = sum (B2: I2). Column K is the average score: = average (B2: I2). Column L is the ranking. Assuming the average score is =RANK(K2, K$2:K$5 1), when adding $,remind K$ to avoid pulling the formula, and this area will also change and make mistakes. Therefore, we must add $ M column to find the standard deviation: the average value is a centralized trend, and the standard deviation is a discrete trend. =STDEVP(K$2:K$ 13) can also change the region and find the standard deviation of each subject. The greater the standard deviation, the more dispersed the scores, and vice versa. Find the number of students in each grade: taking a single subject as an example, the number of students with more than 90 points =COUNTIF(B$2:B$5 1, "> = 90") and the number of students with 80-90 points =COUNTIF(B$2:B$5 1, "> = 80. " & gt= 90 ")70-80 = = COUNTIF(B $ 2:B $ 5 1，" & gt=70")-COUNTIF(B$2:B$5 1，" & gt=80")
J. What does my mood mean in this reading?
This is really obsessive-compulsive disorder.
I think if you can't remember whether the lock is open or not, you can go back and look at it once, but after looking at it several times, it means you need to adjust it yourself.
The following is taken from the internet, and you can have a look: compulsive thinking can be divided into compulsive thoughts, compulsive emotions and compulsive intentions. There are all kinds of contents, such as repeatedly wondering whether the doors and windows are closed properly, whether you will get sick if you touch dirty things, and why the sun rises and sets in the west, and you have the impulse to jump off the balcony.