Matters needing attention in data import:
(1) See Table 2 for the item number and result format in the Excel table.
(2) The filled test numbers of all grades should also correspond to the items set in the "Test Item Settings" of the data reporting software of the national student physical health standard data management system, otherwise the data cannot be imported;
(3) 3) All data and information in the Excel table must be filled in completely, and other items are not allowed to be empty except the number and home address of the reward and punishment items; Blank lines are not allowed between data lines. When a blank line is encountered, the default is that the data ends here, which makes it impossible to import all the data.
(4) When an endurance event is entered and the result of the event is in minutes and seconds, the symbol of seconds can be omitted. For example, 3' 15 "can only be entered as 3' 15. In addition, when you enter the minute symbol, you can use it in Insert-Special Symbol-Unit Symbol, or you can enter single quotation marks or instead of it on the keyboard. For example, 3' 15 "can be entered as 3' 15.
(5) It is suggested that schools import students' data by grade to avoid a series of problems such as inconsistent data types or computer suspended animation caused by too long import time.
(6) Primary school grade 1-4, there are no endurance events, just leave the columns in the EXCEL table blank, and don't fill in other numbers or set the format.
(7) When a student is exempted from the exam due to illness or disability, his test scores cannot be blank in the EXCEL table and must be filled in. You can fill in the scores that meet the requirements at will according to the logical value requirements of each item, and then fill in the corresponding item number in the column of reward and punishment item number. After importing, the total score of students is 0.
(8) If you export the scores or basic information of each item from other systems to an EXCEL table, please arrange the data as required, copy and paste them into the data template of this software by column, and do not copy and paste the whole table or multiple columns at the same time to avoid abnormal data import.
(9) Please don't put the exam information of different grades into other worksheets except Sheet 1, otherwise there will be an error of "EXCEL has no data to import" or only the grade and class information filled in Sheet 1 can be imported.