News
01/06/08Web site started
BackMagazines
12/02/2018 №2
EDUCATIONAL COMPACTLY SET EXCEL DATA TABLES AT INFORMATICS LESSONS
Annotation
Curriculum for studying Excel at almost all faculties of MGIMO includes the section on operation with relational (tabular) databases. For mastering standard tools, such as sorting, filtering, obtaining intermediate results and pivot tables, one is required to have primary databases. These databases can be prepared in advance and later their copies will be used at lessons. The second option is that each pupil creates them independently by the given formulas. The idea of the use of independent compactly set one-plate databases has been successfully used in educational process. The purpose of the given article is to share experience and make informatics teachers familiar with possible ways to implement this idea.Key words
informatics, Excel, data tables, primary tables, training control and measuring materials, online testing.
Bibliography
1. Golitsyna, O.L, N.V. Maximov and I.I. Popov, 2016. Databases: teaching manual. Moscow: Forum. (rus) 2. Zhilin, V.A., 2018. Programming basics in VBA in Excel: teaching manual. Moscow: MGIMO-University. (rus) 3. Zhilin, V.A. and V.P. Akimov, 1999. Tabular Excel Processor. Computing practice: teaching manual. Moscow: Ankil. (rus) 4. Zhilin, V.A. and V.P. Akimov, 2000. Tabular Excel Processor. Computing practice: teaching manual. Moscow: MGIMO. (rus) 5. Zhilin, V.A. and V.P. Akimov, 2003. Tabular Excel processor. Laboratory practice: teaching manual. Moscow: Triadа Plus. (rus) 6. Makarova, N.V. (Ed.), 1999. Informatics: textbook. Moscow: Finance and Statistics. (rus) 7. Skhirtladze, A.G. et al., 2015. Information technologies: textbook. Moscow: Academia. (rus) 8. Kogalovsky, M.R., 2002. Encyclopedia of databases technologies: evolution of technologies. Technologies and Standards. Infrastructure. Terminology. Moscow: Finance and Statistics. (rus)