Calculation of some synthetic data and building a dashboard for the head of the clinic division by means of spreadsheets

The article considers the option of using spreadsheets to calculate individual synthetic data based on the statistics available in the clinic and building an interactive dashboard for the head of the department of the medical institution according to the dataset. The methodology for improving the IT competencies and analytical abilities of students is demonstrated during the implementation of the educational project for the development of such a board within the course «Introduction to Information Technologies», step-by-step instructions for its creation are given, prepared by students; and didactic possibilities of such work are revealed.