Home → Releases → № 1 (71) →

COMPETENCIES FOR COMPUTATIONS IN SPREADSHEETS: FINDING MINIMUM AND MAXIMUM VALUES BY CONDITION, FUNCTIONS MINIFS, MAXIFS

Electronic Means of Support of Education , UDC: 004.67: 372.862 DOI: 10.24412/2072-9014-2025-171-90-100

Authors

  • Popov Vladislav S.
  • Alefirenko Evgeniya A.
  • Chernitsyna Larisa Yu.

Annotation

The article reveals a pedagogical contradiction between the high examination requirements for the results of computer science training at the level of secondary general education and the insufficient development of the subject content in regulatory documents, educational and methodological literature and school pedagogical practice in terms of studying the functions of spreadsheets. The article considers new functions of spreadsheets MINIFS, MAXIFS, features of their arguments, methods of replacing them with a set of functions IF, MIN, MAX. The article presents tasks for computing the minimum and maximum values by a condition, lists the areas of the formed competencies, and shows that the formed competencies differ both in the level of complexity of the subject content and in the object.
Tags:
spreadsheets; MINIFS; MAXIFS; Excel; LibreOffice Calc; competencies; competency-based approach

How to link insert

Popov, V. S., Alefirenko, E. A. & Chernitsyna, L. Y. (2025). COMPETENCIES FOR COMPUTATIONS IN SPREADSHEETS: FINDING MINIMUM AND MAXIMUM VALUES BY CONDITION, FUNCTIONS MINIFS, MAXIFS Bulletin of the Moscow City Pedagogical University. Series "Pedagogy and Psychology", № 1 (71), 90. https://doi.org/10.24412/2072-9014-2025-171-90-100
References
1. 1. Federal work program of secondary general education. Computer Science (basic level) (for grades 10–11 of educational organizations). Moscow: Institute of Educational Development Strategy, 2023. 38 p.
2. 2. The Federal work program of secondary general education. Computer Science (advanced level) (for grades 10–11 of educational organizations). Moscow: Institute of Education Development Strategy, 2023. 52 p.
3. 3. Davydov S. G. Digital competencies of Russians and self-isolation during the COVID-19 pandemic / S. G. Davydov // Monitoring public opinion: economic and social changes.2021. No. 2 (162). P. 403–422. DOI: 10.14515/monitoring.2021.2.1913
4. 4. Yunov S. V. Spreadsheets as a determinant of the formation of ICT competencies of education workers / S. V. Yunov // Teaching information technology in the Russian Federation: Proceedings of the Seventeenth Open All-Russian Conference (Novosibirsk, May 16–17, 2019). Novosibirsk: Novosibirsk National Research State University, 2019. P. 221–223.
5. 5. Nikonova E. Z. Elective courses for students as a tool for the formation of information competence / E. Z. Nikonova, E. A. Sliva // Modern research on social problems (electronic scientific journal). 2017. Vol. 8. No. 4-2. P. 192–196. DOI: 10.12731/2218-7405-2017-4-2-192-196
6. 6. Zimnaya I. A. Key competencies as the effective and targeted basis of the competence approach in education / I. A. Zimnaya. M.: Research Center for Quality Problems of specialist Training, 2004. 40 p.
7. 7. Universal competencies and new literacy: from slogans to reality: Scientific publication: monograph. Moscow: National Research University «Higher School of Economics», 2020. 472 p. DOI: 10.17323/978-5-7598-2177-9
8. 8. Khutorskoy A. V. Model of competence education / A. V. Khutorskoy // Higher education today. 2017. No. 12. P. 9–16. DOI: 10.25586/RNU.HET.17.12.P.09
9. 9. Korneenko O. E. Information technologies: tabular processors, computer graphics, technologies and systems for creating dynamic presentations, organizer programs: a practical guide / O. E. Korneenko, D. V. Doroshev. Gomel: F. Skorina State State University, 2023. 48 p.
10. 10. Malyshev A. V. Method and algorithms for calculating the ZigZag indicator for securities quotations in VBA Excel / A. V. Malyshev, I. V. Korovyakovsky, N. Allaberenov, V. A. Alekseev // Proceedings of the Southwestern State University. Series: Management, computer engineering, computer science. Medical instrumentation. 2019. Vol. 9. No. 3 (32). P. 8–27.
11. 11. Winston Wayne L. Business modeling and data analysis. Solving current problems using Microsoft Excel / Wayne L. Winston. St. Petersburg: Peter, 2021. 944 p.
12. 12. Nesterenko A. A. Contradictions as a tool for designing pedagogical systems / A. A. Nesterenko // Development of creative abilities in the process of teaching and upbringing based on TRIZ: conference materials. Chelyabinsk, 2007. P. 97–104.
13. 13. Galaguzova Yu. N. Contradictions as a tool for designing and analyzing pedagogical systems / Yu. N. Galaguzova // Bulletin of the V. N. Tatishchev Volga State University. 2011. No. 8.
14. 14. The approximate work program of secondary general education. Computer science. Basic level (for grades 10–11 in educational institutions) / Institute of Education Development Strategy of the Russian Academy of Education. Moscow: Russian Academy of Education, 2022. 40 p.
15. 15. The approximate work program of secondary general education. Computer science. Advanced level (for grades 10–11 in educational institutions) / Institute of Education Development Strategy of the Russian Academy of Education. Moscow: Russian Academy of Education, 2022. 58 p.
16. 16. Specification of control measuring materials for the unified State exam in computer Science in 2025. Moscow: Federal Institute of Pedagogical Measurements, 2024. 2 p.
Download file .pdf 726.89 kb