Таблицы как протокол интерфейса ввода массовых тестов по латинскому и другим языкам в персональной информационной системе преподавателя: комплексная технология для Word, Excel, Quizlet, Gift и Moodle
- Авторы: Матухин П.Г.1, Провоторова Е.А.1, Грачева О.А.1, Комиссарова Н.В.2, Рыбакова И.В.1
-
Учреждения:
- Российский университет дружбы народов
- Московский городской университет управления Правительства Москвы
- Выпуск: Том 15, № 4 (2018)
- Страницы: 424-431
- Раздел: ИННОВАЦИОННЫЕ ПЕДАГОГИЧЕСКИЕ ТЕХНОЛОГИИ В ОБРАЗОВАНИИ
- URL: https://journals.rudn.ru/informatization-education/article/view/20591
- DOI: https://doi.org/10.22363/2312-8631-2018-15-4-424-431
- ID: 20591
Цитировать
Полный текст
Аннотация
В статье представлены результаты проекта по созданию и внедрению в процесс обучения языковым дисциплинам (латинский и английский языки, РКИ) авторской информационной системы (АИС). Выявлены проблемы комбинированного применения СДО Moodle и специальных средств обучения языкам типа Quizlet. Поставлен вопрос унификации формата массовых тестов и их импорта в обучающие среды. Исходной формой организации массивов тестового материала являются списки Word или таблицы Excel. Предложена структура таблицы как формы интерфейса АИС преподавателя. Описан автоматизированный процесс преобразования массивов из таблиц Word и Excel в Gift с целью импорта в Moodle и Quizleт. Показано, что использование табличного интерфейса позволяет реализовать эффективную комбинированную технологию импорта массовых тестовых заданий в различные среды обучения языковым дисциплинам.
Полный текст
On preparatory departments and initial courses of the university students study ancient and modern languages. It is Latin for medical and legal fields. Students in many other fields study English. Foreign citizens learn Russian as a foreign language (RFL). Language training often occurs in an accelerated mode. To improve the quality of the educational process teachers should develop and use special manuals, modern information tools and technologies. The market of information products and mobile applications for educational purposes is raising from day-to-day. This paper presents some results of a study of the possibilities of joint application of different programs - corporate LMS MOODLE and QUIZLET, a special program of language training. A unified Protocol of input data preparation for training sets and test tuples is proposed. The tabular structure allows anyone to create a comprehensive test load technology for both environments. Problem. Teachers of Latin and other languages faced the problem. A new organization of educational communication is required [1; 2]. It should be based on the joint use of mobile devices and ready-made online tools. Documents, tables, presentations can be easily placed into online archives [3; 4]. There is also a plenty of different tools for the educational feedback [5]. Each program requires a specific format of the source data. Teacher meets limitations in the combined use of special tools in the complex author information system of language training (AIST). The up-to-date standard of corporate online systems is the MOODLE LMS. The developers have provided good opportunities to organize and control the individual work of the student [6]. However, this system does not provide special training tools for exercises. An important element of the method is the possibility of using a wide range of group training techniques. The MOODLE cannot provide group exercises. Therefore, the language teacher faces the problem to enlarge his/her arsenal of language training mobile application. A combination of mass approach to transformation of components and simultaneous flexibility of technology required. Note, we do not proclaim the purpose of full automation. But a combination of automatic and manual operations. In our study, we intended to focus on the preparation of the initial training content. We started to create a simple technology that allows anyone to transform pre-prepared question sets [7] into files suitable for uploading to the all components of the AIST. Thus, we expect to achieve the main goal to develop a model of information technology for the preparation and unification of arrays of test tasks, which are intended for import in the QUIZLET MODULE. As well as for subsequent input into the MOODLE BANK of questions. The core of the new technology should be a data exchange Protocol. Its function is to provide an appropriate interface between the components of the AIST. We suppose the WORD lists, WORD table, and EXCEL spreadsheet to be the initial form of the raw test arrays. Method. Special training kits used general-purpose computer programs: WORD, EXCEL have been developed [5; 7]. The next was the use of mobiles and BYOD (Bring Your Own Device) technology [8; 9]. Good results were obtained with the HOT POTATOES [10]. Using for the distant and blended learning the OneDrive/Excel-online cloud version built-in functions a plenty of different Latin, Russian as a Foreign Language, English test sets for classroom and self-study were prepared [7]. These tables are relevant for today use. They can be used as complementary components of corporate and specialized learning environments, such as MOODLE or QUIZLET. We need to develop the improved technology in terms of these arrays into new systems input. The fundament of the development are the classical principles of the educational information systems construction [12]. Usually tests are made within the question BANK via manual input. The set of import formats includes GIFT, MOODLE XML, Aiken, Blackboard, WebCT, Examview, Microsoft Word 2010 table format, Embedded answers (Cloze), and Missing word. Special software is required. The only appropriate format for our purposes is a special markup language for text files GIFT - General Import Format Template. We chose it because to prepare a set of test questions teacher needs only arrange items as a WORD or EXCEL table. Note, in this study we consider only one type of test questions - quizzes. Those implies to choose one correct answer from the list of options. The operation assumes an insert of special markup characters into the questions table. This is a fundamental feature in the process of preparation of mass tests, which can include up to hundreds of questions. Figure. Lexical minimum for levels 1, 2, 3 of the Latin as the LSP The entire volume of vocabulary in Latin as a Language for Specific Purposes for medical students divided into 3 subsections - anatomical, clinical and pharmaceutical terminology (Figure). The system should enable students to learn the necessary volume of vocabulary in the independent mode. With a standard approach, systems requires a teacher to prepare a special import array. The most adjustable solution to the problem of the data form seems to be the table. The results presented below we obtained in the course of implementation of joint interdisciplinary projects of teachers of language and computer disciplines. Results. The model of the AIST includes the corporate LMS and custom applications. The base of it is the principle of universality of the data form. This form acts as a common interface between all the components of the AIST. It is an analogue of the data exchange Protocol in computer systems. Earlier we used tables to support educational communication via the OneDrive cloud storage. The advantage is the fact that it guarantees the safety of the information entered, protects against accidental errors. We ranged a certain sequence of the test question elements (tuple). The scheme contains the title of the question, its wording, the correct answer, a set of incorrect answers. The question title role performs numbering. The wording of the questions is standardized. Correct answers teacher should place in the first position of the answers sub tuple. The order of incorrect answers can be arbitrary because the test designer enables randomization. This tabular scheme is the AIST interface Protocol. It serves as the media for a complex technology of data input for all components of the system. The Protocol allows importing question tuples into the QUIZLET without any additional transformations. The teacher needs only to organize the correct order of the exercises in the classroom and to give students recommendations for the out-of-classes self-training. To import a question set in the MOODLE BANK, anyone needs to create a GIFT file. The test header should be limited from two sides by a pair of colons “::”. Then enclose in curly braces “{......}” the answers. Mark the first correct answer by the “=” sign, and incorrect answers by inserting the sign “~” before them. After special characters placing, merge the text rows of the EXCEL table cells using the CONCATENATE() function. The concatenation result is then supplemented with empty strings and copied into a text file. Thereafter, the resulting GIFT format file anyone can enter in MOODLE, using the IMPORT command from a BANK of QUESTIONS set. After that, a new test can be designed. Discussion. Originally, the technology was tested by language teachers at the pregraduate faculty for tuition of foreign students of engineering directions in RFL. Legal fundamentals of the RFL teaching and certification clearly stated by a number of decrees [13]. The development is also used to prepare exercises and test tasks in the Latin language for students of humanitarian and medical areas. At the faculty of Philology acquaintance with the Latin, language is clearly structured, depending on the direction of the course it takes 2 or 3 semesters. The introduction of the early studied vocabulary in the following modules allows students to repeat the terms and to feel the inner connections and the integrity of the language. This way shows how the technique allows the teacher to implement the principle of succession in the language teaching and learning. Due to the limited scope of this work, we did not touch the output of test results and the preparation of reports. We plan to present them in a separate paper. Using a tabular interface with a standard configuration of questions tuples, anyone can implement a practical and effective technology to import tests into different language learning environments. At the same time, the tabular Protocol guarantees the security of the language learning content. The paper seems to be interesting for language teachers and humanities teachers refresh courses professors and attendee.
Об авторах
Павел Гранитович Матухин
Российский университет дружбы народов
Автор, ответственный за переписку.
Email: m-pg@mail.ru
старший преподаватель кафедры компьютерных технологий филологического факультета Российского университета дружбы народов
Российская Федерация, 117198, Москва, ул. Миклухо-Маклая, 6Елена Аркадьевна Провоторова
Российский университет дружбы народов
Email: provelar@yandex.ru
старший преподаватель кафедры иностранных языков филологического факультета Российского университета дружбы народов
Российская Федерация, 117198, Москва, ул. Миклухо-Маклая, 6Ольга Алексеевна Грачева
Российский университет дружбы народов
Email: oagra@hotmail.ru
доцент кафедры русского языка факультета русского языка и общеобразовательных дисциплин Российского университета дружбы народов
Российская Федерация, 117198, Москва, ул. Миклухо-Маклая, 6Наталья Валерьевна Комиссарова
Московский городской университет управления Правительства Москвы
Email: natalie_komis@mail.ru
доцент кафедры юриспруденции Московского городского университета управления Правительства Москвы
Российская Федерация, 109542, Москва, Рязанский проспект, 99Ирина Викторовна Рыбакова
Российский университет дружбы народов
Email: rybakova_irina@mail.ru
старший преподаватель кафедры иностранных языков филологического факультета Российского университета дружбы народов
Российская Федерация, 117198, Москва, ул. Миклухо-Маклая, 6Список литературы
- Грачёва О.А., Матухин П.Г., Эльсгольц С.Л. Межпредметные информационно-технологические проекты в разработке учебно-методических пособий по русскому языку для физиков // Вестник Российского университета дружбы народов. Серия: Информатизация образования. 2013. № 4. C. 27-38.
- Komissarova N.V. Teaching English via IT Tools and Professional Communication // Материалы XXI Международной конференции Национального объединения преподавателей английского языка в России. Екатеринбург: УГПУ, 2015. С. 130-131.
- Matukhin P.G., Elsgolts S.L., Pevnitskaya E.V., Gracheva O.A., Provotorova E.A. Multimedia Tutorial In Physics for Foreign Students of the Engineering Faculty Preparatory Department // Mechanics, Materials Science & Engineering. 2016. Vol. 2. Pp. 84-90.
- Антохина Е.В., Година Е.З., Матухин П.Г., Провоторова Е.А., Титова Е.П. Онлайн-средства информационно-методической поддержки дистантного изучения курса «Анатомия человека» для иностранных студентов предвузовского этапа обучения на базе облачных BYOD-технологий Microsoft OneDrive/Word Online // Вестник ЦМО МГУ. 2015. № 4. C. 33-39.
- Матяш Г.А., Матухин П.Г., Аникина Е.О., Провоторова Е.А. Создание тестов в среде Microsoft Office Excel. База вопросов, тренажеры, генератор вопросов, тесты. М.: РАО, 2013. C. 1-35.
- Грачёва О.А., Матухин П.Г. Инновационные элементы в обучении иностранных слушателей базовому языку физики на основе облачного ресурса OneDrive и СДО Moodle в мобильном режиме // Всероссийская научно-практическая конференция «Актуальные вопросы реализации образовательных программ на подготовительных факультетах для иностранных граждан». Днепропетровск, 2016. С. 410-418.
- Gracheva O.A., Matukhin P.G. Innovative elements in foreign students basic language of physics teaching based on cloud resource OneDrive and Moodle distant learning system in mobile mode // All-Russian scientific-practical conference “Topical issues of implementation of educational programs at the preparatory faculties for foreign citizens”. М.: ГИРЯП, 2016. C. 123-129.
- Gracheva O.A., Elsgolts S.L., Matukhin P.G., Pevnitskaya E.V., Matyash G.A. The base of questions, simulators, test generator and a set of options on Russian as a foreign language for foreign studentsphysicists. URL: http://www.ofernio.ru/rto_files_ofernio/19358.doc
- Эльсгольц С.Л., Провоторова Е.А., Матухин П.Г., Грачева О.А., Певницкая Е.В. Перспективы использования BYOD-технологий в WIKI-проектах для образовательной языковой, предметной и ИТ-адаптации иностранных студентов // Преподавание общеобразовательных предметов на русском языке в иноязычной аудитории: материалы Международного научно-практического семинара. М.: МОЦ МГ, 2014. С. 148-155.
- Komissarova N.V., Gleason K., Matukhin P.G. Knowledge Hub: spiral matrix thinking as a communication technology for individual and group learning in OneDrive and Word Online // Вестник Российского университета дружбы народов. Серия: Информатизация образования. 2017. Т. 14. № 2. С. 194-204.
- Комиссарова Н.В., Глисон К., Матухин П.Г. Спиральные трассы в матрице Knowledge Hub как коммуникативная технология для индивидуального и группового обучения в среде OneDrive/Word Online // Вестник Российского университета дружбы народов. Серия: Информатизация образования. 2017. Т. 14. № 2. C. 194-204.
- Башмаков А.И., Башмаков И.А. Разработка компьютерных учебников и обучающих систем. М.: Филин, 2003. 616 с.
- Matukhin P.G., Grachova О.А., Elsgolts S.L., Pevnitskaya Е.V. Tabular organization of the educational content as the basis of the complex BYOD support and monitoring of foreign students studying physics and Russian language, physics-based cloud resource MS OneDrive // Proceedings of International scientific-practical conference “Informatization of Engineering Education”. М.: MEI, 2016. Pp. 681-684.
- Komissarova N.V. et al. The Set of Teaching Materials for TRFL Certification Preparation. Part 9. Legal Fundamentals of RFL Teaching and Testing of Foreign Citizens in Russian Centers of Science and Culture Abroad // Chronicles of the United Fund of Electronic Resources “Science and education”. 2017. No. 9. P. 100.
Дополнительные файлы










