As one of the important research branches in educational data mining domain, student performance prediction was intensively studied. However, a comprehensive review of student performance prediction was still underexplored from the perspective of real applications. This paper detailed the technologies and methods exploited in student performance prediction research from the perspective of task granularity, and then introduced several application-oriented cases of student performance prediction, so as to provide targeted reference information for scientific researchers and educators.