Guofeng examination question bank matching and scoring system

The Guofeng Exam question bank matching and scoring system is a set of software based on Excel's VBA and formulas. It can be opened in Excel, and various question banks can be manually created and classified on the corresponding page (external question banks can usually be directly pasted in); question types ( Objective questions (including single choice and multiple choice) and points can be set by yourself and a question bank table can be established. On the question configuration page, by setting the number of various question types and knowledge points, and randomly combining the configurations to generate test papers (with answers), the question matching work can be carried out quickly and objectively, avoiding the supervisor's preference in setting questions, and conducive to comprehensive testing of students' comprehensive knowledge degree of point. After confirmation, the preliminary test paper can be exported to a dedicated test paper file with one click for the respondents to answer. Respondents can manually select answers from the electronic file of the test paper, or print the test paper for a written test. For electronic answer sheets, the modified system can automatically traverse all answer sheets and score them. It can also compare the test questions that each person answered incorrectly on the answer page. It can easily count the error filters for each question, making it easy to find key and difficult questions for explanation. . This software runs directly on Excel and does not require database configuration, making it convenient and practical. It is suitable for various training institutions and training institutions with existing question banks such as primary and secondary schools to conduct tests and knowledge points. It can also be used for internal training assessments within enterprises and the detection of personal learning status.