Good Excel data effectiveness in student performance management

Teachers often use Excel to make forms, input student information, Excel powerful tabulation function, bring convenience to the teacher work, but in the form of data entry process will inevitably error, inadvertently will input some wrong data, such as duplicate ID number, out of range of invalid data. In fact, as long as a reasonable set of "data Validation" rules, you can avoid errors.

Instance one: My id you don't use it.

To facilitate the management of student information, each student has its own unique ID (school number), in the information entry, student ID is not allowed to repeat, if the duplicate ID in Excel input, it will bring inconvenience to information management, we can be in Excel "Data validity" to set, refused to enter duplicate data.