Receipt date: 
01.05.2021
Year: 
2021
Journal number: 
УДК: 
331.108:004
DOI: 

10.26731/2658-3704.2021.3(11).47-58

Article File: 
Pages: 
47
58
Abstract: 

HR workers and recruits often use the software, which allows visualizing and analyzing data in their work. Alongside with a big variety of special but expensive software, MS Excel remains a reliable and accessible tool to visualize and analyze the results of the company’s performance. The article describes the individual experience of using MS Excel in learning «Information technologies in human resources». This experience can be used in teaching students of bachelor and master degrees in «Human Resources» and «Management» programs. This includes building a speedometer chart, a bullet chart, a gauge chart, a radial and a combination chart, a Pareto chart, a Gantt chart, etc. Students who study the described set of methods of work will get an ability to solve tasks of professional activity based on information culture using information and communication technologies, knowledge of personnel reporting skills, analysis of economic indicators of the organization's activities, application of technologies for visualization of the results of business evaluation of personnel, etc.

List of references: 
  1. Mikhaelis S.I. Aktivizatsiya formirovaniya informatsionnoi kul'tury studentov v protsesse samostoyatel'noi uchebnoi deyatel'nosti. Avtoreferat dissertatsii na soiskanie uchenoi stepeni kandidata pedagogicheskikh nauk / Buryatskii gosudarstvennyi universitet. Ulan–Ude, 2006. (In Russian).
  2. Cherepanova A.L. Aktivizatsiya rechemyslitel'noi deyatel'nosti v formirovanii kompetentsii studentov IrGUPS // Transportnaya infrastruktura Sibirskogo regiona. 2018. Vol. 2. PP. 492–496. (In Russian).
  3. Cherepanova A. L. Razvitie obshchekul'turnykh kompetentsii pri izuchenii temy «Postroenie diagramm v tablichnom protsessore» // Informatika i obrazovanie. 2014. № 5 (254). PP. 55–59. (In Russian).
  4. Chulanova O.L., Sviridova O.P. Issledovanie vozmozhnostei i riskov primene-niya HR-analitiki dlya optimizatsii protsessov upravleniya personalom v tsifrovoi ekono-mike // Vestnik Evraziiskoi nauki, 2020 №2 [Elektronnyi resurs]. URL: https://esj.today/PDF/02ECVN220.pdf. (In Russian).
  5. Sinar E.F. Data Visualization: Get Visual to Drive HR’s Impact and Influence. Society for Human Resource Management (SHRM)-Society for IndustrialOrganizational Psychology (SI-OP) Science of HR White Paper Series [Elektronnyi resurs]. URL: https://www.shrm.org/hr-today/trends-and-forecasting/special-reports-and... (data obrashcheniya: 08.04.2021).
  6. Luchshie 9 instrumentov HR analitiki [Elektronnyi resurs]. URL: https://asu–analitika.ru/luchshie–9–instrumentov–hr–analitiki (data obrashcheniya: 06.03.2021). (In Russian).
  7. Top Excel Templates for Human Resources [Elektronnyi resurs]. URL: https://www.smartsheet.com/top–excel–templates–human–resources (data obrashcheniya: 22.03.2021).
  8. HR Knowledge Corner [Elektronnyi resurs]. URL: http://www.hrknowledgecorner.com/ (data obrashcheniya: 23.03.2021).
  9. 4+ HR Gantt Chart Templates https://www.template.net/editable/hr-gantt-chart (data obrashcheniya: 22.03.2021).
  10. Grafik otpuskov sotrudnikov [Elektronnyi resurs]. URL: http://vexcele.ru/load/dlja_biznesa/grafik_otpuskov/5-1-0-6 (data obrashcheniya: 01.04.2021). (In Russian).
  11. Kak sdelat' grafik otpuskov v Excel [Elektronnyi resurs]. URL: https://exceltable.com/otchety/grafik–otpuskov–skachat–shablon (data obrashcheniya: 01.04.2021).
  12. Vsplyvayushchii kalendar' [Elektronnyi resurs]. URL: https://www.planetaexcel.ru/techniques/6/50/ (data obrashcheniya: 01.04.2021). (In Russian).
  13. Voronka podbora kak effektivnyi instrument naima [Elektronnyi resurs]. URL: https://irkutsk.hh.ru/article/27627 (data obrashcheniya: 18.03.2021). (In Russian).
  14. Konoreva K.V., Tselyutina T.V. Vozmozhnosti ispol'zovaniya instrumentov pro-gnozirovaniya v sfere massovogo rekrutinga. Voronka po naboru // Nauchnyi zhurnal Diskurs. 2018. № 12 (26). PP. 334–344. (In Russian).
  15. Primenenie matritsy i diagrammy kompetentsii [Elektronnyi resurs]. URL: https://habr.com/ru/post/443162/ (data obrashcheniya: 22.03.2021). (In Russian).
  16. Mikhaelis S.I. Metodicheskaya razrabotka po teme «Sozdanie pulevoi diagrammy» // Modern Science. 2021. № 4–3. PP. 398–410. (In Russian).
  17. Vasil'eva E.K. Statistika [Elektronnyi resurs]: uchebnik dlya studentov vuzov, obuchayushchikhsya po spetsial'nostyam ekonomiki i upravleniya (080100)/ Vasil'eva E. K., Lyalin V.S. Elektron. tekstovye dannye. M.: YuNITI–DANA, 2012. 398 c. Rezhim dostupa: http://www.iprbookshop.ru/8581 (data obrashcheniya: 06.03.2021). (In Russian).
  18. Salostei S. Diagramma tempov rosta v Excel [Elektronnyi resurs]. URL: https://finalytics.pro/inform/diagramma3/ (data obrashcheniya: 06.03.2021). (In Russian).
  19. Sozdanie diagrammy v vide spidometra v Excel [Elektronnyi resurs]. URL: https://exceltip.ru/sozdanie-diagrammy-v-vide-spidometra/ (data obrashcheniya: 08.04.2021). (In Russian).
  20. Ezepov D. Kak postroit' diagrammu spidometr v Excel? [Elektronnyi resurs]. URL: https://acadauto.ru/video/kak-postroit-diagrammu-spidometr-v-excel/ (data obrashcheniya: 08.04.2021). (In Russian).
  21. Prichiny tekuchesti kadrov: ot analiza k deistviyu [Elektronnyi resurs]. URL: https://www.hr–director.ru/article/67711–prichiny–tekuchesti–kadrov–ot–analiza–k–deystviyu (data obrashcheniya: 08.04.2021). (In Russian).
  22. Verna V. V., Mel'nichenko S.A. Upravlenie tekuchest'yu personala i sozdanie si-stemy ucheta dvizheniya i tekuchesti kadrov v organizatsii // Sbornik tezisov dokladov uchast-nikov I Mezhdunarodnoi nauchno-prakticheskoi konferentsii «Innovatsionnye napravleniya integratsii nauki, obrazovaniya i proizvodstva» [Elektronnyi resurs]: Sbornik tezisov / pod obshch.red. Masyutkina E. P. – Kerch': FGBOU VO «KGMTU», 2020. URL : http://www.kgmtu.ru/documents/nauka/Sbornik_Tezisov_May_Kerch.pdf.
  23. Mikhaelis S.I. Metodicheskaya razrabotka po provedeniyu otkrytogo laboratorno-go zanyatiya na temu «Diagramma Pareto» // Voprosy pedagogiki. 2019. № 4-1. PP. 95-100. (In Russian). (In Russian).
  24. How to Create a Tornado Chart in Excel [Elektronnyi resurs]. URL: https://excelchamps.com/blog/tornado–chart/ (data obrashcheniya: 23.03.2021).
  25. Jorrit van der Togt, Thomas Hedegaard Rasmussen (2017) Toward evidence-based HR // Journal of Organizational Effectiveness: People and Performance, Vol. 4 Issue: 2. – PP. 127–132, D0I.org/10.1108/ J0EPP–02–2017–0013.