Abstract: The paper is based on concept of smart database which deals with formal student guidance throughout his four years of engineering. The older versions made use of static assessment to generate generic student report on the other hand Academic Advisor makes use of various smart algorithms to generate a dynamic student guidance support system which help students to keep a track of their progress and helps them to make informed decisions throughout their academic session and also in their future job endeavors. It helps the IT firms to shortlist students for interview based on the criteria provided by Academic Advisor based on a special and smart grading system. Hence Academic Advisor will provide student with a virtual personalized tutor.

Keywords: Educational Data Mining(EDM); Guidance Support System; Adaptive Hypermedia System; Academic Analytics.