Research on the Application of Cognitive Diagnostic Models in Assessment Evaluation

With the integration of cognitive diagnostic technology into the field of education, meeting individual learning needs has become possible. This study takes the “Excel Data Analysis” module in the “University Computer Basics” course as the research subject, aiming to evaluate the application effect of Cognitive Diagnostic Models in student assessment and evaluation. Through in-depth interviews with teachers and experts, the key competencies that students need to master were clarified, including data understanding and basic operations, data computation and processing, data management and analysis, data visualization, etc. This study constructed a DINA model, established a hierarchical structure of competence attributes, defined the Q-matrix and the ideal competence mastery pattern, and used the flexCDMs platform for parameter estimation, analyzing the test item parameters and the probability of students' competence attributes mastery. The results show that students perform well in “data computation and processing,” while “advanced analysis skills” need to be strengthened. The study provides evidence for teaching improvement, and although there are limitations, it points out the direction for future research.