Methodology Of Using The Database Tools For Calcuation Of Student Rating

Under conditions of the modern education process, it is very important to fully and accurately access data of students’ productivity and attendance for development of correct approach for their education. For this purpose, teachers use a point-rating system, or PRS. Originally, this system was provided in handwritten and printed tables. For this tables, collected data was put on with a traditional method (five-rating system, ten-rating system etc.). However, with the passing of time these records became obsolete and were replaced with new convenient and accurate records, which were created in accordance with current scientific and technical progress. These are electronic databases and database management systems, or DBMS. Nowadays, there are many different varieties for creation of point-rating systems with such electronic records. These include Google forms as well as software of Microsoft Office package – MS Excel and MS Access. In this work, MS Access is discussed in detail as a relational DBMS, which can be used as a basis for development of innovational students’ productivity PRS. For development of such system, we examined basic concepts of PRS and analyzed the MS Access software functionality as well as its tools. Based on the collected data, a mathematical model for accessing of students’ productivity rating was created and was further used for PRS interpretation in MS Access DBMS. For the convenient and simple usage, there were also created several forms and reports in program.