Analysis of the ranking and rating assessments with functions, tools and object oriented VBA for Excel

The paper considers the possibilities of object oriented programming in VBA for Excel in the analysis of the ranking and rating assessments. Key issues (classification criteria) of ranking and rating assessments are: preliminary exams seminars, projects, working in teams, discussion topics, class, attendance and activity in class and final exam. VBA considers in the context of the simple and innovative creating of different scenarios for calculating percentage points.