It is necessary for English teachers to grasp the causes of students' language anxiety and explore ways to avoid, reduce, and eliminate students' anxiety. This paper discusses the foreign language anxiety of college English teachers in classroom teaching, its possible causes, teachers' awareness of anxiety, and countermeasures. This paper introduces the composition of student affairs analysis system from data layer, analysis layer, application layer, and display layer and combines data warehouse and data mining technology to improve the functions of student information, teacher information, achievement information, course selection information, and course evaluation. On the premise of data mining and data information management, it realizes the construction and application of teaching management data analysis system, using classification model. Apriori algorithm improves the algorithm, uses big data technology to analyze data and design courses, and analyzes the inherent relationship between mental health problems and attributes.