A more effective instructional method is proposed to address the shortcomings of current college soccer training activities. In this paper, 30 students with comparable soccer quality in colleges and universities were selected and divided equally into experimental and control groups, with the experimental group using SAQ training methods and the control group using traditional training methods. The square dribbling test, 15-meter zigzag dribbling test, straight line with the ball around the barrel test and DAT non-directional dribbling test were selected as the dribbling ability test indexes, and the cross quadrant jump, Illinois test, cross disguised running and Nebraska test were selected as the agility quality test indexes. The analysis of the data measured before and after the experiment by factor analysis showed that the Р values of the players in the experimental group were less than 0.05 in the square dribble and DAT non-directional dribble test, and the Р values were greater than 0.05 in the comparison of the linear barrel test. This study used a scientific analysis method to investigate soccer training activities in colleges and universities, which can effectively optimize the instructional methods of soccer training.