{'fraction_non_alphanumeric': 0.015853658536585366, 'fraction_numerical': 0.006097560975609756, 'mean_word_length': 5.172932330827067, 'pattern_counts': {'":': 0, '<': 0, '<?xml version=': 0, '>': 0, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
Methodical tools for forming key competences on the subject “Spreadsheets” at school

This paper focuses on the key role of IT training in digital competence. It is about methodological aspects of studying spreadsheets on the topic “Table information processing” in secondary schools, the learning objectives and the specifics of the tasks they provide, the sustainability of the skills and the necessary competencies for their application in solving different problems. The results of a large-scale study involving 232 high school students and 94 university students have been presented, which show the durability of students’ knowledge and skills in solving problems and tasks with the help of spreadsheets in different spheres of public life. The aim of the authors is to show and analyze the results of the research.